Recent content by yjoke

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