Hi Everyone,
I’m trying to customize the AR Aging report to display an UD field (Character02) right beside the InvoiceNum but wasn’t able to do so. Appreciate if someone can shed some light on this.
My RDD
My DataSet query
My field query
The output
Thanks and Regards,
CK
Tried removing the highlighted portion below and the data seems to be populated, but character02/projectID is still missing
Removal
Output
is the UD field from a UD table (like UD02.Character02), or from one of the native Tables (like InvcHead.Character02)?
It’s from native Tables (InvcHead.Character02)
Then you don’t need to add UD02. Select the In head table then go to the Exclusions tab and uncheck the Character02 check boxes.
Character02 has been excluded since the beginning 
I removed the UD table and relation but still no luck, the character02 just won’t populate , is there anything that I missed out on?
Needs to be in RDD and the DS Query (Match joins to the RDD relationship):
="SELECT IH.Character02, ...
... LEFT JOIN InvcHead_" +Parameters!TableGuid.Value + " IH ON ...
Also, ensure to add to the dataset
Then you will find available in the fields list.
Yes that is correct
the field expression is as follow:
Tried changing the field to PONum and it works, so my guess is something is broken between the table relationship or something else.
Invchead wasn’t originally on this report RDD, I added it in manually .
Why are you using =First(…
Should just be =Fields!InvoiceNum.Value & " (" & Fields!Character02.Value & “)”
You did rerun this report using the new dataset as well?
I always create a new style to consume the new RDD (Data Definition).
Removed the =First( , still facing the same issue 
Yes this report is using the new dataset, I’m able to see the rest of the changes that I’ve made on the report using that dataset from time to time.
This is very tricky, everything seems to be in place but somehow it just doesn’t want to show itself.
So you’re not getting any errors. Its just that the value is is not coming through?
And you’re sure there is data in there?
Your join in the SSRS query is incorrect. You are trying to join T5 to T1 & T2.
Yes that is correct
100% sure about this as well
Is it possible to do that?
I did this as there are no invoicenum field on T1, thus, I created a calculated field in T2 and set the relationship as follow:
Pretty sure I tried creating the calculated field in T1 as well and set the same relation, but doesn’t work the magic
Thank you for all your enthusiastic reply so far , appreciate it very much.
I found something else but wasn’t sure if this is the cause.
Do we need to specify the dataset in SSRS in order for the data to populate?
I noticed that there are only 4 datasets in the SSRS report.
