Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Creating drop down lists for parameters

Posted on 2008-10-24
5
Medium Priority
?
1,455 Views
Last Modified: 2012-05-05
I'm doing another variation on a report I've been working on and I've run into a seemly simple problem that I can't resolve fast enough.

So.  As you can see in the screenshot, I have 2 date prompts that search between a range.  That works great.

I can make the drop-down list, and it populates all the provider names.  But when I click the "Finish" button, it states "The request has multiple errors." and spits tons of exception junk.  I made the dates so easily, I'm not sure where I'm going wrong with this one.

Thanks.
experts.PNG
0
Comment
Question by:IntercareSupport
[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
  • 3
  • 2
5 Comments
 
LVL 5

Expert Comment

by:welchb123
ID: 22799780
We need to see some more information please.  Sounds like you might have an error in the Query.  Click on the query explorer and select your query.   Hit the reuten tabular data button.  Do you get errors?

In Addition
1) what happens when you try to validate the report (Click the toolbar item with a green check mark)?
2) What happens when you validate the Query?
0
 

Author Comment

by:IntercareSupport
ID: 22799996
I'm not sure what the "reuten tabular data" button is.  There's a "Return Tabular Data" option that when clicked says "All of the query data items will be displayed on a single list....." and so on.  When I click past this, I'm given the prompts for my date range and then my providers.  When I select a valid date range and provider, I get a report with nothing in it.  There should be a lot of data.

When I validate the query, it says there are "no errors".  If I keep the filter (below) but remove the drop down on the prompt, Cognos pops up the prompt on the second screen showing all my providers, and then it works fine.

[Provider] like ?@provider?

The problem is that I want my drop down on the prompt page.  I think it's the way I'm tying the "value prompt" drop down to my query.
0
 
LVL 5

Expert Comment

by:welchb123
ID: 22811925
Hmmm... Not clear to me what is going on.  (Just as a best practive note I would not use the @ in the name of the parameter.   I try to keep my parameter names using just numbers and letters with no special characters).   The next step I would take is to go to the query and grab the SQL.  If you have not done this before go to the query navigator and click on the word Queries in the query tree structure.  Then click once on your query and go to the properties.  Click on the line that says Generated SQL/MDX then click on the three periods.  This should open a Generated SQL/MDX window where you can see the SQL cognos is generating.

What database are you using?
Is this a stored procedure Query?
0
 
LVL 5

Accepted Solution

by:
welchb123 earned 2000 total points
ID: 22813458
Just had a thought.  Create a copy of the report.   In your copy delete the prompt page you have created.  In your report Click on Provider and then control click on the date field (to select them both)and click on the generate prompt page button to let Report Studio build the page.  This should build a prompt page with both prompts on it.
0
 

Author Comment

by:IntercareSupport
ID: 23004355
Umm.  I don't know if the points were awarded.  I meant to award all points to welchb123.  I may have messed up.
0

Featured Post

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!

Question has a verified solution.

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

Problem Statement In an SAP BI BO Integration project when a BO universe is built on a BEx query, there can be an issue of unit & formatted value objects not getting generated in a BO universe for some key figures. This results in an issue whereb…
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
This course is ideal for IT System Administrators working with VMware vSphere and its associated products in their company infrastructure. This course teaches you how to install and maintain this virtualization technology to store data, prevent vuln…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
Suggested Courses

715 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