BAQ Report From Union Query E10


The BAQ report works fine as long as you go into the SSRS report and remove all references to fields in the second subquery. Take out the references in the query AND fields in the BAQ result AND labels data sets.



My Union query of PartBin and PartTran to back out inventory transactions to the prior month end works okay, except I get the bin quantities and transactions on separate lines. In my dashboard I can select the option to bring back in the transactions, with an identifier of "IsTransaction" so at least I can add them back in a spreadsheet for one line per bin.

So I thought I'd do an SSRS BAQ Report where I could group the output and get the one line per bin there. But when I run the BAQ report I get this error from the system monitor:

Program Ice.Services.Lib.RunTask raised an unexpected exception with the following message: RunTask: System.Web.Services.Protocols.SoapException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset 'RptLabels'. ---> System.Data.SqlClient.SqlException:

Invalid column name 'Part1_PartNum'.Invalid column name 'Part1_PartDescription'.Invalid column name 'Part1_ClassID'.Invalid column name 'Part1_ProdCode'.Invalid column name 'Part1_IUM'. (and so on)

It doesn't like the column names of subquery 2.

I suppose I could move the query to the SSRS report, but I'd lose the BAQ special constants, etc. and the options entry from the Epicor side.

If I could figure out how to sum the bin and transaction rows into one row in the dashboard I'd be happy.

Anyone tried something like this?




Joe D. Trent

Bigham Ag Equipment