Solved

Creating drop down lists for parameters

Posted on 2008-10-24
5
1,454 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 500 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

Want Experts Exchange at your fingertips?

With Experts Exchange’s latest app release, you can now experience our most recent features, updates, and the same community interface while on-the-go. Download our latest app release at the Android or Apple stores today!

Question has a verified solution.

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

Hi, I am very much excited today since I'm going to share something very exciting Tool used for Analytical Reporting and that's nothing but MICROSTRATEGY. Actually there are lot of other tools available in the market for Reporting Such as Co…
Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
Suggested Courses

631 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