Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 294
  • Last Modified:

more prompts on infoview than expected

I have some filters using conditions from the universe but I have more prompts than filters

I have for example 7 conditions from the universe they have 10 prompts in them. When I run the report I see 15 prompts. How can i determine where the additional prompts are coming from ?
0
pcomb
Asked:
pcomb
  • 4
  • 3
1 Solution
 
mlmccCommented:
Which reporting tool are you using?

If it is Crystal, do you have a subreport?
Does it have parameters?
If so if they aren't linked to the main report you will get prompted.

mlmcc
0
 
pcombAuthor Commented:
I am using info view it's one report with prompts but I am getting a list of 17 prompts but I can only find 12 so not sure where the others are coming from
I did not create the repprt
0
 
mlmccCommented:
What reporting tool?
Crystal, DeskI, WebI?

The reporting tool type will help determine how to find the prompts.

If it is a Crystal Report, can you upload the report file?

If it is a WebI it may be helpful to see a screen shot of the Edit Query screen.

mlmcc
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
James0628Commented:
This is something of a shot in the dark, but with the old BO (before the merge with CR), you could create prompts by just entering them in a query, and if you used the same prompt more than once, you had to make sure to spell it the same each time.  If you had a typo, for example, that created a separate prompt.

 If your prompts are anything like that, I'd check the spelling, etc.  Case may or may not be signficant.

 Like I said, just a shot in the dark, but it sounds like it might be something like that.  Maybe some of your "conditions" have prompts that should be duplicates, but aren't, because the names are different.

 James
0
 
pcombAuthor Commented:
hi its Webi
There are no obvious misspellings or duplications

I have a report that uses x conditoins (defined in universe) those conditions contain x +3 @prompts. I have added these conditions to the Query filters section.
However when I run the report I get prompted for x + 6 prompts. none of these are duplicates, there are some for fields that are not in any of the prompts I see in the conditions in the universe.

I cannot see anywhere else these filters could be added?


thanks
0
 
mlmccCommented:
Are there any mandatory prompt in the universe?
ie if you remove the filters from the reports are there still values prompted for?

One way to try to find them would be to remove a filter the run the query to see the prompt screen

Are any of the prompts date ranges that would generate 2 prompts?

mlmcc
0
 
pcombAuthor Commented:
it seems to be one specific report. If I delete all the prompts from this report I still get prompted. If I use a difference version of that report and delete all prompts I do not get prompted.

I think I may just have to scrap that report as I cant see how its still prompting

thx
0
 
mlmccCommented:
There can be objects in the universe that can be added to the select part that include a prompt.  We have several dimensions that have that.  The prompt is to get information from the user to use in the report or in one case to allow the user to choose which of 2 fields to include in the report.

You could start eliminating fields from the select or compare the 2 select lists to see the differences.  Probably one of the objects includes a prompt.  

Are the 2 reports running against the same universe?

mlmcc
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now