Search results for query: *

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...

Thanks, that may be a little cryptic for me. Are you suggesting I use that join command within the text object?

I would like to display the values entered into two parameters into my report and I'm not sure how to show them. One fine point: there may be more than one value in either or both of the parameters! {Tran.Trantype} may be JN or WD or both and {Tran.TranSubType} may be CA or not populated, at all.

I actually have used the Format Section formula for the group footer after grouping by account number. I clicked on the "suppress" box and then the formula says "if maximum ({Trans.RecDate}, {Trans.acct }> date (2002, 05, 01) then true else false" in other words, in this...

Thanks, Mawdac. I have been using this in the record selection parameter: maximum ({Trans.date}) > 5-1-2002 I was getting at the date of the transaction would be later than 5-1-02

I need to find the accounts where the latest transaction date is not later than 5/1/2002. when I have tried the Max function the formula gives me an error that a boolean is expected in that part of the formula does anyone have an idea of what I may have missed? I will be specifying a list of...