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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by hhiebert

  1. hhiebert

    Using Custom Functions in a Template in Version 9

    I've found out absolutely nothing. Crystal Decisions has had nothing to offer and I haven't been able to find anything on the web. I ended up creating a .rpt file that just holds common formulas containing these fields and grab formulas from this file as required. Old school method. Helen...
  2. hhiebert

    Why don't my reports get cached?

    Caching doesn't happen under 3 circumstances: 1. RCAPI is being called (ie. report is being changed on the fly) 2. Different parameters are passed into the report. 3. The report has subreports.
  3. hhiebert

    How to change ePortfolio lite default reports directory?

    Go to Programs, Crystal Enterprise 9, Tools, RAS Configuration Manager. Change the directory under 'Report Directory'. You'll need to restart the Crystal Report Application Server service in order for the changes to take effect. That's it, that's all. hh...
  4. hhiebert

    Reporting off of a subreport field

    Naith, Thanks for all your hard work...and for putting up with me. One more question though (and I hope that's it). Can I base my record selection on a shared variable? I'm thinking that I can't....but I need to...somehow. hh...
  5. hhiebert

    Reporting off of a subreport field

    I think we're all talking about different things....or else I'm just thoroughly confused. Both Now() and CurrentDate retrieves the date 07Apr2003 (today's date and the date on the server). The database, however, is static and contains 06Apr2003's database ...this is how we do most of our...
  6. hhiebert

    Reporting off of a subreport field

    Thanks for the feedback. I'll check it out on Monday as I have a winter storm to drive through right now. I'll let you know if I get the desired results. hh...
  7. hhiebert

    Reporting off of a subreport field

    I'm not concerned with time. Just the date. The date of the database though could be off from the current date. It could be a restore of a previous database (this happens periodically) and so I don't believe Now()would work and CurrentDate definetely wouldn't. Any other options? Also, not...
  8. hhiebert

    Viewing a Crystal Report from a Web Site

    I was really hoping to avoid ePortfolio. I'm not worried about backing up report instances, or running reports on demand or anything. They'd just be saved with data. So really it's just the ability to view them through a viewer that I'm looking for. Not possible?!? hh...
  9. hhiebert

    Reporting off of a subreport field

    The way my database is set-up, the database date is stored within the database in a table called system. This table has no relationship with any of the other tables. I need to use this date to determine what records to retrieve from my database. How is...and is...this possible? NOTE...
  10. hhiebert

    Viewing a Crystal Report from a Web Site

    I want to throw some Crystal Report links on our company's web site and allow users to view the reports in a viewer (like ActiveX or whatever) when they click on it. How can I do this? I have a copy of the RAS edition of CE that came with Crystal Reports 9 Advanced. I don't want to use the...
  11. hhiebert

    Installation

    I'm looking for some help with setting up a well-oiled report delivery machine. My tools are CR 9 Advanced, CE RAS 9 and CE Standard 9 (which all come in the CR 9 Advanced bundle). I have a separate W2K server (A) that I want to use to run and schedule the reports on. Then I want to transfer...
  12. hhiebert

    Linking 3 Tables

    Thanks Lisa, that SQL worked wonders and I learnt something new. Oh and yes, I was using CR 9. hh...
  13. hhiebert

    Creating a Custom Function That Contains a Document Property Field

    Now that CR 9 offers Custom Functions I was hoping to save myself some work by moving the following formula into a function...up till now I was copy the formula from report to report. However, when I try to create a custom function in Crystal Reports I get the error "This function cannot...
  14. hhiebert

    Manual Running Totals don't like "Repeat Headers"?

    Lisa, you're my new hero! I've been looking for this solution all my life [slight exaggeration]. hh...
  15. hhiebert

    CR 9 SQL Command and changing the data source

    I tried this out....didn't seem to work. Anybody figured out a solution for this...or stumbled across one? hh...

Part and Inventory Search

Back
Top