Multi Column report

[Former Member]

Hi,

I am newbie in Crystal report. I stuck into a design problem of crystal report. I would like to design a report as per the desired-report.png (attached).

My dataset is like report2.xml and relationship specified in relationship-diagram.png (attached)

The problem is crystal report make the Cartesian product of these two table which result in several rows. I am using .Net windows application to build this report.

Could anyone please suggest how to design this type of report ?

[Former Member · Accepted solution]

I have design the report as below.

But the data are not coming as expected. It is coming as shown in previous thread. Data xml is attached with main thread.

[former_member188030 · Accepted solution]

Hi Manish,

Are you facing this issue from CR designer or .NET app?

Does the report work as expected from CR designer?

What version of Crystal Reports are you using?

-Bhushan

[Former Member · Accepted solution]

Hi Bhusan,

I am facing this issue from .net app. I guess some thing is wrong with relationship or I need to configure something in crystal report so that it behave as per desired format. I guess crystal report read record by record and it tries to match diamond record with metal report in which there is no direct relation and might result in Cartesian product.

I am using xml datasource so in designer it shows some dummy data. I am using CRforVS_13_0_9.

[former_member183750 · Accepted solution]

One thing I am not sure of in your reply;

Is this report working anywhere? E.g.; if it does not work in the CR Designer, it will not work in a .net app either.

- Ludek

Senior Support Engineer AGS Product Support, Global Support Center Canada

Follow us on Twitter

[Former Member · Accepted solution]

No it is not working anywhere. When ever I tried to run this report I got the cross product of two table ie ValueWiseSummaryDiamond & ValueWiseSummaryMetal.

Could you please help me in resolving this problem ?

[former_member188030 · Accepted solution]

Hi Manish,

To make the report work fine, it has to work fine from CR designer first.

As you are facing the issue with report design, I would recommend you to post the query in the Crystal Reports Design forum http://scn.sap.com/community/crystal-reports.

One the report works from CR designer as expected, it would work from the application too.

Thanks,

Bhushan

[Former Member · Accepted solution]

HI Bhusan,

You could download the report & test it in your enviroment.

https://www.dropbox.com/s/grtr1dseml3ot54/Report.zip

Please let me know your finding.

[Former Member · Accepted solution]

Hi Bhusan,

My problem got resolved. It is resolved by creating two sub report one for stone section & other for metal section. Now I am getting the desired output.

Thanks for your support.

[former_member188030 · Accepted solution]

Happy to Help!

[former_member188030]

Hi Manish,

To view the report properly from a .NET application, the report has to work fine from CR designer.

I think you are stll in process of designing the report. Could you confirm the same.

Are you facing the issue from CR designer or .NET application?

Does the erport work fine from CR designer?

- Bhushan

Senior Engineer

SAP Active Global Support

Follow us on Twitter

Got Enhancement ideas? Try the SAP Idea Place

Getting started and moving ahead with Crystal Reports .NET applications.

[Former Member]

This is the desired report format

Id	StoneDescription	Rate	Weight	Value	Carat	Id2	Metal	Rate3	Weight4	Value5
1	Diamond	0.35	0.07	4375	0.35	1	Loose Diamond	0	0	0
2	Diamond	1.15	0.23	15525	1.15	2	Silver Utensils	48	20550	976125
3	Diamond	4.25	0.85	63750	4.25	3	Gold 18K	2250	103.21	232223
4	Diamond	0.8	0.16	12800	0.8	4	Gold 22K	2750	204.3	561825
5	Diamond	0.2	0.04	3300	0.2	5	Sovereign	2810	88	247280
6	Diamond	1	0.2	17000	1
7	Diamond	9.43	1.89	165025	9.43
8	Diamond	0.5	0.1	9000	0.5
9	Diamond	1.7	0.34	127500	1.7

This is the Cartesian product what I am getting in report. For example every diamond row is multiplied to metal rows. As shown in example below-

Id	StoneDescription	Rate	Weight	Value	Carat	Id2	Metal	Rate3	Weight4	Value5
1	Diamond	0.35	0.07	4375	0.35	1	Loose Diamond	0	0	0
2	Diamond	1.15	0.23	15525	1.15	1	Loose Diamond	0	0	0
3	Diamond	4.25	0.85	63750	4.25	1	Loose Diamond	0	0	0
4	Diamond	0.8	0.16	12800	0.8	1	Loose Diamond	0	0	0
5	Diamond	0.2	0.04	3300	0.2	1	Loose Diamond	0	0	0
6	Diamond	1	0.2	17000	1	1	Loose Diamond	0	0	0
7	Diamond	9.43	1.89	165025	9.43	1	Loose Diamond	0	0	0
8	Diamond	0.5	0.1	9000	0.5	1	Loose Diamond	0	0	0
9	Diamond	1.7	0.34	127500	1.7	1	Loose Diamond	0	0	0
1	Diamond	0.35	0.07	4375	0.35	2	Silver Utensils	48	20550	976125
2	Diamond	1.15	0.23	15525	1.15	2	Silver Utensils	48	20550	976125
3	Diamond	4.25	0.85	63750	4.25	2	Silver Utensils	48	20550	976125
4	Diamond	0.8	0.16	12800	0.8	2	Silver Utensils	48	20550	976125
5	Diamond	0.2	0.04	3300	0.2	2	Silver Utensils	48	20550	976125
6	Diamond	1	0.2	17000	1	2	Silver Utensils	48	20550	976125
7	Diamond	9.43	1.89	165025	9.43	2	Silver Utensils	48	20550	976125
8	Diamond	0.5	0.1	9000	0.5	2	Silver Utensils	48	20550	976125
9	Diamond	1.7	0.34	127500	1.7	2	Silver Utensils	48	20550	976125
1	Diamond	0.35	0.07	4375	0.35	3	Gold 18K	2250	103.21	232223
2	Diamond	1.15	0.23	15525	1.15	3	Gold 18K	2250	103.21	232223
3	Diamond	4.25	0.85	63750	4.25	3	Gold 18K	2250	103.21	232223
4	Diamond	0.8	0.16	12800	0.8	3	Gold 18K	2250	103.21	232223
5	Diamond	0.2	0.04	3300	0.2	3	Gold 18K	2250	103.21	232223
6	Diamond	1	0.2	17000	1	3	Gold 18K	2250	103.21	232223
7	Diamond	9.43	1.89	165025	9.43	3	Gold 18K	2250	103.21	232223
8	Diamond	0.5	0.1	9000	0.5	3	Gold 18K	2250	103.21	232223
9	Diamond	1.7	0.34	127500	1.7	3	Gold 18K	2250	103.21	232223
1	Diamond	0.35	0.07	4375	0.35	4	Gold 22K	2750	204.3	561825
2	Diamond	1.15	0.23	15525	1.15	4	Gold 22K	2750	204.3	561825
3	Diamond	4.25	0.85	63750	4.25	4	Gold 22K	2750	204.3	561825
4	Diamond	0.8	0.16	12800	0.8	4	Gold 22K	2750	204.3	561825
5	Diamond	0.2	0.04	3300	0.2	4	Gold 22K	2750	204.3	561825
6	Diamond	1	0.2	17000	1	4	Gold 22K	2750	204.3	561825
7	Diamond	9.43	1.89	165025	9.43	4	Gold 22K	2750	204.3	561825
8	Diamond	0.5	0.1	9000	0.5	4	Gold 22K	2750	204.3	561825
9	Diamond	1.7	0.34	127500	1.7	4	Gold 22K	2750	204.3	561825
1	Diamond	0.35	0.07	4375	0.35	5	Sovereign	2810	88	247280
2	Diamond	1.15	0.23	15525	1.15	5	Sovereign	2810	88	247280
3	Diamond	4.25	0.85	63750	4.25	5	Sovereign	2810	88	247280
4	Diamond	0.8	0.16	12800	0.8	5	Sovereign	2810	88	247280
5	Diamond	0.2	0.04	3300	0.2	5	Sovereign	2810	88	247280
6	Diamond	1	0.2	17000	1	5	Sovereign	2810	88	247280
7	Diamond	9.43	1.89	165025	9.43	5	Sovereign	2810	88	247280
8	Diamond	0.5	0.1	9000	0.5	5	Sovereign	2810	88	247280
9	Diamond	1.7	0.34	127500	1.7	5	Sovereign	2810	88	247280

I am unable to understand why it is making Cartesian product when I have specified the relationship. Could you please look into relation diagram ?

Please provide your valuable feedback.