Joined: 17 Feb 2009
Online Status: Offline
Posts: 2
Topic: How to supress prompt of database parameter in Cry Posted: 17 Feb 2009 at 5:00am
Hi,
We are using Crystal Reports 2008. In a particular crystal report generated from some SAP WB query, has a parameter (prompt) on month. Now we need to schedule it for monthly execution. But we are still unable to manage the prompt (for a date parameter supplied from SAP BW query) for month automatically. We don,t have API license, so we can not use VBA .Net or Java programming.
Can we manage this database level prompt using Crystal Report formulas. Please suggest how can we manage this prompt so that it can be executed automatically according to schedule.
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4374
Posted: 17 Feb 2009 at 7:04am
haven't had such a situation, but you might try creating a command that would return the correct value for the parameter. you can create a new command in the database expert...add command for the connection that you are using.
This is where I would start. It may not work, but it is where I would start.
Joined: 17 Feb 2009
Online Status: Offline
Posts: 2
Posted: 17 Feb 2009 at 11:42pm
Hi,
Thanks for the reply. But as the data source is SAP BW query, 'Database Expert' does not allow to add command. Please let me know if there is any other way out to resolve this issue.
¨
regards
Avijit
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
IP Logged
