Solved

Creating drop down lists for parameters

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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Hi, In my previous Article  (http://www.experts-exchange.com/Database/Reporting/A_15199-Introduction-to-Microstrategy.html)I discussed some basic understanding of Microstrategy that how we can get in Intro of Microstrategy (MSTR). Now it's tim…
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.
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

708 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now