Report Parameter can be null

Hi,
I have a report parameter that can be null in some cases. Currently, in
the Report Parameters interface, I have check the 'Allow null value' option
for this parameter. When I preview the report (RS2005, SP1), the report
forces me to pick a value for this parameter before the report will open (if
I try to 'View Report', it says Please select a value for parameter, '<my
parameter>'.).
Any ideas on this? Also, it looks like I cannot allow for null values and
use multi-select on the same parameter. Do you know why this is?
Thank you for your help.
--
LaurieTHi LaurieT,
You can set the default value for your report parameter to be NULL in the
Report Parameter interface. This should allow the report to run without
forcing you to set a value for that parameter.
Brian
--
Brian Knight
Quaere SQL Server Blog
http://dba.typepad.com
"LaurieT" wrote:
> Hi,
> I have a report parameter that can be null in some cases. Currently, in
> the Report Parameters interface, I have check the 'Allow null value' option
> for this parameter. When I preview the report (RS2005, SP1), the report
> forces me to pick a value for this parameter before the report will open (if
> I try to 'View Report', it says Please select a value for parameter, '<my
> parameter>'.).
> Any ideas on this? Also, it looks like I cannot allow for null values and
> use multi-select on the same parameter. Do you know why this is?
> Thank you for your help.
> --
> LaurieT|||In the Report Parameter interface, I selected the option of 'Null' for
Default values, but it still forces me to pick a value for my parameter.
When I check the box that says that my parameter can have a Null value, I
expected the parameter drop down list to change, so that it contains a <Null>
option, but it doesn't. Initially it displays "<Select a Value>", and the
other options, but no "<Null>" or blank option. So now, I have said that the
value can be null, but how can I even pick null as a value?
I am totally confused.
--
LaurieT
"Brian Knight" wrote:
> Hi LaurieT,
> You can set the default value for your report parameter to be NULL in the
> Report Parameter interface. This should allow the report to run without
> forcing you to set a value for that parameter.
> Brian
> --
> Brian Knight
> Quaere SQL Server Blog
> http://dba.typepad.com
>
> "LaurieT" wrote:
> > Hi,
> >
> > I have a report parameter that can be null in some cases. Currently, in
> > the Report Parameters interface, I have check the 'Allow null value' option
> > for this parameter. When I preview the report (RS2005, SP1), the report
> > forces me to pick a value for this parameter before the report will open (if
> > I try to 'View Report', it says Please select a value for parameter, '<my
> > parameter>'.).
> >
> > Any ideas on this? Also, it looks like I cannot allow for null values and
> > use multi-select on the same parameter. Do you know why this is?
> >
> > Thank you for your help.
> > --
> > LaurieT

Report Manager Interface

Hello All,
I need some help regarding modification to Report Manager.
I need to add company Logo and Name at the center of the top section of the
Report Manager (section of the page that has bread-crumbs and search box). I
could modify CSS files to do the same but the logo appears near the
breadcrumbs and it gets crowded.
Can I modify any masterpage or .aspx to change the look and feel? I could
find the aspx pages but they only carry references to the assemblies. Can
anyone help me with this please?
thanksIts not customizable, but can be changed using css. How to change ? you can
go through this link.
http://weblogs.asp.net/jgalloway/archive/2006/12/12/reporting-services-add-a-logo-to-the-report-manager.aspx
Amarnath, MCTS
"Manu" wrote:
> Hello All,
> I need some help regarding modification to Report Manager.
> I need to add company Logo and Name at the center of the top section of the
> Report Manager (section of the page that has bread-crumbs and search box). I
> could modify CSS files to do the same but the logo appears near the
> breadcrumbs and it gets crowded.
> Can I modify any masterpage or .aspx to change the look and feel? I could
> find the aspx pages but they only carry references to the assemblies. Can
> anyone help me with this please?
> thanks

REPORT MANAGER - Hiding Tabs/Links ***

Is there a way to hide Tabs and Links on the REPORT MANAGER interface to
limit user access? If you can provide and example that would be highly
appreciated.Yes, you want to limit access using security. On the properties tab of any
item there should be a security sub-tab which will allow you to set what
users can and can't do with that object. Depending on a users rights only
tabs that a user can use will show up.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Mike Collins" <MikeCollins@.discussions.microsoft.com> wrote in message
news:7F502733-69FE-4C4A-A16B-02E6A3192933@.microsoft.com...
> I'm not an expert on this, but you can limit user access through IIS. Make
> sure anonymous access is not checked in your security in IIS. Then through
> the Report Manager, you can add users (or groups) and give them certain
> access rights.
> "doug" wrote:
> > Is there a way to hide Tabs and Links on the REPORT MANAGER interface to
> > limit user access? If you can provide and example that would be highly
> > appreciated.

Report interface getting refreshed

All of a sadden my report refreshes its interface every time I choose
something from dropdowns. Any reason for that?
ThanksYou must have cascading parameters (one parameter dependent on another).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Mark Goldin" <mgoldin@.ufandd.com> wrote in message
news:e$fMgNEkIHA.2396@.TK2MSFTNGP05.phx.gbl...
> All of a sadden my report refreshes its interface every time I choose
> something from dropdowns. Any reason for that?
> Thanks
>|||And if I do then that's how it works?
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:O3EI2TEkIHA.4684@.TK2MSFTNGP06.phx.gbl...
> You must have cascading parameters (one parameter dependent on another).
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Mark Goldin" <mgoldin@.ufandd.com> wrote in message
> news:e$fMgNEkIHA.2396@.TK2MSFTNGP05.phx.gbl...
>> All of a sadden my report refreshes its interface every time I choose
>> something from dropdowns. Any reason for that?
>> Thanks
>|||It's refreshing the page to update the dependent parameter. I only see this
behavior when I have dependent parameters.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Mark Goldin" <mgoldin@.ufandd.com> wrote in message
news:e8n$TZEkIHA.2268@.TK2MSFTNGP02.phx.gbl...
> And if I do then that's how it works?
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:O3EI2TEkIHA.4684@.TK2MSFTNGP06.phx.gbl...
>> You must have cascading parameters (one parameter dependent on another).
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Mark Goldin" <mgoldin@.ufandd.com> wrote in message
>> news:e$fMgNEkIHA.2396@.TK2MSFTNGP05.phx.gbl...
>> All of a sadden my report refreshes its interface every time I choose
>> something from dropdowns. Any reason for that?
>> Thanks
>>
>