How to detach a report permanently?

[Anonymous]

Hi

I would like to detach a report permanently so that a user cannot change any of the values it shows, yet allow them to do so on other tables/charts etc.

In case you are wondering I have a report that shows Sales YTD, Budgeted Sales 2011, Budgeted Sales YTD and some calculated fields which show how much of the Budgeted Sales 2011 we have achieved and how much against the Budgeted Sales YTD we have achieved. The report works great until a user selects a product brand in another table or year or month which then changes the figures on this report which we do not want it to do....

Any help greatly appreciated!

Thanks

Sagardetacj

[pover · Accepted solution]

You can't detach a object permanently, but you can fix the table values using set analysis.

For example,

sum({1<Year=2010>} Sales)

will fix the year to 2010 and ignore all other selections.

Regards.

[Anonymous]

Thankyou!

Best Regards

Sagar

[Anonymous]

There is "Detached" checkbox in the chart properties - it is permanent, like any chart properties.

Hint: to "detach" report using set analysis, you have to use sets not only in expression, but also the chart dimensions should be calculated with sets. I assume the reason is obvious.

[pover]

Michael is right. I don't know why I first looked for this property in the Layout and Caption tab, but it is in the General tab. My mindset that almost all common properties between objects are in the Layout and Caption tab is probably to fault.

And yes, it is permanently detached because even after a reload, the object is not updated with the new data. I don't know if that is the desired behavior so instead of permanently detaching an object, it might be more useful to write a small macro to detach the object on opening the application so that the object is attached for the reloads, but detached for the user.

I don't know what is meant by calculating dimensions with sets. I've never had to do that to fix report data, but if the point is that using set analysis is more work than ticking the detached property then yes, that is obvious.

Regards.

[Anonymous]

Hi

Thanks for the info - but it looks like I will be using the set analysis (which I have got working now..)

I am going to try the other method as well and use the one that is simplest...

Thanks!

Sagar

[richard_chilvers]

Hi

This discussion was a while back, but I have the same issue.

I have found that if you check the Detached box on the General tab of a chart, it is not permanent and on re-opening/reloading the chart is recalculated.

That is fine except, I then want to detach the chart (until the next reload). It sounds like I need to use a macro. Any ideas what that might be ?

Thanks.

[#8]

Is there a way we can remove the text "(Detached)" that appears in the chart's title bar ?

I am looking to detach a chart permanently. But i dont want that text to appear  in the title bar ? Is there a way this can be done ?

[ashfaq_haseeb]

Hi,

why don't you use alternate states instead.

Regards

ASHFAQ

[#10]

I get this same issue.  it does not detach the chart permanently.

Are there any ways that this can be done?

Thanks all