two cross data bands that matches output

Stimulsoft Reports.NET discussion
Max Shamanov
Posts: 786
Joined: Tue Sep 07, 2021 10:11 am

Re: two cross data bands that matches output

Post by Max Shamanov »

Hello,

The data is attached in the report resources.

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 »

Sorry, where can I find this?
Max Shamanov
Posts: 786
Joined: Tue Sep 07, 2021 10:11 am

Re: two cross data bands that matches output

Post by Max Shamanov »

Hello,

We attached data file.

Thank you.
Attachments
Demo.xml
(1.79 MiB) Downloaded 134 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 »

Thank you so much! I highly appreciate it. :)
Max Shamanov
Posts: 786
Joined: Tue Sep 07, 2021 10:11 am

Re: two cross data bands that matches output

Post by Max Shamanov »

Hello,

You are welcome!
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,

I have a question. Can you confirm if my understanding was correct.
The report displays suppliers.companyname -- sum of products.unitsinstock under each categories.categoryname
correct?

What is the blank crossdataband for? (screenshot attached - blank crossband.png)
It has the products datasource, categories relation and crossdataband master component (beside it).

I want to fully understand it.

What I am basically after is this:

Code: Select all

Revisions:                            0 1 2 3 4 5 A B C D .1 .2 .3
document 1                            0   2     5 A     D
document 2                                  3 4     B        .2
I will be needing one crossdataband to display revisions (horizontally)
1 crossheaderband to display the document and 1 crossdataband for its revisions

how can I achieve this? can you please help?
I just need an explanation how to achieve this and why use the specific component. I want to fully understand it for me to be able to explain it to new devs, if we'll have them.

I attached my report (my report.png)
Attachments
blank crossband.png
blank crossband.png (29.5 KiB) Viewed 1645 times
my report.png
my report.png (21.11 KiB) Viewed 1645 times
Lech Kulikowski
Posts: 6237
Joined: Tue Mar 20, 2018 5:34 am

Re: two cross data bands that matches output

Post by Lech Kulikowski »

Hello,

> What is the blank crossdataband for? (screenshot attached - blank crossband.png)
It has the products datasource, categories relation and crossdataband master component (beside it).

It is detailed source - Products for calculating the correct sum for each Category.

> how can I achieve this? can you please help?

Please send us your data as it presents in the report for analysis.

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,

I attached sample report and database.

Question: In my report, there is a data

Code: Select all

SC-DOC-0027	Lorem ipsum 27	GA	PBE	RWC	DRW L1
SC-DOC-0027	Lorem ipsum 27	GA	PBE	RWC	DRW L1
How can I display it as:

Code: Select all

                                                                Revision
SC-DOC-0027	Lorem ipsum 27	GA	PBE	RWC	DRW L1  0  1
I want it displayed like this: (sample)

Code: Select all

                                                                             - 0 1 2 3 4 5 6 7 8 A B C D E F G H A. B. C. A1 B1 C1
SC-DOC-0026	Lorem ipsum 26	GA	PBE	REJECTED	 DRW L1	                                                        C1
SC-DOC-0027	Lorem ipsum 27	GA	PBE	RWC	         DRW L1	       0 1
SC-DOC-0028	Lorem ipsum 28	GA	PBE	RWC	         DRW L1	           2 3


Great, thanks!
Attachments
Revisions Report (sample).mrt
(48.62 KiB) Downloaded 174 times
dmasterplanDB.zip
(717.9 KiB) Downloaded 140 times
Lech Kulikowski
Posts: 6237
Joined: Tue Mar 20, 2018 5:34 am

Re: two cross data bands that matches output

Post by Lech Kulikowski »

Hello,

Please check the modified report.

Thank you.
Attachments
Screenshot 2022-09-14 111411.png
Screenshot 2022-09-14 111411.png (133.06 KiB) Viewed 1615 times
Revisions Report (sample).mrt
(29.98 KiB) Downloaded 135 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 »

Thanks devs!

I highly appreciate it. I will raise questions whenever I don't understand it. :)
Post Reply