Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: multiple stored procedure in one report Post Reply Post New Topic
Author Message
jxs5455
Newbie
Newbie


Joined: 17 Jul 2014
Online Status: Offline
Posts: 1
Quote jxs5455 Replybullet Topic: multiple stored procedure in one report
    Posted: 17 Jul 2014 at 9:59am
Hi all,

I'm new to crystal reports and with each requirement I'm becoming familiar with the tool. I have to create a report shows the the daily, weekly, monthly and quarterly report of product brand sales for a specific region.

I am not able to paste an image from my computer. A single report should have 3 separate tables - one for daily sales metrics, the second one for weekly and the third for monthly and one chart that shows the quarterly sales metrics.

The Daily, Weekly and Monthly reports would come from the same stored procedure, only the start date and end dates change. But the results should be placed within a table.
The Quarterly sales graph comes from a different stored procedure.

With all the research I did, I read that it could be achieved using a sub report.

I have few questions.
1) Is it possible to get a report that looks exactly like the image I have attached using crystal report.
2) Should I create 4 sub reports all in one main report.

The report will have just one common parameter, which is the region.

Any help will be appreciated. As soon as I find something, I shall certainly update it here.

Thank you very much
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 23 Jul 2014 at 5:28am
I can't see an image, but using subreports it should be possible. When you link the main report to the subreport, you will probably want to build some formulas that will set your start and end dates for each subreport.

HTH
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.