Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Parameters, Groups, Counts Post Reply Post New Topic
Author Message
LizW
Newbie
Newbie
Avatar

Joined: 22 May 2007
Location: United States
Online Status: Offline
Posts: 6
Quote LizW Replybullet Topic: Parameters, Groups, Counts
    Posted: 22 May 2007 at 12:44pm
Confused  I am new to CR, need major help.  I have to design a report based on multiple manipulations of a set of data.  Some of the Report columns use a parameter date, some do not.  One column is based on a closed status, one column is based on both closed and open status of tickets.  It would look like this:
 
 
UnitName   Tickets opened, Tickets closed, Tickets currently opened, Oldest open ticket, Date of Oldest Open Ticket.
 
Can I attach a parameter to individual fields?  (Tickets Opened and Tickets closed would be user input parameter dates).
 
Can I filter/select then group and count records AFTER reading records?
 
Help!
Help! I've Crystaled and Can't Get Up!
IP IP Logged
RobV
Newbie
Newbie
Avatar

Joined: 26 Apr 2007
Location: United Kingdom
Online Status: Offline
Posts: 13
Quote RobV Replybullet Posted: 23 May 2007 at 1:14am
Liz,
 
Please post a workable sample of data. This is probably straight forward but difficult to be sure without seeing the raw data.
 
RobV
IP IP Logged
LizW
Newbie
Newbie
Avatar

Joined: 22 May 2007
Location: United States
Online Status: Offline
Posts: 6
Quote LizW Replybullet Posted: 23 May 2007 at 8:26am

Thanks for such a prompt reply to a post, it is impressive!I do not know how much data you need, so here is a smattering of info, will post results in a separate reply:

wdManager Open Time Close Time Status Flag Incident ID Team
phil shoup 5/1/2007 16:04 open TRUE L2-54453 servicedesk
phil shoup 5/22/2007 15:17 open TRUE L2-54431 servicedesk
phil shoup 5/12/2007 15:15 alert stage 1 TRUE L2-54430 team1
phil shoup 5/22/2007 15:36 open TRUE L2-54439 team1
phil shoup 5/22/2007 15:09 5/22/2007 16:18 closed FALSE L2-54427 team2
phil shoup 5/2/2007 15:30 5/22/2007 15:32 closed FALSE L2-54435 team2
phil shoup 5/22/2007 16:08 updated TRUE L2-54454 team2
phil shoup 5/22/2007 17:01 updated TRUE L2-54466 team2
phil shoup 5/22/2007 15:57 5/22/2007 15:59 closed FALSE L2-54451 teamHW
phil shoup 5/22/2007 16:53 5/22/2007 16:55 closed FALSE L2-54463 teamJuv
eric wersal 5/22/2007 16:55 open TRUE L2-54462  
eric wersal 5/22/2007 17:57 updated TRUE L2-54470  
john thompson 5/22/2007 16:17 5/22/2007 16:50 closed FALSE L2-54457  
kurt buchert 5/22/2007 15:58 updated TRUE L2-54450  
rodney crockett 5/22/2007 15:08 updated TRUE L2-54423  
steve doane 5/22/2007 17:05 updated TRUE L2-54467  
terry williams 5/22/2007 17:56   open TRUE L2-54469  
Help! I've Crystaled and Can't Get Up!
IP IP Logged
LizW
Newbie
Newbie
Avatar

Joined: 22 May 2007
Location: United States
Online Status: Offline
Posts: 6
Quote LizW Replybullet Posted: 23 May 2007 at 8:28am

Here is what I am trying to get:

wdManager Assignment Opened in DateRange Closed in DateRange Currently Open Oldest Ticket Number Oldest Ticket Time
phil shoup 7 4 6 L2-54430 5/1/2007 16:04
  team1 1 0 2 L2-54453 5/12/2007 15:15
  team2 3 2 2 L2-54454 5/22/2007 16:08
  teamHW 1 1 0  
  teamJuv 1 1 0  
  servicedesk 1 0 2 L2-54430 5/1/2007 16:04
             
Help! I've Crystaled and Can't Get Up!
IP IP Logged
RobV
Newbie
Newbie
Avatar

Joined: 26 Apr 2007
Location: United Kingdom
Online Status: Offline
Posts: 13
Quote RobV Replybullet Posted: 23 May 2007 at 9:32am
I shall take a look at this now Liz.
 
RobV
 
IP IP Logged
LizW
Newbie
Newbie
Avatar

Joined: 22 May 2007
Location: United States
Online Status: Offline
Posts: 6
Quote LizW Replybullet Posted: 05 Jun 2007 at 11:53am
Rob, I never did see a post after this.  I believe I gave you my work email address, and it can be rather tacky about blocking emails.  If you did send a reply, would you resend it to my home email?
 
Thanks,
 
Liz
2lizanne@charter.net             Home
 
 
PS, we are ordering the CR Encyclopedia, and have checked the chapters posted online.  Chapter 10 - Cross Tab - sounds like it is going to be a possible solution....  Yipee if it is!
Help! I've Crystaled and Can't Get Up!
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.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.