Search results for query: *

THanks, That works.

Hi all, Currently my Date and Time format is in GMT which means it is 4 hours ahead. I want to subtract 4 hours of this date field. For example, it shows as 01-Mar-2009 10:50:10PM but i want it to be 01-March-2009 6:50:10PM. Any ideas? Thanks, T.

I installed MySQL OBDC driver, then connect OBDC from there. I got it from our DBA. I believe you can download it some where on web.

Thanks, I got it solved after I posted this post. I did installed MYSQL OBDC connection and it works fine. Thanks!

Hi everyone. Have a question. How do I connect MYSQL database in Crystal? I am thinking Create New Connection > More Data Sources > JDBC (JNDI). Is this icorrect? Thanks, T.

Hi Turkbear, Thanks for replying. However, how to check for the timing for cancelling an inactive connection? I found a work around for this report which takes only 2 to 3 minutes by using Crosstab, but if I want to get the same layout that user wants then my query will be involved with...

Hi everyone, I am using Crystal Reports Server. I wonder if i can extend report runtime in Central Management Console (CMC). Normally, report will run if it is under 15 minutes. For reports over 15 minutes when compliling it will be timeout in Inforview. For example, there is one report...

NVM, got it!

I meant i already changed to whileprintingrecords; numbervar sched; numbervar compl; if compl = 0 then "0%" else totext(compl%sched,2)+"%"//2 for two decimals Still blank fields whenever compl = 0

lbass, I did exactly what you suggested but I found it weird that I didn't see 0% whenever completed = 0 as your formula says. It just has blank fields. whileprintingrecords; numbervar sched; numbervar compl; if sched = 0 then "0%" else totext(compl%sched,2)+"%"//2 for two decimals

I used the same logic and I got it. Now I can relax. Thanks!

Thanks lbass, Yes it works, however one more thing, I forgot to mention that there is a row total on right. How to calculate percentage for this total row. Like example below. New Connects Upgrades Total Red Scheduled 10 10...

I'm using CR XI. Right now I am having a problem with calculating percentage in Crosstab. I wrote a query with all data needed for Crosstab. Below is an example when I put in Crosstab. New Connects Upgrades Red Scheduled 11 10...

Have you tried to format the line so that it 'extends to bottom of Section when printing'? If you data can grows, then it is not a problem, your lines always extend to the bottom of your section.

make sure it does not draw over other section. You might try to play around with format line by "Extent to Bottom of Section when printing" option, this can helps to make sure your verticle line does not go over another section and your line just reach the bottom of the section.

Double hit your text box and modify, make sure hit 'Enter' key for each word to move them to another line. In this case you would write Customer then 'Enter' Identification then Enter Number, then you would have Customer Identification Number Align them in Center

Great. Thanks!

Btw. Do you know how to remove single quote, change 'Tables','Chairs','Spoons' to Tables, Chairs, Spoons ? Thanks

Cool, that's worked! Thanks!

Hi everyone, I am using CR XI and Oracle 10g. I had created a report with SQL query inserting in a Command and I followed this FAQ/hints in this link http://www.tek-tips.com/faqs.cfm?fid=6779 to create multiple values parameter and pass it within subreport. Everything works perfectly without...