Solved

Creating drop down lists for parameters

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

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

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 …
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.
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

829 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