Search results for query: *

Hi, I am in a situation where I have to pull the data from tow different databases say a and b both of them are oracle. Now what I ma doing is using two connections to two databases at the database expert,and linking a column between the two tables in the two databases and putting the required...

Hi I am using crystal reports 9, I have a STRING field of this format 2008/08/01 00:00:00, now I want to convert it into a date field and display it as 08/01/2008. I tried date, cdate and other functions on that field but could not get it work. Help would be appreciated. Thanks...

Hi I am using Crystal reports 9. I have tow details sections, detail a detail b in the report and I want detaila to be displayed only once in the report irrespactive of the data in the detailb. Is there a way this can be done? Please let me know. Thanks...

Hi I am using CR 9 and there is a scheduled report which runs every week on the sunday and the report ouputs to an excel file and stores it in a folder on the network drive every time it runs. Now the user wants the output of the report to be appended to the excel file previously generated...

Hi All, I am using crystal reports Xi and the user needs the output of the report to be an access file. Righ now what I am doing is first transfer the report output to a text file and then importing that text file into access. This is a weekly process and I want to acutomate it so the output...

Hi, We are using BOXI and I have a report which is scheduled to run every week on sunday and the user wants to see the run date attached to the name of the result(where the result is stored in the 'HISTORY' tab on the server side). Where they could identify which output correspnds to which...

Hi, I am using crystal XI and I am trying to export the data to CSV text file, but how to export the xolumn names only once in to the text file. I tryied placing the column names in the page header and the report header but none worked. With this the column names are exported either once for...

Hi I am using crystal 9 and oracle 9i. in the query i am using to generate the report has to accept a parameter and generate the data accoring to it. the field what I am trying to parameterize is a varchar on the database side and for this I created a parametr with the type 'string' on the...

Hi, I am using CR XI and when I am trying to output the report data to a text file I can do that but the datais tab delimited by default. I need a ',' delimited file, I could not find the option to that. Any help in this would be great. Thanks...

Hi, I have a result set and it has around 1 million records, so i can not copy it into excel, but I have to performa sum on a column on the result set. what is the other alternative. Thanks...

Hi in my report I have 5 groups like g1h grh g3h g4h g5h d g5f (this has col's which i have groped cg1,cg2,cg3,cg4,cg5) g4f g3f g2f g1f I am supressing everything and displaying the data in g5f. so except g5f everything is supressed. Now what i want to know is if I change the g5to the place of...

Hi, I have a string field which also has numbers in it ans i am having problem to sort it. below is the data. 0 1 1a 11 2b abc There are 1 to 11 numbers in the string and then the string also has some thing like 1a,2b ans also has abc,dcg etc. the output i am lokking for is 0 1 2 ... 11 1a...

Hi I have a drill down report where if i click on a group i get all the sub groups in the group, and inside if i click on a sub group it will still take me to the groups inside. Now there is no problem with the report but how do i transfer all the data in to excel when ever it runs. now if i...

Hi I have 3 group levels in my report. say for example country, state and region. and there is a 'amount in $' field in the report and i have to display the sum of 'amount in $' for the three groups. that is when i open the report it has all the countries and their respective sums, then if i...

I have a flat file and i need the report to get data from the flat file. Actually I set the date source to the flat file under Access/Excel in data source but it is not fetching me the data in to the report. in the report it shows only the database in the field explorer and under that there are...

Hi I am using crystal reports 11 and I have a problem when I am trying to pass the date parametrs in to the sql script at the add command facility. I am getting the following error. Failet to retrive data from the Database, Missing right parantesis. but when I run the same query in oracle it...

Hi I am using crystal reports 11 and I have a problem when I am trying to pass the date parametrs in to the sql script at the add command facility. I am getting the following error. Failet to retrive data from the Database, Missing right parantesis. but when I run the same query in oracle it...