two cross data bands that matches output

Stimulsoft Reports.NET discussion
User avatar
dmasterplan
Posts: 143
Joined: Thu Mar 17, 2022 4:04 am
Location: Philippines

Re: two cross data bands that matches output

Post by dmasterplan »

Hi,

What is the rule of crossheaderband? I copied the components from the sample report you provided BUT I am getting duplicates.
Can you please explain how to use crossheaderband, what is its use and what is the rule in using it?

Thank :)
Attachments
Revisions Report (sample 2).mrt
(27.99 KiB) Downloaded 113 times
duplicates.png
duplicates.png (41.84 KiB) Viewed 1317 times
report layout.png
report layout.png (29.19 KiB) Viewed 1317 times
Lech Kulikowski
Posts: 6198
Joined: Tue Mar 20, 2018 5:34 am

Re: two cross data bands that matches output

Post by Lech Kulikowski »

Hello,

For the DataBand is applied grouped data source (Data From Other Data Source).

Thank you.
Attachments
Screenshot 2022-09-15 092408.png
Screenshot 2022-09-15 092408.png (100.48 KiB) Viewed 1312 times
User avatar
dmasterplan
Posts: 143
Joined: Thu Mar 17, 2022 4:04 am
Location: Philippines

Re: two cross data bands that matches output

Post by dmasterplan »

Hi,

Mine is different from what you've shown so I grouped my columns by SQL but I am still getting duplicates.

Report is attached for your checking.

Thanks for your patience.
Attachments
Revisions Report (sample 2).mrt
(28.09 KiB) Downloaded 103 times
duplicates.png
duplicates.png (53.17 KiB) Viewed 1307 times
Lech Kulikowski
Posts: 6198
Joined: Tue Mar 20, 2018 5:34 am

Re: two cross data bands that matches output

Post by Lech Kulikowski »

Hello,

In that case, should be:

Code: Select all

select documentno from cmdrawing
group by documentno
Thank you.
User avatar
dmasterplan
Posts: 143
Joined: Thu Mar 17, 2022 4:04 am
Location: Philippines

Re: two cross data bands that matches output

Post by dmasterplan »

HI,

Yeah, that would be correct BUT in my report I have other 3 to 6 fields after documentno.
How do I do that then?

Thanks
Lech Kulikowski
Posts: 6198
Joined: Tue Mar 20, 2018 5:34 am

Re: two cross data bands that matches output

Post by Lech Kulikowski »

Hello,

For the DataBand needs only grouped data.

Thank you.
User avatar
dmasterplan
Posts: 143
Joined: Thu Mar 17, 2022 4:04 am
Location: Philippines

Re: two cross data bands that matches output

Post by dmasterplan »

Hmmm....
BUT I have 6 fields including documentno.
What exactly do you mean by this?
Lech Kulikowski
Posts: 6198
Joined: Tue Mar 20, 2018 5:34 am

Re: two cross data bands that matches output

Post by Lech Kulikowski »

Hello,

Sorry, maybe we did not exactly understand your task. But vertically documents should be shown once or not? Please provide a sample what result you need.

Thank you.
User avatar
dmasterplan
Posts: 143
Joined: Thu Mar 17, 2022 4:04 am
Location: Philippines

Re: two cross data bands that matches output

Post by dmasterplan »

dmasterplan wrote: Thu Sep 15, 2022 10:22 am Hmmm....
BUT I have 6 fields including documentno.
What exactly do you mean by this?
nevermind, I think I'll figure it out myself.
Grouping other fields I think should do :)

Thank you for your effort!
User avatar
dmasterplan
Posts: 143
Joined: Thu Mar 17, 2022 4:04 am
Location: Philippines

Re: two cross data bands that matches output

Post by dmasterplan »

Hi Devs,

What property is set when you have this icon right here? (encircled in green)

I have finished my report. I appreciate your support and guidance.

I just need to understand this as I needed to be technical and explain this to my boss and colleagues.

Thanks a lot!
Attachments
whatPropertyIsSetWhenYouHaveThis.png
whatPropertyIsSetWhenYouHaveThis.png (7.61 KiB) Viewed 1283 times
Post Reply