Solved

more prompts on infoview than expected

Posted on 2014-09-16
8
287 Views
Last Modified: 2014-09-21
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
Comment
Question by:pcomb
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
8 Comments
 
LVL 101

Expert Comment

by:mlmcc
ID: 40326814
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
 

Author Comment

by:pcomb
ID: 40326826
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
 
LVL 101

Expert Comment

by:mlmcc
ID: 40327071
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
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

 
LVL 35

Expert Comment

by:James0628
ID: 40327618
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
 

Author Comment

by:pcomb
ID: 40327777
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
 
LVL 101

Expert Comment

by:mlmcc
ID: 40328401
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
 

Author Comment

by:pcomb
ID: 40328455
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
 
LVL 101

Accepted Solution

by:
mlmcc earned 500 total points
ID: 40328509
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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Healthcare organizations in the United States must adhere to the guidance of both the HIPAA (Health Insurance Portability and Accountability Act) and HITECH (Health Information Technology for Economic and Clinical Health Act) for securing and protec…
There are many software programs on offer that will claim to magically speed up your computer. The best advice I can give you is to avoid them like the plague, because they will often cause far more problems than they solve. Try some of these "do it…
This video demonstrates basic masking and how to edit the mask to reveal the desired image.
This video Micro Tutorial shows how to password-protect PDF files with free software. Many software products can do this, such as Adobe Acrobat (but not Adobe Reader), Nuance PaperPort, and Nuance Power PDF, but they are not free products. This vide…

687 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question