two cross data bands that matches output
- dmasterplan
- Posts: 143
- Joined: Thu Mar 17, 2022 4:04 am
- Location: Philippines
Re: two cross data bands that matches output
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
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 (41.84 KiB) Viewed 1317 times
-
- report layout.png (29.19 KiB) Viewed 1317 times
-
- Posts: 6198
- Joined: Tue Mar 20, 2018 5:34 am
Re: two cross data bands that matches output
Hello,
For the DataBand is applied grouped data source (Data From Other Data Source).
Thank you.
For the DataBand is applied grouped data source (Data From Other Data Source).
Thank you.
- Attachments
-
- Screenshot 2022-09-15 092408.png (100.48 KiB) Viewed 1312 times
- dmasterplan
- Posts: 143
- Joined: Thu Mar 17, 2022 4:04 am
- Location: Philippines
Re: two cross data bands that matches output
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.
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 (53.17 KiB) Viewed 1307 times
-
- Posts: 6198
- Joined: Tue Mar 20, 2018 5:34 am
Re: two cross data bands that matches output
Hello,
In that case, should be:
Thank you.
In that case, should be:
Code: Select all
select documentno from cmdrawing
group by documentno
- dmasterplan
- Posts: 143
- Joined: Thu Mar 17, 2022 4:04 am
- Location: Philippines
Re: two cross data bands that matches output
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
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
-
- Posts: 6198
- Joined: Tue Mar 20, 2018 5:34 am
Re: two cross data bands that matches output
Hello,
For the DataBand needs only grouped data.
Thank you.
For the DataBand needs only grouped data.
Thank you.
- dmasterplan
- Posts: 143
- Joined: Thu Mar 17, 2022 4:04 am
- Location: Philippines
Re: two cross data bands that matches output
Hmmm....
BUT I have 6 fields including documentno.
What exactly do you mean by this?
BUT I have 6 fields including documentno.
What exactly do you mean by this?
-
- Posts: 6198
- Joined: Tue Mar 20, 2018 5:34 am
Re: two cross data bands that matches output
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.
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.
- dmasterplan
- Posts: 143
- Joined: Thu Mar 17, 2022 4:04 am
- Location: Philippines
Re: two cross data bands that matches output
nevermind, I think I'll figure it out myself.dmasterplan wrote: ↑Thu Sep 15, 2022 10:22 am Hmmm....
BUT I have 6 fields including documentno.
What exactly do you mean by this?
Grouping other fields I think should do
Thank you for your effort!
- dmasterplan
- Posts: 143
- Joined: Thu Mar 17, 2022 4:04 am
- Location: Philippines
Re: two cross data bands that matches output
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!
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 (7.61 KiB) Viewed 1283 times