I am having problems running a report after making a change to concatenate two fields.
I have a report with parameters. @StartDate, @EndDate, @ShipperNo, @ServiceType.
I have a dataset called Distinct Account. The query is as follows:
SELECT DISTINCT Deliveries.ShipperNo + ' ' + ShipperName.AccountName AS ShipperNo
FROM Deliveries LEFT OUTER JOIN
ShipperName ON Deliveries.ShipperNo = ShipperName.ShipperNo
ORDER BY ShipperNo
Previously my query was: Select Distinct Deliveries.ShipperNo FROM Deliveries
This query picked up all the shipper nos which enabled my report to run.
I have now joined to the ShipperName table to get the Account Name and to able to concatentate two fields: ShipperNo and ShipperName.
On my parameter ShipperNo i have selected Allow Multiple Values.
On my Parameter ShipperNo Under Available values I have selected Get Value from a query.
Value Field: ShipperNo
Label Field: ShipperNo
When i run my report on my multiple dropdown list for Shipper No, it looks as follows:
Previously my report ran correctly when not using concatentation. I am now finding that my report is not returning any data at all.
Am i doing something wrong?