Report Action - click through to remote report 3

[SQLScholar]

Hey all,

Is it possible to do a click through (and pass parametres etc) to a report that is not part of the VS solution. If so how? I only seem to have a choice of reports that are part of the solution.

Dan

----------------------------------------

http://www.fountain.me.uk

Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Dr. Seuss

Computer Science is no more about computers than astronomy is about telescopes - EW Dijkstra
----------------------------------------

 

[NoCoolHandle]

My first guess is yes, but it migth be necessary to import the existing report to the current soultion to make it work..

From report manager you can export (save) the report out to disk from the properties tab.

What version of ReportingServices are you using?

 

[ousoonerjoe]

				ReportName = "/Application/INV/PUR001" 
				'If LstParam Is Nothing Then LstParam = New Generic.List(Of Microsoft.Reporting.WinForms.ReportParameter)()
				'LstParam.Add(New Microsoft.Reporting.WinForms.ReportParameter("PO", PoNum, False))
				'frmSvrReport.Show()  'calls a form with a ReportViewer control.
				'LstParam = Nothing
				'below calls IE and loads the report specified in ReportName and passes a parameter called PoNum to the report.
				System.Diagnostics.Process.Start("iexplore.exe", "[URL unfurl="true"]http://servername/reportserver?"[/URL] & ReportName & "&rs:Command=Render&PO=" & PoNum)

--------------------------------------------------
“Crash programs fail because they are based on the theory that, with nine women pregnant, you can get a baby a month.” --Wernher von Braun
--------------------------------------------------

 

[xlbo]

yes - just use the "jump to url" option

this can be set to an expression so use the paramters to append strings to the report path to prefill the parameters you want et voila..

e.g. "

http://report/path/and/name/here&param1="

& fields!fieldname1.value & "&param2=" & fields!fieldname2.value

etc etc - you can also pass other items like the format of the report and whether to display parameters area etc as part of the url

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[SQLScholar]

Aha.

Thanks all. I will look into trying this shortly. Not needed as such straight away, but i have noticed that we are going to have too many reports if we cant link in this way.

Dan

----------------------------------------

http://www.fountain.me.uk

Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Dr. Seuss

Computer Science is no more about computers than astronomy is about telescopes - EW Dijkstra
----------------------------------------