on 12-15-2013 7:53 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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
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
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
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
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
User | Count |
---|---|
61 | |
9 | |
7 | |
6 | |
6 | |
6 | |
5 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.