Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Creating drop down lists for parameters

Posted on 2008-10-24
5
Medium Priority
?
1,456 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
  • 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

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

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

Hello, In my precious Article  (http://www.experts-exchange.com/Database/Reporting/A_15280-Create-Project-in-Microstrategy-Part-I.html)we saw the Configuration part for Microstrategy which included Metadata Creation and DataSource Preparation as …
I recently went through setting up a JasperReports Server using the AWS EC2 instance, and this article will cover some basic administration tasks I had to perform.
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…
Suggested Courses
Course of the Month11 days, 6 hours left to enroll

885 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