Showing posts with label parent. Show all posts
Showing posts with label parent. Show all posts

Monday, March 19, 2012

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)

Sunday, March 11, 2012

Back Button : Going back to parent report from the child report in Report Manager screen

Hi,
In my report manager screen, i want to place the back button option by which user can navigate to the parent report?
For example, I am viewing the orders screen(parent report), in that screen i am clicking the orderid column, it navigates to another report(child report), from which i want to go back to parent report..
I am not using the reportviewer control...
i am using only the report manager....
is it possible?
how do we achieve this?

thanks in advance

Have you figured a way to do this? I am trying to do the same thing.

Thanks,

|||It is possible using Jump To Report functionality

Back Button : Going back to parent report from the child report in Report Manager screen

Hi,
In my report manager screen, i want to place the back button option by which user can navigate to the parent report?
For example, I am viewing the orders screen(parent report), in that screen i am clicking the orderid column, it navigates to another report(child report), from which i want to go back to parent report..
I am not using the reportviewer control...
i am using only the report manager....
is it possible?
how do we achieve this?

thanks in advance

Have you figured a way to do this? I am trying to do the same thing.

Thanks,

|||It is possible using Jump To Report functionality

Friday, February 24, 2012

Avoiding Empty Tags using XML Explicit..

Hey all, a nice little challenge for you as I've searched all over..

Here is some very simple XML Explicit code:

SELECT 1 AS TAG,
NULL AS Parent,
product AS [ParentTag!1!AProduct!Element]

FROM tblTable

WHERE X = Y

FOR XML EXPLICIT

When there is no results, I get an empty tag.

<ParentTag/>

This I do not want. Insted I would like nothing. Is there a simple way to achieve this?

Using SQL Server 2000

Looking forward to your responses!

Roqs

Dunno if its just my SQL Server but mine is working fine. I get a blank when no data is returned (Not the <ParentTag/>)

Tried this with northwind.

SELECT 1 AS TAG,

NULL AS Parent,

CompanyName AS [ParentTag!1!AProduct!Element]


FROM Customers


WHERE CustomerID = 'LFKI'


FOR XML EXPLICIT