Print Page | Close Window

How to Send Query Parameter

Printed From: Crystal Reports Book
Category: Crystal Reports .NET 2003
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=9382
Printed Date: 04 May 2025 at 8:47pm


Topic: How to Send Query Parameter
Posted By: renge
Subject: How to Send Query Parameter
Date Posted: 15 Mar 2010 at 2:22pm

Hello.

I am a Japanese live in Japan.
I use CrystalReport on VB2003.
I have problem on crystal-Report.
Please Anybodey help me.

My coding system is under below.

VB2003(My Program)->CrystalReport->MS-ACCESS2000(Query)

My Program Calls a static Query on Access.
I want to change Query use Parameter.(Dynamic Query)
that's Parameter is date.
I want to use a Query using period of date.

My problem is
How to send parameter from VB2003-Program to CrystalReport and MS-ACCESS

Sorry My English is poor.Cry
Please teach me.


Replies:
Posted By: lockwelle
Date Posted: 16 Mar 2010 at 3:37am
I don't know Access stored procs, but for SQL server, if you change the stored proc, refreshing the database with refresh the parameters and if you need a parameter, Crystal will create it for you.
 
Hopefully it works the same way for Access.

Posted By: kevlray
Date Posted: 16 Mar 2010 at 7:14am
I have used Access queries in CR and set up a date range parameter in CR.  It has always worked.  Everytime I update the report (i.e., refresh).  It re-runs the query with the date parameter I have supplied in CR.


Print Page | Close Window