Search results for query: *

I am using SQL navigator pointing to Oracle. Originally i didn't want to use the select [field1] to display the field in lower case because i was using (select *). I have re-thought it and will get the columns in lower case when querying the view. thanks for everyones help.

I actually found a guru myself. he suggested putting quotes around the name. ex: "Sample" it worked!! But beware. there seems to be a problem doing a select on that field. Thansk, John

i've tried that and the columns display in upper case. see below. CREATE OR REPLACE VIEW mv_time_on_test_junk ( Sample, sampled_date ) AS SELECT SAMPLE.SAMPLE_NUMBER as Sample, SAMPLE.SAMPLED_DATE as sampled_date FROM SAMPLE

when creating a view. Is there a way to name your columns in lower case?

Thank you all for your comments and suggestions. We just added another site to our system in Japan and they do not have DST. We are looking into using GMT time on our terminal server which also does not have DST, then we can just subtract the time difference. However, if we don't go that way i...

I have multiple reports that are generated around the world. My users in Japan want to convert the time stamps in our database to their time. The problem is how do i account for day light savings time. Does Crystal have any built in function to handle this?

That did the trick. Thanks, John

LBass, Thankyou for your help. One more thing, it seems to make the formula left justified and i need it right justified. All the settings sre for right justified. Again thanks in advance, John

Thank you mrudolph and GJParker for all your help. I was able to get the less than 0or equal sign on the report. However, I am having another problem. I am concatenating this symbol with other fields and they are numeric and text fields. Is there a way to designate part of a formula to use on...

I am trying to set the less than or equal to synbol on a report. I can set it like <= but my users want the < sign above a single line _. In Micrososft word you can insert a symbol to get this. Does anyone have any idea how to do this in crystal? Thanks, John

I have a similar problem as kate44, however I am running Crystal 8.0. It doesn't look as if 8.0 has a the Database expert option. The following works, but I want to replace 45663 with a Global variable that I created in a formula. (select RESULT."ENTRY" from result where RESULT."TEST_NUMBER"...

You may also need to put your fields in sections. You can put the six fields in the same section, but any fields below should be put in another section. Otherwise when the field wraps it will write over the field below it.