I am creating a report. I started with just one dataitem with bunch of columns. Everything was working fine. Underneath that I put in another dataitem set that is pulling from the Sales Invoice line. When I entered this in and then ran the report again, one of the fields just started repeating over and over.
you can see in the picture what I mean. Can anyone help?
This does help. Thank you! By the way Yun Zhu, your site has been instrumental in my learning. Keep it up!
Hi, It looks like you are showing all the values.
If you have only one Header data, try First function.
If you have multiple Header data, try to use Get Data and Set Data.
https://www.youtube.com/watch?v=LXPsbZeiS5w
Hope this helps.
Thanks.
ZHU
Here is the layout. I also changed the properties on these fields so that HideDuplicates is set to DataSet_Result. That stopped some form repeating, but when I import and run the report I get 34 pages. It needs to be just 1.
Then you can probably share your rdlc layout here. Then it is easier to see.
I am using rdlc layout
Then you have placed the fields in a repating section of your report layout.
Are you using a word layout or rdlc layout?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,556
Super User 2024 Season 2
#2
Martin Dráb
228,625
Most Valuable Professional
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (