You’re offline. This is a read only version of the page.
129
Hello,
I would like to know that in ssrs report, can we use multi data set in "single grid"? and how ? If I can get some reference or example .
Thankyou
Ayu.
Hi aayushii,
No, I guess you cannot access multiple dataset fields in the single grid. Because the Tablix property will be set for the whole table not for individual text box.
But you can use the First function to get only the first value in the dataset. Refer to standard report PurchPackingSlip where it uses Header and Line table.
To use First function - Select text box - Expression - Datasets - Select the dataset name - On the values select the required field - By default it will have syntax as First(Fields!FieldName.value,"DatasetName")
Thanks,
Girish S.
#1
André Arnaud de Cal...
292,111
Super User 2025 Season 1
#2
Martin Dráb
230,934
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
