Passing values to a report 
Author Message
 Passing values to a report

Is there a way to pass values to be included as part of a report ?

The report I need has three parts. First two parts just record number count
of records in  two  different, unrelated tables with enter date between two
dates. I have used other queries to find the counts. Now I need to pass the
counts as well as the two dates to be included in the report.

The  third part is a listing of two  columns in an answer table. Since this
part can get quite long, report  is  preferred over  form. Besides, I can't
find any help/information on action(DataPrint).

I would think passing values to a report should be a very common action for
periodical report like monthly or weekly report.



Sat, 09 Oct 1999 03:00:00 GMT
 Passing values to a report

Quote:

> Is there a way to pass values to be included as part of a report ?

Yes:

In the ObjectPAL which runs the report, set an environment string to the
text you want on the report:

  wri{*filter*}vironmentString("text_1", "This will appear on the report")

On the report, add a calculated field which reads the environment
string:

  readEnvironmentString("text_1")

--
Daniel McKeown

 \ _ /
- (~) -
 / U \

 %%%%%
 |~ ~|
{-O-0-}
   0  
 \___/



Sun, 10 Oct 1999 03:00:00 GMT
 Passing values to a report

Quote:

> Is there a way to pass values to be included as part of a report ?

> The report I need has three parts. First two parts just record number count
> of records in  two  different, unrelated tables with enter date between two
> dates. I have used other queries to find the counts. Now I need to pass the
> counts as well as the two dates to be included in the report.

Before running the report setup the vales you require then write them to
environment space using

wri{*filter*}vironmentString("Date1",<the value goes in here>)

Place two "Undefined Fields" on the report.  Then when you use the
dialog box
to defie the fields choose "calculated field".

Now eneter

readEnvironmentString("Date1")

for each field. When you run the report it will use the stored value.
This obviously uses up your environment space but it work.  You can
achieve the same outcome with read/writeProfileString.  Look in the
help.

HTH

Che

Quote:

> The  third part is a listing of two  columns in an answer table. Since this
> part can get quite long, report  is  preferred over  form. Besides, I can't
> find any help/information on action(DataPrint).

> I would think passing values to a report should be a very common action for
> periodical report like monthly or weekly report.



Sun, 10 Oct 1999 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Passing value to Crystal report

2. Passing a value from a form / subform to a report

3. crystal reports 8 and passing parameter values

4. how to pass a value to a stored procedure within crystal reports

5. How to pass VB5 values to Crystal Report text field

6. pass the value from my VB form to Data Report's label control

7. Passing value of strin variables to a report title

8. Passing Range of values in Drill through Reports.

9. Setting up default values from the passed value

10. chng. fld.values on report, passing values to report : QUESTION ??

11. Crystal Reports - Report Title Passing

12. Passing Report Variables from the Master to Detail Reports


 
Powered by phpBB® Forum Software