Quick way to set up actions?

Question

Quick way to set up actions?

cubed

Newbie

Points: 8
More actions
March 22, 2011 at 6:33 am

#389103

Hi all
Hope you can help
I am creating a series of reports which have lots of "Action" links to "Go To Report", each of these have approximately 8 parameters to pass to the child report.
I'm just wondering if there is a quick way to copy and paste the action and parameter set from one control to another even if there is a code-behind file I can access?
It's going to be quite time consuming adding each parameter to each report field, with only a slight parameter value change each time.
Cheers
Phil

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 1

Right click on the report in the explorer pane, view code.

That will give you the xml source code. Keep in mind that you have 2 instances of the same file opened and that it's easy to screw up the xml. I ALWAYS save a copy before starting to edit. Saved me quite a few times.

Then start doing searches to find the code you used in one of the parameter expressions. From there on out you can just copy / paste.

Here's a sample of what that code might look like :

<Action>

<Drillthrough>

<ReportName>Marges - détails</ReportName>

<Parameters>

<Parameter Name="BeginDate">

<Value>=Parameters!BeginDate.Value</Value>

</Parameter>

<Parameter Name="EndDate">

<Value>=Parameters!EndDate.Value</Value>

</Parameter>

<Parameter Name="FGF_EA">

<Value>=Parameters!FGF_EA.Value</Value>

</Parameter>

<Parameter Name="FGF_OD">

<Value>=Parameters!FGF_OD.Value</Value>

</Parameter>

<Parameter Name="SalesReps">

<Value>=Parameters!SalesReps.Value</Value>

</Parameter>

<Parameter Name="BillTo">

<Value>=Parameters!BillTo.Value</Value>

</Parameter>

<Parameter Name="SalesRep_To_Hidden">

<Value>=Parameters!SalesRep_To_Hidden.Value</Value>

</Parameter>

<Parameter Name="DocTypes">

<Value>=Parameters!DocTypes.Value</Value>

</Parameter>

<Parameter Name="Bureaux">

<Value>=Parameters!Bureaux.Value</Value>

</Parameter>

<Parameter Name="ParamReportProduits">

<Value>=Parameters!ParamReportProduits.Value</Value>

</Parameter>

<Parameter Name="Famille">

<Value>=Parameters!Famille.Value</Value>

</Parameter>

<Parameter Name="IsOD">

<Value>=Parameters!IsOD.Value</Value>

</Parameter>

<Parameter Name="Type">

<Value>=Parameters!Type.Value</Value>

</Parameter>

<Parameter Name="DateFilterType">

<Value>=Parameters!DateFilterType.Value</Value>

</Parameter>

<Parameter Name="DocumentNo">

<Value>=Parameters!DocumentNo.Value</Value>

</Parameter>

<Parameter Name="MargeMaxPourAnalyse">

<Value>=Parameters!MargeMaxPourAnalyse.Value</Value>

</Parameter>

<Parameter Name="MargeMinPourAnalyse">

<Value>=Parameters!MargeMinPourAnalyse.Value</Value>

</Parameter>

<Parameter Name="MontantVenteMinPourAnalyse">

<Value>=Parameters!MontantVenteMinPourAnalyse.Value</Value>

</Parameter>

<Parameter Name="PercEcartCoutNegocieCoutUtilise">

<Value>=Parameters!PercEcartCoutNegocieCoutUtilise.Value</Value>

</Parameter>

</Parameters>

</Drillthrough>

</Action>

cubed Newbie Points: 8 More actions · Answer 2

I can't thank you enough. That's going to save me so much time.

Cheers for the quick reply too. 🙂

Phil