Scheduling Reports with parameters 1

[rb2005]

Hi All,

I have created reports using Business View. I have one parameter for Dynamic Data Connection and one for date. Internal user can schedule those reports. I have set the parameter for connection and I want user to enter date. It's running fine if the user view the reports. But if the user wants to schedule the reports then the parameter promts is not coming, the report is running with the default parameters. I know in Crystal eportfolio or web desktop I can customize schedule but in that case user can see my dynamic data connection if user select parameters. I don't want them to see the connection parameters. Is there any way so I can display the parameter promt at the time of scheduling via web desktop?

I am using Crystal 10.5 both for report and enterprise. I am using enterprise to publish report and run,schedule report. I am not using any custom web application.

Thanks,
RB

 

[ckiklas]

If my users were going to schedule this report (as opposed to viewing it), I would build the report so that the dates were relative, ie Yesterday, Today, Last Full Week, Last Month, etc.

That way, when scheduled, the user selects which relative date to use on the schedule.

 

[rb2005]

Are you using Crystal Enterprise? You can have parameter promt for view only in CE 10. You can not schedule report using parameter, it will take default parameter. You can do that using web desk top in that case user can see all paremetrs. I have found a solution i.e using JAVA you write code for scheduling report with parameter.

 

[ShortyA]

If you set the report to have a parameter (called DateRange for this example) and it's fixed values (or default values) will be "Yesterday", "Last Full Week" etc you can then set up your Record Selection Formula:

and {MyTable.MyDateField}in
switch
(
    {?DateRange} = "Last Full Week", LASTFULLWEEK,
    {?DateRange} = "Last Full Month", LASTFULLMONTH,
    {?DateRange} = "Month To Date", MonthToDate,
    {?DateRange} = "Week To Date From Sunday", WeekToDateFromSun,
    {?DateRange} = "Since 15th May 2005", date(2005,05,15) to currentdate
)

When the user runs the report whether via VIEW or SCHEDULE they should get the parameter option if they are using ePortfolio. The only difference when scheduling is that they will have to select Parameters from the dropdown. Is this what you are experiencing ?

ShortyA

 

[rb2005]

I want to schedule report in CE 10 with parameter. I know how to do that in CE desktop. But the thing is I have three parameters and I set two of them for prompt, but it is showing all the parameter at the time of scheduling. Any one has any clue?

 

[ShortyA]

Under the Crystal Management Console if you select the report, then the Parameters tab. Click on the parameter you DON'T want to see and then there should be a tickbox labelled "Prompt the user for new value(s) when viewing". If you remove the tick here the user will not be prompted.

Hope this helps.
ShortyA