Question about parametres passing between reports

Hi, all experts here,

Thank you very much for your kind attention.

I am having a question about the parametres passing between reports. Do we need to create totally the same parametres for the two reports even we only want to jump to the desired report on a particular parametre? E.g. report A got 2 parametres P1 and P2, we only want to jump to report B based on parameter P1 (that is, once I click on the value of P1 in report A, it will birng us to report B with that particular parametre value only), in this case, do we need to create totally the same parametres P1 and P2 in report B as well? or we only need to create P1 in report B? Hope the question is clear for your help.

Thank you very much in advance for your kind help and advices. And I am looking forward to hearing from you soon.

WIth best regards,

Yours sincerely,

As long as P2 can have an empty or null value, or has a default value, you can pass that from the first report.

Or you can set P2 to be a valid value from P1. Sometimes this could be an ALL value.

cheers,

Andrew

|||

Hi,Andrew,

Thanks a lot for your kind advices.

With best regards,

Yours sincerely,

sql

Question about actions on SQL Server 2005 cubes and ProClarity

Hi, all experts here,

Thank you very much for your kind attention.

I am having a question about the actions implemented on cubes in SQL Server 2005 analysis services. The question is-will these actions implemented on cubes in SQL Server 2005 analysis service witll be transferred to ProClarity as well? (what I mean is when we browse the cubes in ProClarity, will we be able to execute the actions from ProClarity?). Hope my question is clear for your help and advices.

Thanks a lot in advance for your help and I am looking forward to hearing from you shortly.

With best regards,

Yours sincerely,

If you process the Adventure Works sample cube, that is part of the installation samples have actions implemented.

Have a look at them in the actions-tab in the cube editor. You have drill-through actions, report actions and html-actions.

Process that cube and open it with ProClarity Professional 6.2-6.3

The report actions (Integration with reporting services 2005) require that you deploy the Adventure Works Reporting Services 2005 project(also part of samples).

HTH

Thomas Ivarsson

|||

Hi,

yes it does.

you can find them in the left panel, under the tab "Actions" in Proclarity.

Regards

|||Actions are carried through to ProClarity Desktop, but not Web Standard.
|||

Hi,all,

Thank you all for your very helpful and kind advices.

With best regards,

Yours sincerely,