Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Crystal Reports Question

0 views
Skip to first unread message

G. C. Royston

unread,
May 15, 1999, 3:00:00 AM5/15/99
to
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 S. Wass ( dBVIPS )

unread,
May 16, 1999, 3:00:00 AM5/16/99
to
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:

--
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 <*<*

Andy Taylor

unread,
May 16, 1999, 3:00:00 AM5/16/99
to
GC

Just add the table to your qbe file used to create the report.

With later versions of Crystal you can create queries within
Crystal for this sort of thing.

Andy

In article <7hkhof$57...@forums.borland.com>, "G. C. Royston"
(groy...@concentric.net) writes: >I am using Crystal Reports 3.01

G. C. Royston

unread,
May 16, 1999, 3:00:00 AM5/16/99
to
Geoff,
Thanks for your prompt response. I am not sure that I know how to base the
CR report on a query. Could you elaborate for one who is programically
challenged?

I originally attempted to post this message to the dbase.version5 newgroup
which I have been monitoring for a while, but for some reason Outlook
Express version 5 won't allow me to post there. I get the error "Message
could not be sent-No sender was specified. Please check your News Account
configuration." When I check the News Account under tools the
news.dbase2000.com is there and everything seems set the same as for other
servers, but Outlook Express doesn't like something about the settings.

Geoff S. Wass ( dBVIPS ) <gsw...@ibm.net> wrote in message
news:373E7343...@ibm.net...

Gary White [dBVIPS]

unread,
May 17, 1999, 3:00:00 AM5/17/99
to
On Sun, 16 May 1999 16:42:01 -0500, G. C. Royston wrote:

> I originally attempted to post this message to the dbase.version5 newgroup
> which I have been monitoring for a while, but for some reason Outlook
> Express version 5 won't allow me to post there. I get the error "Message
> could not be sent-No sender was specified. Please check your News Account
> configuration." When I check the News Account under tools the
> news.dbase2000.com is there and everything seems set the same as for other
> servers, but Outlook Express doesn't like something about the settings.

You may have loaded the group list before the groups were renamed.
The simplest thing to do is delete the news.dbase2000.com account,
then add it back and get a new group list.


Please move to the dBASE2000 News Groups at
news://news.dbase2000.com
as soon as possible The groups here will close very soon.

Gary White [dBVIPS]

Some dBASE Stuff at
http://www.AppTools.com/dbase

G. C. Royston

unread,
May 17, 1999, 3:00:00 AM5/17/99
to
Gary,
you were absolutely right. After reloading, I was able to post successfully.
Thanks for the advice.

G.C. Royston

Gary White [dBVIPS] <dBV...@usa.net> wrote in message
news:37404a61....@forums.borland.com...

Geoff S. Wass ( dBVIPS )

unread,
May 17, 1999, 3:00:00 AM5/17/99
to
G.C. Royston,

When you say you don't know how to base a report on a query, are you saying you
don't know how to make a query or that you don't know how to use a query to make
a report?

I am not sure about your news group problems. Are you able to post to the
dbase.test news group or any of the other ones? Maybe you need to remove the
news.dbase2000.com and add it back (then select your news groups) again.


"G. C. Royston" wrote:

> Geoff,
> Thanks for your prompt response. I am not sure that I know how to base the
> CR report on a query. Could you elaborate for one who is programically
> challenged?
>

> I originally attempted to post this message to the dbase.version5 newgroup
> which I have been monitoring for a while, but for some reason Outlook
> Express version 5 won't allow me to post there. I get the error "Message
> could not be sent-No sender was specified. Please check your News Account
> configuration." When I check the News Account under tools the
> news.dbase2000.com is there and everything seems set the same as for other
> servers, but Outlook Express doesn't like something about the settings.
>

--

Gary White [dBVIPS]

unread,
May 18, 1999, 3:00:00 AM5/18/99
to
On Mon, 17 May 1999 16:11:43 -0500, G. C. Royston wrote:

> you were absolutely right. After reloading, I was able to post successfully.
> Thanks for the advice.

Glad you got it working. Hope to see you there.

G. C. Royston

unread,
May 19, 1999, 3:00:00 AM5/19/99
to
Geoff,

Thanks for response. After I posted this question about the query I followed
your first suggestion and got the CR report working with a QBE allowing me
to use a field from a second database in the report. I had just not realized
that you could do this.

The news group problem was solved by deleting and re-adding the
news.dbase2000.com server. I have been posting to the dbase.version5 group
with no problems. Will all groups on this server be shut down or is it just
this group?

Grover Royston

Geoff S. Wass ( dBVIPS ) <gsw...@ibm.net> wrote in message

news:373FC347...@ibm.net...

Gary White [dBVIPS]

unread,
May 20, 1999, 3:00:00 AM5/20/99
to
On Wed, 19 May 1999 20:11:25 -0500, G. C. Royston wrote:

> The news group problem was solved by deleting and re-adding the
> news.dbase2000.com server. I have been posting to the dbase.version5 group
> with no problems. Will all groups on this server be shut down or is it just
> this group?

It will be all the dBASE groups.

Geoff S. Wass ( dBVIPS )

unread,
May 24, 1999, 3:00:00 AM5/24/99
to
Grover,

Thanks for the success report. I'm glad I was able to help. It's good you have
made it into the new news groups. It is only the dBASE news groups at Inprise
that will be closing. Alan Katz only bought dBASE from them. The other languages
still belong to Inprise.


"G. C. Royston" wrote:

> Geoff,
>


> Thanks for response. After I posted this question about the query I followed
> your first suggestion and got the CR report working with a QBE allowing me
> to use a field from a second database in the report. I had just not realized
> that you could do this.
>

> The news group problem was solved by deleting and re-adding the
> news.dbase2000.com server. I have been posting to the dbase.version5 group
> with no problems. Will all groups on this server be shut down or is it just
> this group?
>

> Grover Royston

0 new messages