Crystal Reports Help Needed

[Former Member]

Hi All,

I am new to crystal reports.I got a new requirement and the document contains some format as below

1.brand Weekly Sales and Stock Report- Summary

2.brand Weekly Sales and Stock Report- Details

And under brand Weekly Sales and Stock Report- Summary there one report format

And brand Weekly Sales and Stock Report- Details there is another report format.

So i am unable to understand the requirement.

Please guide me  how to do this report and please explain summary and details report.

PFA

[abhilash_kumar · Accepted solution]

Hi Divya,

We'll be beating around the bush without any knowledge of the database stucture and a Requirements doc.

In any case, I'm assuming you'll need a Subreport. The Subreport would show the Weekly Sales and Stock Details whereas the Main Report can show the Summary.

You can create a Command Object (of whatever way you prefer to bring the data in) for the Main Report and try to include all the Summary calculations in the SQL Query. Do the same for the Subreport except this query should show the Details (which I believe would be at the Group Level - Brand)

-Abhilash

[Former Member · Accepted solution]

Hi Abhilash,

As per my requirement i have view which contains all the fields for both summary and detail report as i shown above.

So now i need to use the same view for main report which will show the summary data and same view for sub report which will show detail data ?

Or any other approach is there .

Please suggest.

[abhilash_kumar · Accepted solution]

You can use the same view, however you'll need to use a Subreport for either showing the Summary data or Detail data.

-Abhilash

[Former Member · Accepted solution]

Hi Abhilash,

I am planning to do this.But unable to create a report with one schema without using any table/query.

Please suggest.

I need to create the sub report with same schema which i am using for main report and i don't want to pull any tables for that schema.Then i will add the sub report to main report.Then i will pass the required fields to sub report as shared variables from main report to show detail report.

Will it work ?

Please suggest

[abhilash_kumar · Accepted solution]

Basically, you'll need a group in the Main Report.

The Subreport would be placed on the Group Footer and to show the Details of that particular customer/transcation/invoice.

Using the 'Change Subreport Links' option, you should link the Group Field in the Main Report with a corresponding field in the Subreport so that the Subreport shows 'relevant' data for that Group.

-Abhilash

[Former Member · Accepted solution]

Hi Abhialsh,

As per my requirement i need to show like this.

Summary report (Main Report)

Brand	Supplier	Sold Qty	Sales Values	Rank
HP OWN BUY	HN-FIFTH & PACIFIC COMPANIES INC.	4509	74825.9	1
HP OWN BUY	HN-GIORGIO ARMANI SPA	1816	62263.7	2

Grand Total :

Detail Report:(Sub report)

Group	Product Code	Barcode	Desc	Categories	Brand	Supplier	Qty Sold	Cost	Sales Values
HOM115	HNHOCTC27779101254	9650397084544	IPAD STAND BAG	COTE & CIEL	HN OWN BUY	HN-PAPER RAIN ASIA LIMITED		1	9.263	7
HOM122	HNHOCTC27945140254	9650397084803	IPHONE4S CARD POUCH	COTE & CIEL	HN OWN BUY	HN-PAPER RAIN ASIA LIMITED		6	23.359	18
HOM146	HNHOCTC27847122254	9650397084612	15" MAC ZIP SLEEVE	COTE & CIEL	HN OWN BUY	HN-PAPER RAIN ASIA LIMITED		1	6.041	5
HOM146	HNHOCTC27848140254	9650397084629	15" MAC ZIP SLEEVE	COTE & CIEL	HN OWN BUY	HN-PAPER RAIN ASIA LIMITED		1	6.041	5
Grand Total

Here both the reports fields coming from same view.

So now what is the best approach to create main report and sub report with same view.

Whether i need to use same view 2 times for both reports or i need to pass required fields to sub report from main report via shared variables.

If we have to use shared variables how i can create the sub report with same datasource without taking the view again.

Please suggest

[abhilash_kumar · Accepted solution]

1) Create a Group on the Brand field and maybe also the Supplier field

2) Suppress the Details Section and insert a summary at the Group Level

3) Insert a Subreport on the Group Footer

4) Use the Change Subreport Links option to link the Brand field in the Main Report with the Brand field in the Subreport

5) Use this subreport show the Details by dropping the required fields on the Details Section

-Abhilash

[Former Member · Accepted solution]

Hi Abhilash,

Thank you

Here i no need to show the details(Sub report) for brand wise.

I need to show sub report after main report(In report footer)

1st i need to show main report(summary report)

After that i need to show sub report(detail report)

So now nee to use same view 2 times for main report and sub report ?

Please suggest

[abhilash_kumar · Accepted solution]

Yes that's right.

Use the same View twice.

-Abhilash