Depending on call volume, using the Min/Max functions may cause confusion with the users. If they put in a date range of 8/1/2006 to 8/31/2006, looking for all tickets in August, but that group only had tickets in the middle of the month, the report would show dates of 8/13 - 8/19 or some other bizarre range. They might think they are missing tickets. Not an insurmountable issue, but something to be aware of.
I haven't done this and it might not be worth the effort, but what if you were to create a small, hidden form that stored the start/end dates. When the user enters start/end dates, push the values over, then open your report. Add a sub-report to your Crystal report to extract those values and you have the actual date range for displaying.
Thad
"Perfection is achieved, not when there is nothing more to add, but when there is nothing left to take away." - Antoine de Saint-Exupéry
| "Roney Samuel"
<[EMAIL PROTECTED]>
Sent by: "Action Request System discussion list(ARSList)" <[email protected]> 09/22/2006 08:37 AM
|
|
** Dear Shafqat,
I am sure you have but just to verify I believe you have set the reporting server on the User tool. What frank is pointing out is the only way to get a date range report with remedy and crystal. You sort the value with remedy and make sure that only the records with the specified date range are passed to crystal. Once crystal receives the records you can use the Minimum and the Maximum functions on crystal to display the exact date range on the report. Hope this helps.
Regards,
Roney Samuel Varghese
On 9/22/06, Blodgett, Jamie <[EMAIL PROTECTED]> wrote:
**
Or, have the report be a sub-report of a blank report pulling data such as all active Groups from the group form, but hide the group data. Then you can actually have Crystal control the query criteria and print data entered.
Jamie Blodgett
Rinker Materials
-----Original Message-----
From: Action Request System discussion list(ARSList) [mailto: [email protected]]On Behalf Of Frank Caruso
Sent: Friday, September 22, 2006 8:55 AM
To: [email protected]
Subject: Re: Crystal Reports with ARS
** You could create a Crystal function which calcs the MINIMUM start date and the MAXIMUM end date and the put those on the report
On 9/22/06, Shafqat Ayaz <[EMAIL PROTECTED]> wrote:
**
Thanks Frank and Dwayne, that works!
Is there any way to print the parameters on the report? for example what i would like to do is have the report run from a start date and a end date plus the Assigned To, I have got the report to run, I can have the Assigned To name in the report as it is a report field, is there any way to print the Start Date and End Date without doing a double prompt? what I mean is that I am entering these on a form and passing them to the report, but obviously the dates don't get passed, if I put a prompt field, then Crystal comes up with a dialog box and then puts the dates in.
The other problem I am having is that if I put the report in the Report form it does not run, if I embed it then it runs fine, but intermittantly when i press the button nothing happens, I have to close the user tool and re-open and then on the 2nd or 3rd try it works.
Thanks once again, I really appreciate your help
shaf
Frank Caruso <[EMAIL PROTECTED]> wrote:
** Remedy is basically passing Crystal a Record Set of data. You can prompt for a Crustal parameter and use it in the Selection criteria,however, it won't alter the result set. As mentioned in the last post, try and produce the desired set of data from Remedy first. Or, you can prompt for a parameter, but instead of using it in the Selection criteria of the report you could use it in Suppressing\Showing Detail sections that meet your criteria. I would opt for producing the correct record set from the User tool.
On 9/22/06, Dwayne Martin < [EMAIL PROTECTED]> wrote:
Hi Shafqat,
Try working your selection into the Qualification of the Open
Window action of the Active Link, eg:
'Assigned To' = $Assigned To$
The second "$Assigned To$" refers to the field on the local
form, and can be some other field besides "Assigned To".
Dwayne Martin
James Madison University
---- Original message ----
>Date: Fri, 22 Sep 2006 01:27:08 -0700
>From: Shafqat Ayaz < [EMAIL PROTECTED]>
>Subject: Crystal Reports with ARS
>To: [email protected]
>
> **
> Hi Gang
>
> I have written a Crystal Report, it is a very basic
> report that runs on the HelpDesk form. The problem I
> am having is this
> The report is supposed to take a parameter of the
> Assigned To name and then fetch all records for that
> user, now when I run this report from within
> Crystal, it works fine, but when I run it from an
> A/L within a form, for example press a button to run
> the report, the report comes back and asks for the
> user name and then totally ignores it! it just
> fetches all the record on the database. I have tried
> all options for example Embedded, Local, and
> Reporting Form, all do the same.
> Environment is Oracle 9.2 ARS 5.1 Crystal Reports
> V10
> Any help greatly appreciated.
>
> thanks
>
> shafqat
>
> Shafqat Ayaz
>
>
>
> ------------------------------------------------
>
> Get your email and more, right on the new Yahoo.com
> __20060125_______________________This posting was
> submitted with HTML in it___
Dwayne Martin
Computing Support
James Madison University
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
--
Frank Caruso
Specific Integration, Inc.
Senior Remedy Engineer
www.specificintegration.com
703-376-1249 __20060125_______________________This posting was submitted with HTML in it___
Shafqat Ayaz
Do you Yahoo!?
Everyone is raving about the all-new Yahoo! Mail. __20060125_______________________This posting was submitted with HTML in it___
--
Frank Caruso
Specific Integration, Inc.
Senior Remedy Engineer
www.specificintegration.com
703-376-1249 __20060125_______________________This posting was submitted
with HTML in it___
CONFIDENTIALITY: The information contained in this transmission may contain
privileged and confidential information. It is intended only for the use
of the person(s) named above. If you are not the intended recipient, you
are hereby notified that any review, dissemination, distribution or duplication
of this communication, and the information contained in it, is strictly
prohibited. If you are not the intended recipient, please contact the sender
and immediately destroy all copies of the original message.
__20060125_______________________This posting was submitted
with HTML in it___
__20060125_______________________This posting was submitted with HTML in
it___
***IMPORTANT NOTICE: This communication, including any attachment, contains information that may be confidential or privileged, and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message is strictly prohibited. Nothing in this email, including any attachment, is intended to be a legally binding signature.***
