Notifications
Announcements
Selecting a multiple parameter in multi select lookup instead of getting multiple customer report am getting only one customer report. but in the body of report all the parameter data's are merged here i need every new customer account data in new page.
Hi kavitha,
What are your Multiselect parameters? Are you using a custom report?
Yes, it's a custom report. Multi select parameter is CustAccount.
Hello kavitha Mani,
You should group the entire report by customer ID.
That way, only one customer details on a single report design(page).
how can i do the grouping, header or body of the report section.
Create a table and group by customer ID. This table will contain your entire design. Also on the group property, specify the page break parameters.
how to separate each customer account in new page with header details
Add a header.
Please find the below attachment,
here our requirement is whenever the client code changes it should come in the new page of the report, since we are passing multiple client code as a parameter. The highlighted part in attachment is a header section of the report and the below is body section.
Hi Kavitha,
You should not assign the field value directly from the dataset in the header for your requirement.
Add a client code field to the report body section and hide it. Take note of the name of this field in the properties. Assume the field is called Textbox1.
Enter "=Reportitems!textbox1.value" in the header where you want this value to appear. When the clientcode on the report page changes, the header will select the value of the hidden text box.
docs.microsoft.com/.../built-in-collections-reportitems-collection-references-report-builder
Text box doesn't have page break but it was there in Tablix property. so not able to do the page break could you help me how to achieve it.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 663 Super User 2026 Season 1
Abhilash Warrier 289 Super User 2026 Season 1
Martin Dráb 232 Most Valuable Professional
