Backing Up of Snapshot History

Hi,

Is there a way to back up the snapshot history of a specific report? I'm thinking on an operations perspective where we need to back up snapshot histories and restore them in case something happens on a production environment. Also, I'm thinking of saving only for specific reports and not for all reports in the same environment/server.

Thanks.

There isn't a supported way. You can get innovative by archiving tables Snapshot, History, and ChunkData in the ReportServer database (see CopyExecutionSnapshot stored procedure) but a future service pack may break your implementation if the schema changes.

|||

Thanks Teo. But I can't seem to search any documentation on CopyExecutionSnapshot in SQL Server Books Online or MSDN. Would you be able to point me to the right place?

|||It is a stored procedure in the Report Catalog and no, you won't find the Report Server database documented. Use it at your own risk.

Background water mark

It would be really cool to sort of ghost our company logo as a background
beneath report content.
Any ideas on how to do this are welcome?
All the Best,
GHello Joe,
Reporting Services doesn't have a specific way to produce watermarks, but
you can create them manually.
Watermark at the printer level
Look at the capacities of the printer driver you use to create a paper copy
of the report. Many printers, even low-end ones, have the ability to add
watermarks as part of the print process. This is usually defined in the
printer driver's settings. It can be configured by creating a separate
instance of an existing printer driver and then configuring that instance
to add a watermark to all output. Adding another instance of a printer
driver does not take much system overhead, so this is economical and
convenient. To produce the watermarked edition of a document, just print to
the right instance of the printer driver.
Watermark at the report level
If you want to add the watermark on the report level, there are a few ways
to do this. You may simply create a bitmap with the appropriate watermark
on it and set that as a background image for the header, body or footer of
the report. Another approach would be to create a textbox behind the report
grid and place the needed watermarking there. In both cases, you would
probably need to set the background for all cells on the grid to
"Transparent" so that the background items would show through; any colored
items (even if they use white) would overprint the image.
Another possibility is to create a textbox for the watermark, make the
background of that textbox transparent, and bring it to the top of the
Z-order for the report, so it remains on top of everything else.
Here is the article I reference:
http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1163757,00.html
Hope this helps.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Wei Lu,
Thank you for the definitive reply, I have noticed that Report Services
does not like to place other objects on top of Image components.
Setting up additional printer definitions would be easy, however it would
certainly confuse and aggravate the average user.
I will try your other suggestions and post the results.
All the best,
Greg Rowland|||My Pleasure, Greg.
If you have any question, please feel free to let me know.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hello Greg,
Have you tested the suggestion? Anything I can help, please feel free to
let me know.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.

background images and external URLs sorting problem

I have created a report which uses an external .bmp accessed through a URL as
the background image of the header (i.e. to brand the report with the company
logo).
this works fine until I use the interactive sort function which causes the
image to disappear. refreshing the report brings back the image, but resets
the sort.
Does anybody know of any way to make the image reappear after using the sort?
thanks in advance!
--
BLVI have exactly the same problem. Have you managed to solve it in the mean
time?
"BLV" wrote:
> I have created a report which uses an external .bmp accessed through a URL as
> the background image of the header (i.e. to brand the report with the company
> logo).
> this works fine until I use the interactive sort function which causes the
> image to disappear. refreshing the report brings back the image, but resets
> the sort.
> Does anybody know of any way to make the image reappear after using the sort?
> thanks in advance!
> --
> BLV

Background image sizing

Hello,
I have a jpg image to use as report background. How can I strecth the image in order to fill the page background (i'm using PDF output) with my image ?

Thanks,
PierreIn report designer, go to the properties editor window and select "Body" for the report body from the drop down list.
The report body has a background image property. Note: page header and page footer are independent of the report body - but you can also use images in those page sections.

-- Robert|||Hello Robert,
thanks for the reply. I already Tryied these settings but I can't stretch the background image, just set the repeating style.

Since the report must be rendered as PDF only, how can I create a background image so that it fits perfctly to the resulting PDF ? I guess it depends on the DPI used in reporting services.

Thanks,
Pierre|||

Sorry, we don't have an option right now that would stretch the image.

If your image fits the physical page size (i.e. Report.PageSize - Report.Margins) at 96 dpi, it should also look fine then in PDF at higher resolutions.

-- Robert

|||

Hi Robert,
ok, hoping for the next release :-)

Thanks,
Pierre

sql

Background image sizing

Hello,
I have a jpg image to use as report background. How can I strecth the image in order to fill the page background (i'm using PDF output) with my image ?

Thanks,
PierreIn report designer, go to the properties editor window and select "Body" for the report body from the drop down list.
The report body has a background image property. Note: page header and page footer are independent of the report body - but you can also use images in those page sections.

-- Robert|||Hello Robert,
thanks for the reply. I already Tryied these settings but I can't stretch the background image, just set the repeating style.

Since the report must be rendered as PDF only, how can I create a background image so that it fits perfctly to the resulting PDF ? I guess it depends on the DPI used in reporting services.

Thanks,
Pierre|||

Sorry, we don't have an option right now that would stretch the image.

If your image fits the physical page size (i.e. Report.PageSize - Report.Margins) at 96 dpi, it should also look fine then in PDF at higher resolutions.

-- Robert

|||

Hi Robert,
ok, hoping for the next release :-)

Thanks,
Pierre

Background colour

hi there ,
if a question abot ms report server.
i have two fields ,
field1 : name = gender value = 1 for men and 2 for woman
field 2 : name = lastname value = for example "jenkins"
so what i want to do is if gender = 1 (men) then i want to set the background colour of the field2(name) blue
else (gender = 2) i want to set the background colour of the field2(name) red.
do anyone know how i could do this ??
i'am a "newcommer" in the world of reporting services ,i always used crystal report for creating my reports.
thanks
patrickHi,
Here is a trick but most of programmers do not recommend it (Me too).
You fire the query as
Select [Name]=(Case When Gender=1 then '<font style=''backgroundcolor:blue;''>' + lastname + '<font>' Else '<font style=''backgroundcolor:red;''>' + lastname + '<font>' End )
Remember this is not recommended but you can use it in urgency.
Regards,
Hemchand.|||

Hello:
Is Gender ALWAYS a 1 or a 2?

In the field (Field2:name=LastName) within Report Layout - Select Properties (Right Side under Solutions Explorer) -

Click on BackGround (you will get a down arrow and scroll and look for Expression - Expressions is always at the top of the list)

In the Expression Box enter the following:

=iif(Field!:Gender.Value = "1", "Blue", "Red")
I probably do not have your field named correctly but you can enter =iif(THEN SELECT YOUR FIELD FROM THE DATASET and then append the remainder of the above statement.
Hope this helps!
Best Regards,
Joe

Background Color Return:

I am writing a report that I need to return a background color for a cell in
a table. The background color depends on what color is named in another
cell. For example, if the cell (Quality_status.value) displays the word
Green then the cell (Quanity_status.value) background color needs to be
Green. I have tried several IIF expressions in the BackgroundColor
properties but none of them seem to work. Please help!!
--
Sincerely,
Debo
--
Sincerely,
DeboThe only supported property of a field is Value. Therefore you can't do it.
HTH
Charles Kangai, MCT, MCDBA
"Debo" wrote:
> I am writing a report that I need to return a background color for a cell in
> a table. The background color depends on what color is named in another
> cell. For example, if the cell (Quality_status.value) displays the word
> Green then the cell (Quanity_status.value) background color needs to be
> Green. I have tried several IIF expressions in the BackgroundColor
> properties but none of them seem to work. Please help!!
> --
> Sincerely,
> Debo
> --
> Sincerely,
> Debo|||I went to a textbox properties, background color, scrolled to the top to
add an expression. and did
=iif(fields!CompanyName.Value = "Alfred's","Red","Green") and it worked
have you tried
=(fields!Quality_status.Value)
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Debo" <debo@.discussions.microsoft.com> wrote in message
news:835302E4-20F1-4D56-A738-9954ED6B346E@.microsoft.com...
> I am writing a report that I need to return a background color for a cell
in
> a table. The background color depends on what color is named in another
> cell. For example, if the cell (Quality_status.value) displays the word
> Green then the cell (Quanity_status.value) background color needs to be
> Green. I have tried several IIF expressions in the BackgroundColor
> properties but none of them seem to work. Please help!!
> --
> Sincerely,
> Debo
> --
> Sincerely,
> Debo|||Hi Wayne,
I thought Debo was trying to read the BackColor property, and you cannot
read any property of a textbox except Value. Of course if you enter the name
of the color in words in a textbox, then you can do it, because you are
reading the Value property.
Cheers
Charles Kangai, MCT, MCDBA
ps - good to hear from you Wayne!
"Wayne Snyder" wrote:
> I went to a textbox properties, background color, scrolled to the top to
> add an expression. and did
> =iif(fields!CompanyName.Value = "Alfred's","Red","Green") and it worked
> have you tried
> =(fields!Quality_status.Value)
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
>
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Debo" <debo@.discussions.microsoft.com> wrote in message
> news:835302E4-20F1-4D56-A738-9954ED6B346E@.microsoft.com...
> > I am writing a report that I need to return a background color for a cell
> in
> > a table. The background color depends on what color is named in another
> > cell. For example, if the cell (Quality_status.value) displays the word
> > Green then the cell (Quanity_status.value) background color needs to be
> > Green. I have tried several IIF expressions in the BackgroundColor
> > properties but none of them seem to work. Please help!!
> > --
> > Sincerely,
> >
> > Debo
> > --
> > Sincerely,
> >
> > Debo
>
>

Background color for each first row in groups

I have a report that groups on departments. I want the first row for each
group to be light gray, while the row below it are white. Any suggestions?
ThanksIt has been a little while since you posted this question, but I think I have
an answer I discovered while researching a solution to one of my problems.
The RowNumber aggregate function might be helpful to you. Try the following
somewhere in your report to verify this will help:
RowNumber("group_name")
Try concatinating that to a text field on the row you want the coloring to
ultimately be on; I believe you will find that the first record in each group
has a 1. Presuming it does give you a 1 where you want it to be, all you
need to do then is select the row in question, and place the following
expression in the Background Color field (or any othr formatting field, like
Font Weight or Font Style):
=IIF( RowNumber("group_name") = 1 , "Light Gray" , "White" )
"PatNUFC" wrote:
> I have a report that groups on departments. I want the first row for each
> group to be light gray, while the row below it are white. Any suggestions?
> Thanks

Background color differences between Visual Studio & Reporting Services

I'm trying to deploy a report to Reporting Services, but I've found that there's a behaviour difference Visual Studio and Reporting Services with the Matrix control for the subtotals.

For the background color for the "textbox" on the cells, I've used the folowing expression:

=Iif(Fields!ID__vs_YAGO.Value < 1, "Red"

,Iif(Fields!ID__vs_YAGO.Value < 1.02, "Yellow"

,"GreenYellow"))

The individual cells alternate colors, based on the value in the cell. In Visual Studio, the Subtotal cells also alternate colors (which is correct). But when the report is deployed to Reporting Services, The Subtotal cells have a transparent background. (Incorrect).

If I set the same expression into the background setting for the Subtotal cells, the expression is evaluated once for the entire row and the entire row has the same color (different Subtotal lines will alternate). This is the same in both Visual Studio and Reporting Services.

I'm using SP2, 2005 (32 bit for Reporting Services). To ensure full compatibility, I've editted / deployed the report all on the same machine.

Does anyone know of this problem and how to resolve it?

Additional: In testing the various output formats, it seems to be a bug in the HTML rendering engine. PDF amd TIFF work fine. I believe Excel export uses either part of the HTML rendering engine or pieces of the same code base.

P.S. I'm detecting other reporting differences between Visual Studio and Reporting Services, such as how "null key records" (from Analysis Services) are handled in groups. Is there a compatibility list published somewhere?

I've been having the same issues. I have been pulling my hair out for weeks.

Things to add:

I noticed that when deployed to Reporting Services, if you export to a TIFF or PDF, you will get the intended result. However, displayed on the web, and when exported to excel, it gives the above problems.

Background color differences between Visual Studio & Reporting Services

I'm trying to deploy a report to Reporting Services, but I've found that there's a behaviour difference Visual Studio and Reporting Services with the Matrix control for the subtotals.

For the background color for the "textbox" on the cells, I've used the folowing expression:

=Iif(Fields!ID__vs_YAGO.Value < 1, "Red"

,Iif(Fields!ID__vs_YAGO.Value < 1.02, "Yellow"

,"GreenYellow"))

The individual cells alternate colors, based on the value in the cell. In Visual Studio, the Subtotal cells also alternate colors (which is correct). But when the report is deployed to Reporting Services, The Subtotal cells have a transparent background. (Incorrect).

If I set the same expression into the background setting for the Subtotal cells, the expression is evaluated once for the entire row and the entire row has the same color (different Subtotal lines will alternate). This is the same in both Visual Studio and Reporting Services.

I'm using SP2, 2005 (32 bit for Reporting Services). To ensure full compatibility, I've editted / deployed the report all on the same machine.

Does anyone know of this problem and how to resolve it?

Additional: In testing the various output formats, it seems to be a bug in the HTML rendering engine. PDF amd TIFF work fine. I believe Excel export uses either part of the HTML rendering engine or pieces of the same code base.

P.S. I'm detecting other reporting differences between Visual Studio and Reporting Services, such as how "null key records" (from Analysis Services) are handled in groups. Is there a compatibility list published somewhere?

I've been having the same issues. I have been pulling my hair out for weeks.

Things to add:

I noticed that when deployed to Reporting Services, if you export to a TIFF or PDF, you will get the intended result. However, displayed on the web, and when exported to excel, it gives the above problems.

Backend generate and save the report to local drive?

Hi,
Any ideas on how to automatically generate and save the report to local
server drive backend when user click on certain link on the application?
The user do not have to render and display the report in frontend or click
on save button when prompted? The system should not prompt user for any
action instead.
Thanks in advance for any suggestion.Hi,
you can call the WebService of reporting Services (with optional
additional parameters, get the byte[] from the render method and save
this in a file on your network share of choice. That can all happen
behind the scenes and in addition if you want to asynchronously.
HTH, Jens K. Suessmeyer.
--
http://www.sqlserver2005.de
--

Back up of Encryption Keys and changing Windows Service Identity

I need to change windows server identity for the report service but I get
following error for this operation
ReportServicesConfigUI.WMIProvider.WMIProviderException: Key not valid for
use in specified state. (Exception from HRESULT: 0x8009000B)
at
ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject
mo)
at
ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.BackupEncryptionKey(Byte[]&
encryptedBytes, String password)
What is a solution for this?
Thanks,
ShimonOn Dec 10, 8:11 pm, "Shimon Sim" <shimonsim...@.community.nospam>
wrote:
> I need to change windows server identity for the report service but I get
> following error for this operation
> ReportServicesConfigUI.WMIProvider.WMIProviderException: Key not valid for
> use in specified state. (Exception from HRESULT: 0x8009000B)
> at
> ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject
> mo)
> at
> ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.BackupEncryptionKey(Byte[]&
> encryptedBytes, String password)
> What is a solution for this?
> Thanks,
> Shimon
This link might be helpful.
http://www.developmentnow.com/g/115_2007_5_0_0_973220/Report-Server-Windows-Service-MSSQLSERVER.htm
Regards,
Enrique Martinez
Sr. Software Consultant

Back to Parent Report button not visible

When I preview a report that has a link to a details report page in VS a "Back to Parent Report" button is displayed. However, when I publish the report to the Report Server, the .aspx page doesnt display the "Back to Parent Report" button. Is there a setting I need to make to have the button displayed?

thanks, lance

The "back to parent" functionality in the HTML report viewer is achieved by clicking the browser's back button.

-- Robert

|||

Well, this isnt the same functionality. Yes, the browser back button goes 1 page back. But the back to parent report, jumps back to the parent report no matter how many pages you have paged through in the child report. If I have a child report that has 20 pages and I scroll through all the pages by clicking next page, the UI you're suggesting requires me to click the back button in the browser 20 times. I could add links in every child report back to the parent report, but this requires embedded links. A "back to parent" report button should automate this process.

Is it possible to add the "back to parent report" button?

Thanks, lance

|||I concur. I need to add the back to parent report button as well.|||What do you think MSFT? Can this functionality be added easily and quickly (anytime before June 23, 2006 would be great)

?

Thanks, -lance|||

Are you talking about viewing a report through report manager? In this case, the browser's back button will always return to the parent report, even if you clicked next page multiple times in the child report.

-- Robert

|||Yes, but thats a non standard UI. Most users are used to having a back to parent button (just as VS has) in order to automatically jump back to the original list page. When paging through a list of records, the back button usually takes you back a list page (see google).

thanks, -lance|||

Ok. So it sounds like you want the browser back button to take you to the previous page (when paging through reports), and you want a separate "back to parent" button.

Once you jump back to parent, I guess you would expect that the brower's back button would then take you back to the previous page on the parent report (basically keeping the browser's pagination history information in sync with drillthroughs / back to parent jumps)?

Well, this kind of functionality is under consideration for a future release - but definitely not available in two days (by June 23rd) as you have asked earlier in this thread.

-- Robert

|||That doesn't appear to be the case when you add "interactive sorting" to the child report. One the table is re-sorted a number of times, the user shouldn't need to hit back n+1 times.|||

Thanks for your help on this. I know there was a lot of back and forth about the behavior.

I know that people in my organization have asked for a back to parent report feature (i had to embed links to jump back to the parent report into all the reports) and it would be a beneficial feature.

-lance

|||

Robert,

From what I am seeing, the back button works well in IE6 to navigate up from a dill down in reports.

However, in IE7rc1 this is not the case. The back button does not work.

Is this a known issue?

thanks.

Chris

|||

You have to click the back button twice with IE7 RC1 - this is a known issue.

-- Robert

|||Was this functionality released? Or is it still coming.|||

I would just like to register that I am still interested in having a back to parent button available on the standard report viewer web page. It does not seem to have come with SQL 2005 SP2.

There is however the oprion to make such a button appear when you create a web page using aspx:

<rsweb:ReportViewer ID="ReportViewer1" runat="server" Enabled="true"
OnDrillthrough = "ReportViewer1_Drillthrough" OnBack = "ReportViewer1_Back"
AsyncRendering=false SizeToReportContent=true >

.in .cs

...

ReportViewer1.PromptAreaCollapsed = true;
ReportViewer1.ShowBackButton = true;
ReportViewer1.HyperlinkTarget = "_self";
...

Can Microsoft make this button available as an option as part of the standard report viewer?(http://MyServer/ReportServer/Pages/ReportViewer.aspx)

Back to Parent Report button not visible

When I preview a report that has a link to a details report page in VS a "Back to Parent Report" button is displayed. However, when I publish the report to the Report Server, the .aspx page doesnt display the "Back to Parent Report" button. Is there a setting I need to make to have the button displayed?

thanks, lance

The "back to parent" functionality in the HTML report viewer is achieved by clicking the browser's back button.

-- Robert

|||

Well, this isnt the same functionality. Yes, the browser back button goes 1 page back. But the back to parent report, jumps back to the parent report no matter how many pages you have paged through in the child report. If I have a child report that has 20 pages and I scroll through all the pages by clicking next page, the UI you're suggesting requires me to click the back button in the browser 20 times. I could add links in every child report back to the parent report, but this requires embedded links. A "back to parent" report button should automate this process.

Is it possible to add the "back to parent report" button?

Thanks, lance

|||I concur. I need to add the back to parent report button as well.|||What do you think MSFT? Can this functionality be added easily and quickly (anytime before June 23, 2006 would be great)

?

Thanks, -lance|||

Are you talking about viewing a report through report manager? In this case, the browser's back button will always return to the parent report, even if you clicked next page multiple times in the child report.

-- Robert

|||Yes, but thats a non standard UI. Most users are used to having a back to parent button (just as VS has) in order to automatically jump back to the original list page. When paging through a list of records, the back button usually takes you back a list page (see google).

thanks, -lance|||

Ok. So it sounds like you want the browser back button to take you to the previous page (when paging through reports), and you want a separate "back to parent" button.

Once you jump back to parent, I guess you would expect that the brower's back button would then take you back to the previous page on the parent report (basically keeping the browser's pagination history information in sync with drillthroughs / back to parent jumps)?

Well, this kind of functionality is under consideration for a future release - but definitely not available in two days (by June 23rd) as you have asked earlier in this thread.

-- Robert

|||That doesn't appear to be the case when you add "interactive sorting" to the child report. One the table is re-sorted a number of times, the user shouldn't need to hit back n+1 times.|||

Thanks for your help on this. I know there was a lot of back and forth about the behavior.

I know that people in my organization have asked for a back to parent report feature (i had to embed links to jump back to the parent report into all the reports) and it would be a beneficial feature.

-lance

|||

Robert,

From what I am seeing, the back button works well in IE6 to navigate up from a dill down in reports.

However, in IE7rc1 this is not the case. The back button does not work.

Is this a known issue?

thanks.

Chris

|||

You have to click the back button twice with IE7 RC1 - this is a known issue.

-- Robert

|||Was this functionality released? Or is it still coming.|||

I would just like to register that I am still interested in having a back to parent button available on the standard report viewer web page. It does not seem to have come with SQL 2005 SP2.

There is however the oprion to make such a button appear when you create a web page using aspx:

<rsweb:ReportViewer ID="ReportViewer1" runat="server" Enabled="true"
OnDrillthrough = "ReportViewer1_Drillthrough" OnBack = "ReportViewer1_Back"
AsyncRendering=false SizeToReportContent=true >

.in .cs

...

ReportViewer1.PromptAreaCollapsed = true;
ReportViewer1.ShowBackButton = true;
ReportViewer1.HyperlinkTarget = "_self";
...

Can Microsoft make this button available as an option as part of the standard report viewer?(http://MyServer/ReportServer/Pages/ReportViewer.aspx)

Back to Parent Report button not visible

When I preview a report that has a link to a details report page in VS a "Back to Parent Report" button is displayed. However, when I publish the report to the Report Server, the .aspx page doesnt display the "Back to Parent Report" button. Is there a setting I need to make to have the button displayed?

thanks, lance

The "back to parent" functionality in the HTML report viewer is achieved by clicking the browser's back button.

-- Robert

|||

Well, this isnt the same functionality. Yes, the browser back button goes 1 page back. But the back to parent report, jumps back to the parent report no matter how many pages you have paged through in the child report. If I have a child report that has 20 pages and I scroll through all the pages by clicking next page, the UI you're suggesting requires me to click the back button in the browser 20 times. I could add links in every child report back to the parent report, but this requires embedded links. A "back to parent" report button should automate this process.

Is it possible to add the "back to parent report" button?

Thanks, lance

|||I concur. I need to add the back to parent report button as well.|||What do you think MSFT? Can this functionality be added easily and quickly (anytime before June 23, 2006 would be great)

?

Thanks, -lance|||

Are you talking about viewing a report through report manager? In this case, the browser's back button will always return to the parent report, even if you clicked next page multiple times in the child report.

-- Robert

|||Yes, but thats a non standard UI. Most users are used to having a back to parent button (just as VS has) in order to automatically jump back to the original list page. When paging through a list of records, the back button usually takes you back a list page (see google).

thanks, -lance|||

Ok. So it sounds like you want the browser back button to take you to the previous page (when paging through reports), and you want a separate "back to parent" button.

Once you jump back to parent, I guess you would expect that the brower's back button would then take you back to the previous page on the parent report (basically keeping the browser's pagination history information in sync with drillthroughs / back to parent jumps)?

Well, this kind of functionality is under consideration for a future release - but definitely not available in two days (by June 23rd) as you have asked earlier in this thread.

-- Robert

|||That doesn't appear to be the case when you add "interactive sorting" to the child report. One the table is re-sorted a number of times, the user shouldn't need to hit back n+1 times.|||

Thanks for your help on this. I know there was a lot of back and forth about the behavior.

I know that people in my organization have asked for a back to parent report feature (i had to embed links to jump back to the parent report into all the reports) and it would be a beneficial feature.

-lance

|||

Robert,

From what I am seeing, the back button works well in IE6 to navigate up from a dill down in reports.

However, in IE7rc1 this is not the case. The back button does not work.

Is this a known issue?

thanks.

Chris

|||

You have to click the back button twice with IE7 RC1 - this is a known issue.

-- Robert

|||Was this functionality released? Or is it still coming.|||

I would just like to register that I am still interested in having a back to parent button available on the standard report viewer web page. It does not seem to have come with SQL 2005 SP2.

There is however the oprion to make such a button appear when you create a web page using aspx:

<rsweb:ReportViewer ID="ReportViewer1" runat="server" Enabled="true"
OnDrillthrough = "ReportViewer1_Drillthrough" OnBack = "ReportViewer1_Back"
AsyncRendering=false SizeToReportContent=true >

.in .cs

...

ReportViewer1.PromptAreaCollapsed = true;
ReportViewer1.ShowBackButton = true;
ReportViewer1.HyperlinkTarget = "_self";
...

Can Microsoft make this button available as an option as part of the standard report viewer?(http://MyServer/ReportServer/Pages/ReportViewer.aspx)

Back to Parent Report button not visible

When I preview a report that has a link to a details report page in VS a "Back to Parent Report" button is displayed. However, when I publish the report to the Report Server, the .aspx page doesnt display the "Back to Parent Report" button. Is there a setting I need to make to have the button displayed?

thanks, lance

The "back to parent" functionality in the HTML report viewer is achieved by clicking the browser's back button.

-- Robert

|||

Well, this isnt the same functionality. Yes, the browser back button goes 1 page back. But the back to parent report, jumps back to the parent report no matter how many pages you have paged through in the child report. If I have a child report that has 20 pages and I scroll through all the pages by clicking next page, the UI you're suggesting requires me to click the back button in the browser 20 times. I could add links in every child report back to the parent report, but this requires embedded links. A "back to parent" report button should automate this process.

Is it possible to add the "back to parent report" button?

Thanks, lance

|||I concur. I need to add the back to parent report button as well.|||What do you think MSFT? Can this functionality be added easily and quickly (anytime before June 23, 2006 would be great)

?

Thanks, -lance|||

Are you talking about viewing a report through report manager? In this case, the browser's back button will always return to the parent report, even if you clicked next page multiple times in the child report.

-- Robert

|||Yes, but thats a non standard UI. Most users are used to having a back to parent button (just as VS has) in order to automatically jump back to the original list page. When paging through a list of records, the back button usually takes you back a list page (see google).

thanks, -lance|||

Ok. So it sounds like you want the browser back button to take you to the previous page (when paging through reports), and you want a separate "back to parent" button.

Once you jump back to parent, I guess you would expect that the brower's back button would then take you back to the previous page on the parent report (basically keeping the browser's pagination history information in sync with drillthroughs / back to parent jumps)?

Well, this kind of functionality is under consideration for a future release - but definitely not available in two days (by June 23rd) as you have asked earlier in this thread.

-- Robert

|||That doesn't appear to be the case when you add "interactive sorting" to the child report. One the table is re-sorted a number of times, the user shouldn't need to hit back n+1 times.|||

Thanks for your help on this. I know there was a lot of back and forth about the behavior.

I know that people in my organization have asked for a back to parent report feature (i had to embed links to jump back to the parent report into all the reports) and it would be a beneficial feature.

-lance

|||

Robert,

From what I am seeing, the back button works well in IE6 to navigate up from a dill down in reports.

However, in IE7rc1 this is not the case. The back button does not work.

Is this a known issue?

thanks.

Chris

|||

You have to click the back button twice with IE7 RC1 - this is a known issue.

-- Robert

|||Was this functionality released? Or is it still coming.|||

I would just like to register that I am still interested in having a back to parent button available on the standard report viewer web page. It does not seem to have come with SQL 2005 SP2.

There is however the oprion to make such a button appear when you create a web page using aspx:

<rsweb:ReportViewer ID="ReportViewer1" runat="server" Enabled="true"
OnDrillthrough = "ReportViewer1_Drillthrough" OnBack = "ReportViewer1_Back"
AsyncRendering=false SizeToReportContent=true >

.in .cs

...

ReportViewer1.PromptAreaCollapsed = true;
ReportViewer1.ShowBackButton = true;
ReportViewer1.HyperlinkTarget = "_self";
...

Can Microsoft make this button available as an option as part of the standard report viewer?(http://MyServer/ReportServer/Pages/ReportViewer.aspx)

Back call without drillthrough report

ASP.Net 2.0 Web app with ReportViewer Control.
I have a basic report that has a link to another report.
The first report loads OK then I click the link then the second report loads
OK.
But when I then hit the back button (the back arrow in the Reportviewer
Control) I get Back call without drillthrough report?
My control in aspx page:
<rsweb:ReportViewer ID="ReportViewer1" runat="server"
Font-Names="Verdana" Font-Size="9pt"
ProcessingMode="Remote"
Height="96%" Width="100%"
BorderColor="#ECE9D8" BorderStyle="Solid" BorderWidth="1px"
ShowBackButton="True">
</rsweb:ReportViewer>
my code behind:
string url = Request.QueryString["url"];
string path = Request.QueryString["path"];
if (!Page.IsPostBack)
{
ReportViewer1.ServerReport.ReportServerUrl = new System.Uri(url);
ReportViewer1.ServerReport.ReportPath = path;
}
Any ideas appretiated!The problem I have here only happens on some servers and not others. I
determind the diffrence between working and not workin servers is:
c:\windows\assembly\Microsoft.ReportViewer.WebForms
working servers have version 8.0.50727.42
servers with the problem have version 8.0.50727.762
Is there a way to downgrade Microsoft.ReportViewer.* assemblies? I try to
uninstall but not allowed. Maybe if I uninstall VS2005 and SP1 and
reinstall?
Thank you for any ideas!
"dev648237923" <dev648237923@.noemail.noemail> wrote in message
news:e8LjwTJeHHA.3996@.TK2MSFTNGP06.phx.gbl...
> ASP.Net 2.0 Web app with ReportViewer Control.
> I have a basic report that has a link to another report.
> The first report loads OK then I click the link then the second report
> loads OK.
> But when I then hit the back button (the back arrow in the Reportviewer
> Control) I get Back call without drillthrough report?
> My control in aspx page:
> <rsweb:ReportViewer ID="ReportViewer1" runat="server"
> Font-Names="Verdana" Font-Size="9pt"
> ProcessingMode="Remote"
> Height="96%" Width="100%"
> BorderColor="#ECE9D8" BorderStyle="Solid" BorderWidth="1px"
> ShowBackButton="True">
> </rsweb:ReportViewer>
> my code behind:
> string url = Request.QueryString["url"];
> string path = Request.QueryString["path"];
> if (!Page.IsPostBack)
> {
> ReportViewer1.ServerReport.ReportServerUrl = new System.Uri(url);
> ReportViewer1.ServerReport.ReportPath = path;
> }
> Any ideas appretiated!
>|||Hello Dev,
Based on my research, this is a known issue in ReportViewer Web control
after install the VS SP1.
The problem is the way the session keep alive ping happens. We ping each
session in the drillthrough stack to keep each one alive independently. But
the viewer http handler has logic to detect the following scenario:
1. User views main report
2. User clicks to a drillthrough report
3. User presses the *browser* back button
4. User performs an export/page navigation/another drillthrough/etc.
In the case of a browser back button click, the server doesn't know that
the user has moved back to the main report. So we have some information on
the url that tells the http handler that this request is for the parent
report (this is the reportstack=1 url parameter). As a result, the http
handler will unwind the drillthrough stack to the appropriate parent report
and continue processing.
The problem is that this reportstack parameter is also on the ping to keep
session alive. So immediately on rendering the page, the browser will now
ping all of the sessions. One of these is the root report, which eventually
unwinds the entire stack.
The only workaround is to not use ASP.Net session. The viewer can be
configured to not use session in server mode
(http://msdn2.microsoft.com/en-us/library/aa983458(VS.80).aspx). This
problem does not happen in local mode because there is only one session
regardless of how many drillthrough occur - the ASP.Net session.
If you want to downgrade to the early version of the controls, please use
the gacutility to remove the dlls from GAC and then install the earlier
redistribute package.
http://msdn2.microsoft.com/en-us/library/ex0ss12c(vs.80).aspx
And you could download the redistribute package here:
http://www.microsoft.com/downloads/details.aspx?familyid=8a166cac-758d-45c8-
b637-dd7726e61367&displaylang=en
Hope this will be helpful!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hi --
Is there a hotfix scheduled or do you think SP2 will have an updated viewer.
Thank you!
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:nOjNZpoeHHA.5016@.TK2MSFTNGHUB02.phx.gbl...
> Hello Dev,
> Based on my research, this is a known issue in ReportViewer Web control
> after install the VS SP1.
> The problem is the way the session keep alive ping happens. We ping each
> session in the drillthrough stack to keep each one alive independently.
> But
> the viewer http handler has logic to detect the following scenario:
> 1. User views main report
> 2. User clicks to a drillthrough report
> 3. User presses the *browser* back button
> 4. User performs an export/page navigation/another drillthrough/etc.
> In the case of a browser back button click, the server doesn't know that
> the user has moved back to the main report. So we have some information on
> the url that tells the http handler that this request is for the parent
> report (this is the reportstack=1 url parameter). As a result, the http
> handler will unwind the drillthrough stack to the appropriate parent
> report
> and continue processing.
> The problem is that this reportstack parameter is also on the ping to keep
> session alive. So immediately on rendering the page, the browser will now
> ping all of the sessions. One of these is the root report, which
> eventually
> unwinds the entire stack.
> The only workaround is to not use ASP.Net session. The viewer can be
> configured to not use session in server mode
> (http://msdn2.microsoft.com/en-us/library/aa983458(VS.80).aspx). This
> problem does not happen in local mode because there is only one session
> regardless of how many drillthrough occur - the ASP.Net session.
> If you want to downgrade to the early version of the controls, please use
> the gacutility to remove the dlls from GAC and then install the earlier
> redistribute package.
> http://msdn2.microsoft.com/en-us/library/ex0ss12c(vs.80).aspx
> And you could download the redistribute package here:
> http://www.microsoft.com/downloads/details.aspx?familyid=8a166cac-758d-45c8-
> b637-dd7726e61367&displaylang=en
> Hope this will be helpful!
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscriptions/support/default.aspx.
> ==================================================> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>|||Hello Dev,
I don't get the information from product team. Currently, there is no
hotfix. I will confirm this with the product team.
For now, if you have any concern with the workaround, you may want to work
with Microsoft Customer Service and Support (CSS) for a faster resolution.
Once you open a Support incident with Microsoft CSS, a dedicated Support
Professional can work with you in a more efficient manner.
To obtain the phone numbers for a specific technology request please take a
look at the web site listed below.
<http://support.microsoft.com/default.aspx?scid=fh;EN-US;PHONENUMBERS>
If you are outside the US please see http://support.microsoft.com for
regional support phone numbers.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||I meant to say 'It didn't work' Sorry
Andy
EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com

Back Button in RS 2000?

Hello.
I'm developing reports in Reporting Services 2000 and Visual Studio 2003. I
have a "drill-through" report. Upon drilling through to the report, and then
clicking the back button to return to the main report, the report doesn't
even render. However, while developing the report and previewing it in VS
2003, there is a back button supplied there that works perfectly every time.
My question is this: is there a way to tell Reporting Services to include a
back button like the one in the report designer on the deployed report?
Alternatively, is there a way to provide a hyperlink in the drill-through
report that takes the user back to the original report (with all parameters
included in the link)?
Thanks!
JohnA small Back button is available in 2005. If it is not a parameter report
then it would have been easy, but since the main report is parameter based,
you can have a back button link and once you click; it comes back to the
main page and waits for parameter. So really it doesn;t serves your purpose.
But if the main page can wait for the input then you can use this method.
Amarnath
"JohnJohn" wrote:
> Hello.
> I'm developing reports in Reporting Services 2000 and Visual Studio 2003. I
> have a "drill-through" report. Upon drilling through to the report, and then
> clicking the back button to return to the main report, the report doesn't
> even render. However, while developing the report and previewing it in VS
> 2003, there is a back button supplied there that works perfectly every time.
> My question is this: is there a way to tell Reporting Services to include a
> back button like the one in the report designer on the deployed report?
> Alternatively, is there a way to provide a hyperlink in the drill-through
> report that takes the user back to the original report (with all parameters
> included in the link)?
> Thanks!
> John

Back button for drilldown reports

Hereâ's a good question for the knowledgeable: I have been experimenting with
drilldown reports (where a report item is linked to a â'Jump to Reportâ'
action). In the designer there is a nifty little button that allows me to
move back to the previous report (level). This button does not seem apparent
in the Report Manager.
Am I missing something? I realize that there is IEâ's â'backâ' button however
that does not always return me to the previous report. For example if I
toggle the visibility of an item the browserâ's â'backâ' button will return me
to the previous state (hidden) as opposed to back to the report from which
this one was called.Yeah, there isn't one. I just put a back hyperlink in the header and footer
of each page and made sure when going back it sets the parameters to
whatever the default values are or in some cases whatever they were set to
the last time that report was visited.
bob.
"Herman K" <HermanK@.discussions.microsoft.com> wrote in message
news:D08E3158-FB92-4828-A6A8-ABCAA702AE3A@.microsoft.com...
> Here's a good question for the knowledgeable: I have been experimenting
> with
> drilldown reports (where a report item is linked to a 'Jump to Report'
> action). In the designer there is a nifty little button that allows me to
> move back to the previous report (level). This button does not seem
> apparent
> in the Report Manager.
> Am I missing something? I realize that there is IE's 'back' button
> however
> that does not always return me to the previous report. For example if I
> toggle the visibility of an item the browser's 'back' button will return
> me
> to the previous state (hidden) as opposed to back to the report from which
> this one was called.
>

Back button for drill down reports

Hello,

In the sharepoint site from the main report when i go to my drill down report i see no back button, Is there a way to provide back button in the toolbar. I dont want to use the page back button. or is there any way by which if i click for my drill down report the report will be opened in a new window?

Thanks & Regds,

I don't quite remember doing this .. but i was trying to use the

<a href=" javascript:history.back()" >back</a>

tag in reporting services to create a hyperlink which goes one page back in the page history. That effectively will take you to the previous main report.

Alternative is, use a text box in the drill down report, and in the navigation tab of the text box, choose the main report again. The CONS of this is that the main report is generated rather than just going back to the previous page, additionally if the user had changed the parameters of the main report before drilling down, this would not work, as it would open the report with the default set parameters. You can pass all the params of the main report to the drill down report (whether they are being used there or not) and then pass it back.

This does not seem to be the best solution, as i can see it. I remember doing something of this sort long back in BETA of SQL Server. I shall see if i can come up with an alternate way of doing this.