Search results for query: *

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.

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, 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...

Hi, I'm using Crystal Reports 10 and database is Oracle 9i. I have four groups in my report and first three group headers are suppressed while fourth group header is not. Then my Detail section starts. After the 4th group header appears on the first page which is just a single row, the Detail...

Hi, I'm working on Cognos Data Manager (Version 8). I have built a Hierarchy manually with two levels which talk about Boxes (Level 1) and Components (Level 2). Now I want to build a Dimentional table where I want the Box_Id of Level 1 to have Surrogate Key. I’ll give you an example of data...

Hi, I'm using Crystal reports 10 and Oracle 9i database. I have a report in which I have two groups. First one is on customer name and the second one is on Order date by year. So, the data looks as follows. GH1 Customer name:A GH2 year: 2004 total amount:1000 GH2 year: 2005 total...

Hi , I'm using SQL Server 2000/Crystal reports 9. I need to show the time zone in the report. Could anybody please suggest me how to get the time zone like Central,eastern,etc. Thank you!!

Hi, I'm using CR 0 and Oracle 9i. I want the group header to repeat on each page but it is not doing so. It shows up only if the detail continues on next page.Other wise it won't. Please help!! Thank you.

Hi, I'm using Crystal reports 10. I'm trying to get the data in a .CSV file into Crystal. How to do it? Please help!!

Hi, I use Cr10 , Oracle 9i. I'm trying to link two tables and I want to use fullouter join. But, this option is disabled all the time and I don't know why!! Please help! Thank you!

Hi, I use CR10,Oracle 9i. I have a report which talks about the name, size, rate , etc. of various items we sell. So, the main report gives the details of the size,rate,etc. while the subreport brings in the picture(jpeg) of it. Now the report looks as follows Group header name: XXX...

Hi, I use CR10 and Oracle 9i. One my table's field stores a sentence /phrase and I need to pick the first letter of each word and make an abbrevation. Could you please suggest me some functions or ideas? Thank you!!

Hi, I'm using CR 10 and Oracle 9i. I have a report with multiple fields on it and my last column is a subreport.When I'm exporting this report to the excel, my subreport is going to the next row in the excel instead of being in the same row. I moved the subreport to various locations like I...

Hi, I'm working on Crystal Reports 10 and database is Oracle 9i. My problem is - I have a subreport in the groupHEADER and I'm trying pull some value from that subreport into my main report.So, I have used the shared variables and my formula which has the shared variable is in the same group...