This is a last resort. I’ve got a BAQ that I’m using as my data source for an SSRS report. My BAQ is uses the ShipHead.PackID as the main criteria for my report and, for the sake of argument, the value is 456. I’ve created a filter so the user and enter the Packing List ID for this new report. The BAQ works absolutely as expected.
Entering my BAQ into a BAQ Report Designer and entering my SSRS name, then I download that .rdl file. I open the .rdl file in Report Builder, place the Packing List ID on the report. Save it and up load my .rdl file to testing .
I preview my report and 99.9% of the value I see from my BAQ is correct except for the Packing List ID value. It displays some value out of nowhere and isn’t anywhere on the BAQ result list. The data shows from the Packing List ID entered, but the actual Packing List ID field is wrong … 3192. The Packing List ID values don’t even go that high from the ShipHead table.
I have no idea where this value is coming from. How could it be wrong? I’m at a total loss and completely confused. This should’ve been the easiest report modification ever! Has anybody seen this type of behavior before?