Page 1 of 2
Alternating Highlight Rows for GroupHeaderBand
Posted: Mon Dec 04, 2023 11:14 pm
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 :/
Re: Alternating Highlight Rows for GroupHeaderBand
Posted: Mon Dec 04, 2023 11:47 pm
by Lech Kulikowski
Hello,
You can use the GroupLine variable.
Thank you.
Re: Alternating Highlight Rows for GroupHeaderBand
Posted: Tue Dec 05, 2023 1:45 am
by ericp
Hi Lech, can you please explain more?
Re: Alternating Highlight Rows for GroupHeaderBand
Posted: Tue Dec 05, 2023 8:50 am
by Lech Kulikowski
Hello,
For the Groups you should use the GroupLine variable instead of the Line.
Thank you.
Re: Alternating Highlight Rows for GroupHeaderBand
Posted: Wed Dec 27, 2023 6:17 am
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.
Re: Alternating Highlight Rows for GroupHeaderBand
Posted: Wed Dec 27, 2023 8:36 am
by Lech Kulikowski
Hello,
Please check the following article:
https://www.stimulsoft.com/en/documenta ... export.htm
Thank you.
Re: Alternating Highlight Rows for GroupHeaderBand
Posted: Wed Dec 27, 2023 5:31 pm
by ericp
I already have a very basic layout and it's still doing the hidden rows though
Re: Alternating Highlight Rows for GroupHeaderBand
Posted: Thu Dec 28, 2023 9:30 am
by Lech Kulikowski
Hello,
Please send us a sample report with test data that reproduces the issue for analysis.
Thank you.
Re: Alternating Highlight Rows for GroupHeaderBand
Posted: Thu Dec 28, 2023 7:27 pm
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.
Re: Alternating Highlight Rows for GroupHeaderBand
Posted: Fri Dec 29, 2023 1:44 pm
by Lech Kulikowski
Hello,
Please select all components, then open the Layout tab and set "Align to Grid".
Thank you.