Report Design
 Crystal Reports Forum : Crystal Reports .NET 2003 : Report Design
Message Icon Topic: How to Send Query Parameter Post Reply Post New Topic
Author Message
renge
Newbie
Newbie


Joined: 15 Mar 2010
Location: Japan
Online Status: Offline
Posts: 1
Quote renge Replybullet Topic: How to Send Query Parameter
    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.

IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet 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.
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet 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.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.