Page 2 of 4

Re: two cross data bands that matches output

Posted: Thu Sep 01, 2022 7:41 am
by Max Shamanov
Hello,

The data is attached in the report resources.

Thank you.

Re: two cross data bands that matches output

Posted: Thu Sep 01, 2022 8:32 am
by dmasterplan
Sorry, where can I find this?

Re: two cross data bands that matches output

Posted: Thu Sep 01, 2022 12:17 pm
by Max Shamanov
Hello,

We attached data file.

Thank you.

Re: two cross data bands that matches output

Posted: Thu Sep 01, 2022 2:15 pm
by dmasterplan
Thank you so much! I highly appreciate it. :)

Re: two cross data bands that matches output

Posted: Thu Sep 01, 2022 2:51 pm
by Max Shamanov
Hello,

You are welcome!

Re: two cross data bands that matches output

Posted: Tue Sep 13, 2022 10:08 am
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)

Re: two cross data bands that matches output

Posted: Tue Sep 13, 2022 10:27 am
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.

Re: two cross data bands that matches output

Posted: Wed Sep 14, 2022 2:39 am
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!

Re: two cross data bands that matches output

Posted: Wed Sep 14, 2022 9:14 am
by Lech Kulikowski
Hello,

Please check the modified report.

Thank you.

Re: two cross data bands that matches output

Posted: Thu Sep 15, 2022 2:22 am
by dmasterplan
Thanks devs!

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