Page 3 of 4
Re: two cross data bands that matches output
Posted: Thu Sep 15, 2022 6:01 am
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
Re: two cross data bands that matches output
Posted: Thu Sep 15, 2022 7:25 am
by Lech Kulikowski
Hello,
For the DataBand is applied grouped data source (Data From Other Data Source).
Thank you.
Re: two cross data bands that matches output
Posted: Thu Sep 15, 2022 9:02 am
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.
Re: two cross data bands that matches output
Posted: Thu Sep 15, 2022 9:21 am
by Lech Kulikowski
Hello,
In that case, should be:
Code: Select all
select documentno from cmdrawing
group by documentno
Thank you.
Re: two cross data bands that matches output
Posted: Thu Sep 15, 2022 9:35 am
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
Re: two cross data bands that matches output
Posted: Thu Sep 15, 2022 9:44 am
by Lech Kulikowski
Hello,
For the DataBand needs only grouped data.
Thank you.
Re: two cross data bands that matches output
Posted: Thu Sep 15, 2022 10:22 am
by dmasterplan
Hmmm....
BUT I have 6 fields including documentno.
What exactly do you mean by this?
Re: two cross data bands that matches output
Posted: Thu Sep 15, 2022 8:21 pm
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.
Re: two cross data bands that matches output
Posted: Fri Sep 16, 2022 12:11 am
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!
Re: two cross data bands that matches output
Posted: Fri Sep 16, 2022 6:56 am
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!