Print Page | Close Window

Parameterizing Crystal Report

Printed From: Crystal Reports Book
Category: General Information
Forum Name: Talk with the Author
Forum Discription: Ask Brian questions about his books and give him your comments. Like the book? Hate the book? Have suggestions? Let me know!
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=21551
Printed Date: 26 Apr 2024 at 4:41pm


Topic: Parameterizing Crystal Report
Posted By: Pramod009
Subject: Parameterizing Crystal Report
Date Posted: 16 Jun 2015 at 6:27pm
Hi Guys,

I have some requirement like : Fetching the data for all user on to the report. Now the scenario is :

There are around 500 users and total records fetched from the table are 3.5 millions.

This took a huge time when i run the report, i.e around 4 hours to access the records but the data never showed up on to the report as its not able to create around 30-40 thousands of pages.

Please let me how we can improve this report.

I have all the data on a table its just to pull the columns based on the date.

Please let me know ...

Thanks in Advance...

-------------
Warm Regards,
Pramod


Replies:
Posted By: hilfy
Date Posted: 22 Jun 2015 at 5:41am
Is there a specific time-period that you want to pull data for? In that case you can add either a "range" parameter for the start and end dates or a separated start date and end date parameter. You would then use these parameters in the Select Expert to filter on the dates. The formula in the Select Expert would look something like this:

Range Parameter
{MyTable.DateField} in {?Date Range Param}

Two date parameters
{MyTable.DateField} >= {?Start Date} and
{MyTable.DateField} <= {?End Date}

Note that sometimes the range parameter doesn't pull data that for the start date and/or end date - just the data between the two.

-Dell

-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics

Posted By: Vimal Nair
Date Posted: 23 Feb 2016 at 5:29pm
Create a parameter for user and date and make user as optional parameter. If you need a particular user for all date range you can filter by using user parameter. And for improvement purpose you can take the report according to alphabetical order. This might require multiple scheduling of the report but still you will get an output. If it has to be run reccuring create a report and create run schedule with user parameter.
 
User parameter will be like User Like 'A', User like 'B'. etc


-------------
Born To Live


Print Page | Close Window