Finance | Project Operations, Human Resources, ...

Multiselect lookup in SSRS report

(0) Share

Report

Posted on by kavitha Mani

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.

I have the same question (0)

All responses (11)

Answers (0)

Suggested answer

huijij 19,811 on at

Like (0)

Report

Hi kavitha,

What are your Multiselect parameters? Are you using a custom report?

Was this reply helpful? Yes No
Suggested answer

kavitha Mani 8 on at

Like (0)

Report

Yes, it's a custom report. Multi select parameter is CustAccount.

Was this reply helpful? Yes No
Suggested answer

Komi Siabi 13,109 Most Valuable Professional on at

Like (0)

Report

Hello kavitha Mani,

You should group the entire report by customer ID.

That way, only one customer details on a single report design(page).

Was this reply helpful? Yes No
Suggested answer

kavitha Mani 8 on at

Like (0)

Report

how can i do the grouping, header or body of the report section.

Was this reply helpful? Yes No
Suggested answer

Komi Siabi 13,109 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No
kavitha Mani 8 on at

Like (0)

Report

how to separate each customer account in new page with header details

Was this reply helpful? Yes No
Suggested answer

Komi Siabi 13,109 Most Valuable Professional on at

Like (0)

Report

Add a header.

Was this reply helpful? Yes No
kavitha Mani 8 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Arunraj Rajasekar 1,743 on at

Like (0)

Report

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

Was this reply helpful? Yes No
kavitha Mani 8 on at

Like (0)

Report

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.

Was this reply helpful? Yes No