Crystal Reports help!

I am connecting to an AS400 via ODBC using Crystal Reports 9.0. I have a date that is coming out in a 7 digit number format. I need a formula for Crystal Reports that will convert this to a date format.

For example 1051111 would return 11/11/05.

The formula will have to get rid of the first "1" and put the other numbers in the correct format.

If someone can provide me with this formula and where I need to put it in Crystal Reports V9.0 that would be great.

ThanksSomething like this should do it. Just place it in your detail section.

StringVar ConvertDate := Right (ToText({your_number_field),6 );
StringVar YY := ConvertDate [1 to 2];
StringVar MM := ConvertDate [3 to 4];
StringVar DD := ConvertDate [4 to 5];

DD & "/" & MM & "/" & YY;

Brian
http://www.briankuipers.com|||Thanks alot, that helped a little. Except I told you wrong. The original format actually comes down as 1,051,111.00 with the commas and the decimal point.

When I use your formula it is counting the commas as text. I need a formula that would pull out the commas and decimal points and just use the text string of 1051111 that I originally stated was being used.

Thanks

Crystal Reports driver for SQL Server 2005

I use Crystal Reports with SQL Server 2005. Which driver (ODBC or OLEDB) should be used when connecting Crystal Reports to SQL Server 2005. Business Object support forum has an article (which is old) says to use ODBC. That it is faster than OLEDB. They have a more recent article which state to also use ODBC when upgrading Crystal Reports 8.5 to XI and connecting to SQL Server.

But then I read the OLEDB is the new interface and should be used instead of ODBC which is going away.

Which is preferred for Crystal Reports XI?

ODBC is not going away.

In general, there is no preferred interface - though 3rd party suppliers may have their own good reasons for making recommendations for users of their applications. Both APIs have their strong points. ODBC is the most widely used, but there are places where OLE DB can be a better choice. The choice depends on the needs of the application

Crystal Report - C#

Hi, everyone
I'm looking for sample codes in C#, using Crystal Report 10 and connecting to database ORACLE (not Access or SQL Server!)
Any help is appreciated,
thank youJust a link to the samples is fine... I'm really in trouble!|||I could find a way to use CrystalReportViewer, but everytime you click something it must refresh the page. I can't use it because it's too slow. I can't believe that actually someone use it...

In classic ASP I can use ActiveX Viewer and it's PERFECT. How can I use it in .NET?|||Hi,
i am using CR 10 and Oracle, but I don't have a direct connection from CR to Oracle. What I am using is a strongly typed dataset, which I link to the reportsource.
Maybe this helps.|||Hi,
i am using CR 10 and Oracle, but I don't have a direct connection from CR to Oracle. What I am using is a strongly typed dataset, which I link to the reportsource.
Maybe this helps.

Hi Reinhold,
I'm using CR 10 and Oracle, too.

As far as I'm a newbie in .NET, can you post me a sample code that explain your solution?
Because that CrystalReportViewer object is useless with that "refresh" problem.

Thanks in advance

Crystal Report

How can I set the page when I am connecting Crystal Report and ASP trhough SmartViewerActiveX.Not sure what you are asking
Can you give more details?

Crystal Report

Hello every body ,

I am facing a problem while running the reportsin VB 6.0. I am connecting the crystal report using CR VEIWER and data environment . when the s/w is running in the client side its showing the error
PHYSICAL DATABASE NOT FOUND.

But if the crytal report application is in the client machine it will work properly. I even copied all the DLL files.
I know its not the conventinal way of connecting crystal report to VB. Can any one help meIt sounds like you may be trying to connect to a local database (one that's located on your development machine)? I don't know anything about using Crystal to connect to a database (I do all my database stuff in VB, then pass the records to Crystal to manipulate).

Do a search here (dev-archive's Crystal Forum) (http://www.dev-archive.com/forum/forumdisplay.php?s=&forumid=64) for more Crystal/Database info. (You should also post all future CR questions on that forum instead of on the VB6 forum.)

Good Luck and sorry I couldn't help anymore. :)