Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Macho123
  • Order by date
  1. Macho123

    data from tow databases

    ...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, crs, casa) */ cad.CAD_ENERGY_TYPE, cad.cad_account_type...
  2. Macho123

    data from tow databases

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

    data from tow databases

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

    data from tow databases

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

    Converting string to date

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

    Converting string to date

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

    Converting string to date

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

    supressing part of details section

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

    supressing part of details section

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

    Appending report output to an existing file.

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

    Appending report output to an existing file.

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

    Exportin report data to ms access.

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

    Group Naming

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

    Exportin report data to ms access.

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

    Run date to the name of the Report

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

    Excluding list of project statuses

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

    Run date to the name of the Report

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

    exproting column names.

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

    exproting column names.

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

    exproting column names.

    Any response please.

Part and Inventory Search

Back
Top