Crystal Reports Question

Yahoo Archive
1
Does anyone know how to keep a group header and its details together. I
do not want the group header to print on page 1 and the details on page
2. I did this on another form but I can not find it or figure out what
I did.

It has been a long day.

Thanks,
Dina
2
I think I found it - of course as soon as I hit send. I believe it is Under
Change Group - Keep Group Together. This worked for the form but if this is
not correct can someone please let me know.

Thanks.

D
Dina Hieber wrote:

> Does anyone know how to keep a group header and its details together. I
> do not want the group header to print on page 1 and the details on page
> 2. I did this on another form but I can not find it or figure out what
> I did.
>
> It has been a long day.
>
> Thanks,
> Dina
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
3
Good Morning Group,

I have a Crystal question. I am creating a VB form in the OrderHed that
contains check boxes that identify the certification requirements on the
sales order.

Here is my problem. The OrderHed Table in the Crystal Form does not have
the 5 Check Boxes. On a trial bases I deleted the OrderHed from a copy of
the canned form and re-inserted the OrderHed the boxes show up.

Is there any way I can just change the existing OrderHed.dbf to include all
fields in the Vantage OrderHed.

We are on V4.904 using Crystal 7

Thanks,

Wayne
4
Wayne,

I don't think there is any way to change what data is output to the dbf
files.

As an alternative, if you use the VB Forms check box, that data is in the
OrderHed dbf file for you to grab in crystal.

-Sarah


-----Original Message-----
From: Wayne Katzenberger [mailto:wkatz@...]
Sent: Tuesday, April 17, 2001 9:32 AM
To: 'Vantage User Group'
Subject: [Vantage] Crystal Reports Question


Good Morning Group,

I have a Crystal question. I am creating a VB form in the OrderHed that
contains check boxes that identify the certification requirements on the
sales order.

Here is my problem. The OrderHed Table in the Crystal Form does not have
the 5 Check Boxes. On a trial bases I deleted the OrderHed from a copy of
the canned form and re-inserted the OrderHed the boxes show up.

Is there any way I can just change the existing OrderHed.dbf to include all
fields in the Vantage OrderHed.

We are on V4.904 using Crystal 7

Thanks,

Wayne



To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have already
linked your email address to a yahoo id to enable access.

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
5
Wayne,
Open the existing canned report and use the verify database option: It's
under the Database dropdown menu. You will be asked to fix - respond Yes.
This will update the fields that Crystal see.
Regards
Jim Stetter

-----Original Message-----
From: Wayne Katzenberger [mailto:wkatz@...]
Sent: Tuesday, April 17, 2001 9:32 AM
To: 'Vantage User Group'
Subject: [Vantage] Crystal Reports Question


Good Morning Group,

I have a Crystal question. I am creating a VB form in the OrderHed that
contains check boxes that identify the certification requirements on the
sales order.

Here is my problem. The OrderHed Table in the Crystal Form does not have
the 5 Check Boxes. On a trial bases I deleted the OrderHed from a copy of
the canned form and re-inserted the OrderHed the boxes show up.

Is there any way I can just change the existing OrderHed.dbf to include
all
fields in the Vantage OrderHed.

We are on V4.904 using Crystal 7

Thanks,

Wayne


Yahoo! Groups Sponsor

Click Here to Find Software Faster


To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have already
linked your email address to a yahoo id to enable access.

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]
6
Jim,

Just tried that. It came back that data base is up to date. Any other
suggestions?

Wayne

-----Original Message-----
From: Jim Stetter [mailto:jimstetter@...]
Sent: Tuesday, April 17, 2001 8:42 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Reports Question


Wayne,
Open the existing canned report and use the verify database option: It's
under the Database dropdown menu. You will be asked to fix - respond Yes.
This will update the fields that Crystal see.
Regards
Jim Stetter

-----Original Message-----
From: Wayne Katzenberger [mailto:wkatz@...]
Sent: Tuesday, April 17, 2001 9:32 AM
To: 'Vantage User Group'
Subject: [Vantage] Crystal Reports Question


Good Morning Group,

I have a Crystal question. I am creating a VB form in the OrderHed that
contains check boxes that identify the certification requirements on the
sales order.

Here is my problem. The OrderHed Table in the Crystal Form does not have
the 5 Check Boxes. On a trial bases I deleted the OrderHed from a copy of
the canned form and re-inserted the OrderHed the boxes show up.

Is there any way I can just change the existing OrderHed.dbf to include
all
fields in the Vantage OrderHed.

We are on V4.904 using Crystal 7

Thanks,

Wayne


Yahoo! Groups Sponsor

Click Here to Find Software Faster


To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have already
linked your email address to a yahoo id to enable access.

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]



To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have already
linked your email address to a yahoo id to enable access.

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
7
Did you do a print preview from the Sales order before verifying the
database?
8
Sara,

Yes I did. Still can't see the check boxes. I opened a new report and
inserted the OrderHed table and they do appear if a add all fields.

Wayne

-----Original Message-----
From: sarah.vareschi@... [mailto:sarah.vareschi@...]
Sent: Tuesday, April 17, 2001 10:20 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Reports Question


Did you do a print preview from the Sales order before verifying the
database?


To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have already
linked your email address to a yahoo id to enable access.

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
9
We use 5 VBForms fields from the Order Header and about 15 from the Order
Detail tables, and all i had to do was print preview the report, then open
the report in crystal and verify the database and then add the fields to the
report and everything works fine. They show up in crystal as
"ODField_Name".
10
Wayne,

When you goto to add a database field to your report, the first fields you
see are those that are already used on the report. If you scroll down
further you should see all the fields under the OrderHed table.
Jim Stetter
-----Original Message-----
From: Wayne Katzenberger [mailto:wkatz@...]
Sent: Tuesday, April 17, 2001 1:09 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Reports Question


Sara,

Yes I did. Still can't see the check boxes. I opened a new report and
inserted the OrderHed table and they do appear if a add all fields.

Wayne

-----Original Message-----
From: sarah.vareschi@... [mailto:sarah.vareschi@...]
Sent: Tuesday, April 17, 2001 10:20 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Reports Question


Did you do a print preview from the Sales order before verifying the
database?


To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have
already
linked your email address to a yahoo id to enable access.

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/



Yahoo! Groups Sponsor

Click Here to Find Software Faster


To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have already
linked your email address to a yahoo id to enable access.

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]
11
Wayne,

What you must do is go to the VB form Designer open your OrderHed form and
fill the EXTERNAL NAME
for example "test".
In the OrderHed.dbf there will be a field called QHTEST.
Now print a order and go to Crystal and use the verify database option, you
will be asked to fix - respond Yes.
You will now be able to access the VB form field in the report

Erik

-----Original Message-----
From: Wayne Katzenberger [mailto:wkatz@...]
Sent: dinsdag 17 april 2001 15:32
To: 'Vantage User Group'
Subject: [Vantage] Crystal Reports Question


Good Morning Group,

I have a Crystal question. I am creating a VB form in the OrderHed that
contains check boxes that identify the certification requirements on the
sales order.

Here is my problem. The OrderHed Table in the Crystal Form does not have
the 5 Check Boxes. On a trial bases I deleted the OrderHed from a copy of
the canned form and re-inserted the OrderHed the boxes show up.

Is there any way I can just change the existing OrderHed.dbf to include all
fields in the Vantage OrderHed.

We are on V4.904 using Crystal 7

Thanks,

Wayne



To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have already
linked your email address to a yahoo id to enable access.

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
12
I am trying to create a formula that will determine the total time, the
formula I am using is: DateDiff ({production_data.Start_time},
{production_data.end_time})

It keeps telling me "Not Enough arguments have been given to this
function"

I need help...

Robert Rodriguez, Asst. General Manager
Livonia Tool & Laser
936 Anderson Road
Litchfield, MI 49252-9600
Phone: 888-875-0833
Fax: 517-542-2427
http://www.livoniatool.com
Email: robert@...




[Non-text portions of this message have been removed]
13
You need to have the interval type in there first DateDiff(interval
type,startdate, enddate)



Brandon R Murch

Director of Information Technology

WindStone Medical Inc.

(406)259.6387

bmurch@...



-----Original Message-----
From: Robert Rodriguez [mailto:robert@...]
Sent: Wednesday, September 24, 2003 1:42 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Reports Question



I am trying to create a formula that will determine the total time, the
formula I am using is: DateDiff ({production_data.Start_time},
{production_data.end_time})

It keeps telling me "Not Enough arguments have been given to this
function"

I need help...

Robert Rodriguez, Asst. General Manager
Livonia Tool & Laser
936 Anderson Road
Litchfield, MI 49252-9600
Phone: 888-875-0833
Fax: 517-542-2427
http://www.livoniatool.com
Email: robert@...




[Non-text portions of this message have been removed]






Yahoo! Groups Sponsor



ADVERTISEMENT

<http://rd.yahoo.com/M=194081.3897168.5135684.1261774/D=egroupweb/S=1705
007183:HM/A=1754016/R=0/SIG=11pv1u2ju/*http:/www.ediets.com/start.cfm?co
de=30529&media=atkins> click here



<http://us.adserver.yahoo.com/l?M=194081.3897168.5135684.1261774/D=egrou
pmail/S=:HM/A=1754016/rand=917147519>


Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo!
<http://docs.yahoo.com/info/terms/> Terms of Service.



[Non-text portions of this message have been removed]
14
I should be more specific...interval types include 'd' for days, 'h' for
hours 'm' for minutes...



Brandon R Murch

Director of Information Technology

WindStone Medical Inc.

(406)259.6387

bmurch@...



-----Original Message-----
From: Brandon Murch
Sent: Wednesday, September 24, 2003 1:42 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Reports Question



You need to have the interval type in there first DateDiff(interval
type,startdate, enddate)



Brandon R Murch

Director of Information Technology

WindStone Medical Inc.

(406)259.6387

bmurch@...



-----Original Message-----
From: Robert Rodriguez [mailto:robert@...]
Sent: Wednesday, September 24, 2003 1:42 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Reports Question



I am trying to create a formula that will determine the total time, the
formula I am using is: DateDiff ({production_data.Start_time},
{production_data.end_time})

It keeps telling me "Not Enough arguments have been given to this
function"

I need help...

Robert Rodriguez, Asst. General Manager
Livonia Tool & Laser
936 Anderson Road
Litchfield, MI 49252-9600
Phone: 888-875-0833
Fax: 517-542-2427
http://www.livoniatool.com
Email: robert@...




[Non-text portions of this message have been removed]






Yahoo! Groups Sponsor



ADVERTISEMENT

<http://rd.yahoo.com/M=194081.3897168.5135684.1261774/D=egroupweb/S=1705
007183:HM/A=1754016/R=0/SIG=11pv1u2ju/*http:/www.ediets.com/start.cfm?co
de=30529&media=atkins> click here



<http://us.adserver.yahoo.com/l?M=194081.3897168.5135684.1261774/D=egrou
pmail/S=:HM/A=1754016/rand=917147519>


Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo!
<http://docs.yahoo.com/info/terms/> Terms of Service.



[Non-text portions of this message have been removed]






Yahoo! Groups Sponsor



ADVERTISEMENT

<http://rd.yahoo.com/M=194081.3897168.5135684.1261774/D=egroupweb/S=1705
007183:HM/A=1706996/R=0/SIG=11p5b9ris/*http:/www.ediets.com/start.cfm?co
de=30509&media=atkins> click here



<http://us.adserver.yahoo.com/l?M=194081.3897168.5135684.1261774/D=egrou
pmail/S=:HM/A=1706996/rand=980080017>


Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo!
<http://docs.yahoo.com/info/terms/> Terms of Service.



[Non-text portions of this message have been removed]
15
How do add multiple database to a crystal report? I have more than one
Vantage Db and want to run one report to run against more than one db.

Thanks,

Mark Smith
Director of IS
Innerpac, Inc
16
You would need to create a seperate ODBC connection for each DB. Then
add tables from each connection, then simply join tables for the 2 DB's
and create the report.

Brian Stenglein
Clow Stamping Co.

--- In vantage@yahoogroups.com, "innerpac_il" <mark_smith@i...> wrote:
>
> How do add multiple database to a crystal report? I have more than
one
> Vantage Db and want to run one report to run against more than one db.
>
> Thanks,
>
> Mark Smith
> Director of IS
> Innerpac, Inc
17
Brian:



Thanks for responding. I pretty much tried this approach before posting
to the group. I am testing with a single table checkhed and joined only
on name, but I can't group on company name from secondary connection.
When you join tables are you joining dissimilar tables from each
connection?



Mark Smith
Director of Information Systems
Innerpac, Inc
(p) 708-863-8300
(f) 708-863-9770
www.innerpac.com



________________________________

From: Brian Stenglein [mailto:bstenglein@...]
Sent: Monday, April 11, 2005 7:55 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Crystal Reports Question




You would need to create a seperate ODBC connection for each DB. Then
add tables from each connection, then simply join tables for the 2 DB's
and create the report.

Brian Stenglein
Clow Stamping Co.

--- In vantage@yahoogroups.com, "innerpac_il" <mark_smith@i...> wrote:
>
> How do add multiple database to a crystal report? I have more than
one
> Vantage Db and want to run one report to run against more than one db.
>
> Thanks,
>
> Mark Smith
> Director of IS
> Innerpac, Inc





Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links




________________________________

Yahoo! Groups Links

* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .



[Non-text portions of this message have been removed]
18
Mark,

I haven't tried reporting from multiple DB's so I'm talking in theory
only. I just wanted to make sure you weren't overlooking the
necessity of having 2 seperate ODBC connections. Could you explain
in a little more detail what it is you are trying to accomplish, I
might be able to help more if I understand your goal.

Brian Stenglein
Clow Stamping Co.


--- In vantage@yahoogroups.com, "Mark Smith" <mark_smith@i...> wrote:
> Brian:
>
>
>
> Thanks for responding. I pretty much tried this approach before
posting
> to the group. I am testing with a single table checkhed and joined
only
> on name, but I can't group on company name from secondary
connection.
> When you join tables are you joining dissimilar tables from each
> connection?
>
>
>
> Mark Smith
> Director of Information Systems
> Innerpac, Inc
> (p) 708-863-8300
> (f) 708-863-9770
> www.innerpac.com
>
>
>
> ________________________________
>
> From: Brian Stenglein [mailto:bstenglein@c...]
> Sent: Monday, April 11, 2005 7:55 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Crystal Reports Question
>
>
>
>
> You would need to create a seperate ODBC connection for each DB.
Then
> add tables from each connection, then simply join tables for the 2
DB's
> and create the report.
>
> Brian Stenglein
> Clow Stamping Co.
>
> --- In vantage@yahoogroups.com, "innerpac_il" <mark_smith@i...>
wrote:
> >
> > How do add multiple database to a crystal report? I have more
than
> one
> > Vantage Db and want to run one report to run against more than
one db.
> >
> > Thanks,
> >
> > Mark Smith
> > Director of IS
> > Innerpac, Inc
>
>
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
must
> have already linked your email address to a yahoo id to enable
access. )
> (1) To access the Files Section of our Yahoo!Group for Report
Builder
> and Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> <http://groups.yahoo.com/group/vantage/files/>
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/links
>
>
>
>
> ________________________________
>
> Yahoo! Groups Links
>
> * To visit your group on the web, go to:
> http://groups.yahoo.com/group/vantage/
>
> * To unsubscribe from this group, send an email to:
> vantage-unsubscribe@yahoogroups.com
> <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service <http://docs.yahoo.com/info/terms/> .
>
>
>
> [Non-text portions of this message have been removed]
19
Essentially I am creating a report to pull from multiple databases, but
in detail I am trying to get data from the checkhed table for two
companies with regards to check number and amount. Pretty simple when
it's only one db, however when I add the second odbc connection its like
its doesn't even see it.



Mark Smith
Director of Information Systems
Innerpac, Inc
(p) 708-863-8300
(f) 708-863-9770
www.innerpac.com



________________________________

From: Brian Stenglein [mailto:bstenglein@...]
Sent: Monday, April 11, 2005 10:58 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Crystal Reports Question




Mark,

I haven't tried reporting from multiple DB's so I'm talking in theory
only. I just wanted to make sure you weren't overlooking the
necessity of having 2 seperate ODBC connections. Could you explain
in a little more detail what it is you are trying to accomplish, I
might be able to help more if I understand your goal.

Brian Stenglein
Clow Stamping Co.


--- In vantage@yahoogroups.com, "Mark Smith" <mark_smith@i...> wrote:
> Brian:
>
>
>
> Thanks for responding. I pretty much tried this approach before
posting
> to the group. I am testing with a single table checkhed and joined
only
> on name, but I can't group on company name from secondary
connection.
> When you join tables are you joining dissimilar tables from each
> connection?
>
>
>
> Mark Smith
> Director of Information Systems
> Innerpac, Inc
> (p) 708-863-8300
> (f) 708-863-9770
> www.innerpac.com
>
>
>
> ________________________________
>
> From: Brian Stenglein [mailto:bstenglein@c...]
> Sent: Monday, April 11, 2005 7:55 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Crystal Reports Question
>
>
>
>
> You would need to create a seperate ODBC connection for each DB.
Then
> add tables from each connection, then simply join tables for the 2
DB's
> and create the report.
>
> Brian Stenglein
> Clow Stamping Co.
>
> --- In vantage@yahoogroups.com, "innerpac_il" <mark_smith@i...>
wrote:
> >
> > How do add multiple database to a crystal report? I have more
than
> one
> > Vantage Db and want to run one report to run against more than
one db.
> >
> > Thanks,
> >
> > Mark Smith
> > Director of IS
> > Innerpac, Inc
>
>
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
must
> have already linked your email address to a yahoo id to enable
access. )
> (1) To access the Files Section of our Yahoo!Group for Report
Builder
> and Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
> <http://groups.yahoo.com/group/vantage/files/>
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/links
>
>
>
>
> ________________________________
>
> Yahoo! Groups Links
>
> * To visit your group on the web, go to:
> http://groups.yahoo.com/group/vantage/
>
> * To unsubscribe from this group, send an email to:
> vantage-unsubscribe@yahoogroups.com
> <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service <http://docs.yahoo.com/info/terms/> .
>
>
>
> [Non-text portions of this message have been removed]





Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links




________________________________

Yahoo! Groups Links

* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .



[Non-text portions of this message have been removed]
20
You might be able to do a quick export out to a DBF table on each DB, and
then create your report in Crystal without the need for an ODBC connection.

Just a thought

Dan Shallbetter
States Electric Mfg.


-----Original Message-----
From: Mark Smith [mailto:mark_smith@...]
Sent: Monday, April 11, 2005 11:42 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Crystal Reports Question


Essentially I am creating a report to pull from multiple databases, but
in detail I am trying to get data from the checkhed table for two
companies with regards to check number and amount. Pretty simple when
it's only one db, however when I add the second odbc connection its like
its doesn't even see it.



Mark Smith
Director of Information Systems
Innerpac, Inc
(p) 708-863-8300
(f) 708-863-9770
www.innerpac.com



________________________________

From: Brian Stenglein [mailto:bstenglein@...]
Sent: Monday, April 11, 2005 10:58 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Crystal Reports Question




Mark,

I haven't tried reporting from multiple DB's so I'm talking in theory
only. I just wanted to make sure you weren't overlooking the
necessity of having 2 seperate ODBC connections. Could you explain
in a little more detail what it is you are trying to accomplish, I
might be able to help more if I understand your goal.

Brian Stenglein
Clow Stamping Co.


--- In vantage@yahoogroups.com, "Mark Smith" <mark_smith@i...> wrote:
> Brian:
>
>
>
> Thanks for responding. I pretty much tried this approach before
posting
> to the group. I am testing with a single table checkhed and joined
only
> on name, but I can't group on company name from secondary
connection.
> When you join tables are you joining dissimilar tables from each
> connection?
>
>
>
> Mark Smith
> Director of Information Systems
> Innerpac, Inc
> (p) 708-863-8300
> (f) 708-863-9770
> www.innerpac.com
>
>
>
> ________________________________
>
> From: Brian Stenglein [mailto:bstenglein@c...]
> Sent: Monday, April 11, 2005 7:55 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Crystal Reports Question
>
>
>
>
> You would need to create a seperate ODBC connection for each DB.
Then
> add tables from each connection, then simply join tables for the 2
DB's
> and create the report.
>
> Brian Stenglein
> Clow Stamping Co.
>
> --- In vantage@yahoogroups.com, "innerpac_il" <mark_smith@i...>
wrote:
> >
> > How do add multiple database to a crystal report? I have more
than
> one
> > Vantage Db and want to run one report to run against more than
one db.
> >
> > Thanks,
> >
> > Mark Smith
> > Director of IS
> > Innerpac, Inc
>
>
>
>
>



[Non-text portions of this message have been removed]