Talk with the Author
 Crystal Reports Forum : General Information : Talk with the Author
Message Icon Topic: Parameterizing Crystal Report Post Reply Post New Topic
Author Message
Pramod009
Newbie
Newbie
Avatar

Joined: 13 May 2015
Location: India
Online Status: Offline
Posts: 1
Quote Pramod009 Replybullet Topic: Parameterizing Crystal Report
    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
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3558
Quote hilfy Replybullet 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
DecisionFirst Technologies - a Proviti Enterprise
9-Time SAP BusinessObjects Partner of the Year.
www.decisionfirst.com
IP IP Logged
Vimal Nair
Newbie
Newbie
Avatar

Joined: 29 Dec 2014
Location: United Arab Emirates
Online Status: Offline
Posts: 26
Quote Vimal Nair Replybullet 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
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.016 seconds.