Search results for query: *

Here are the 2 queries and there is no record selection formula. Those custid's which match from the both databases will be shown in th report(because i linked both the queries on custid at the link tab of database expert. Db1 query: select /*+ PARALLEL(cad, 8) PARALLEL(crs, 8) USE_HASH(cad...

LB, I am linking both the (customer_id) fields from two db's at the links tab in the database expert. But this is taking long time to retrive the data. Thanks...

This is how the situation is. I have all the customer details(service type,supplierid,arrears,....) in one database (db1). There one attribute for the customer saying customer_type in the other database (db2) which also has to be in the report. I do not have any db link between the both...

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 Andy, The formula you gave worked great, numbervar yr := val(left({table.string},4)); numbervar mt := val(mid({table.string},6,2)); numbervar dy := val(mid({table.string},9,2)); Date (yr,mt,dy) In my case the date comes as string. Thanks once again. Beltmanjr thanks for your response...

My default field in the database itself is a STRING but has date in it. totext(date(string_field_name),'mm/dd/yyyy') it says bad date format string type. To make it clear the STRING field present in the database has the date in it and when that is brought to crysatl though the datatype is...

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

Thanks for the reply. Actually I am not usning the report header because I have to output the report data to a CSV text file and page headers and report headers are not exported to CSV file with CR9. So I came up with this thing of union of two queries one query in command1 with the column name...

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, Thanks for the reply. We are not using that software at the client place. Is crystal by itself capable of doing the append thing. Or other wise can I do this with the shell script and automate it with the help of the Business ObjectsInfoview. Because we have unix environment on the server...

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

Thanks for the reply. But we are not using those tools at my work palce. Thanks...

in the section where u have your group name use this formula insted of the group name. create a formula liek this and replace with the group name. if {Command.field_on_which_group_is_made} = 06/07 or if {Command.field_on_which_group_is_made} = 07/07 or if...

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

No, I am talking abnout Central Management Console. Here the report is scheduled to run every week. And the repot outputs to a text file when ever it runs and stored in a location on the server and the user looks at that file. He wants to see the date the report ran on with the name of the file...

goto. report->selectexpert and there you need to select you column and you can exclude what ever you want from that particular field. Pk.

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 Andymc, That really helped but I am stuck at creating the registry sub keys can you through some light on where to do that and exact steps. Thanks very much. krant

Thanks a Lot Andymc. I am not sure if I have permission to chnagethe registry as mentioned in the documents, but now I know a way to solve it. Thanks once again. krant

Any response please.