Crystal Reports Problem

Yahoo Archive
1
Thanks, Terry, I'll give that a try. I cheated in the meantime and created a
formula for the date using the ToText function and dropped that into the header.
That also works.

Regards,
-Karl




________________________________
From: Terry S. Ellis <tse@...>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Sat, July 3, 2010 1:51:38 PM
Subject: Re: [Vantage] Crystal Reports Problem

Â
When you create a group header on a date field there is and option to group by
day, week, month, year... I believe it defaults to week which would cause the
results you ate seeing.


Right click the group header on the design tab and select change group to set
the group by value.

Terry S Ellis
Consultant
716-983-8827

Sent from my mobile device

On Jul 3, 2010, at 4:20 PM, Karl Dash <dashkarl@...> wrote:

> I am bringing a .csv file into Crystal report. One column is a date field
> formatted in Excel as M/DD/YY. I have successfully brought the file into
>Crystal
>
> but when I use the date field as a group header, it converts it to the Sunday
> closest to the actual date. i.e. 1/1/07 becomes 12/31/06 and 2/2/07 becomes
> 1/28/07. If I put the date into the detail line it displays correctly. I have
> never seen anything so Bizarre. Is this an undocumented feature of Crystal XI
> (ver 11.5.3.417)?
>
> Any help?
> Thanks,
> -Karl
>
> [Non-text portions of this message have been removed]
>
>

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







[Non-text portions of this message have been removed]
2
I recently implemented ODBC so I can use Crystal Reports with my Vantage
database. Made a simple one table report and everything worked fine. I
then started to create a report with some joins. The particular report I
am creating contains the Customer table and the InvcDtl Table with an
Outer Join on the Company and CustNum fields. When I run the report I
get the following error:

ODBC Error:[DataDirect-Technologies][ODBC Progress Drivers]The keywords
LEFT OUTER JOIN were not found in an outer join escape sequence.

Anyone know tell me what that means and how to work around it?

Thank for your help


Todd Hofert
IT Director
Spartan Graphics, Inc.




[Non-text portions of this message have been removed]
3
I believe there is an ODBC fix for that. If you call Epicor, they can send it to you along with the instructions.

Jasper

-----Original Message-----
From: Todd Hofert [mailto:todd@...]
Sent: Thursday, January 22, 2004 8:16 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Reports Problem


I recently implemented ODBC so I can use Crystal Reports with my Vantage
database. Made a simple one table report and everything worked fine. I
then started to create a report with some joins. The particular report I
am creating contains the Customer table and the InvcDtl Table with an
Outer Join on the Company and CustNum fields. When I run the report I
get the following error:

ODBC Error:[DataDirect-Technologies][ODBC Progress Drivers]The keywords
LEFT OUTER JOIN were not found in an outer join escape sequence.

Anyone know tell me what that means and how to work around it?

Thank for your help


Todd Hofert
IT Director
Spartan Graphics, Inc.




[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/.
(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

Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
4
-----Original Message-----
From: Todd Hofert [mailto:todd@...]
Sent: Thursday, January 22, 2004 5:16 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Reports Problem


I recently implemented ODBC so I can use Crystal Reports with my Vantage
database. Made a simple one table report and everything worked fine. I
then started to create a report with some joins. The particular report I
am creating contains the Customer table and the InvcDtl Table with an
Outer Join on the Company and CustNum fields. When I run the report I
get the following error:

ODBC Error:[DataDirect-Technologies][ODBC Progress Drivers]The keywords
LEFT OUTER JOIN were not found in an outer join escape sequence.

Anyone know tell me what that means and how to work around it?

Thank for your help


Todd Hofert
IT Director
Spartan Graphics, Inc.




[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
<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
<http://groups.yahoo.com/group/vantage/links>



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/SIG=12cvobnh3/M=267637.4116730.5333196.1261774/D=egroup
web/S=1705007183:HM/EXP=1074863738/A=1945637/R=0/*http://www.netflix.com/Def
ault?mqso=60178397&partid=4116730> click here

<http://us.adserver.yahoo.com/l?M=267637.4116730.5333196.1261774/D=egroupmai
l/S=:HM/A=1945637/rand=922151250>


_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
<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]
5
Todd, you might also open the Crystal Reports "visual linking expert" in the
database pull down menu, highlight one of the joins between tables, and
using the "link options" button change the link from "equal" to "left
outer". If memory serves me correctly, changing one link between tables
changes them all.

Norm Watkins
Engineering Mgr.
ELECPAC
847-639-2307

-----Original Message-----
From: Todd Hofert [mailto:todd@...]
Sent: Thursday, January 22, 2004 7:16 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Reports Problem


I recently implemented ODBC so I can use Crystal Reports with my Vantage
database. Made a simple one table report and everything worked fine. I
then started to create a report with some joins. The particular report I
am creating contains the Customer table and the InvcDtl Table with an
Outer Join on the Company and CustNum fields. When I run the report I
get the following error:

ODBC Error:[DataDirect-Technologies][ODBC Progress Drivers]The keywords
LEFT OUTER JOIN were not found in an outer join escape sequence.

Anyone know tell me what that means and how to work around it?

Thank for your help


Todd Hofert
IT Director
Spartan Graphics, Inc.




[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/.
(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

Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
6
Question for anyone who has worked with these devices before. I'm trying to
fix a problem for another company whose IT guy quit, no notice. The owner
has a SOHO that connects to the FB2 as a VPN. The thing that is strange is
that Remotely when he starts WinXP he is being autheticated via the PDC at
the office with a roaming profile. Forgetting the bandwidth involved I've
never come across this situation. Has anyone dealth with a similar
situation that may be able to help me off list.

Thanks for the info/advice.

I now return you to your normally scheuled Vantage issues.

Jim Carnes
Information Systems Administrator
jcarnes@...
Kenlee Precision Corporation
1700 Morrell Park Ave
Baltimore, MD 21230



[Non-text portions of this message have been removed]
7
I contacted support per a previous users post (Jasper Recto) and they do
have a fix. I implemented it and I am up and running

Thank You.

-----Original Message-----
From: Norm Watkins [mailto:nwatkins@...]
Sent: Thursday, January 22, 2004 10:08 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Reports Problem

Todd, you might also open the Crystal Reports "visual linking expert" in
the database pull down menu, highlight one of the joins between tables,
and using the "link options" button change the link from "equal" to
"left outer". If memory serves me correctly, changing one link between
tables changes them all.

Norm Watkins
Engineering Mgr.
ELECPAC
847-639-2307

-----Original Message-----
From: Todd Hofert [mailto:todd@...]
Sent: Thursday, January 22, 2004 7:16 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Reports Problem


I recently implemented ODBC so I can use Crystal Reports with my Vantage
database. Made a simple one table report and everything worked fine. I
then started to create a report with some joins. The particular report I
am creating contains the Customer table and the InvcDtl Table with an
Outer Join on the Company and CustNum fields. When I run the report I
get the following error:

ODBC Error:[DataDirect-Technologies][ODBC Progress Drivers]The keywords
LEFT OUTER JOIN were not found in an outer join escape sequence.

Anyone know tell me what that means and how to work around it?

Thank for your help


Todd Hofert
IT Director
Spartan Graphics, Inc.




[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/.
(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

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




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/.
(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

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

While you wait for the patch you can also click on the database menu at the
top, and click on Visual Linking Expert. It will show the tables in your
report with the joins between them. Click on one of the links, and then
click on the link options button and change it to "left outer join".
Depending on how your report is set up you may need to do this for more than
on (maybe even all) of the links you have. I don't have the patch to fix
it, but doing this lets all the reports I have run fine.

Liz Hahn
Buyer
Guntert & Zimmerman


-----Original Message-----
From: Todd Hofert [mailto:todd@...]
Sent: Thursday, January 22, 2004 5:16 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Reports Problem


I recently implemented ODBC so I can use Crystal Reports with my Vantage
database. Made a simple one table report and everything worked fine. I
then started to create a report with some joins. The particular report I
am creating contains the Customer table and the InvcDtl Table with an
Outer Join on the Company and CustNum fields. When I run the report I
get the following error:

ODBC Error:[DataDirect-Technologies][ODBC Progress Drivers]The keywords
LEFT OUTER JOIN were not found in an outer join escape sequence.

Anyone know tell me what that means and how to work around it?

Thank for your help


Todd Hofert
IT Director
Spartan Graphics, Inc.







[Non-text portions of this message have been removed]
9
I have the patch handy - I can email you off list if you would like. I
simple registry file that you double-click and import.



Let me know,







Brandon R Murch

Director of Information Technology

WindStone Medical Inc.

(406)259.6387

bmurch@...



-----Original Message-----
From: ehahn@... [mailto:ehahn@...]
Sent: Thursday, January 22, 2004 8:50 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Reports Problem



Todd,

While you wait for the patch you can also click on the database menu at
the
top, and click on Visual Linking Expert. It will show the tables in
your
report with the joins between them. Click on one of the links, and then
click on the link options button and change it to "left outer join".
Depending on how your report is set up you may need to do this for more
than
on (maybe even all) of the links you have. I don't have the patch to
fix
it, but doing this lets all the reports I have run fine.

Liz Hahn
Buyer
Guntert & Zimmerman


-----Original Message-----
From: Todd Hofert [mailto:todd@...]
Sent: Thursday, January 22, 2004 5:16 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Reports Problem


I recently implemented ODBC so I can use Crystal Reports with my Vantage
database. Made a simple one table report and everything worked fine. I
then started to create a report with some joins. The particular report I
am creating contains the Customer table and the InvcDtl Table with an
Outer Join on the Company and CustNum fields. When I run the report I
get the following error:

ODBC Error:[DataDirect-Technologies][ODBC Progress Drivers]The keywords
LEFT OUTER JOIN were not found in an outer join escape sequence.

Anyone know tell me what that means and how to work around it?

Thank for your help


Todd Hofert
IT Director
Spartan Graphics, Inc.







[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
<http://docs.yahoo.com/info/terms/> Service.



[Non-text portions of this message have been removed]
10
Thanks to all that have responded. I have the problem corrected. The
registry entry recommended by several is the approach I took and it
works. Thanks again.

Todd Hofert

-----Original Message-----
From: Brandon Murch [mailto:bmurch@...]
Sent: Thursday, January 22, 2004 10:57 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Reports Problem

I have the patch handy - I can email you off list if you would like. I
simple registry file that you double-click and import.



Let me know,







Brandon R Murch

Director of Information Technology

WindStone Medical Inc.

(406)259.6387

bmurch@...



-----Original Message-----
From: ehahn@... [mailto:ehahn@...]
Sent: Thursday, January 22, 2004 8:50 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Reports Problem



Todd,

While you wait for the patch you can also click on the database menu at
the top, and click on Visual Linking Expert. It will show the tables in
your report with the joins between them. Click on one of the links, and
then click on the link options button and change it to "left outer
join".
Depending on how your report is set up you may need to do this for more
than
on (maybe even all) of the links you have. I don't have the patch to
fix
it, but doing this lets all the reports I have run fine.

Liz Hahn
Buyer
Guntert & Zimmerman


-----Original Message-----
From: Todd Hofert [mailto:todd@...]
Sent: Thursday, January 22, 2004 5:16 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Reports Problem


I recently implemented ODBC so I can use Crystal Reports with my Vantage
database. Made a simple one table report and everything worked fine. I
then started to create a report with some joins. The particular report I
am creating contains the Customer table and the InvcDtl Table with an
Outer Join on the Company and CustNum fields. When I run the report I
get the following error:

ODBC Error:[DataDirect-Technologies][ODBC Progress Drivers]The keywords
LEFT OUTER JOIN were not found in an outer join escape sequence.

Anyone know tell me what that means and how to work around it?

Thank for your help


Todd Hofert
IT Director
Spartan Graphics, Inc.







[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
<http://docs.yahoo.com/info/terms/> Service.



[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/.
(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

Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
11
Hi Brandon (or anyone else who can help),

It's been four years since this was posted, but I'm having the same
problem mentioned below. We have some old reports in Crystal 8.5 on
Vantage 6.1 and are having problems with them. We get this
error "The keywords LEFT OUTER JOIN were not found in the outer join
escape sequence."

We have the Merant 3.6 driver and would like to have the Merant 3.7
driver, but cannot find it. So it looks like I need this patch
mentioned below. Do you have it or does anyone know of a better
approach.

--- In vantage@yahoogroups.com, "Brandon Murch" <bmurch@...> wrote:
>
> I have the patch handy - I can email you off list if you would
like. I
> simple registry file that you double-click and import.
>
>
>
> Let me know,
>
>
>
>
>
>
>
> Brandon R Murch
>
> Director of Information Technology
>
> WindStone Medical Inc.
>
> (406)259.6387
>
> bmurch@...
>
>
>
> -----Original Message-----
> From: ehahn@... [mailto:ehahn@...]
> Sent: Thursday, January 22, 2004 8:50 AM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Crystal Reports Problem
>
>
>
> Todd,
>
> While you wait for the patch you can also click on the database
menu at
> the
> top, and click on Visual Linking Expert. It will show the tables in
> your
> report with the joins between them. Click on one of the links, and
then
> click on the link options button and change it to "left outer join".
> Depending on how your report is set up you may need to do this for
more
> than
> on (maybe even all) of the links you have. I don't have the patch
to
> fix
> it, but doing this lets all the reports I have run fine.
>
> Liz Hahn
> Buyer
> Guntert & Zimmerman
>
>
> -----Original Message-----
> From: Todd Hofert [mailto:todd@...]
> Sent: Thursday, January 22, 2004 5:16 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Crystal Reports Problem
>
>
> I recently implemented ODBC so I can use Crystal Reports with my
Vantage
> database. Made a simple one table report and everything worked
fine. I
> then started to create a report with some joins. The particular
report I
> am creating contains the Customer table and the InvcDtl Table with
an
> Outer Join on the Company and CustNum fields. When I run the report
I
> get the following error:
>
> ODBC Error:[DataDirect-Technologies][ODBC Progress Drivers]The
keywords
> LEFT OUTER JOIN were not found in an outer join escape sequence.
>
> Anyone know tell me what that means and how to work around it?
>
> Thank for your help
>
>
> Todd Hofert
> IT Director
> Spartan Graphics, Inc.
>
>
>
>
>
>
>
> [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
> <http://docs.yahoo.com/info/terms/> Service.
>
>
>
> [Non-text portions of this message have been removed]
>
12
I also am now experiencing the same error. I am just starting to use Crystal 8.5 with vantage 6.1x.... Do I need an update of ODBC driver? Can anyone supply it?



--- In vantage@yahoogroups.com, "debsmithmich" <debsmithmich@...> wrote:
>
> Hi Brandon (or anyone else who can help),
>
> It's been four years since this was posted, but I'm having the same
> problem mentioned below. We have some old reports in Crystal 8.5 on
> Vantage 6.1 and are having problems with them. We get this
> error "The keywords LEFT OUTER JOIN were not found in the outer join
> escape sequence."
>
> We have the Merant 3.6 driver and would like to have the Merant 3.7
> driver, but cannot find it. So it looks like I need this patch
> mentioned below. Do you have it or does anyone know of a better
> approach.
>
> --- In vantage@yahoogroups.com, "Brandon Murch" <bmurch@> wrote:
> >
> > I have the patch handy - I can email you off list if you would
> like. I
> > simple registry file that you double-click and import.
> >
> >
> >
> > Let me know,
> >
> >
> >
> >
> >
> >
> >
> > Brandon R Murch
> >
> > Director of Information Technology
> >
> > WindStone Medical Inc.
> >
> > (406)259.6387
> >
> > bmurch@
> >
> >
> >
> > -----Original Message-----
> > From: ehahn@ [mailto:ehahn@]
> > Sent: Thursday, January 22, 2004 8:50 AM
> > To: vantage@yahoogroups.com
> > Subject: RE: [Vantage] Crystal Reports Problem
> >
> >
> >
> > Todd,
> >
> > While you wait for the patch you can also click on the database
> menu at
> > the
> > top, and click on Visual Linking Expert. It will show the tables in
> > your
> > report with the joins between them. Click on one of the links, and
> then
> > click on the link options button and change it to "left outer join".
> > Depending on how your report is set up you may need to do this for
> more
> > than
> > on (maybe even all) of the links you have. I don't have the patch
> to
> > fix
> > it, but doing this lets all the reports I have run fine.
> >
> > Liz Hahn
> > Buyer
> > Guntert & Zimmerman
> >
> >
> > -----Original Message-----
> > From: Todd Hofert [mailto:todd@]
> > Sent: Thursday, January 22, 2004 5:16 AM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Crystal Reports Problem
> >
> >
> > I recently implemented ODBC so I can use Crystal Reports with my
> Vantage
> > database. Made a simple one table report and everything worked
> fine. I
> > then started to create a report with some joins. The particular
> report I
> > am creating contains the Customer table and the InvcDtl Table with
> an
> > Outer Join on the Company and CustNum fields. When I run the report
> I
> > get the following error:
> >
> > ODBC Error:[DataDirect-Technologies][ODBC Progress Drivers]The
> keywords
> > LEFT OUTER JOIN were not found in an outer join escape sequence.
> >
> > Anyone know tell me what that means and how to work around it?
> >
> > Thank for your help
> >
> >
> > Todd Hofert
> > IT Director
> > Spartan Graphics, Inc.
> >
> >
> >
> >
> >
> >
> >
> > [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
> > <http://docs.yahoo.com/info/terms/> Service.
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
13
I am bringing a .csv file into Crystal report. One column is a date field
formatted in Excel as M/DD/YY. I have successfully brought the file into Crystal
but when I use the date field as a group header, it converts it to the Sunday
closest to the actual date. i.e. 1/1/07 becomes 12/31/06 and 2/2/07 becomes
1/28/07. If I put the date into the detail line it displays correctly. I have
never seen anything so Bizarre. Is this an undocumented feature of Crystal XI
(ver 11.5.3.417)?

Any help?
Thanks,
-Karl




[Non-text portions of this message have been removed]
14
When you create a group header on a date field there is and option to group by day, week, month, year... I believe it defaults to week which would cause the results you ate seeing.

Right click the group header on the design tab and select change group to set the group by value.

Terry S Ellis
Consultant
716-983-8827

Sent from my mobile device

On Jul 3, 2010, at 4:20 PM, Karl Dash <dashkarl@...> wrote:

> I am bringing a .csv file into Crystal report. One column is a date field
> formatted in Excel as M/DD/YY. I have successfully brought the file into Crystal
> but when I use the date field as a group header, it converts it to the Sunday
> closest to the actual date. i.e. 1/1/07 becomes 12/31/06 and 2/2/07 becomes
> 1/28/07. If I put the date into the detail line it displays correctly. I have
> never seen anything so Bizarre. Is this an undocumented feature of Crystal XI
> (ver 11.5.3.417)?
>
> Any help?
> Thanks,
> -Karl
>
> [Non-text portions of this message have been removed]
>
>


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