Recent content by sparky2708

Kind of figured out why this happens. If your class inherits from an abstract class the JBuilder Designer tool stupidly tries to instantiate the abstract class and fails which results in the red colored component. I can't think of a way to implement abstract classes in any other way. Maybe...

I have a class that Extends JFrame which basically implements maximize and center called JFrameExtend. That is all it does. Now I have created an abstract class called GenericApp that derives from JFrameExtender and implements a menubar and some other components (some buttons that always appear...

How do I use the Crystal Analysis package to interact with an OLAP cube to make entries in Excel look like: Year: 2001 2002 Month: 1 2 3 4 5 ... 1 2 3 4 5... <companies> <balances> ... ... ... I basically want the year and month on different lines...

Try this - it helped me: http://support.microsoft.com/default.aspx?scid=KB;en-us;q224973

Thanks aklein. I thought of doing it this way - just by directly querying the tables. My application deals with executing multiple reports so the tables that I query can't be hardcoded furthermore if I query the tables from the &quot;Report&quot; object it isn't obvious from the report object...

How do I use the API to query whether there is any data in the report that I am trying to execute? I tried: long test = 10; VARIANT arr; VariantInit(&arr); arr = crRpt->GetNextRows(0, &test); if (test > 0) crRpt->Export(var); For some reason &quot;test&quot; is always 1. Even if there...

I forgot to mention. Our Crystal Enterprise 8.5 is installed on a Windows 2000 Server. The registry fix was attempted on this Windows 2000 machine, NOT a Solaris machine. Any help would be greatly appreciated.

I am looking into a problem one of our users has reported when they try to export a Crystal Report in Crystal Enterprise 8.5 to an Excel Document. There is a fix on the Crystal Decision website for Solaris for this problem...

We need to setup each one of our users to have a particular folder be the initial folder when they login to Crystal Enterprise. How do I do this across all of our users instead of asking each user to do it themselves?

The problem with this approach is that I am making different joins in reports I am iterating through. I need to check which of the reports that is being executed on a daily basis has produced no results. If this is the case this report should not be given to users.

(1) I need to export a Crystal Report to a PDF but only create the file if there is any data in the report. I am using the RDC. The only way I see to do it is using the &quot;NoData&quot; event. How would I do that? i.e. how do I use these events? (2) Is there a cleaner function that I can...

Dgillz, I think you are describing my mod trick. Basically take the Row number mod 2 which either returns 1 or 0 and then set the color depending on whether you get 1 or 0. The problem is: how do I get the row number? Is there a command in Crystal Reports that will tell you how many rows you...

I was thinking of a clever way of doing this but can't seem to cme up with a way. So suppose you have a crosstab in Crystal Reports and you want some field in that crosstab that is running down the page to alternate in color. Say you want every other row to have some color like green. How would...

1. Looked all throughout Crystal Decisions website but couldn't find how to chnage the timeout - if you come across it please post it up in this thread. 2. Thank you - we decided to do the same - stored procedures. Performance improved but still there is much difference in executing the query...

We have Crystal Enterprise 8.0 installed and thinking of upgrading to version 8.5. Do any of the versions have a way of uploading a massive amount of reports 100+ at one time instead of going to the admin website and uploading them one by one. Any help would be greatly appreciated.