Search results for query: *

Hi there, I have a several reports made in crystal reports 8.5, and I would like to print them in landscape version. How is that possible in that version of crystal. Thanks

What is the correct syntax to connect Crystal Reports through Visual Basic 6 to an Access 2000 database, in order to show the specified fields? When i need to connect to an SQL 2000 database i use the following code: Report.Database.LogOnServer "p2ssql.dll", "ServerName&quot...

Hi there, Id like to thank also to nick for sharing that code.. but i have another problem now.. i really got to create a random passwd but how can i decrypt it to its original value? yjoke

bperry Thank U a LOT !! :-) Your Third option really did the trick.. I guess i got lost thinking about distinct(Field) function.. You where a real TipMaster.. hehe Hope to c you arround !! :-) Cheers, YJoke

As i said (you must haven't seen it..) : "* - Doen's matter the returned values here, i will handle this data with some routines i made.." - regarding the "whatever *" .. I meen.. any returned value (or none) is acceptable.. in the application i will handle all the data...

I'm sorry i've made a mistake in my last thread .. It isn't a Date type field.. it's a description field, and the idea is to return all the data in the table only showing to the end user the FirstPKField and it's discription without repeating the data that it's shown.. Right now my results are...

Hi there, I've been tryin to retrieve the data in a table that has 6 primary fields and some other more regular ones.. I've inserted in it all the possible combinations of the pk fields in the aplication i'm creating, but when i'm returning all the data in the fields i can't avoid to have...

None of the formulas all of U suggested worked. So, after a long quest chase "the Holy Grail" I've come up with a solution to my problem. I use the following formula: date(1899,12,30) + ({the_date_field_in_question}) This formula worked for me.

OK!! Thank you.It's working fine.. see you!!

Ok!! So I don't need to put any formula for the logo??

Hello!! I need to put various company logos on the report.I mean, the user can have the possibility to change the company logos in the report that he want to sent to printer. I guest the way to do that,is to store the logos on the database(SQl2000) and than make a hyperlink in the logo at the...

thaks its working!!

Can you be more specific about the syntax of the formula?? Thanks..

I'm trying to format the integer "37317" that is on the date field on SQL2000,to a normal date string format as "yyyy-mm-dd" to show on a report. I'd like to know how that is possible and what's the formula to make that possible. Please help..it's urgent..!!!! Thank's

OK!! So what do you suggest as a possible solution.... Please help me!!

Hi there. I've been having some (lots of) problems in a project that I'm working on. I'm using an SQL 2000 database, Visual Basic 6.0 SP5, and Crystal Reports 8.5 Pro. One of the problems that I'm facing is in converting a date from an Integer (in SQL 2k,who is the number 37317) to a...

I tried the formula in the link that you suggest, but when I apply it in the formula editor, I get the message: " A statement is expected here ". I don´t know what that statement is. Please help me again with any suggestion. ThanK you.. please i need help....

thank you.I tried the formula in the link that you suggest, but when I apply it in the formula editor, I get the message: " A statement is expected here ". I don´t know what that statement is. Please help me again with any suggestion. ThanK you.. hhhhheeeeeellllllpppp!!!

thank you.I tried the formula in the link that you suggest, but when I apply it in the formula editor, I get the message: " A statement is expected here ". I don´t know what that statement is. Please help me again with any suggestion. ThanK you..

Hi there. I've been having some (lots of) problems in a project that I'm working on. I'm using an SQL 2000 database, Visual Basic 6.0 SP5, and Crystal Reports 8.5 Pro. One of the problems that I'm facing is in converting a date from an Integer (in SQL 2k,who is the number 37317) to a...