Recent content by jpdmdc

Hi, I'm using Crystal reports 10 with Oracle 9i. could anyone help me how I can capture 1st sunday's date( in a month) in a variable? Thank you.

LBASS, YOU ARE AMAZING!!! Thank you SOOOOOOOOOOOOOO Much! :-)

Hi LBass, I have put the numbers/columns in "" to show you where I have put which formula. On the row side I have two groups Center_Name and Queue while i have only one Date filed for column grouped by month. Please let me know where I'm going wrong. Thank you very much. May/08 Jun/08...

Hi LBass, Thank you again for your reply. I Numbervar Tot os taking the last value in that colum while Number Curr is able to take the currentvalue of the field. So, my numbers are messed up. I tried bringing the totals to the top and also to the left but nothing works. Any other suggestion...

Rows are - Center_name,Queue_name Columns - Call_date(Only one column) grouped by month Summarized column - CALL_ID Count(call_id) Is this what you were asking? If not, then sorry, I didn't get you. Can you explain me please?

Hi Lbass, Thank you so much for your reply. It is a simple cross tab report which shows the call volume by center and by month as given below. Jan Feb Total NY 1stQ 1239 737 1976 23% 15% 19% 2ndQ 248 242 490 4% 5% 4% 3rdQ...

Hi, I'm using Crystal reports 10 on Oracle 9i. I have a cross tab report which shows the percentages of call volume we have per month. The problem I have is it doesn't show the decimal points. For example - if the number is 15.8% it shows it as 15% only. i tried to change it by using the...

Hi, I'm using Crystal Reports 10 and Oracle 9i. I have a sql query in the 'Add command' and have also created two date parameters in the 'Add Command'- Start_date and End_date. When I refresh the report, I see the name of the parameters in the parameter window but don't see any provision where...

Hi Lbass, thank you so much for you reply. If I want to find this at group level, for example : I have a center where 50 orders were processed and i'm trying to find out the average time taken to complete those 50 orders in that particular center. Like that i have multiple centers and each...

Hi, I need to find date diff between two dates in hh:mm:ss format. For example : date1 = 11/1/2007 12:00:00 am date2 = 11/3/2007 11:30:05 pm Then I should get 59 hours,30 minutes and 5 seconds. Could somebody help me with this please! I'm using Crystal reports 10 and oracle 9i...

hi, We are using Crystal Reports 10 and Oracle 9i. I'm trying to export a cross tab report to excel and when the report has more than one page, the same group name and the column headings are repeating and my user doesn't want it. Could any one help please?!! Thank you in advance!

Hi, We are using Crysta enterprise 10. We have a new database and have a report which runs against it. when we give the logon information and try to run the report in Crystal reports, it runs fine but not from the Enterprise. do we have to create a DSN for enter prise too? If so, how? Please...

Hi, I would need the code to change a .txt file to .old file. Please help if anyone of you got it. Thank you!

Hi, We are using Crystal Enterprise 10 and oracle 9i database. If the database is not updated then we want to notify the users abouut it as the reports may be with partially populated data or no data. could any one help me please! Thank you in advance.

Hi, I'm using Crystal Reports 10 Professional Version and the database is Sql Server 2005. An order might appear more than once in a table where we store the information of the calls we received from the customers for each order. If the customer calls us for some reason mulitple times for the...