Crystal Reports Question

Thread View: borland.public.vdbase.16bit

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by G. C. Royston Sat, 15 May 1999 00:00

#239

Author: G. C. Royston
Date: Sat, 15 May 1999 00:00

8 lines
916 bytes

I am using Crystal Reports 3.01 and would like to use a name from a field in
a dbase table different from the one I am using for the report. Is there any
way to do this? Is it possible to pass the field name as a parameter to use
in  the CR header?  The organization can be changed via the VDB 5.6 program
and I prefer not to hard-code this name in the CR report. Thanks is advance
for any response.

G.C. Royston

Re: Crystal Reports Question

#240

Author: Geoff S. Wass ( dBVIPS )
Date: Sun, 16 May 1999 00:00

45 lines
2357 bytes

G.C. Royston,

I can think of a few ways to do this:

1 ) Be sure your report is based on a query (.QBE) and include the second table
in the query (even if it cannot be linked to the other table(s) of your query).
You can then access the field in Crystal Reports and place it on your report. It
can only have one record.

2 ) Use the dBASE application object _app to pass a variable. This is a little
more trouble, but avoids have the extra table. In the command window, create
_app.YourValue = "whatever". Then modi report YourReport and create a Crystal
Report calculated field using _app.YourValue. In your program, you must
programmatically create _app.YourValue *before* running the report. If you
understand how the .QBE works, you can stick this inside of the .QBE and not
have to worry about making _app.YourValue every time you run the report or
modify it.

** IMPORTANT **

These dBASE news groups are dead. There are NEW news groups hosted by the NEW
owner of dBASE: dBASE Inc. Below my signature is a link to the NEW news server
which hosts the NEW news groups. Come join the fun!

"G. C. Royston" wrote:

> I am using Crystal Reports 3.01 and would like to use a name from a field in
> a dbase table different from the one I am using for the report. Is there any
> way to do this? Is it possible to pass the field name as a parameter to use
> in  the CR header?  The organization can be changed via the VDB 5.6 program
> and I prefer not to hard-code this name in the CR report. Thanks is advance
> for any response.
>
> G.C. Royston

--
Geoff Wass ( dBVIPS )
Kuala Lumpur, Malaysia

=>=> More dBASE info at http://members.theglobe.com/Geoff_Wass <=<=

*>*> Visit the NEW! dBASE Inc. news groups on the news server
news://news.dbase2000.com <*<*

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads