Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

This is what I ended up using. Is there a better, more effective way? SELECT "cust"."no", "cust"."branch", "cust"."surname", "cust"."name", prod='dmd', "dmd"."rowno&quot...

Chelsea (or others), Can you let me know more about the 2nd option. I'm not familiar with using UNIONs and surprise, surpise, Crystal Decisions knowledgebase doesn't have much to add. Can you help with some of these blanks? SELECT demand.ID, etc. AS Products FROM demand UNION SELECT...

I have one primary table and 2 foreign tables that I need to use in a report. The relationship between the primary and foreign table (in both cases) is one to many. For each row in the primary table, I need to show totals from fields in the foreign tables. Let me try and explain. Primary...

Ignore my last post Naith. It was working...I just didn't have enough records in my report to notice the change with an increment of 3. Also, I didn't need to add the WhilePrintingRecords statement. Thanks so much for your insight. hh...

Actually, I didn't want to use a date parameter since the data is not dependant on it. I just need it for fulfill reporting standards in stating the reporting range....which would be the database date. Am I better off using a date parameter for the report? hh-