8
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,
Please see PayrollworkerPaycheck>Report design in AOT, which is very similar to your requirement. Examine the way the tablix fields and header values are referred to.
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.
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
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.
Add a header.
how to separate each customer account in new page with header details
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 can i do the grouping, header or body of the report section.
Hello kavitha Mani,
You should group the entire report by customer ID.
That way, only one customer details on a single report design(page).
Yes, it's a custom report. Multi select parameter is CustAccount.
#1
André Arnaud de Cal...
292,884
Super User 2025 Season 1
#2
Martin Dráb
231,760
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
Share
Report
All responses (
Answers (
