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

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?

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

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

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

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

I need to select the activity record with the latest record date. The table will have many records for each account, I just want the latest dated transaction. I have not been able to find a date function that reflects what I want to do

Is there a way to be sure I select the duplicate records and print them both, not just the second one?

I would like to export to PDF format, but is not an option that comes up when exporting. Is that available as a download, or is an upgrade needed, or is there another option I haven't thought of? Thanks for the help.

How can I get my subject line to show up bold like everyone else's. Not being able to is giving me a complex!

Why do I get that message when trying to export? Sometimes it happens many times in a row. Do I need to do a file save before exporting?

When importing a pick list into a parameter that will be used as part of the record selection, I ran into a data base error whenever I imported more than about 25 records. I need to enter about 1000 customer account numbers, so running a report for each 25 takes a LONG time. Is there an actual...

I need to show group footer records only if there are two In transfers and two Out transfers in a month for the same account. I have logic that says if Trans.type in [ "AZ", "DR"...] then In and if trans.type in {"AT", "FH"...] then Out I hope...

I need help with the syntax for a variable. I have assigned a variable that I want to use to count the number of times an account has certain restrictions occurring during the last month. For example, Numbervar counter := 0 to initialize. Then I need some proper syntax to add one to the...

I need to make CR8 show only the duplicate records. In other words, the reverse of suppressing duplicate records. I have the records sorted. The records I want to show will be those whose id matches the record previous to it. I will have about 4,000 records but only a handful of duplicates.

Does anyone know how to make line numbers appear before each line of detail for a CR8 report? It seems simple but not obvious how to do it. Thanks.