AnsweredAssumed Answered

Retrive data from FM12 Pro Advanced using SSRS 2008

Question asked by NeerajSaini_1 on Jan 10, 2013

Title

Retrive data from FM12 Pro Advanced using SSRS 2008

Post

     Hi,

      

     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?

     Regards

     NS

Outcomes