Hi All,
Just in the process of amending our ARForm report style (SSRS). I’m having trouble bringing in the PBReportID (or ReportID) from the AR Header onto the ARForm. Can anyone give me some tips?
Thanks!
1 Like
What steps have you taken? It should be pretty simple as the table is already in the RDD so just include the field then edit the SSRS.
2 Likes
Hi Randy,
Many thanks for you reply!
So far I’ve added the field PBProjectID to the ARForm dataset and then use the field in a tablix column. However, when I’ve uploaded through SSRS report style and ran through AR Invoice print, the cell is blank. The AR Header shows the project ID with a value.
Do I need to edit the RDD?
Apologies, I’m pretty new to all this!
Thanks,
Jake
Yes, You need to ‘un-exclude’ the field in the RDD like so:
Open Your Report Style
click on RDD field and navigate to ARInvoice RDD
Duplicate the base to make a copy
Find PBProjectID and uncheck Exclude box
Save
Back on Report Style: set RDD to your new ud RDD
Save
Now you can modify RDL to add it to the Dataset SQL expression and Field List.
HTH,
Josh
1 Like
Josh got to you before I could answer but he’s correct.
1 Like
PS - WAY too many steps to add a field, add in the generate, download, upload to preview, upload to implement and it’s WAY WAY WAY too many.
1 Like
Sing it sister!
2 Likes