You’re offline. This is a read only version of the page.
3,851
Hi ,
I am new to the ssrs reports can you guide me how to build an ssrs reports with RDP class ,that class having 2 temporary tables 1is header information another one is lines information.
My Example is "Sample Header and Sample Details" Are the 2 physical tables having the common field Number this is unique in sample header and the sample details having the multiple line for particular Number
my o/p comes like this
dataste1
Number
1
2
3
dataset2
number work
1 sdcf
1 jdljslfd
1 fkldfd;l
2 ld;fldf;g
3 ksdkls
3 kfsdffsd
my o?p comes like this but my actual requirement display data like below
dataset1
1
dataset2
1 gflddl
1 dfsjflkl
dataste1
2
datset2
2 lsdflk;
like this
cau you guide how to do in precision design
bassed on this scenario i can work out my issue.
Thanks In advance
*This post is locked for comments
I have the same question (0)
Hi veeru,
Your attempt is in a wrong direction. SSRS is not similar to forms and you don't have joins as you have in the Ax forms. If you look at SalesConfirmDP or WmsPickingList_OrderPickDP you will see that there is only one Header record inserted which stores the consolidated information applicable across the entire report. In your case you should follow the example of CustTransListDP where you have to create one table that stores both the customer information and customer transaction information and later on use "GroupBy" on CustomerId (In your case it is purchId) option on the AutoDesign or Precision Design to create your report.
Hope this helps.
Share
Report
All responses (
Answers (
