Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Dynamic parameter and repository Post Reply Post New Topic
Author Message
Alex
Newbie
Newbie


Joined: 28 Jan 2008
Location: Canada
Online Status: Offline
Posts: 22
Quote Alex Replybullet Topic: Dynamic parameter and repository
    Posted: 09 Apr 2008 at 12:19pm

Hi all,

I created a dynamic prompt and while running in CR everything works fine.

Once I am trying to save report on server (infoview & business objects) I am getting error message "Failed read data from report... Reason: Failed to read parameter object"

Now my question is should I add dynamic parameter to repository to be able to run report from the server, or there is any way to save report to server as I would with static parameters?

Thanks,

Alex

 
 


Edited by Alex - 09 Apr 2008 at 12:54pm
IP IP Logged
Alex
Newbie
Newbie


Joined: 28 Jan 2008
Location: Canada
Online Status: Offline
Posts: 22
Quote Alex Replybullet Posted: 09 Apr 2008 at 1:00pm

OK, I found some info myself. I am going to post it here in case someone else need it. It looks like dynamic prompts dont have same functionality in CR and BO.

Available when Crystal reports are stored outside of BusinessObjects Enterprise? Available when Crystal reports are published to BusinessObjects Enterprise?

Create dynamic prompts and cascading lists of values.

Yes

Yes

Reuse list of value definitions within a single report at design time.

Yes

Yes

Reuse list of value definitions within multiple reports at design time.

No

Yes

Schedule lists of values.

No

Yes

Populate lists of values from command objects.

Yes

No

All lists of values that are used by managed reports are based on Business Views; however Business Views can themselves be based on command objects. In this way, lists of values can be indirectly based on command objects.

Populate lists of values from report fields.

Yes

No

Populate list of values from Business Views.

No

Yes

Cache lists of values at report run time, and share that list among multiple executing reports.

No

Yes

Schedule lists of values to update themselves on a regular basis.

No

Yes

Schedule portions of lists of values to update themselves on a regular basis, while the remaining portions retrieve their values from the database on demand.

No

Yes

IP IP Logged
johnwsun
Senior Member
Senior Member


Joined: 28 May 2008
Location: Australia
Online Status: Offline
Posts: 179
Quote johnwsun Replybullet Posted: 24 Jun 2009 at 12:01am

Hi all,

I have a same problem found by Alex.

What's the solution? Please advise.

thanks in advance.

 

John

IP IP Logged
wtanner
Newbie
Newbie
Avatar

Joined: 27 Jul 2010
Location: United States
Online Status: Offline
Posts: 3
Quote wtanner Replybullet Posted: 06 Aug 2010 at 3:49am
Hello,
 
Am I reading it correctly that your dynamic paramaters do not work in the server/infoview area, just in the designer?
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet Posted: 06 Aug 2010 at 5:09am

From what I have heard this is an issue except for the the latest version (Enterprise XI 3.1).

IP IP Logged
wtanner
Newbie
Newbie
Avatar

Joined: 27 Jul 2010
Location: United States
Online Status: Offline
Posts: 3
Quote wtanner Replybullet Posted: 06 Aug 2010 at 5:12am
I was able to get the parameters to show using a setup that had the provider be SQLOLEDB, not SQLNCLI. The user will need to log in for each dynamic parameter (not cool) but at least it runs.  I will do some more searching.
 
I am running CR 2008, CR Server 2008, and hitting SQL 2005/2008.
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.031 seconds.