Recent content by tmkraynak

I need to have a sorted table in order to export the records in a specific order.

Sorry, but that did not help. A table can be sorted manually. A query has sort options. It does not make sense that a table cannot be sorted. Any other ideas?

This should be really easy, but it is not producing the expected results. I want to create a sorted table from a query. The fields are selected and marked appropriately in the query. The preview is sorted correctly. But the resulting table is not sorted correctly. Running the same query multiple...

solution: The monthly export hot fix did it!! Crystal 9 Database and Export Drivers Monthly Hot Fix

IDO: I just applied the March 2005 SP for CR9 and it still fails. Can you tell me the specific UFL(s) that work? TIA, Tim

This seems to NOT work on version 9 also (formula field, with the length test and chr(013) at the end.) Has anyone a solution that works in 9?

I need to build a report from multiple databases (Oracle, w 50000 records and Excel w 10000 records). I am using SQL in order to summarize the records and control for many-to-many relationships. I have successfully built the SQL Add Command for each database, individually. When they are...

In a letter type report, I am selectively suppressing field labels and data values so that the report is not cluttered with blank space. I am using multiple detail sections within the detail band with conditional suppression of the sections (along with the suppressing of blank sections). I want...

In CE 80 and 85, in the report scheduling process, one of the options presented allows the user to revise the "Selection Formula". How can this option be removed ? We do not want users to be able to change theselections other than what has been presented in the Parameters. TIA, Tim

What do you mean by "available elsewhere"? The Reporting Wizard was marketed to us as a user tool (limited, but it seemed to meet our needs). We were not intending on putting programming resources into it. Is this some sham product ?

We are using ER version 8, and allow users to modify the published reports. The problem randomly occurs during the report modification process (aka Report Wizard). The problem is that the system temporarily "forgets" the filter statements, then, after 15 minutes to several hours later...

We are using ER version 8 and are getting "random" failures in exporting historical instances of report to Excel. We use the Activex viewer as the report viewer in ER. For some reports, the export works fine, for some others it fails (that is, it hangs for a long time, then shows a...

I want to let users schedule their own reports, but not be able to see the others instances of historical reports. Is this possible? We have multiple folders with copies of the same master report (master") in each. Each folder allows full access to only a set of user groups. These users...

I have a report that uses an ADO recordset. Date selection for blank dates does not seem to work correctly. I want to exclude records with blank dates. If I do not use any date selection, records display (there are records with dates, and there are records with blank dates). However if I select...