Retrive data from FM12 Pro Advanced using SSRS 2008
I am trying to show data on a report using SSRS 2008 and for some reason I am not getting any response back.
The query I am using is
Select RMA,EBay,RackLocation,Tested_Good,Tested_Bad,LocID,Mfg,ModPart,PCCalc,HardwareType,SUM(Quantity) as TotalQuantity from Hardware where Inventoried = 'Yes' and RMA is NULL and OnHand > 0 group by ModPart,RMA,EBay,RackLocation,Tested_Good,Tested_Bad,LocID,Mfg,PCCalc,HardwareType
There are 3 calculated fields in this query , removing those shows me the data in the designer but in any case I don't see data on the UI.
Did anyone got the same issue?