Dynamic Prompts in Crystal

[Former Member]

I am building Crystal reports from an existing BW queried. The report automatically generates prompts corresponding to the BW prompts, but these are static, and so when the report is moved to a new environment it fails to pick up the new values.

I tried changing the prompt to be dynamic but the result is that all prompts (not just the one I change) fail to display a list of values. How do I put dynamic prompts over BW?

Thanks in advance

Cliff Stinson

Edited by: Cliff Stinson on Dec 13, 2010 4:09 AM

[IngoH · Accepted solution]

Hi,

in the CR Designer the prompts are static but as soon as the report is being published to the BusinessObjects Enterprise server the list of values are dynamically retrieved from the BW System.

ingo

[Former Member · Accepted solution]

Thank you for that. I see there is also an option to "publish" a CR into BW. (I have not yet tried this.) Does the BW publishing also make the prompt dynamic?

[IngoH · Accepted solution]

Hi,

the report is being save to BW and then published to the BusinessObjects Enterprise system and becomes dynamic there.

ingo

[Former Member · Accepted solution]

Does this assume that Publisher is installed?

I have saved the reports to BV and to BOE but the prompts remain static. Hover the client does not have Publisher installed.

Thanks

Cliff

[IngoH · Accepted solution]

Hi,

if you want the prompts to be dynamic you need to publish the report - means save to BW and then publish from BW to BUsinessObjects Enterprise.

regards

ingo

[Former Member · Accepted solution]

The point I am not understanding is what you mean by "publish". If I save a report to BW and ten save it to BOE (Infoview) is that published?

Or do I need to save to BW and click the check box that says "publish". On my client this produces an error. I am told publisher is not installed. Do I need publisher installed before I can publish?

Thanks again

Cliff

[IngoH · Accepted solution]

The point I am not understanding is what you mean by "publish". If I save a report to BW and ten save it to BOE (Infoview) is that published?

>> yes that is being described as publishing in the installation guide for the SAP INtegration Kit.

Ingo

[afzal_kar · Accepted solution]

Hi ,

I am facing the same issue. I did publish the CR report in BW and same i can see in the BOE. But still I am not get tting the cascading prompts as I get in the bex query .please help me out.

Thanks & Regards

Afzal

Edited by: Afzal Kar on Dec 13, 2011 7:52 AM

[afzal_kar · Accepted solution]

Hi Ingo,

Thanks for your post for global cascading Prompts in Crystal Report with reflects in Cr 2008.

I am facing same issues we have bex with selection variables which act as an cascading prompts for the Crystal report built on the top of these bex queries.

In CR 2008 the parameter not being reflected as in bex with cascading prompts.

So far we have updated the CR 2008 with Sp4 service pack in all locations i,e webi, integration kit and CR 2008 in both server and client sites.

Also as you have suggested , I have published the Crystal report  through the Bo publishing wizard. but still there is no impact on the Crystal reports when viewd throuh infoview. Could you please help us out in this regards

Thanks

Afzal Kar

[Former Member]

I can get a dynamic prompt to return data in a new report in Crystal 2008 but other reports created in versions prior to 2008 that use dynamic prompts the list of values is blank when opened in 2008.  I have tried deleting and re-adding the prompt but they still will not pull values.  Does anyone have a workaround for this issue?

[afzal_kar]

Hi Barry, Please check in back end database do you have data for the parameter u are using in the Crystal.

[afzal_kar]

Hi Ingo, Thanks for your post for global cascading Prompts in Crystal Report with reflects in Cr 2008. I am facing same issues we have bex with selection variables which act as an cascading prompts for the Crystal report built on the top of these bex queries. In CR 2008 the parameter not being reflected as in bex with cascading prompts. So far we have updated the CR 2008 with Sp4 service pack in all locations i,e webi, integration kit and CR 2008 in both server and client sites. Also as you have suggested , I have published the Crystal report  through the Bo publishing wizard. but still there is no impact on the Crystal reports when viewd throuh infoview. Could you please help us out in this regards Thanks Afzal Kar

[Former Member]

I had assumed that saving the report to BW and to BOE was what Ingo meant by "publishing" This failed to make the prompts dynamic. I have now heard there is a Publisher but it is not installed at this client. Do we need to install it before the prompts become dynamic?

Thanks

Cliff