Recent content by bzzyplayin

I have spent some time trying to figure out which "function" of the report(s) is causing the issue. I narrowed it down to certain conditional suppressions on groups within the subreport. The two conditional suppressions is: previous and startswith. Once I comment these out the report...

We ran into this same issue after installing the latest hot fix/SP for Crystal Enterprise 10. Now a handful of our reports that displayed correctly prior to applying the service pack now appear blank when the report is first displayed. However, if you print the report, zoom up or down or...

Bigal - What errors are you seeing? Are you getting different errors when you "View on demand" versus "View latest instance"? Also, on the reports that produce the errors, is the sub-report visible immediately or only when the user drills down from the main report? I actually ran into various...

I deleted some sections of the code to shorten the post (I wasn't extermely careful on deleting the code). I thought it might not be clean. Sorry about that. The statement does work fine when simply removing the last section of code (from the actual RPT file). Including the "//and" on the...

Update: I published the report to our test server (after all of the patches have been applied and the same problem occurred). Note: We also use comments to document our code. There are no problems when we use text as comments. We only run into the problem when actual code is commented out...

I should have clarified, the issue occurred when select case statements were commented out. I will provide a sample tomorrow of the selection criteria that I used (to test that theory). Note: As soon as I removed the commented code, the report was viewable without taking down the page...

We recently converted from 8.5 to 10. With the conversion, I have discovered a few bugs that I wanted to share with all of you since I had to figure out what was causing the issue(s) on my own. Crystal (Business Objects) was no help at all! Reports with comments in the record selection fail...

Thanks Ddeegan for posting the question on report standards. I am also interested in getting some examples of report guidelines and standards that other developers follow. Just to provide you with some background, I work with AS400 developers, so we are all pretty new to Crystal and never...

Is anyone using Lawson's attribute table for reporting in Crystal? My dilemma with this file is that the attributes are in multiple records per object ID. They allow 9,999 user-defined attributes. So, the data ends up in the following format (with multiple records per ObjectID): ObectID...

My dilemma, in which I need urgent help with, is with a Lawson table. We are just starting to build attributes. They allow 9,999 user-defined attributes. So, the data ends up in the following format (with multiple records per ObjectID): ObectID AttributeName Value 12 SQFT...

I ran into this same problem and have a solution. Note: I use CR 8.5 and CE 8.5 In design view be sure you have 'Show Guidelines in Design' turned on. If you have several guidelines out of place, you can get rid of them by clicking the arrow type thing at the top of the page and dragging...

I just figured it out. It took 3 formula's but it worked. The time field in the database in numeric (in a military time format). I have listed the 3 formulas below: //Formula 1: Time to Text totext({file.field},0,"") //Formula 2: Time insert colon if len({@Time to Text})=4 then...

Thanks Naith. I will install it on the CE machine tomorrow and test it out :) Any thoughts on converting a numeric military time field to a Crystal time field?

Thanks dgillz! The NumberToDate formula worked perfectly! Question: I publish all of my reports to Crystal Enterprise 8.5. Do you know which directory I need to put the dll's in on the server machine? Will the date be displayed correctly for all users running the report from CE regardless...

The field is a length of 6. Dates are listed in Crystal as: 981231 (December, 31 of 1998) yymmdd 990115 (January, 15 of 1999) yymmdd 21231 (December, 31 of 2002) ymmdd 30115 (January, 15 of 2003) ymmdd I have been able to display the dates correctly with the format below, but the...