Alternating Highlight Rows for GroupHeaderBand

Stimulsoft Reports.JS discussion
ericp
Posts: 41
Joined: Mon Aug 21, 2023 9:22 pm

Alternating Highlight Rows for GroupHeaderBand

Post by ericp »

I'm wondering if you can do alternating highlighted rows for GroupHeaderBands. I've tried the expression (Line % 2 == 0), but that only seems to work for DataBands and not GroupHeaderBands :/
Lech Kulikowski
Posts: 6271
Joined: Tue Mar 20, 2018 5:34 am

Re: Alternating Highlight Rows for GroupHeaderBand

Post by Lech Kulikowski »

Hello,

You can use the GroupLine variable.

Thank you.
ericp
Posts: 41
Joined: Mon Aug 21, 2023 9:22 pm

Re: Alternating Highlight Rows for GroupHeaderBand

Post by ericp »

Hi Lech, can you please explain more?
Lech Kulikowski
Posts: 6271
Joined: Tue Mar 20, 2018 5:34 am

Re: Alternating Highlight Rows for GroupHeaderBand

Post by Lech Kulikowski »

Hello,

For the Groups you should use the GroupLine variable instead of the Line.

Thank you.
Attachments
Screenshot 2023-12-05 094952.png
Screenshot 2023-12-05 094952.png (218.92 KiB) Viewed 4174 times
ericp
Posts: 41
Joined: Mon Aug 21, 2023 9:22 pm

Re: Alternating Highlight Rows for GroupHeaderBand

Post by ericp »

Awesome, got it to work on the PDF! For some reason when I try to export it to an Excel file, it has all of these hidden rows. Is there a reason for that? This only seems to be the problem when I add that GroupLine variable.
Attachments
Screen Shot 2023-12-26 at 10.14.59 PM.png
Screen Shot 2023-12-26 at 10.14.59 PM.png (121.33 KiB) Viewed 2996 times
Screen Shot 2023-12-26 at 10.17.36 PM.png
Screen Shot 2023-12-26 at 10.17.36 PM.png (55.95 KiB) Viewed 2996 times
Lech Kulikowski
Posts: 6271
Joined: Tue Mar 20, 2018 5:34 am

Re: Alternating Highlight Rows for GroupHeaderBand

Post by Lech Kulikowski »

Hello,

Please check the following article:
https://www.stimulsoft.com/en/documenta ... export.htm

Thank you.
ericp
Posts: 41
Joined: Mon Aug 21, 2023 9:22 pm

Re: Alternating Highlight Rows for GroupHeaderBand

Post by ericp »

I already have a very basic layout and it's still doing the hidden rows though
Attachments
Screen Shot 2023-12-27 at 9.30.48 AM.png
Screen Shot 2023-12-27 at 9.30.48 AM.png (212.59 KiB) Viewed 2922 times
Lech Kulikowski
Posts: 6271
Joined: Tue Mar 20, 2018 5:34 am

Re: Alternating Highlight Rows for GroupHeaderBand

Post by Lech Kulikowski »

Hello,

Please send us a sample report with test data that reproduces the issue for analysis.

Thank you.
ericp
Posts: 41
Joined: Mon Aug 21, 2023 9:22 pm

Re: Alternating Highlight Rows for GroupHeaderBand

Post by ericp »

Please see the attached mrt file. I've gone ahead and applied the GroupLine % 2 == 0 expression, and it looks awesome in the PDF preview, but when I try to save to excel, it gets all weird with the hiding rows.
Attachments
ProjectChange-Test Alternating Rows.mrt
(70.95 KiB) Downloaded 146 times
Lech Kulikowski
Posts: 6271
Joined: Tue Mar 20, 2018 5:34 am

Re: Alternating Highlight Rows for GroupHeaderBand

Post by Lech Kulikowski »

Hello,

Please select all components, then open the Layout tab and set "Align to Grid".

Thank you.
Attachments
Screenshot 2023-12-29 144230.png
Screenshot 2023-12-29 144230.png (320.36 KiB) Viewed 2799 times
Post Reply