Recent content by stevesd

I have a CR written in CR 8.5 that is using a subreport. When exporting the file, I am running into two problems that I need help with: 1. Exporting to Excel gets all the data (other formats do not get the subreport data) but are excruciatingly slow. I mean two records in about ten seconds...

I guess it was: conditionally suppressed but that didn't seem to matter. I think it printed all the time anyway.

My text file contains only the primary report and no items from the subreport. Any ideas on how to get the subreport to export to text file?

Thanks lynchg for your speedy reply. I have tried one change that seemed to make sense: I have formatted the detail line of the subreport conditionally. That is I found a field in the detail line, and wrote, 'if isnull({cust.acct}) then true, else false' I hope that will suppress the sub...

I need to suppress printing the main and the subreport unless there is data in my subreport line. If there is data in the subreport, in other words, that's the only time I want to show both.

I didn't find any way within the structure of the reply 'box' to insert a link to the thread. Your tip on how to enter it was the way in. I admit, tho, that that tip was too technical for me. Can you tell what it does and try to break it down step by step. I realize it would be a lot of work...

I need to eliminate most of the detail lines in a report because the result gives more lines than our server, sometines even Excel can handle. The situation is that I am displaying several items per account and each generates a line in CR so each takes a line in the resulting spreadsheet. If I...

Thanks, from Omaha, NE USA. I appreciate the help

thanks, Madawc, for the suggestion of exporting to Excel. That is exactly what I do, because the users want excel format in order to work with the data. I find that it does many things such as letting me compress the fields and show just a few characters on the CR. FV Trainer has interpreted...

Where is the setting to have my reports default to 'landscape' instead of 'portrait'? I find that no users want CR in CR format but always want spreadsheets. I am using CR 8.5 and have many users.

Hello, I am doing a CR (8.5) that should be a simple join, but is returning too many records. My report uses the Tran table to select specific records daily. When joined to the Rest table where there are more than one record for each acct on the Tran table, so I am getting rows duplicated in...

thanks very much, lbass. the totals are true.

A detail record printing for an account. In other words, when I select a record with my record selection parameters, it is an occurrence. In life, it means the customer has placed an order. some will place several a day, while others will place many a day, others only once.

I would like to summarize a long list of account/transaction dates. The summary would be: Number of accounts with 1 to 3 occurrences: ### Number of accounts with 4 or more occurrences: ### I do have running totals built to do a distinct count to give me the number of accounts doing business...

I am asked to select records based on two parameters {type} and {subtype}. But I can't always choose based on both. sometimes I have to use just {type}, i.e. if {type} ="CR" then I want all {subtype} but if {type}= "EF", then {subtype} must be "FI" or...