Search results for query: *

In Crystal 8.5 when creating a report, where would the SQL Union command be written. In report expert when choosing SQL Queries a repository opens. How would I get the query file into the repository? Thanks

Don't think that I explained clearly, if I link Tables A & B, how will I then write the query to pull in records from both tables? My record query looks like the following: {TLedger.Institution} = {?Institution} and {TLedger.ControlCode} = 'T' and {TLedger.StatusCode} = ["A&quot...

I have two tables, A and B. These tables are similar from a data content persepctive. Table A contains order information that is pending, while Table B contains completed order information. I need to report on the combined information. Is it possible to combine A/B records and to then...

I am not getting the results I need....the scoop The Table is called MLedger. I have the report groups of (Institution/SecType/CUSIP) so the lowest level group is CUSIP. For each record on MLedger, a Db column called, {MLedger.CurMktValue}, is split into to seperate fields on report, one...

Thanks for your help, so far....I applied the formula and got a message that says "The summary / running total field could not be created." I believe that it is not possible to find the maximum or minimum of a group of records and to then display that value in Crystal, and then...

I have two formulas on a detail record, called A & B...very basic formulas. I need to take the greater of the 'Sum' of A or B (i.e. a Group) and then arrive at a report total of these values. Any ideas on arriving at the report totals.... I am able to write formulas to display the greater of...