Parameter Prompt List & Filter selection

I have created a parameter for a report that displays a drop-down list of
values to pick from. The parameter values are defined as being "loaded from
a query." The problen is that I need to have the option of blanks as a valid
value in this parameter so that the report can be generated for "all" values
too. Note: The query is the result of a dataset which executes an MDX
statement .
Part II of my problem is that I want to be able to filtermy results to say
either "part number = parameter value", or part number <> " ". I can't seem
to conditionally set the filter. Perhaps I am using the wrong syntax. Note:
I have tried placing the filter on both the dataset and the matrix object.
Any help would be greatly appreciated!
PBOn Mar 8, 12:37 pm, ppbedz <ppb...@.discussions.microsoft.com> wrote:
> I have created a parameter for a report that displays a drop-down list of
> values to pick from. The parameter values are defined as being "loaded from
> a query." The problen is that I need to have the option of blanks as a valid
> value in this parameter so that the report can be generated for "all" values
> too. Note: The query is the result of a dataset which executes an MDX
> statement .
> Part II of my problem is that I want to be able to filtermy results to say
> either "part number = parameter value", or part number <> " ". I can't seem
> to conditionally set the filter. Perhaps I am using the wrong syntax. Note:
> I have tried placing the filter on both the dataset and the matrix object.
> Any help would be greatly appreciated!
> PB
If you install Service Pack 2, you will have 'Select All' as an
available option for multi-select parameters. For the most part,
filters can only do and-ing, not or-ing. Hope this helps.
Regards,
Enrique Martinez
Sr. SQL Server Deveoper

Parameter entered has the wrong format.. you must be ....me!

Hi

I have the problem that the below defined paramter gets entered in the database as a interger. the Field in the DB is a nvarchar(5) and the controll that suplies the value is a TextBox

this is the parameter definition:
<asp:ControlParameterControlID="tbComment"Name="Comment"PropertyName="Text"Type="String"/>

Why do I get this error, why does ASP to whant to make an integerfrom this text field? When putting a interger value in the textbox all works well and the data gets posted to the database.

I use aSqlDataSource with automatic generated script.

look forwart to a solution

walter

Do you use a stored procedure or ...? make sure the parameter (comment) is not passed to a parameter of type int.

Parameter Description in Headline

I have the Problem, than I need the Selected Parameter in the Headline.
I have defined another ValueField which I need as the Selections.
But I need only the selected Parameter in one Headline text field.
Thanks for your help.
BraveMake a textbox with the expression:
="Report with parameters: " & Parameters!Parameter1.Value & " and " &
Parameters!Parameter2.Value
"Brave" wrote:
> I have the Problem, than I need the Selected Parameter in the Headline.
> I have defined another ValueField which I need as the Selections.
> But I need only the selected Parameter in one Headline text field.
> Thanks for your help.
> Brave

Page orientation for physical pages

Hello,
I need to design a single report (PDF) which must have both landscape and portrait orientation.

For what I know the page size is defined and static for all pages of the same report (RDL). Is there any workaround (I'm using Sql2005) ?

Thanks,
Pierre

You are right the page size defined in the rdl can't be expression and apply to all pages. One possible workaround is to use deviceinfo to specify page size and the page range. http://msdn2.microsoft.com/en-us/library/ms154682(SQL.90).aspx. For example, you can specify one page size to get page 1-3 of the report, and a different size to get a different set of pages.

|||

Hello Fang,
thanks for the reply. For what I know I can define one deviceinfo setting per report. How can I define the device info setting the page 1 with a different PageHeight and PageWidth than the page 2 and 3 on the same deviceinfo ?

Thanks,
Pierre

|||Since you can use device info settings (StartPage and EndPage) to retrieve a range of pages, you can get page 1 with certain page size, then page 2 and 3 with a different page size.