.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Forum >> Sql Server >> Post New QuestionBookmark and Share Subscribe to Forum

I need HELP getting the ALL Report choice in the drop down to run the Report for ALL

Posted By: burlingtowngal     Posted Date: October 21, 2011    Points:5   Category :Sql Server
I'm pulling from Table A which has 4 Transaction Statuses... '03', '05', '06', & '07'

I've defined a dataset which pulls them...

SELECT 'ALL' AS label, NULL AS value, 0 AS iordr<br>
UNION ALL
SELECT '03' AS label, '03' AS value, 1 AS iordr<br>
UNION ALL
SELECT '05' AS label, '05' AS value, 2 AS iordr<br>
UNION ALL
SELECT '06' AS label, '06' AS value, 3 AS iordr<br>
UNION ALL
SELECT '07' AS label, '07' AS value, 4 AS iordr<br>
ORDER BY iordr

But when I try to define the Parameter, when I select ALL from the drop down of the report, it doesn't pull '03', '05', '06' and '07' - in fact, it pulls NOTHING... how do I make it so that the 'ALL' choice will pull ALL statuses in one report?

Report Parameter Properties:
General
Data Type: Text; Allow null Value
Select parameter visibility: Visible
Available Values:
Select from one of the following options:
Get values from a query
Dataset (the one defined above)
Value field: value
Label field: label
Default Values:
Select from one of the following options: No default value

Responses

No response found. Be the first to respond this post
Post Reply

You must Sign In To post reply
 
 
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more Here
Quick Links For Forum Categories:
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  OOPs  SilverlightIISJQuery
JavaScript/VBScriptBiztalkWPFPatten/PracticesWCFOthers
www.DotNetSpark.comUnAnsweredAll

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend