Recent content by goesnowhere

In my opinion, there are 3 factors that may or may not knock Crystal off of the reporting pedastal. 1) New version written in Java. Every Java app I have ever used has been slow. I hope Crystal is the exception. 2) No significant features and enhancements have been added for last couple of...

Just in case future dates exist, you would want (select max(datefield) from table where table.date <= current timestamp) current timestamp function may differ based on the database platform that you are using Then in the record selection clause table.date >= {%LastKnownDate) - 7 and...

Create SQL Expression field called LastKnownDate (or something similar) Enter something similar (select max(datefield) from table) Use %LastKnownDate SQL Express field in the record selection clause table.date >= {%LastKnownDate) - 7 You may take a performance hit on the speed of the report...

Why don't you add the contacts data table into your 1st subreport and link by the Contact ID (or something similar) and group by contact name and add the particulars in the detail section of the subreport.... Each contact should have a ContactId (look at the primary key in the contacts table)...

There is a way to create a subreport with in subreport but it very limited and you need to know a bit about SQL. Actually you are limited to one field (but often this is enough). Use a SQL Expression to create a select statement linking back to one of the database fields in the tables that you...

Yes, splitting the images with a tiff splitter appears the only way around this issue. I just wanted to make sure I wasn't creating extra work for myself. Thanks for your time. D.

I often use this database solution. It reduces the complexity of trying to achieve the same thing by using conditional formatting in the report. Of course, I assume, that you have permission to do this in the database. I create a table in the database with 3 columns create table report_copy...

Crystal XI sp2 DB2 8.2.4 Database ODBC (RDO) Is it possible to displays multiple pages from a multiple page tiff object in Crystal Reports XI. I am able to insert a graphic object and have it point to a tiff file on a hard drive and it displays on the report . However it only displays the...

I think the spread of TLA's is more rampant than colloquial puerility .. IMO :-)

I have found only two ways around this. (1) Create a database view or stored procedure to eliminate the subreport, where the view has a nested subquery returning the values you require or (2) if you can, eliminate the subreport by moving the tables in the subreport to the main report and do a...

Access 2003 ADP(Access 2000 File Format), SQL Server 2000 backend I have created a simple form, using the standard functionality in Access. When using the following standard toolbar buttons Filter by Form I enter SMITH into the last_name field Apply Filter Get my results Remove...

Note correction to y variable, should be 11. WhilePrintingRecords; Stringvar x; Numbervar y; Stringvar z; // Creates text string to 5 decimal spaces and omits the thousands separator x := totext({table.field},5,''); y := 11-len(x); z := space(y) + x;

If you do not require report header/footer, page header/footer, or group header/footer in excel, then suppress those sections in crystal. Sometimes the section height causes Excel to add the extra row because of extra space beneath the field in a specific section. If you are just exporting...

Oops... TLORDER.CHARGES should be the numeric field that you are exporting. Sorry. D.

Give this a try... WhilePrintingRecords; Stringvar x; Numbervar y; Stringvar z; // Creates text string to 5 decimal spaces and omits the thousands separator x := totext({TLORDER.CHARGES},5,''); y := 15-len(x); z := space(y) + x; Hope this helps... D