0 Replies Latest reply on Jan 10, 2013 11:28 AM by NeerajSaini_1

    Retrive data from FM12 Pro Advanced using SSRS 2008

    NeerajSaini_1

      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