duplicate prompts while publishing report with dynamic promt

building reports crystal reports
1

Hi All,

Using Dynamic prompts in Crystal reports is creating duplicate prompts while publishing reports withiin the framework, causing password to be set each time report is published.

The prompts from business view SHOULD not cause password to be set each time report is published…this defeats the purpose of using business views. Can someone help?

thanks,
hena

hena (BOB member since 2010-08-17)

2

Using Dynamic prompts in Crystal reports is “creating duplicate prompts” while publishing reports withiin the framework, causing “password to be set each time report is published”.
Your query is not clear :nonod:
–Krishnam

Krishnam (BOB member since 2010-11-25)

3

Let me re-frame the question:

When are duplicate prompts created and how to solve them?
This is happening when reports are being developed locally…
and then published to BOE framework.

I do not know the details but what are the typical scenarios where duplicate prompts can occur?

hena (BOB member since 2010-08-17)

4

Double check the user and password settings.

In Business View Manager, Open the Data Connection for the LOV in question, and choose Never Prompt for password in user/passwd screen, save the DC and Schedule the list of values and run the report in Infoview.

BO_Chief :us: (BOB member since 2004-06-06)

5

I had observed a single prompt created asking the input twice in crystal. The scenario is as below

If you are creating a dynamic prompt using @Prompt in universe, and the select text being different within the prompt

For example lets say i have a prompt definition for a prompt ‘username’ in in universe as below
username in @Prompt(‘select username’,‘a’,‘object’,multi,)
or
username in @Prompt(‘select user’,‘a’,‘object’,multi,)

This prompt when used in crystal will prompt you twice in the report even if you have a single prompt created in the universe.
This is one scenario where duplicate prompts are created.

–Krishnam

Krishnam (BOB member since 2010-11-25)

6

The dynamic Cascading List of Values for the prompt is based of a Business View and not a universe. Yet it is creating duplicate prompts when published in Business Objects Enterprise.

hena (BOB member since 2010-08-17)

7

I have been creating a dynamic prompt base on a SQL Command which has input parameters and guess what…it creates duplicate prompts…

which I think is the dumbest behaviour ever in crystal report. According to SAP, this is by design… (I wonder who is “smart” enough to design something like that.)

Anyway, turns out crystal reports creates duplicate prompts when you try to hit several times a data source that has input parameters. it won’t appear only once because it is using the data source for different purposes.

First it is going to retrieve the data for the dynamic prompts. (You will notice that the name of the prompt will change.) Then it will prompt again to retrieve data for the final result.

I also encounter the Credential problem. It ask me for a credential details in between 2 prompt panel. For me it occurs because I am hitting the data source multiple times with the same parameter which it did not recognise because I changed the parameter config. I think this could not be handled by the Business View Manager but I never managed to solved.
Edited:
By the way, using the universe, this type of problem should not occur unless you have 2 different description for a particular parameter

Rayden (BOB member since 2010-01-27)