report does not accept null values for its parameters

Hi all
Im using a stored procedure with in params as datasource to a report.
These params are initialized to null by default in the procedure.
When executing this datasource in the report designer's data tab
every thing works fine - i can live these parameters with nulls (or set
other values) and the procedures return appropriate results.
Then in the report parameters tab i allow these params to get null values,
with no default value.
But when executing the report in the 'preview' mode of visual studio i must
enter values for all params or else the report is not displayed at all (not
even with empty result set..).
No error massage is displayed - just the default blank background..
Thanks for your attention
ReaThe report will not execute unless you provide Default values in the Report
Parameters dialog. Without setting a default value on each and every
parameter, RS has no way of knowing what to use. It is unaware that your SP
has default values assigned.
hth
fmi see www.sqlreportingservices.net
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"Rea Peleg" <rea_p@.afek.co.il> wrote in message
news:%23nq$JF3YEHA.2500@.TK2MSFTNGP09.phx.gbl...
> Hi all
> Im using a stored procedure with in params as datasource to a report.
> These params are initialized to null by default in the procedure.
> When executing this datasource in the report designer's data tab
> every thing works fine - i can live these parameters with nulls (or set
> other values) and the procedures return appropriate results.
> Then in the report parameters tab i allow these params to get null values,
> with no default value.
> But when executing the report in the 'preview' mode of visual studio i
must
> enter values for all params or else the report is not displayed at all
(not
> even with empty result set..).
> No error massage is displayed - just the default blank background..
> Thanks for your attention
> Rea
>|||ok then how do i set null values as default values for report's parameters'
i tried : null , =null, =System.DBnull - all were rejected by compilation.
Thanks again
Rea
"William (Bill) Vaughn" <billvaRemoveThis@.nwlink.com> wrote in message
news:uAKFBp3YEHA.1764@.TK2MSFTNGP10.phx.gbl...
> The report will not execute unless you provide Default values in the
Report
> Parameters dialog. Without setting a default value on each and every
> parameter, RS has no way of knowing what to use. It is unaware that your
SP
> has default values assigned.
> hth
> fmi see www.sqlreportingservices.net
>
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> www.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> __________________________________
> "Rea Peleg" <rea_p@.afek.co.il> wrote in message
> news:%23nq$JF3YEHA.2500@.TK2MSFTNGP09.phx.gbl...
> > Hi all
> > Im using a stored procedure with in params as datasource to a report.
> > These params are initialized to null by default in the procedure.
> > When executing this datasource in the report designer's data tab
> > every thing works fine - i can live these parameters with nulls (or set
> > other values) and the procedures return appropriate results.
> > Then in the report parameters tab i allow these params to get null
values,
> > with no default value.
> > But when executing the report in the 'preview' mode of visual studio i
> must
> > enter values for all params or else the report is not displayed at all
> (not
> > even with empty result set..).
> > No error massage is displayed - just the default blank background..
> > Thanks for your attention
> > Rea
> >
> >
>|||=Nothing
(according to Peter)
--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"Rea Peleg" <rea_p@.afek.co.il> wrote in message
news:uip9OnAZEHA.1356@.TK2MSFTNGP09.phx.gbl...
> ok then how do i set null values as default values for report's
parameters'
> i tried : null , =null, =System.DBnull - all were rejected by compilation.
> Thanks again
> Rea
> "William (Bill) Vaughn" <billvaRemoveThis@.nwlink.com> wrote in message
> news:uAKFBp3YEHA.1764@.TK2MSFTNGP10.phx.gbl...
> > The report will not execute unless you provide Default values in the
> Report
> > Parameters dialog. Without setting a default value on each and every
> > parameter, RS has no way of knowing what to use. It is unaware that your
> SP
> > has default values assigned.
> >
> > hth
> > fmi see www.sqlreportingservices.net
> >
> >
> > --
> > ____________________________________
> > William (Bill) Vaughn
> > Author, Mentor, Consultant
> > Microsoft MVP
> > www.betav.com
> > Please reply only to the newsgroup so that others can benefit.
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > __________________________________
> >
> > "Rea Peleg" <rea_p@.afek.co.il> wrote in message
> > news:%23nq$JF3YEHA.2500@.TK2MSFTNGP09.phx.gbl...
> > > Hi all
> > > Im using a stored procedure with in params as datasource to a report.
> > > These params are initialized to null by default in the procedure.
> > > When executing this datasource in the report designer's data tab
> > > every thing works fine - i can live these parameters with nulls (or
set
> > > other values) and the procedures return appropriate results.
> > > Then in the report parameters tab i allow these params to get null
> values,
> > > with no default value.
> > > But when executing the report in the 'preview' mode of visual studio i
> > must
> > > enter values for all params or else the report is not displayed at all
> > (not
> > > even with empty result set..).
> > > No error massage is displayed - just the default blank background..
> > > Thanks for your attention
> > > Rea
> > >
> > >
> >
> >
>|||Thanks i found a way:
Null values should be added to the parameter's result set/data source.
Then you allow null values for it and set for default value - none.
I hope =Nothing does not work because i spent some 2 hours figuring in
out...:))
Rea
"William (Bill) Vaughn" <billvaRemoveThis@.nwlink.com> wrote in message
news:ew$ZIAJZEHA.2016@.TK2MSFTNGP09.phx.gbl...
> =Nothing
> (according to Peter)
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> www.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> __________________________________
> "Rea Peleg" <rea_p@.afek.co.il> wrote in message
> news:uip9OnAZEHA.1356@.TK2MSFTNGP09.phx.gbl...
> > ok then how do i set null values as default values for report's
> parameters'
> > i tried : null , =null, =System.DBnull - all were rejected by
compilation.
> > Thanks again
> > Rea
> >
> > "William (Bill) Vaughn" <billvaRemoveThis@.nwlink.com> wrote in message
> > news:uAKFBp3YEHA.1764@.TK2MSFTNGP10.phx.gbl...
> > > The report will not execute unless you provide Default values in the
> > Report
> > > Parameters dialog. Without setting a default value on each and every
> > > parameter, RS has no way of knowing what to use. It is unaware that
your
> > SP
> > > has default values assigned.
> > >
> > > hth
> > > fmi see www.sqlreportingservices.net
> > >
> > >
> > > --
> > > ____________________________________
> > > William (Bill) Vaughn
> > > Author, Mentor, Consultant
> > > Microsoft MVP
> > > www.betav.com
> > > Please reply only to the newsgroup so that others can benefit.
> > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > > __________________________________
> > >
> > > "Rea Peleg" <rea_p@.afek.co.il> wrote in message
> > > news:%23nq$JF3YEHA.2500@.TK2MSFTNGP09.phx.gbl...
> > > > Hi all
> > > > Im using a stored procedure with in params as datasource to a
report.
> > > > These params are initialized to null by default in the procedure.
> > > > When executing this datasource in the report designer's data tab
> > > > every thing works fine - i can live these parameters with nulls (or
> set
> > > > other values) and the procedures return appropriate results.
> > > > Then in the report parameters tab i allow these params to get null
> > values,
> > > > with no default value.
> > > > But when executing the report in the 'preview' mode of visual studio
i
> > > must
> > > > enter values for all params or else the report is not displayed at
all
> > > (not
> > > > even with empty result set..).
> > > > No error massage is displayed - just the default blank background..
> > > > Thanks for your attention
> > > > Rea
> > > >
> > > >
> > >
> > >
> >
> >
>

Report Builder: how to create a static report?

hi,
I have created a report based on a report builder model using Visual Studio.
This report will replace the default drill report.
so after I have published my report in report server, I'll modify my model
(model properties) to setup the drill through report of my customer entity.
When I save the new config I receive this error:
rsInvalidModelDrillthroughReport
/Models/DrillReports/Report1 is not a valid drill report.
so the question is, how to create a valid drill report'
there is some particular parameters to setup?
the help don't describe this.
any sample anywhere?
thanks.
Jerome.ok
I have missed some properties.
Now all works fine!!!!
"Jéjé" <willgart_A_@.hotmail_A_.com> wrote in message
news:ezZS2LuFGHA.140@.TK2MSFTNGP12.phx.gbl...
> hi,
> I have created a report based on a report builder model using Visual
> Studio.
> This report will replace the default drill report.
> so after I have published my report in report server, I'll modify my model
> (model properties) to setup the drill through report of my customer
> entity.
> When I save the new config I receive this error:
> rsInvalidModelDrillthroughReport
> /Models/DrillReports/Report1 is not a valid drill report.
> so the question is, how to create a valid drill report'
> there is some particular parameters to setup?
> the help don't describe this.
> any sample anywhere?
> thanks.
> Jerome.
>

Report Builder: Date filter, Relative Date

I have a date filter, and I default it to first day this month and last day this month under relative date, when I run it it givis me error:

The Value expression for the report parameter ‘FromDate’ contains an error: [BC30456] 'Date' is not a member of 'Integer'. (rsCompilerErrorInExpression)

Can anyone fix this problem?

But it works for Today or (n)months ago.

Thanks.

Post your expressions and indicate what the data types are for the referenced field(s).|||

OK, I narrow down what cause this, my date Fields are standard date type. I have 2 dates From Date and To Date, and I put those in filter with default values:

From Date : first day this month, To Date: last day this month

I also have a Textbox with value: =parameters!FromDate.Value

Because I need to display what is being filter on the output, but that is what cause the error, if I use Today or (n) months ago as default, it works.

|||

So are you saying this gives the error?

=parameters!FromDate.Value

I doubt that is causing the problem unless you maybe have a number format string for the textbox?

|||

If I remove the Textbox with value: =parameters!FromDate.Value, then it works fine with the From Date : first day this month, To Date: last day this month. But if I add the Textbox back with those value it gives me the above error?

|||And then if you put a new text box on the report and set the Expression to =Parameters!FromDate.Value and leave all other settings for the text box alone, what happens?

Report Builder Formatting Currency

Hi all

I need Report Builder to format Certain Numbers
as Currency by default. According to the documentation
I need to set the culture setting in the report's datasource.

I'm using a SSAS2005 Cube
The Report Manager then let's me create the Model wich is used
by Report Builder.

My Question is: Where do I set the culture setting?

I cannot find it in the Cube and viewing the model's xml hasn't helped.
Any help will be dearly appreciated

G

under format in properties of the textbox

change it to

$ ###, ###, ###.##

|||

Thanks X

But I know how to format the textbox.
The problem is that I want my measures to default to
currency format like this: (R #,##.##0.00;R (#,##.##)0.00;R ##.#0)
when added to the table/matrix

The docementation for Report Builder says that it can be
done by setting the "Culture" Setting on the Datasource.?

They dont give any other specifics

Thanks for the responce

G

|||

maybe set it in Connection String ?

Data Source=myServer;Initial Catalog=myDatabase;Current Language=en-us

|||

Hi

No good, the report model does not contain a connection string.
As this is what Report Builder uses: I'm assuming that this is the datasource
that is being reffered to.

Still stuck

G

|||

GDavids - SAO wrote:

No good, the report model does not contain a connection string.
As this is what Report Builder uses: I'm assuming that this is the datasource
that is being reffered to.

report model have Datasources link in Properties

Datasource have connection string ;]

|||

thanks giret

Where do I view this?

In Report Manager? Because I dont find it..

Thanks for the reponces

|||

http://localhost/Reports/

click on Your model name

Properties Tab:

General

DataSources

Security

|||

This gives the path to my datasource.

Does this mean that I have to set the connection string for
that datasource that the path from the model refers to?

Report Builder Formatting Currency

Hi all

I need Report Builder to format Certain Numbers
as Currency by default. According to the documentation
I need to set the culture setting in the report's datasource.

I'm using a SSAS2005 Cube
The Report Manager then let's me create the Model wich is used
by Report Builder.

My Question is: Where do I set the culture setting?

I cannot find it in the Cube and viewing the model's xml hasn't helped.
Any help will be dearly appreciated

G

under format in properties of the textbox

change it to

$ ###, ###, ###.##

|||

Thanks X

But I know how to format the textbox.
The problem is that I want my measures to default to
currency format like this: (R #,##.##0.00;R (#,##.##)0.00;R ##.#0)
when added to the table/matrix

The docementation for Report Builder says that it can be
done by setting the "Culture" Setting on the Datasource.?

They dont give any other specifics

Thanks for the responce

G

|||

maybe set it in Connection String ?

Data Source=myServer;Initial Catalog=myDatabase;Current Language=en-us

|||

Hi

No good, the report model does not contain a connection string.
As this is what Report Builder uses: I'm assuming that this is the datasource
that is being reffered to.

Still stuck

G

|||

GDavids - SAO wrote:

No good, the report model does not contain a connection string.
As this is what Report Builder uses: I'm assuming that this is the datasource
that is being reffered to.

report model have Datasources link in Properties

Datasource have connection string ;]

|||

thanks giret

Where do I view this?

In Report Manager? Because I dont find it..

Thanks for the reponces

|||

http://localhost/Reports/

click on Your model name

Properties Tab:

General

DataSources

Security

|||

This gives the path to my datasource.

Does this mean that I have to set the connection string for
that datasource that the path from the model refers to?

Report Builder Color Pallette

The default pallette of the report builder seems to the light blue-based colors. How do you change the default pallette to say be my company's colors? I would think that is would be an extremely common request as almost companies like reports to be branded with their companies colors.

Besides setting the default pallette when you say create a table or chart. The color picker for all color customization only seem to have a fixed set of colors (the system pallette). It does not seem to have any place to enter a custom color.

Also, on the chart options/chart type there is a pallette drop down but no way to edit/add pallettes

Has anyone else had color/pallette/branding issues with report builder?

You can change colors in an individual report, but changing colors schema in general (for all reports) is not currently supported.|||

1. I am not seeing a place in report builder where I can enter color values (RGB, hex, etc) does report builder not support color values in formating?

2. What about formating drill downs which seem to be autogenerated?

3. Where does the color formating come from for that?

4. Is the formating on drill downs in the RDL somewhere?

|||

What about a custom rendering extension that replaces the colors with colors from say a configuration file?

Has anyone else had branding issues with reporting builder?

|||

Entering custom colors is not supported in this release of Report Builder. However, you can create model-based reports using Report Designer, where any color may be specified. You can also configure these reports to be the templates used for Clickthrough reports. See this page for more info:

http://msdn2.microsoft.com/en-us/library/ms189648.aspx

|||

Bob thank you for the answer.

By the way, I really enjoy your articles on your blog and I think that Report Builder has may excellent concepts in it.