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 Mike Lewis 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. AmunRa

    Importing DMP file into 9i

    I have 9i installed on a WIN XP Pro machine. I log into the management console as administrator. When I try and import my DMP file (located on hard drive) it states the the user does not have sufficient privilages. It also says something about in Windows environ's you need 'logon and run...
  2. AmunRa

    Moving from Crystal Dictionaries

    We are trying to move our reports away from Dictionaries and into SQL Stored Procedures. Is there any way to SUCCESSFULLY change the data source of a report based on a dictionary to another datasource i.e. a SQL SP and therefore get the field mapping screen ??
  3. AmunRa

    Help with conditional selections.

    I have a table with fields called F3,F4,F5,F6,F7,F8,F9,F10. I want to conditionalyy select these fields i.e. If todays date is between 1/1/2003 and 30/4/2003 then select F3,F4,F5 Else if it is betwwen 1/5/2003 and 30/9/2003 then select F6,F7,F8 Else select F9,F10. Can anybody help with the...
  4. AmunRa

    Conditionally Selecting Fields

    I have a table with fields called F3,F4,F5,F6,F7,F8,F9,F10. I want to conditionalyy select these fields i.e. If todays date is between 1/1/2003 and 30/4/2003 then select F3,F4,F5 Else if it is betwwen 1/5/2003 and 30/9/2003 then select F6,F7,F8 Else select F9,F10. Can anybody help with the...
  5. AmunRa

    2 versions of Crystal on the same PC?

    The has been a few problems with dual installs. One being that on certain installs, when you try and add more than one table in CR9 it crashes. We use a piece of software called VMWare (www.vmware.com). This allows for multiple o/s to be run simultaneously and also different sofware on each...
  6. AmunRa

    HELP!!!! Report can't use parameter in SQL Query

    It might be worth creating a stored procedure within your oracle database to execute the SQL and then connect your report to that.
  7. AmunRa

    Grand Total Summary/Average in Cross Tab

    The onyl way you could possibly do this would be to write 1 report that had the grand totals in the cross-tab and suppressed the other row. Then a second report that only showed the average rows. Then pull the two together, one being a sub-report. There would be some alignment work to be done.
  8. AmunRa

    Sharing cross tab data between different subreports

    I am afraid this is not possible. The only way you can do this is if you write the cross-tabs manually i..e put all the rows and columns on the report individually.
  9. AmunRa

    How to change HTML viewer to ActiveX?

    If you are still using CE9 in some areas you may need to change the default viewer within CE itself. To change the default viewer to the ActiveX Viewer, this code must be added to the reportviewer.csp found in: X:\Program Files\Crystal Decisions\Web Content\Enterprise\ePortfolio\en · Where X...

Part and Inventory Search

Back
Top