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!

  • Congratulations SkipVought 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: *

  1. mangledbabyducks

    Suggestion for newer runtime product

    Our company developed a stand alone runtime utility based on Crystal Reports 10. We are looking at creating a newer stand alone runtime utility but I'm not sure which version to use, either CR2008 or CR2011. Looking at the following website, the product end-of-life date is longer with CR2008...
  2. mangledbabyducks

    Incorporating record selection into an SQL Command

    Thanks LB Added the following and it worked great: ((Upper ('{?ReportType}') = 'C' AND PROFILE_CUST.INTERFACEID = Upper ('{?RequiredID}')) OR (Upper ('{?ReportType}') = 'P' AND Cast ({INVOICE.CLIENT_LINKNO} as VARCHAR (32)) = Upper ('{?RequiredID}')) OR (Upper ('{?ReportType}') = 'A')) and...
  3. mangledbabyducks

    Incorporating record selection into an SQL Command

    I am working in Crystal Reports 10 on an Interbase 7 database thru an EasySofy ODBC connection. This is my first attempt in trying to use an SQL command in a report. I've got all my record selection criteria into my SQL command except for one piece. I am trying to include the following...
  4. mangledbabyducks

    Linking 3 databases together as one

    I do not have a way of creating a view as I only have READ rights to the tables. MBD
  5. mangledbabyducks

    Linking 3 databases together as one

    I am using Crystal Reports 10 with Interbase databases thru an EasySoft IB7 ODBC connection. I have three identical databases on separate servers and I need to treat them as one. I set up three different ODBC connections so that I can include them all in one report. The problem I am having is...
  6. mangledbabyducks

    Parameters all reset when running the same report

    No response after a month? Am I not explaining the problem correctly or is more information needed? I did not create the runtime utility so I cannot post the code. Was just wondering if others are having the same problem with parameters resetting every time the same report is run. -MBD
  7. mangledbabyducks

    Parameters all reset when running the same report

    Our company has created a runtime utility using Crystal 10's parameter prompting. After entering all the parameters, I run the report. Now let's say I only want to change one of the parameters and leave the rest set as just run. I click to rerun the report and all the parameters reset so I...
  8. mangledbabyducks

    Parameter delimma

    I am using Crystal Reports 8.5 with an Interbase database thru an ODBC connection. Now with that out of the way, here is my problem. I have a parameter where the client can type out a list (ie. 1,3,10) and only these items will appear on the report. The number corresponds to a table with...
  9. mangledbabyducks

    CE / CR 11

    The new, improved Crystal Reports XI came out today... http://www.businessobjects.com/products/reporting/crystalreports/default.asp MBD
  10. mangledbabyducks

    Cross tab report with summary

    Sorry, this is the first time I've posted a question to this forum so I'm sorry for the lack of clarification. When I said that the columns were user defined, I meant that the column description is created by the user at the time it is populated in the table of the database. The user can...
  11. mangledbabyducks

    Cross tab report with summary

    Adding more problems to the problem. The column headings are user defined so I have no way of knowing what to include with the "in" clause. MBD
  12. mangledbabyducks

    Cross tab report with summary

    Sorry LB, The column header is a text string. MBD
  13. mangledbabyducks

    Cross tab report with summary

    I need to create a cross tab report that has a limited number of colums. This limit is required so that the cross tab will not run off the page of the report. Let's say the limit the columns is 6 but I have 8 columns of info. Can I show the first five columns and total items 6 thru 8 as one...
  14. mangledbabyducks

    "Handle is Invalid" error message when saving a report

    I found this answer on the Business Objects Web Crystal Reports forum of all places. And I'd like to thank DanielDr for the post there. He solved this problem by setting the File>Properties for "crw32.exe" to "Win2000 compatible Setting". I tried it and it works great!!!

Part and Inventory Search

Back
Top