I don't believe ...

I don't believe ...that not exists a resource for put optional parameters for filter in Reports else WorkArounds !!!

Specify a default parameter value. You can then use expressions which allow a row to pass through the filter if this default value is selected.|||

No,

I can't default values

If user not select anything on the combo Box in the parameter filter my reports have to show all rows

I would like to do this whitout use WorkArounds !

[]'s

Christian

|||

This works if you are using Procedure for data retrival and Query parameters to fill the combo box.

If you are using Query Parameters to fill the combobox, then add 'All' as a parameter using UNION function to let user know that you are selecting everything. In the stored procedure ignore the parameter if the user is passing 'All' as a parameter and select everything.

Hope this helps.

|||

Thanks Veepak

This Really work but I think yet this is a workaround !!
I don't have the same performance when I put UNION function in my Query.

But, thanks very much !

|||

Please can you mark it as an answer , it helps if anybody has similar question.

sql

I can't show a calculated member

I need to show a calculated member in a report.
Reports works fine with calculated measures, but when you try to use a calculated member then raises an error which says The following system error ocurred. Invalid procedure call or argument.
Any ideas?
Can I use calculated members?
I'm using RS 2005 April CTP.
Thanks in advance.I would very much recommend moving to the June CTP. Many things are more stable, including Analysis Services. There is no reason why calculated members shouldn't work.|||Using the Sept CTP, when I create a data source that includes a hierarchy that includes a calculated member, I get an error message approximately "Encountered a set that cannot include a calculated member".

So it seems, there is a real issue here not solved by recent releases.|||

I also am having difficulties with calculated members using the Eval version of AS2005 and RS2005.

1) I am sure that everyone knows about this error: Add a calculated member (in BI Management Studio or RS), choose a parent heirarchy other than Measures, choose a parent member. If the dimension and hierarchy were both called Stock then the parent hierarchy would be Stock.Stock and the parent member would be [Stock].[Stock]. An error is given when the script/query is run. Changing to text mode shows that the designer form has placed an extra level in the WITH/CREATE MEMBER statement, ie [Stock].[Stock].[Stock].[Stock].[Calculated Member Name]. I worked out that you could work around this by deleting one of the repeated levels, BUT in RS, some extra problems arise: 1a) I can't change back to form mode because my query will be lost and, 1b) If I try to add this calculated member to my set of displayed members, it simply won't show.

2) I attempted to get around the problems described above by creating the same calculated member in the source cube. When I try to include it I get the same error about "Encoutered a set that cannot contain calculated members". This error also occurs if I paste the same RS built query into SQL Mgmt Studio. Is it possible to use calculated members that are not Measures in RS?

3) I have another problem which is related to the fact that RS can't accept anything but Measures for the columns of the query. My fact table has only one value column and hence my cube has only one Measure. Is there any way of making the RS query return multiple value columns if the source is a cube with only one Measure?

Anybody got any ideas?

Aranda

|||We submitted an issue with MS about this and were told that this was by design. If I remember correctly, it had something to do with how RS uses a subcube and calc members not being supported in subcubes.|||

On your point #3, our cubes are constructed the same way.

I was able to solve this (sort of) by creating calculated members on the measures dimension that picked up data from other dimensions -- that is, I used calculated members to pivot the data. It's quite tedious, but effective. However there are some limitations I found:

a. those calculated members don't rollup to higher levels very well

b. I frequently encountered an unsecified "query error" when running the data. the e rror appears to be data-dependant but I haven't been able to track it down.

My bottom line is that RS really can't be used effectively with AS because of the following limitations:

1. Only measures as columns and pivoting measures are unstable

2. You really can't effectively use a cube that has any calculated members defined in any dimiension other than measures. So If you put in a CM on a dimension for some other use, you have contaminated that dimension and it can't be used in RS. Further, RS's reliance on subqueries renders CM's useless.

So these two facts tell me that microsoft has broken its promise (?) that AS would be a general platform whose results can be accessed by a multitude of applications. If you want to use AS with RS, you have to get rid of all Calculated members and calculated cells (except on measures dimension). (btw calculated cells fly below the radar on RS -- so it won't mask them out -- but the calculations don't work if you're using subqueries). Combine this with the fact that MS has eliminated the ability to create a calculated member in a query that has a solve order lower than one in the cube and have those calculations executed inthe proper sequence. So really, MS is telling us that calculated members do not belong in cubes -- only at the query level. what a giant take-away that is.

|||

Thank's Stan H for your useful reply, but it looks like the situation is as I feared. My bottom line is pretty much the same as yours - it really is a massive take-away because calculated members are pretty much what makes cubes worthwile for me.

I will give pivoting measures a try but it doesn't sound too hopeful.

|||

The 'A set has been encountered that cannot contain calculated members' error comes when you try to slice by a set which contains a calculated member in the RS MDX query designer (I've not had any problems putting calculated members on rows in my queries in the RTM version), and as has already been said it's to do with the fact that RS uses subcubes to do its filtering. You can get round this limitation by editing the MDX directly, though, and although you then lose the ability to use the query designer you can at least get your queries to run...

Here's an example in Adventure Works. Say I've got a hierarchy created by the Time Intelligence Wizard on the Date dimension called [Calendar Date Calculations], with one calculated member on it called [Year to Date]. If you try to slice by this member you get the aforementioned error; switching to view the MDX, you see something like this:

SELECT NON EMPTY { [Measures].[Internet Order Count] }
ON COLUMNS,
NON EMPTY { ([Date].[Calendar].[Calendar Semester].ALLMEMBERS ) }
DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME
ON ROWS
FROM
( SELECT ( { [Date].[Calendar Date Calculations].[Year to Date] } ) ON COLUMNS FROM [Adventure Works]) WHERE ( [Date].[Calendar Date Calculations].[Year to Date] )
CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS

To get the desired effect, you need to edit the query to replace the subcube filter with a standard WHERE clause filter:

SELECT NON EMPTY { [Measures].[Internet Order Count] }
ON COLUMNS,
NON EMPTY { ([Date].[Calendar].[Calendar Semester].ALLMEMBERS ) }
DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME
ON ROWS
FROM [Adventure Works]
WHERE ( [Date].[Calendar Date Calculations].[Year to Date] )
CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS

In my experience you can almost always write MDX to make RS do what you want, but I 100% agree that RS shouldn't expect you to do this and the MDX query designer should be able to handle this particular scenario.

HTH,

Chris

|||

Thanks Chris, that was quite helpful.

I wish there was a way to instruct the query builder to avoid subqueries. I am finding their limitations to overwhelm their value.

I can't show a calculated member

I need to show a calculated member in a report.

Reports works fine with calculated measures, but when you try to use a calculated member then raises an error which says The following system error ocurred. Invalid procedure call or argument.

Any ideas?

Can I use calculated members?

I'm using RS 2005 April CTP.

Thanks in advance.I would very much recommend moving to the June CTP. Many things are more stable, including Analysis Services. There is no reason why calculated members shouldn't work.|||Using the Sept CTP, when I create a data source that includes a hierarchy that includes a calculated member, I get an error message approximately "Encountered a set that cannot include a calculated member".

So it seems, there is a real issue here not solved by recent releases.

|||

I also am having difficulties with calculated members using the Eval version of AS2005 and RS2005.

1) I am sure that everyone knows about this error: Add a calculated member (in BI Management Studio or RS), choose a parent heirarchy other than Measures, choose a parent member. If the dimension and hierarchy were both called Stock then the parent hierarchy would be Stock.Stock and the parent member would be [Stock].[Stock]. An error is given when the script/query is run. Changing to text mode shows that the designer form has placed an extra level in the WITH/CREATE MEMBER statement, ie [Stock].[Stock].[Stock].[Stock].[Calculated Member Name]. I worked out that you could work around this by deleting one of the repeated levels, BUT in RS, some extra problems arise: 1a) I can't change back to form mode because my query will be lost and, 1b) If I try to add this calculated member to my set of displayed members, it simply won't show.

2) I attempted to get around the problems described above by creating the same calculated member in the source cube. When I try to include it I get the same error about "Encoutered a set that cannot contain calculated members". This error also occurs if I paste the same RS built query into SQL Mgmt Studio. Is it possible to use calculated members that are not Measures in RS?

3) I have another problem which is related to the fact that RS can't accept anything but Measures for the columns of the query. My fact table has only one value column and hence my cube has only one Measure. Is there any way of making the RS query return multiple value columns if the source is a cube with only one Measure?

Anybody got any ideas?

Aranda

|||We submitted an issue with MS about this and were told that this was by design. If I remember correctly, it had something to do with how RS uses a subcube and calc members not being supported in subcubes.|||

On your point #3, our cubes are constructed the same way.

I was able to solve this (sort of) by creating calculated members on the measures dimension that picked up data from other dimensions -- that is, I used calculated members to pivot the data. It's quite tedious, but effective. However there are some limitations I found:

a. those calculated members don't rollup to higher levels very well

b. I frequently encountered an unsecified "query error" when running the data. the e rror appears to be data-dependant but I haven't been able to track it down.

My bottom line is that RS really can't be used effectively with AS because of the following limitations:

1. Only measures as columns and pivoting measures are unstable

2. You really can't effectively use a cube that has any calculated members defined in any dimiension other than measures. So If you put in a CM on a dimension for some other use, you have contaminated that dimension and it can't be used in RS. Further, RS's reliance on subqueries renders CM's useless.

So these two facts tell me that microsoft has broken its promise (?) that AS would be a general platform whose results can be accessed by a multitude of applications. If you want to use AS with RS, you have to get rid of all Calculated members and calculated cells (except on measures dimension). (btw calculated cells fly below the radar on RS -- so it won't mask them out -- but the calculations don't work if you're using subqueries). Combine this with the fact that MS has eliminated the ability to create a calculated member in a query that has a solve order lower than one in the cube and have those calculations executed inthe proper sequence. So really, MS is telling us that calculated members do not belong in cubes -- only at the query level. what a giant take-away that is.

|||

Thank's Stan H for your useful reply, but it looks like the situation is as I feared. My bottom line is pretty much the same as yours - it really is a massive take-away because calculated members are pretty much what makes cubes worthwile for me.

I will give pivoting measures a try but it doesn't sound too hopeful.

|||

The 'A set has been encountered that cannot contain calculated members' error comes when you try to slice by a set which contains a calculated member in the RS MDX query designer (I've not had any problems putting calculated members on rows in my queries in the RTM version), and as has already been said it's to do with the fact that RS uses subcubes to do its filtering. You can get round this limitation by editing the MDX directly, though, and although you then lose the ability to use the query designer you can at least get your queries to run...

Here's an example in Adventure Works. Say I've got a hierarchy created by the Time Intelligence Wizard on the Date dimension called [Calendar Date Calculations], with one calculated member on it called [Year to Date]. If you try to slice by this member you get the aforementioned error; switching to view the MDX, you see something like this:

SELECT NON EMPTY { [Measures].[Internet Order Count] }
ON COLUMNS,
NON EMPTY { ([Date].[Calendar].[Calendar Semester].ALLMEMBERS ) }
DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME
ON ROWS
FROM
( SELECT ( { [Date].[Calendar Date Calculations].[Year to Date] } ) ON COLUMNS FROM [Adventure Works]) WHERE ( [Date].[Calendar Date Calculations].[Year to Date] )
CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS

To get the desired effect, you need to edit the query to replace the subcube filter with a standard WHERE clause filter:

SELECT NON EMPTY { [Measures].[Internet Order Count] }
ON COLUMNS,
NON EMPTY { ([Date].[Calendar].[Calendar Semester].ALLMEMBERS ) }
DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME
ON ROWS
FROM [Adventure Works]
WHERE ( [Date].[Calendar Date Calculations].[Year to Date] )
CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS

In my experience you can almost always write MDX to make RS do what you want, but I 100% agree that RS shouldn't expect you to do this and the MDX query designer should be able to handle this particular scenario.

HTH,

Chris

|||

Thanks Chris, that was quite helpful.

I wish there was a way to instruct the query builder to avoid subqueries. I am finding their limitations to overwhelm their value.

I can't show a calculated member

I need to show a calculated member in a report.
Reports works fine with calculated measures, but when you try to use a calculated member then raises an error which says The following system error ocurred. Invalid procedure call or argument.
Any ideas?
Can I use calculated members?
I'm using RS 2005 April CTP.
Thanks in advance.I would very much recommend moving to the June CTP. Many things are more stable, including Analysis Services. There is no reason why calculated members shouldn't work.|||Using the Sept CTP, when I create a data source that includes a hierarchy that includes a calculated member, I get an error message approximately "Encountered a set that cannot include a calculated member".

So it seems, there is a real issue here not solved by recent releases.|||

I also am having difficulties with calculated members using the Eval version of AS2005 and RS2005.

1) I am sure that everyone knows about this error: Add a calculated member (in BI Management Studio or RS), choose a parent heirarchy other than Measures, choose a parent member. If the dimension and hierarchy were both called Stock then the parent hierarchy would be Stock.Stock and the parent member would be [Stock].[Stock]. An error is given when the script/query is run. Changing to text mode shows that the designer form has placed an extra level in the WITH/CREATE MEMBER statement, ie [Stock].[Stock].[Stock].[Stock].[Calculated Member Name]. I worked out that you could work around this by deleting one of the repeated levels, BUT in RS, some extra problems arise: 1a) I can't change back to form mode because my query will be lost and, 1b) If I try to add this calculated member to my set of displayed members, it simply won't show.

2) I attempted to get around the problems described above by creating the same calculated member in the source cube. When I try to include it I get the same error about "Encoutered a set that cannot contain calculated members". This error also occurs if I paste the same RS built query into SQL Mgmt Studio. Is it possible to use calculated members that are not Measures in RS?

3) I have another problem which is related to the fact that RS can't accept anything but Measures for the columns of the query. My fact table has only one value column and hence my cube has only one Measure. Is there any way of making the RS query return multiple value columns if the source is a cube with only one Measure?

Anybody got any ideas?

Aranda

|||We submitted an issue with MS about this and were told that this was by design. If I remember correctly, it had something to do with how RS uses a subcube and calc members not being supported in subcubes.|||

On your point #3, our cubes are constructed the same way.

I was able to solve this (sort of) by creating calculated members on the measures dimension that picked up data from other dimensions -- that is, I used calculated members to pivot the data. It's quite tedious, but effective. However there are some limitations I found:

a. those calculated members don't rollup to higher levels very well

b. I frequently encountered an unsecified "query error" when running the data. the e rror appears to be data-dependant but I haven't been able to track it down.

My bottom line is that RS really can't be used effectively with AS because of the following limitations:

1. Only measures as columns and pivoting measures are unstable

2. You really can't effectively use a cube that has any calculated members defined in any dimiension other than measures. So If you put in a CM on a dimension for some other use, you have contaminated that dimension and it can't be used in RS. Further, RS's reliance on subqueries renders CM's useless.

So these two facts tell me that microsoft has broken its promise (?) that AS would be a general platform whose results can be accessed by a multitude of applications. If you want to use AS with RS, you have to get rid of all Calculated members and calculated cells (except on measures dimension). (btw calculated cells fly below the radar on RS -- so it won't mask them out -- but the calculations don't work if you're using subqueries). Combine this with the fact that MS has eliminated the ability to create a calculated member in a query that has a solve order lower than one in the cube and have those calculations executed inthe proper sequence. So really, MS is telling us that calculated members do not belong in cubes -- only at the query level. what a giant take-away that is.

|||

Thank's Stan H for your useful reply, but it looks like the situation is as I feared. My bottom line is pretty much the same as yours - it really is a massive take-away because calculated members are pretty much what makes cubes worthwile for me.

I will give pivoting measures a try but it doesn't sound too hopeful.

|||

The 'A set has been encountered that cannot contain calculated members' error comes when you try to slice by a set which contains a calculated member in the RS MDX query designer (I've not had any problems putting calculated members on rows in my queries in the RTM version), and as has already been said it's to do with the fact that RS uses subcubes to do its filtering. You can get round this limitation by editing the MDX directly, though, and although you then lose the ability to use the query designer you can at least get your queries to run...

Here's an example in Adventure Works. Say I've got a hierarchy created by the Time Intelligence Wizard on the Date dimension called [Calendar Date Calculations], with one calculated member on it called [Year to Date]. If you try to slice by this member you get the aforementioned error; switching to view the MDX, you see something like this:

SELECT NON EMPTY { [Measures].[Internet Order Count] }
ON COLUMNS,
NON EMPTY { ([Date].[Calendar].[Calendar Semester].ALLMEMBERS ) }
DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME
ON ROWS
FROM
( SELECT ( { [Date].[Calendar Date Calculations].[Year to Date] } ) ON COLUMNS FROM [Adventure Works]) WHERE ( [Date].[Calendar Date Calculations].[Year to Date] )
CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS

To get the desired effect, you need to edit the query to replace the subcube filter with a standard WHERE clause filter:

SELECT NON EMPTY { [Measures].[Internet Order Count] }
ON COLUMNS,
NON EMPTY { ([Date].[Calendar].[Calendar Semester].ALLMEMBERS ) }
DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME
ON ROWS
FROM [Adventure Works]
WHERE ( [Date].[Calendar Date Calculations].[Year to Date] )
CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS

In my experience you can almost always write MDX to make RS do what you want, but I 100% agree that RS shouldn't expect you to do this and the MDX query designer should be able to handle this particular scenario.

HTH,

Chris

|||

Thanks Chris, that was quite helpful.

I wish there was a way to instruct the query builder to avoid subqueries. I am finding their limitations to overwhelm their value.

I can't find where to "deploy" my reports to...

I've currently got my deployment path to http://###.###.###.###/ReportServices
and that isn't where I set it up at (I know, I know)...Can you please
tell me how I can find out? I also need to know where my
http://......ReportManager is.
Any help is appreciated.
Thanks,
Trintuse the reporting services configuration tool to setup the virtual
directories.
by default the installation create these one:
http://localhost/reportserver
and
http://localhost/reports (the report manager site)
"trint" <trinity.smith@.gmail.com> wrote in message
news:1190494941.562704.60420@.22g2000hsm.googlegroups.com...
> I've currently got my deployment path to
> http://###.###.###.###/ReportServices
> and that isn't where I set it up at (I know, I know)...Can you please
> tell me how I can find out? I also need to know where my
> http://......ReportManager is.
> Any help is appreciated.
> Thanks,
> Trint
>|||On Sep 22, 7:19 pm, "Jeje" <willg...@.hotmail.com> wrote:
> use the reporting services configuration tool to setup the virtual
> directories.
> by default the installation create these one:http://localhost/reportserver
> andhttp://localhost/reports (the report manager site)
> "trint" <trinity.sm...@.gmail.com> wrote in message
> news:1190494941.562704.60420@.22g2000hsm.googlegroups.com...
>
> > I've currently got my deployment path to
> > http://###.###.###.###/ReportServices
> > and that isn't where I set it up at (I know, I know)...Can you please
> > tell me how I can find out? I also need to know where my
> >http://......ReportManageris.
> > Any help is appreciated.
> > Thanks,
> > Trint- Hide quoted text -
> - Show quoted text -
Jeje,
"The page cannot be found" cannot be found on this machine with both
of those a reports and manager
addresses...getting very frustrated...From the Configuration tool, it
says it is set up right.
Trint|||how do you access the server?
using localhost or netbios name or dns name?
(http://localhosthttp://serverhttp://server.domain.com)
"trint" <trinity.smith@.gmail.com> wrote in message
news:1190509765.296434.198840@.r29g2000hsg.googlegroups.com...
> On Sep 22, 7:19 pm, "Jeje" <willg...@.hotmail.com> wrote:
>> use the reporting services configuration tool to setup the virtual
>> directories.
>> by default the installation create these
>> one:http://localhost/reportserver
>> andhttp://localhost/reports (the report manager site)
>> "trint" <trinity.sm...@.gmail.com> wrote in message
>> news:1190494941.562704.60420@.22g2000hsm.googlegroups.com...
>>
>> > I've currently got my deployment path to
>> > http://###.###.###.###/ReportServices
>> > and that isn't where I set it up at (I know, I know)...Can you please
>> > tell me how I can find out? I also need to know where my
>> >http://......ReportManageris.
>> > Any help is appreciated.
>> > Thanks,
>> > Trint- Hide quoted text -
>> - Show quoted text -
> Jeje,
> "The page cannot be found" cannot be found on this machine with both
> of those a reports and manager
> addresses...getting very frustrated...From the Configuration tool, it
> says it is set up right.
> Trint
>|||On Sep 22, 10:33 pm, "Jeje" <willg...@.hotmail.com> wrote:
> how do you access the server?
> using localhost or netbios name or dns name?
> (http://localhosthttp://serverhttp://server.domain.com)
> "trint" <trinity.sm...@.gmail.com> wrote in message
> news:1190509765.296434.198840@.r29g2000hsg.googlegroups.com...
>
> > On Sep 22, 7:19 pm, "Jeje" <willg...@.hotmail.com> wrote:
> >> use the reporting services configuration tool to setup the virtual
> >> directories.
> >> by default the installation create these
> >> one:http://localhost/reportserver
> >> andhttp://localhost/reports(the report manager site)
> >> "trint" <trinity.sm...@.gmail.com> wrote in message
> >>news:1190494941.562704.60420@.22g2000hsm.googlegroups.com...
> >> > I've currently got my deployment path to
> >> > http://###.###.###.###/ReportServices
> >> > and that isn't where I set it up at (I know, I know)...Can you please
> >> > tell me how I can find out? I also need to know where my
> >> >http://......ReportManageris.
> >> > Any help is appreciated.
> >> > Thanks,
> >> > Trint- Hide quoted text -
> >> - Show quoted text -
> > Jeje,
> > "The page cannot be found" cannot be found on this machine with both
> > of those a reports and manager
> > addresses...getting very frustrated...From the Configuration tool, it
> > says it is set up right.
> > Trint- Hide quoted text -
> - Show quoted text -
Jeje,
I am using http://123.456.78.910/ReportServer/
we are getting ready to switch our dns to this new site (from
Coldfusion to my new
C# site on the new server).
Thanks,
Trint

I can't connect to http://localhost/Reports - rsinternal error

After a new installation I can't connect to http://localhost/Reports - rsinternal error

The logfiles give me the following: (haven't been able to find an answer to this issue)

<Header>

<Product>Microsoft SQL Server Reporting Services Version 8.00.1038.00</Product>

<Locale>en-US</Locale>

<TimeZone>W. Europe Daylight Time</TimeZone>

<Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\LogFiles\ReportServer__07_28_2006_11_27_56.log</Path>

<SystemName>BUIS8907-6</SystemName>

<OSName>Microsoft Windows NT 5.1.2600.0</OSName>

<OSVersion>5.1.2600.0</OSVersion>

</Header>

aspnet_wp!webserver!b0c!7/28/2006-11:27:57:: i INFO: Reporting Web Server started

aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.

aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.

aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.

aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.

aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.

aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.

aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.

aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.

aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.

aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.

aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.

aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.

aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.

aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing InstanceName to 'MSSQLSERVER' as specified in Configuration file.

aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.

aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.

aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.

aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.

aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.

aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.

aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.

aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing WebServiceUseFileShareStorage to default value of 'False' because it was not specified in Configuration file.

aspnet_wp!resourceutilities!b0c!7/28/2006-11:27:57:: i INFO: Running on 1 physical processors, 1 logical processors

aspnet_wp!resourceutilities!b0c!7/28/2006-11:27:57:: i INFO: Reporting Services starting SKU: Evaluation

aspnet_wp!resourceutilities!b0c!7/28/2006-11:27:57:: i INFO: Eval SKU: 120 days left

aspnet_wp!runningjobs!b0c!7/28/2006-11:27:57:: i INFO: Database Cleanup (Web Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds

aspnet_wp!runningjobs!b0c!7/28/2006-11:27:57:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds

aspnet_wp!runningjobs!b0c!7/28/2006-11:27:57:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 seconds

aspnet_wp!runningjobs!b0c!7/28/2006-11:27:57:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds. Cycle: 60 seconds

aspnet_wp!library!b0c!07/28/2006-11:28:09:: i INFO: Call to GetPermissions:/

aspnet_wp!crypto!b0c!07/28/2006-11:28:15:: i INFO: Initializing crypto as user: BUIS8907-6\ASPNET

aspnet_wp!crypto!b0c!07/28/2006-11:28:15:: i INFO: Exporting public key

aspnet_wp!library!b0c!07/28/2006-11:28:15:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;

Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.IO.FileNotFoundException: The system cannot find the file specified.

at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32 errorCode, IntPtr errorInfo)

at RSManagedCrypto.RSCrypto.ExportPublicKey()

at Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()

at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()

at Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()

at Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()

at Microsoft.ReportingServices.Library.Storage.get_Connection()

at Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String storedProcedureName)

at Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(String key)

at Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty(String name)

at Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String name)

at Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(String name)

at Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()

at Microsoft.ReportingServices.Library.RSService.PathToInternal(String source)

at Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String path, Boolean validate, Boolean convert, Boolean translate)

at Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String path)

at Microsoft.ReportingServices.Diagnostics.CatalogItemContext..ctor(IPathTranslator pathTranslator, String userSuppliedPath, String parameterName)

at Microsoft.ReportingServices.Library.RSService.GetPermissions(String item, StringCollection& Operations)

End of inner exception stack trace

I have already tried the rsconfig -c, this was succesfully but did not resolved the issue.

hey,

I am not a expert but i had similar kind of problem initially.

http://localhost/Reportserver is a default name. Instead of localhost try putting ur database name .

like http://Database/reportserver.

ashish

|||

Thanks Ashish for your reply, but unfortunately that didn't work.

Even when I browser the virtual directory in the IIS is gives me the rsinternal error.

I found somewhere else someone who re-installed and it resolved it for them. That was the first thing I did still have the issue.

I think there must be a setting or parameter incorrect somewhere. After the installation was finished I received a message telling me that the service could not be started and I would have to manually start it. I check the service and it was running. I even restarted it. the eventviewer tells me it started successfully so.....?

Thanks again, hoping for more suggestions

sql

I cannot logon to Http://localhost/reports$sqlexpress

Hello,
I am completely stuck. I have installed SQL server express server
advanced with reporting services. I can create some reports in Visual
studio 2005 IDE (from Acces database) but I cannot login to subj
address to do something from the web
I get the following response from my browser:
The server has encountered an error while loading an application
during the processing of your request. Please refer to the event log
for more detail information. Please contact the server administrator
for assistance
What does it mean? I use Windows XP Pro, SP2, using IIS 5.1. IIS is
functioning. I am logged as a user with Administrator rights. I can
browse web pages hosted on my IIS.
Searc on Google on this reveals a lot of hits which I have gone
through but no avail.
Also, how can I check that I have ASP.NET enabled on IIS'
Thanks,
AivarsOn Mar 15, 5:52 pm, "Aivars" <aiva...@.apollo.lv> wrote:
> Hello,
> I am completely stuck. I have installed SQL server express server
> advanced with reporting services. I can create some reports in Visual
> studio 2005 IDE (from Acces database) but I cannot login to subj
> address to do something from the web
> I get the following response from my browser:
> The server has encountered an error while loading an application
> during the processing of your request. Please refer to the event log
> for more detail information. Please contact the server administrator
> for assistance
> What does it mean? I use Windows XP Pro, SP2, using IIS 5.1. IIS is
> functioning. I am logged as a user with Administrator rights. I can
> browse web pages hosted on my IIS.
> Searc on Google on this reveals a lot of hits which I have gone
> through but no avail.
> Also, how can I check that I have ASP.NET enabled on IIS'
> Thanks,
> Aivars
You may need to reinstall SSRS Express w/Advanced Services. I had a
similar issue a few months back and that seemed to resolve it. To
check if ASP.NET is enabled for IIS, do the following:
- Right click 'My Computer' and select 'Manage.'
- Select Services and Applications -> Internet Information Services ->
Default Web Site
- Right-click either the Reports or ReportServer virtual directory and
select Properties.
- There should be a tab at the end called 'ASP.NET'. If you select it,
it will show you the ASP.NET version, etc.
- Also, the Virtual Directory tab is where you would set up connection
pooling (in case you needed to run different versions of Visual
Studio/ASP.NET and need to control which .NET framework is used for
what).
Hope this helps.
Regards,
Enrique Martinez
Sr. ASP.NET/SQL Server Developer|||Running the following statement in your Framework\v2.0.50727 directory
might help:
aspnet_regiis -i -enable
Regards,
Thomas
Aivars schrieb:
> Hello,
> I am completely stuck. I have installed SQL server express server
> <SNIP>
> Also, how can I check that I have ASP.NET enabled on IIS'|||Thanks who responded. I am at dead end - I have reinstalled 5(!!!)
times all SSRS and Toolkit and still I am getting the following error
when logging to reportserver:
The server has encountered an error while loading an application
during the processing of your request. Please refer to the event log
for more detail information. Please contact the server administrator
for assistance.
No clue whatsoever.
Any more ideas?
Aivars
Thomas H=FCtter wrote:
> Running the following statement in your Framework\v2.0.50727 directory
> might help:
> aspnet_regiis -i -enable
> Regards,
> Thomas
>
> Aivars schrieb:
> > Hello,
> > I am completely stuck. I have installed SQL server express server
> > <SNIP>
> > Also, how can I check that I have ASP.NET enabled on IIS'|||Well, what do your event logs say around the time the error happens?
Aivars schrieb:
> Thanks who responded. I am at dead end - I have reinstalled 5(!!!)
> times all SSRS and Toolkit and still I am getting the following error
> when logging to reportserver:
> The server has encountered an error while loading an application
> during the processing of your request. Please refer to the event log
> for more detail information. Please contact the server administrator
> for assistance.|||Thomas, thank you very much.
I reinstalled windows(!). Now i can at least get the to the home page
of reportserver (it looks like it) but it responds with an error:
The report server is not responding. Verify that the report server is
running and can be accessed from this computer. But it is a home page
of report server.
It looks like I am closer. What is that last thing which I am
suppposed to do?
I think that is something to do with windows xp security?
Thanks,
Aivars
Thomas H=FCtter wrote:
> Well, what do your event logs say around the time the error happens?
>
> Aivars schrieb:
> > Thanks who responded. I am at dead end - I have reinstalled 5(!!!)
> > times all SSRS and Toolkit and still I am getting the following error
> > when logging to reportserver:
> >
> > The server has encountered an error while loading an application
> > during the processing of your request. Please refer to the event log
> > for more detail information. Please contact the server administrator
> > for assistance.|||Finally I did get it to work. I had tu use rskeymgmt utility to delete
encrypted contend. And do not ask me why because i do not know myself
how i had something encrypted on server.
maybe when configuring the report server there is an option to encrypt
and i had used it by accident.
Anyway, thanks to all who responded. There is a plethora of
information in Books online and Google is your friend!
Aivars
Aivars wrote:
> Thomas, thank you very much.
> I reinstalled windows(!). Now i can at least get the to the home page
> of reportserver (it looks like it) but it responds with an error:
> The report server is not responding. Verify that the report server is
> running and can be accessed from this computer. But it is a home page
> of report server.
> It looks like I am closer. What is that last thing which I am
> suppposed to do?
> I think that is something to do with windows xp security?
> Thanks,
> Aivars
> Thomas H=FCtter wrote:
> > Well, what do your event logs say around the time the error happens?
> >
> >
> > Aivars schrieb:
> > > Thanks who responded. I am at dead end - I have reinstalled 5(!!!)
> > > times all SSRS and Toolkit and still I am getting the following error
> > > when logging to reportserver:
> > >
> > > The server has encountered an error while loading an application
> > > during the processing of your request. Please refer to the event log
> > > for more detail information. Please contact the server administrator
> > > for assistance.

I am viewing reports through a .Net interface. I want to hide

the URL when the report is rendered. How can I do this?If you are using RS 2005 and are either at or can go to 2.0 framework then
check out the new webform controls that ship with VS 2005. The other option
is to use web services instead of URL integration URL integration is easier
but it really is not suitable if you are trying to hide things from the
user.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"OriginalStealth" <OriginalStealth@.discussions.microsoft.com> wrote in
message news:F77A8831-CD45-4431-8DF6-E89D487C3F80@.microsoft.com...
> the URL when the report is rendered. How can I do this?

I am not able to view RS folders and reports.

I created reports and deployed but i am not able to see on IE my RS folders
I used this path and also i used instead of localhost i used my machine name;
http://localhost/reports$SQL2005/Pages/Folder.aspx
I checked IIS and RS, it's running.
Also i stoped and start again.
It still not working.
What else should i do?
But it did work couple days ago.
Please help.
Thanks.On Jul 26, 11:44 am, GGill <GG...@.discussions.microsoft.com> wrote:
> I created reports and deployed but i am not able to see on IE my RS folders
> I used this path and also i used instead of localhost i used my machine name;
> http://localhost/reports$SQL2005/Pages/Folder.aspx
> I checked IIS and RS, it's running.
> Also i stoped and start again.
> It still not working.
> What else should i do?
> But it did work couple days ago.
> Please help.
> Thanks.
The only other thing I can think of are to stop and restart the SQL
Server service (sqlserver.exe) and the RPC service (remote procedure
call). If this doesn't work, you may need to reinstall SSRS. Hope this
helps.
Regards,
Enrique Martinez
Sr. Software Consultant

I am not able to open my report through URL It's URGENT!!!!!1

I am not able to open reports through URL.

<A HREF="http://localhost/Reports?NTIEE Reports/NTSID_LookUp">View Report</A>

When i click on this link it opens report manager and the NTIEE Reports folder.But i want to open direclty the report.Name of the report is NTSID_LookUp which is depoyed inside NTIEE Reports folder.Pls let me know how i can open a report through my web application.

Run the report in Report Manager and then right-click inside the report to get the Properties. The URL to link directly to the report is there.

If you don't want to see the manager, you should user Reportserver? instead of Reports.

cheers,

Andrew

|||

Try this

<A HREF="http://localhost/ReportServer?NTIEE Reports/NTSID_LookUp&rs:Command=render">View Report</A>

or this

<A HREF="http://localhost/ReportServer/Pages/ReportViewer.aspx?NTIEE Reports/NTSID_LookUp&rs:Command=Render">View Report</A>

Pls also make sure you use the correct the virtual directory - ReportServer (which is the default).

Cheers,

Henary

I am looking for a task which..

Dear all,
A couple of days ago I posted a request but nobody answered it.
I need a task which reports me all the NT users and groups in every
server/database and of course, their permissions.
The following excerpt is a part of the work:
declare @.sql varchar(300)
declare @.USER as char(25)
declare cursor1 cursor fast_forward for
select name from sysusers nolock where isntuser = 1 or isntgroup = 1
open cursor1
fetch next from cursor1 into @.USER
while @.@.fetch_status = 0
BEGIN
set @.sql = ('sp_helprotect NULL, ''' + lTRIM(rTRIM(@.USER)) + '''')
exec (@.sql)
fetch next from cursor1 into @.USER
end
close cursor1
deallocate cursor1
Thanks a lot and regards,Finding a list of server instances is something I haven't had to do before,
so I can't help you there.
sysdatabases lists the databases in an instance.
sysobjects lists the database objects, including tables (U), views (V),
procedures (P), and functions (FN, TF, IF)
sysprotects contains information about permissions, take a look a the
definition of the INFORMATION_SCHEMA.TABLE_PRIVILEGES.
I think syspermissions also contains permissions information.
Good luck! I would purchase a security audit tool instead. That way you
limit your liability and shift the focus of the leeches--oops, I meant
lawyers, to someone with deeper pockets.
It might be easier to generate a database creation script (script all
objects) for each database and parse the output.
"Enric" <Enric@.discussions.microsoft.com> wrote in message
news:7CDE748E-8426-4250-A52D-57DA7798F73E@.microsoft.com...
> Dear all,
> A couple of days ago I posted a request but nobody answered it.
> I need a task which reports me all the NT users and groups in every
> server/database and of course, their permissions.
> The following excerpt is a part of the work:
> declare @.sql varchar(300)
> declare @.USER as char(25)
> declare cursor1 cursor fast_forward for
> select name from sysusers nolock where isntuser = 1 or isntgroup = 1
> open cursor1
> fetch next from cursor1 into @.USER
> while @.@.fetch_status = 0
> BEGIN
> set @.sql = ('sp_helprotect NULL, ''' + lTRIM(rTRIM(@.USER)) + '''')
> exec (@.sql)
> fetch next from cursor1 into @.USER
> end
> close cursor1
> deallocate cursor1
>
> Thanks a lot and regards,

I am having QUERY/ DATASET problem with SQL Reports.

Hi every1,

I really need your help.

I have a web form which is having Drop Down box in which I have 2 selection 'P' and 'C'. Depending upon the selection I have to call the Dataset( If I can make it in code behind) or I can do it in one Complex query if you guys will help me.

Query should be like this.

select a.* , case when selection='P' then select p.column1 from ptable p

case when selection='C' then select c.column1 from ctable c

else a.column1

from atable a

where

acolumn2 = "USERINPUT"

but now the problem is in FROM and Where Clause.

when selection is 'P' then I have to include ptable in FROM Clause and in where clause I have to include two condition like (p.column1 = a.column1 and p.column2="USERINPUT1" or

if selection is 'C' then I have to include ctable in FROM clause and in where clause I have to include two different condition like (c.column1 = a.column1 and c.column2="USERINPUT")

So at once the Query will be any of one like below:

(1) some times this:

select a.* , case when selection='P' then select p.column1 from ptable p

case when selection='C' then select c.column1 from ctable c

else a.column1

from atable a, ptable p

where

a.column2 = "USERINPUT" and

p.column1 = a.column1 and p.column2="USERINPUT1"

-

(2) some times this:

select a.* , case when selection='P' then select p.column1 from ptable p

case when selection='C' then select c.column1 from ctable c

else a.column1

from atable a, ctable c

where

a.column2 = "USERINPUT" and

c.column1 = a.column1 and c.column2="USERINPUT"

Please let me know if you have any kind of confusion so I can clear this but if you got everything from my description please do help me to solve this. I am really struggling for this.

One way I was thinking to generate 3 dataset one(query or dataset) for 'P' , one for 'C' and one for else so I can get the input (selection) from the form and then decide in codebehind which dataset I have to make call so no need to write complex query. But this is my thought and I dont know how to make a call and everything either so please help me in this as well, if you like this solution .

Or try to solve the above query please.

Thanks

Roy

The best way to do this is to construct the query dynamically as a string.

And the best way to do THAT -- IMHO -- is to have your query say only:

Code Snippet

=Code.GetSQL()

... now you can write a simple little VB function that evaluates your parameters and builds up the string, returning that string. You will find it a lot more comfortable to do it this way than doing it in the query window. If you have never written a custom function before, don't worry, you don't need to build a DLL for something like this -- just use the Code tab in the Report Properties dialog. This is the kind of code that IMHO really *deserves* to be embedded in a report, since it is specific to that report and that report's parameters.

If you have the ability to write stored procedures or table-valued functions in the database, that is another option. You can pass your parameters to the procedure or function, and have that code evaluate the parameters and provide the result. It really depends on two things: what your permissions are (for writing to the database) and what your relative comfort level is (for writing VB or writing T-SQL).

HTH

>L<

hyperlinks in reports and the target problem

Hello Everybody:
We are developing a web site and we have the Reporting Services
Reports nested into a
iframe. One of the reports has the hyperlinks that open the same
report with different parameters.
Unfortunately by default, the report reopens in the top window and I
want to open it in the iframe, so I´ve added the "LinkTarget"
parameter to the URL address that opens the report the first time. It
works perfectly during the first click, but once the report is
reloaded, the LinkTarget parameter is lost therefore the second click
opens the same report in the top window. I have no idea how to pass to
the hyperlinks' definition the "LinkTarget" parameter.
All suggestions will be appreciated.
Thanks in advance
Maciej KiewraHi there Maciej
Have you tried putting the LinkTarget on the URL of the parent page
too. This solved the problem for me.
Hope it does for you!

Hyperlink to open in a new blank window.

A field in one of my reports has the navigation property jump to a url, which is a Word document on our server. The problem is the Word file opens up in the existing frame of our website, instead of opening a new frame. In the past I have used _blank. Where do I place this in Visual Studio 2003 to perform this action with Reporting Services?
Thanks for your help.

Hi
it seems that you are trying to open Document in new window so here is the line to be used in Jump to Url Textbox
="javascript:void(window.open('http://www.google.com','_blank'))" this will popup google.com in new page.
if you are picking the url from database you can use this
="javascript:void(window.open('" & Fields!URL.Value &"','_blank'))"
is this you are trying to do?
Thanks
Rohit|||

Yes, that is what I'm trying to accomplish, except it doesn't work. I copy and paste the following into Reporting Services:
Advanced TextBox Properties>Navigation>Hyperlink Action:>Jump to URL:
="javascript:void(window.open('" & Fields!MyLink.Value &"','_blank'))"
I get-->
javascript:void(window.open('" & Fields!MyLink.Value &"','_blank'))" in the URL

I'm using Windows 2000 Server, SQLServer2000, and IE 6.0.29 with all service packs installed.

|||Hi,
That means you need to Install Hotfix for SQL Server 2000 Reporting Services SP2 and make sure you already have installed Reporting Services SP2, The hot fix setup will not run on computer unless you have SP2 Installed on your computer.
Here is the Link for both
http://www.microsoft.com/downloads/details.aspx?FamilyID=7FFE50D4-AFF8-4C1E-9609-6798190C2D58&displaylang=en

Thanks
Rohit
|||

I pulled one Report (RDl) on IE

For Example:-

I am havingtestreport.rdl file

I am giving another reporti.e testreport2.rdl in JUMP to URL box intestreport.rdl file

I opened the below linkwith testreport.rdl

http://localhost/reportserver/testreport

I Clicked oneone item ontestreport.rdl

I got Result on samewindow(OPENED IE) , But I want result on New Window(I have to open New Window for Sub report )

I got solution with Reporting Services SP2 package with SQL2000.RS-KB901383-v8.00.1042.00-ENGHotFix using this statement injumptoURL(

="javascript:void(window.open('http://localhost/reportserver/testreport2,'_blank'))"

But I want onlywith SQLserver2000 Reporting services only with out SP2 Package

Can u please helpme

With

Regards

Battula

|||

Hi

I'm not sure if we can use javascript to open new window without installing HotFix

but after the installation we can open report in new window with parameters thru Jump To URL like this

="javascript:void(window.open('http://localhost/reportserver?/testReport/ReportName&rs:Command=Render&Parameter1=" & Fields!Parameter1.Value & "','_blank'))"

Thanx

|||

Iam able to open new window but not able to see any text to identify that the link is present. Any idea on this.

i have to very hardly hover in the reprot to find where the link is located.

|||You would not put the link in the expression for the pop up. The expression for the field should be normal I.E. =Fields!some_value.Value or some hard coded value, the text should appear and when using the jump to URL should pop open your window. If you are still not seeing anything check your formatting, perhaps its the same color as the background, sillier things are known to happen in developing!

Hyperlink report in new page..Urgent

I am working with two reports. The first reprot has a hyperlink to a textbox which opens a second report. This all works fine, but the when the hyperlink is clicked the second report open on top of the first report. I want the second report to open in a another seperate window, so that i can view two reports at the same time.

Can you please help me .. it's urgent.

Hi

try this I found it on Google

=void(window.open('" & Globals!ReportServerUrl & "?/Directory/ReportName&ParameterName=" & Parameters!ParameterName.Value & "&rs:Format=HTML4.0','_blank','resizable=yes'))"

it worked for me.

(you have to deploy it to test it)

|||

forgot.

use ="java_script: (before void, remove the _ )

="java_script:void(window.open('" & Globals!ReportServerUrl & "?/Directory/ReportName&ParameterName=" & Parameters!ParameterName.Value & "&rs:Format=HTML4.0','_blank','resizable=yes'))"

|||

I use

="java_script:void(window.open('" & "http://server06/ReportServer$Server062005" & "/Pages/ReportViewer.aspx?%2fAccount+Receivable%2fFinishGoodAtyAndNetModelType&Customer="& Fields!Customer.Value & "&Period=" & Fields!Period.Value & "&rs:Format=HTML4.0','_blank','resizable=yes'))"

but when clicking the link:

http://server06/ReportServer$Server062005?%2fAccount+Receivable%2fFinishGoodAtyAndNetModelType&Customer=HUONG+THUY&Period=200602&rs%3aFormat=HTML4.0%27%2c%27_blank%27%2c%27resizable%3dyes%27))

and web page display the error mesaage:

Reporting Services Error

---

An attempt has been made to use a rendering extension that is not registered for this report server. (rsRenderingExtensionNotFound) Get Online Help|||i tried

="java_script:void(window.open('" & Globals!ReportServerUrl & "?/Directory/ReportName&ParameterName=" & Parameters!ParameterName.Value & "&rs:Format=HTML4.0','_blank','resizable=yes'))"

with removing the "_" from java_script...

but stil it does not work..

i have the sp1 & sp2 intalled with hot fix..

please help

HyperLink in reports?

Is it possible to do hyperlink in reports? say I have a Matrix report, when
the user clicks on the specific item, it drills down to the detail page. Is
it possible?Right click on the field you want them to use.
Select Properties
Click Advanced Button
Choose Navigation Tab
Then fill in the Navigation Info
(You have to recolor and underline it to make it look like a link, it's
not automatic)

Hyperlink / Action Button

I am rendering reports using SQL reporting services. I would like a report
rendered with a hyperlink/action button that would contain an ID value that
will be used in rendering a new page...ie. I need to pass a row ID.
How can this be done?http://localhost/ReportServer?/<ReportFolder>/<ReportName>&rc:Toolbar=true&rs:Command=Render&RowID=1
Here is a sample url that can be click and will render a report passing it
the RowID parameter value.
Notice <ReportFolder> and the <ReportName> in the Url. You will need to
replace these with your data that makes since.
Bottom line is, you can dynamically create a Url that will render a report
to the browser based on the parameters passed in the Url.
I hope this makes sense.
Yosh
"tmiller" <tmiller@.discussions.microsoft.com> wrote in message
news:A67B3980-FBB2-4FA6-ADBC-597C400E0814@.microsoft.com...
>I am rendering reports using SQL reporting services. I would like a report
> rendered with a hyperlink/action button that would contain an ID value
> that
> will be used in rendering a new page...ie. I need to pass a row ID.
> How can this be done?