2nd request: group visibility issue

Hi,
I have a report with a SP datasource. The groups have drilldown
capabilities. I have conditional expressions on groups 1 and group 2 that
when a flag in the proc is one value then something like this is displayed:
region 1
district 1
facility A data data data
facility C data data data
facility F data data data
district 2
facility B
facility D
...etc
Then, when the flag is another value, I want to display just the facility
list without the groups. I almost have this successfully implemented, by
having conditionals on groups 1 and 2. It is something like this:
=iif(Fields!GroupRegDis.Value = 1, Fields!districtName.Value, 0)
The only problem is that when I disable the groups like that, I still get
the drilldown's plus sign at the top of the facility list.
+
+
Facility A data data
Facility B data data
etc
I don't want them there. Hope this is clear.
Thanks
--
Patrick StadlerYou cannot conditionally "remove" groupings.
You may try duplicating the table/matrix and remove the groupings for the
copied data region. Depending on the parameter values you would always just
show one of the data regions.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Stads" <Stads@.discussions.microsoft.com> wrote in message
news:F4FCE3A3-1389-4F00-AB4F-BE3BBDB6A519@.microsoft.com...
> Hi,
> I have a report with a SP datasource. The groups have drilldown
> capabilities. I have conditional expressions on groups 1 and group 2 that
> when a flag in the proc is one value then something like this is
displayed:
> region 1
> district 1
> facility A data data data
> facility C data data data
> facility F data data data
> district 2
> facility B
> facility D
> ...etc
> Then, when the flag is another value, I want to display just the facility
> list without the groups. I almost have this successfully implemented, by
> having conditionals on groups 1 and 2. It is something like this:
> =iif(Fields!GroupRegDis.Value = 1, Fields!districtName.Value, 0)
> The only problem is that when I disable the groups like that, I still get
> the drilldown's plus sign at the top of the facility list.
> +
> +
> Facility A data data
> Facility B data data
> etc
> I don't want them there. Hope this is clear.
> Thanks
> --
> Patrick Stadler

2005 Reporting Srv cannot connect to Oracle datasource on web server

created an Oracle datasource (tried both ole db & oracle client) in Visual Studio 2005 report project - works fine connecting and preview of report within ide , deployed to Reporting Services web server, received the following error when attempting to run the report on web server:

An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'oracle'. (rsErrorOpeningConnection)
System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.

web server has oracle client 9i client installed and connecting to db ok through sql plus (this server also is loaded with VS2005 and the SqlServer2005 db)

any thoughts or direction greatly appreciated

Most likely the RS web service and the RS windows service cannot access the Oracle client installation due to missing file system permissions. Please read the following KB article: http://support.microsoft.com/default.aspx?scid=kb;en-us;870668

-- Robert

|||

Robert,

Thanks for the help, this did in fact solve the issue (once the permissions were granted for the entire Oracle directory). Why would such a helpful article not show up in my searches through the help maze? Is there another entry point to search for these articles other than the help search engine?

thanks again,

Richard

|||

Wow this really helped me out also, had the exact same problem. Thanks. I too had to set the permissions for the entire Oracle directory for this to work. Also take note of which account your installation is using, mine wasn't using the Network Service account but instead a special service account created by the system admins, I had to set the permissions for that account on the folders.

Dave

2005 Reporting Srv cannot connect to Oracle datasource on web server

created an Oracle datasource (tried both ole db & oracle client) in Visual Studio 2005 report project - works fine connecting and preview of report within ide , deployed to Reporting Services web server, received the following error when attempting to run the report on web server:

An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'oracle'. (rsErrorOpeningConnection)
System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.

web server has oracle client 9i client installed and connecting to db ok through sql plus (this server also is loaded with VS2005 and the SqlServer2005 db)

any thoughts or direction greatly appreciated

Most likely the RS web service and the RS windows service cannot access the Oracle client installation due to missing file system permissions. Please read the following KB article: http://support.microsoft.com/default.aspx?scid=kb;en-us;870668

-- Robert

|||

Robert,

Thanks for the help, this did in fact solve the issue (once the permissions were granted for the entire Oracle directory). Why would such a helpful article not show up in my searches through the help maze? Is there another entry point to search for these articles other than the help search engine?

thanks again,

Richard

|||

Wow this really helped me out also, had the exact same problem. Thanks. I too had to set the permissions for the entire Oracle directory for this to work. Also take note of which account your installation is using, mine wasn't using the Network Service account but instead a special service account created by the system admins, I had to set the permissions for that account on the folders.

Dave