Report Design: Parameters, Groups, Counts

Parameters, Groups, Counts

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=726
Printed Date: 04 May 2024 at 4:38am

Topic: Parameters, Groups, Counts

Posted By: LizW
Subject: Parameters, Groups, Counts
Date Posted: 22 May 2007 at 12:44pm

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!

Replies:

Posted By: RobV
Date 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

Posted By: LizW
Date 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!

Posted By: LizW
Date 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!

Posted By: RobV
Date Posted: 23 May 2007 at 9:32am

I shall take a look at this now Liz.

RobV

Posted By: LizW
Date 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

mailto:2lizanne@charter.net - 2lizanne@charter.net Home

mailto:ewyatt@tarrantcounty.com - ewyatt@tarrantcounty.com Work

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!