How to add grouping using parameter in SRSS report

(0) Share

Report

Posted on by Shooowtek

843

Hello,

I am working on creating a new SRSS report. The user is supposed to be able to choose whether to group data based on one parameter or not.

I'm wondering how to solve this because the grouped view is different from the ungrouped view.

In this case, should I make two SRSS reports design, where one will be run when the user clicks on the "group" checkbox, and the other when grouping is not selected?

Should I just create two tablix where one will be visible and the other will not be visible after checking the checkbox?

Or should it still be done somehow differently according to good practices?

I have the same question (0)

All responses (10)

Answers (2)

Verified answer

huijij 19,811 on at

Like (0)

Report

Hi

Did you check the MS document about add groups in ssrs report:

docs.microsoft.com/.../add-or-delete-a-group-in-a-data-region-report-builder-and-ssrs

Was this reply helpful? Yes No
Suggested answer

Arunraj Rajasekar 1,743 on at

Like (1)

Report

Hi Shoowtek,

You appear to have figured it all out. If I understand correctly, you want to print a summary and detailed report based on a toggle parameter.

Both of your options are viable, but each has advantages and disadvantages.

Option 1)

You can design two reports and call them using the parameter. Having two designs gives you the flexibility to make report-specific alignments. You must ensure that the fields in the report's header and footer are properly aligned.

Option 2)

You can create two tablix and set the visibility property based on the parameter.

Was this reply helpful? Yes No
Shooowtek 843 on at

Like (0)

Report

Hello Friends,

How to achieve grouping by load line or sales order line?

Was this reply helpful? Yes No
Arunraj Rajasekar 1,743 on at

Like (1)

Report

If I understand your diagram correctly, you are attempting to display customer information, address, and details table for load line 1 and then continue to load for other lines, correct?

Was this reply helpful? Yes No
Shooowtek 843 on at

Like (0)

Report

Dear Arunraj,

Yes.

Was this reply helpful? Yes No
Verified answer

Arunraj Rajasekar 1,743 on at

Like (0)

Report

Create one tablix (table 1) with one row and one column large enough to hold all three sections and use group by load line to group them.

Insert a new tablix (table 2) within the cell (table 1), with two rows and multiple columns equal to the details table.

Merge all cells in the first row and add two text boxes for address and customer information. You can use the second row for details.

The outermost group by on table 1 will assist you in meeting the requirement.

Was this reply helpful? Yes No
Shooowtek 843 on at

Like (0)

Report

And will this work when I have a number of n-rows in load?

Was this reply helpful? Yes No
Suggested answer

Arunraj Rajasekar 1,743 on at

Like (0)

Report

Yes, the data will be grouped by load lines and sorted one below the other in the outer tablix (table 1). The values in the inner table will only be displayed based on the outer group value.

Was this reply helpful? Yes No
Shooowtek 843 on at

Like (0)

Report

Thank you for the explanation, it seems to be clear to me.

I have one more question. Is it possible to group this data additionally by delivery address? Because it may happen that different load lines may have the same delivery addresses.

Below is a simple example, for better understanding of my problem.

I have four lines of loads with addresses:

Line 1, 3 - delivery address 1,

Line 2, 4 - delivery address 2

Expected view:

Of course, there can be a lot of load lines and addresses, so it would be nice to group this dynamically by address.

Was this reply helpful? Yes No
Suggested answer

Arunraj Rajasekar 1,743 on at

Like (0)

Report

Yes, on the outer group by property, use delivery address instead of load lines, and all should be fine.

Was this reply helpful? Yes No