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

    User Function Library

    I did not see that with the installation. How is that performed. Thanks for your help.
  2. mverdera

    User Function Library

    I am converting reports from 8.5 to crystal 10. There seems to be formulas that the reports are calling. I am sure they are based in the user function library. how do I extract them from the CE 8.5 repository and put them into the CE 10 repository. thanks,
  3. mverdera

    Query all reports on CE 10 repository for their properties.

    Is the query builder available in CE 10. Because it doesn't work for us in 8.5
  4. mverdera

    Query all reports on CE 10 repository for their properties.

    We just imported our reports to CE 10 from CE 8.5. We would like to see a report of all the properties of those reports i.e. schedule, destination, type of output, associated group. What tool does Crystal provide to generate a report of that sort from the repository? thanks,
  5. mverdera

    Runtime index

    The index is for a query run in crstal reports 9.0. I am converting a field in the query to match another oracle database table. I want to increase the runtime performance.
  6. mverdera

    Runtime index

    What is the syntax for making a run-time index? I have converted a field to numeric and am joining to another oracle database field which also does not have an index. I would like to build a run-time index on one or both. What is best? and how is it done?
  7. mverdera

    connect to two seperate oracles

    If I cannot combine the threads, can I put in a subreport that is already run so the links will work quickly? Now it is running the subreport each time for each record in the main report.
  8. mverdera

    connect to two seperate oracles

    How do I connect to two oracles servers at the same time so I can do a join on their tables. what method is needed?
  9. mverdera

    different index types

    To clarify my original question, we have fld1 in an table in DB2, which we want to join to a field (say fld2) in an oracle table. One is numeric (Oracle) and the other is character. Can we use the formula command in Crstal to convert the character to numeric and join on the formula. Will...
  10. mverdera

    different index types

    I am trying to combine into a query a DB2 table that has different field type for its index than the one I am joining to it in Oracle. How do I convert indices in Crystal so I can make a proper join. thanks,
  11. mverdera

    build union query in Cr9.2

    figured out my own problem, needed a group by statement. thanks
  12. mverdera

    build union query in Cr9.2

    synapsevampire, I just did a simple union query. It worked for that. But then I did a more complicated query and it produced an error. select fld1, count(fld1) as fld_cnt from ( select fld1 from table1 union select fld1 from table2 ) the inner query worked, but failed when added to outer...
  13. mverdera

    build union query in Cr9.2

    thanks, that was quick, I will give it a try.
  14. mverdera

    build union query in Cr9.2

    I cannot see a query editor. The query I have to write is too complicated to use the drag and drop method. I know this feature was in 8.5. But what about 9.2. Thanks Mark

Part and Inventory Search

Back
Top