Hi,

I'm trying to export a rather large cross-tab report to a file (14000+ lines). Regardless of the file type I select or the speed/memory of the machine I use, Quik Reports quits responding and does not create the file.

I'm using QRW 6.2B (990415).

Is there a solution/workaround for this?

Thanks,

David

There may not be a solution to this, but perhaps a workaround. For very large databases, there could potentially be problems when trying to read it all into a report. You may be able to break it into 2 or more portions (eg customers A-M, then N-Z, for example).

Cross-tab reports usually use a little more memory than standard reports, due to the formatting that has to be done. It could be possible to restructure the report as standard, and use formulas to get the cross-tab 'effect'. Eg "If location = 'A' then Qty on Hand else 0" for an item qty by location report, then subtotal all fields and hide the details.

Is there a way to perform an operation on the date range "lastfullmonth" so I could have "second to last full month", "third to last full month", etc.

What I'm trying to do is a report that will be updated monthly that shows month to month sales for all of our customers. I thought the cross-tab would be ideal for this until I ran into the problem with the export.

Thanks,

David

Hi David,

There is no 'predefined' date range for 2 months ago, but you can create your own formulas to replicate them.

What you first have to do is create a formula that calculates the difference in months between the transaction date (trx date) and the print date (or today). Eg, call it 'Diff' and the syntax would be something like:
month(Print Date) - month(trx date)
Of course, you have to devise a way of determining whether the date wraps around January 1st. Use:
if month(Print Date)<month(trx date) then 12+month(Print Date) - month(trx date) else month(Print Date) - month(trx date).

This will calculate the difference in months, as long as you don't need more than 12 months on the report. You will have to make this formula more complex, comparing the year, if you want a 24 month report, etc. Then, create a formula for each monthly column with syntax:
if Diff = 2 then amount else 0

This will print the amount if the transaction was 2 months ago, otherwise 0 will print. For 3 months ago, use the same syntax but substitute 3 for 2, etc. This will group all transactions from the current month and previous 11 months into separate columns. Lastly, subtotal all 12 columns by Customer number, insert the cusomter number and name field into the group footer section. Hide the detail section and the report is virtually complete.

The advantage of structuring the report this way is that it is based on the Print date (rather than the system date) so you can choose to back-date reports if desired. Also, you will not have to make changes to the report every month to update the dates; simply open the report and print it.

You can also use somewhat complex formulas to calculate the column headers for printing the proper month, based on the print date.

Your dealer will have access to sample reports based on both OE and Softrak's Sales Analysis if they are current dealers with us.

Thanks so much! This is great information.

David