?
Solved

more prompts on infoview than expected

Posted on 2014-09-16
8
Medium Priority
?
289 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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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 2000 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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

If your app took Google’s lash recently, here are the 5 most likely reasons.
In our personal lives, we have well-designed consumer apps to delight us and make even the most complex transactions simple. Many enterprise applications, however, are a bit behind the times. For an enterprise app to be successful in today's tech wo…
Viewers will learn how to use the Hootsuite Dashboard.
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

762 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