Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Help! Post Reply Post New Topic
Author Message
Jayvik
Newbie
Newbie


Joined: 27 Jun 2011
Online Status: Offline
Posts: 3
Quote Jayvik Replybullet Topic: Help!
     Posted: 27 Jun 2011 at 6:14am
Good Afternoon All,
 
I'm not even sure if this can be done, but here's the senario.
 
I'm looking to get two sets of queries on one report, preferably in chart form.
 
So, I have
 
query 1 that gets the total count of the number field based on open.time for last full week.
 
We're looking to get the number of tickets opened based on open.time.
 
Results
 
6/19  42
6/20  114
6/21  77
 
 
query 2 that gets the total count of the number field based on close.time for last full week.
 
We're looking to get the number of tickets closed based on close.time
 
Results
 
6/19  36
6/20  103
6/21  79
 
 
I need to show for example a chart showing 6/19 42 open 36 closed and show on.
 
Hope I didn't make this super confusing...
 
Running Query 1 and Query 2 seperately isn't a problem at all.  That much I know, just getting all the value into one report and then putting them in a chart is what the roadblock is.
 
 
 
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 27 Jun 2011 at 6:31am
do you want a stacked bar chart, side by side bar chart, something else?
when you say "query 1" and "query 2" what you mean? a command, a sql view, something else?


Edited by DBlank - 27 Jun 2011 at 6:50am
IP IP Logged
Jayvik
Newbie
Newbie


Joined: 27 Jun 2011
Online Status: Offline
Posts: 3
Quote Jayvik Replybullet Posted: 27 Jun 2011 at 6:51am
A side by side chart. By query I just mean like running report 1 and report 2, using Select Expert, groups, and summaries.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 27 Jun 2011 at 7:12am
ahhh,
I will assume you have one table with 3 fields (or more)
a PrimaryKey (PK)
a start datetime
an end datetime
You are counting starts by grouping on the startdatetime in one report (set to daily)
You are counting ends by grouping on the end dattime in another report (set to daily)
is that accurate?
Do you have rights to writing a view or stored proc in from your source?
IP IP Logged
Jayvik
Newbie
Newbie


Joined: 27 Jun 2011
Online Status: Offline
Posts: 3
Quote Jayvik Replybullet Posted: 27 Jun 2011 at 7:33am
That's Perfectly accurate.  Unfortunatly i dont have rights to write stored procedures on the database.  So got to thinking, don't see another way other than exporting both reports data only into excel.  Copying the data manually into a new excel with the values (keeping the date common) and let Crystal read the excel as the data source. 
 
Since this is a once time report its not so bad, if it becomes a daily report then I guess you were saying going the stored procedure way?
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 27 Jun 2011 at 7:40am
you can use a crystal command to union the data togetehr into a single data set or query it the same data set twice and join the queries togther for use in one chart
IP IP Logged
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

HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | PRIVACY | CLICK PLAYS | BAEZL

© 2004-2026 Brian Bischof. All Rights Reserved.