We help IT Professionals succeed at work.

Passing parameter values through a URL using a query string

66 Views
Last Modified: 2020-06-03
I am not sure how to ask this but here goes. I am trying to pass a series of parameter values from one products filtering through to anothers. From Tableau to Crystal Reports via URL query string parameters.Line one shows what works if the values are manually entered. However with Tableaus Actions feature. You can edit the URL and manually put those in. I am wondering
This query string shows all US states
1. http://localhost/Ripplestone/CRViewer.aspx?DocID=22&User=administrator&Key=c1dda10c&Params=USA,ALL

This query string produces nothing but shows the naming convention of the parameters in both the Crystal Report and Tableau.
2. http://localhost/Ripplestone/CRViewer.aspx?DocID=22&User=administrator&Key=c1dda10c&Params=<Parameters.Country>,<Parameters.Region>

I am totally clueless as to how to pass a parameter from one filtered action in Tableau through to a URL that displays an embedded Crystal Report. If I have left out key information or botched this question let me know. Thank you.
Comment
Watch Question

Professor Emeritus of MIS at Penn State Erie and Owner, Millet Software
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Scott McDaniel (EE MVE )Infotrakker Software
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2014
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
RUA Volunteer2?Crystal Reports Tableau Developer Trainer Consultant Sales Exec.

Author

Commented:
Thank you Ido & Scott and I do have the syntax needed for Ripplestone:

Here is the direct quote and page from the Admin manual. My goal is to pass a parameter through from Tableau's interface to a Crystal Report through the URL either in the Action feature or other.

Calling a report from outside of Ripplestone (RS Express)
This feature, called RS Express, allows a report to be run and viewed in the report viewer without first logging into Ripplestone. This allows users of Ripplestone to run reports that are published in Ripplestone from external applications without the users first logging into Ripplestone and running the report from the Ripplestone application.
RS Express uses a query string that is appended to the URL to provide information that the viewer and report need to run. This information is normally provided by the Ripplestone application, but will now be provided using the query string
Below are instructions on how to use this feature
1. The query string can take up to 8 parameters. The first 2 are required and the others are optional. The name and description of each are listed below. Parameter name Required Description
DocID
X
The ID of the published document. Note: The report must already be published within Ripplestone.
User
X
The name of an existing user within Ripplestone. For example, Administrator
You can also use the encrypted user name described below.
Params
This is used to pass in values for report parameters. If the report has multiple parameters each parameter is separated by a comma.
Range parameters can be passed in and are separated by a semi-colon (;). For example, if a report had two parameters, a Country parameter and a HireDate parameter and the Hire Date parameter is a range type, then the syntax would be Params=USA,4/1/2017;8/15/2017. This would pass “USA” into the Country parameter and would pass in the two dates as the start value and end value for the HireDate parameter.
Key
A system generated key to make this report unique. This helps make the query string more secure.
ExtFileName
This is used to pass in a file name that will be used to save a copy of the report. The Send To feature needs to be turned on in the Edit Document page to be used.
FileLocation
This is an ID for the Saved File Location that should be used to save the file. This is setup in the Saved File Location page and is used by the Send To feature along with the ExtFileName above. Using this will allow the report to be exported to the provided name and saved to a predefined location.
Display
This option determines if the report should be displayed on the users screen.

Open in new window

Scott McDaniel (EE MVE )Infotrakker Software
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2014

Commented:
Do they provide any examples of how to pass in those parameters?
RUA Volunteer2?Crystal Reports Tableau Developer Trainer Consultant Sales Exec.

Author

Commented:
This is what was provided:Some instructions for passing query strings
RUA Volunteer2?Crystal Reports Tableau Developer Trainer Consultant Sales Exec.

Author

Commented:
Fundamentally I think it was a lack of knowledge of asp.net on my part and how things work in it. The documentation did help some but was not everything needed. Your support was appreciated. 
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.