Wrox Programmer Forums
|
Classic ASP Professional For advanced coder questions in ASP 3. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Professional section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old September 14th, 2004, 02:26 PM
Registered User
 
Join Date: Sep 2004
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default pass a variable to Crystal Reports

 :DI have an ASP project where I have users select or input values into a criteria page and then once they press "Submit" the ActiveX viewer displays the crystal report. All works fine and the criteria can be somewhat dynamic because the variables are used to build a SQL statement that is passed to the crystal report as the data set.

What I would like to do is create a variable on the Crystal report that will display the SQL statement or at least an English translation. This variable will be used to display the criteria of the report so end-users can see what criteria was used to generate the output of the report.

How could I do this?

 
Old June 7th, 2005, 11:44 AM
Authorized User
 
Join Date: Jun 2005
Posts: 21
Thanks: 0
Thanked 0 Times in 0 Posts
Default

even i have the same requirement -- of displaying the select string on the crystal report. if somebody could help

 
Old July 9th, 2007, 10:31 AM
Registered User
 
Join Date: Jun 2007
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to fcortes
Default

Dude did you ever got this working for you? I'm trying to do the same thing but there's simply not a single answer out there
Thanks!
Quote:
quote:Originally posted by hodgesp
  :DI have an ASP project where I have users select or input values into a criteria page and then once they press "Submit" the ActiveX viewer displays the crystal report. All works fine and the criteria can be somewhat dynamic because the variables are used to build a SQL statement that is passed to the crystal report as the data set.

What I would like to do is create a variable on the Crystal report that will display the SQL statement or at least an English translation. This variable will be used to display the criteria of the report so end-users can see what criteria was used to generate the output of the report.

How could I do this?






Similar Threads
Thread Thread Starter Forum Replies Last Post
how to pass datetime parameter to crystal reports hyder_master Crystal Reports 2 June 25th, 2010 01:18 AM
Shared variable problem in Crystal Reports 8.5 mjk6035 Crystal Reports 1 October 20th, 2008 09:10 AM
How to pass Parameter to Crystal Reports 10 shakti_2505270 ASP.NET 2.0 Professional 1 August 30th, 2007 06:01 AM
pass java variable to xsl variable kathy1016cats XSLT 1 June 14th, 2006 06:23 PM
pass variable kapi.goel C# 1 January 6th, 2006 05:54 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.