Search results for query: *

Thanks lbass for the suggestion that the older data may be archived. I did in fact make a bad assumption regarding the data that is available through the particular view that I was using. It appears that only 2004 data is available and I am not sure that we have a view available for prior years...

I have double checked and still do not see anything amiss. Poor eyesight? Bad assumptions? Quite possible. The fields that I am passing for selection in the subreport are parcel and year. I have tried displaying those (pm-) fields on the subreport and see that the passed data is correct in all...

In CR 9 I have created a main report that returns real estate information specific to owner name matched to an input parameter. I have grouped the report by parcel numbers within owner. The detail section displays a line for each billing year within parcel number, including bill number...

I'm creating a report in v8.5 that accesses three tables. Table 1 is a bill file linked by customer account number to table 2 which is a customer file. Table 2 is linked in turn by SSN to table 3 which is an employee file. All links are equal joins. I want to only verify that there is an...

I am looking for the best way to isolate street name out of an address line that begins with street number. I wish to order output by street name for general grouping purposes.

Thanks Ido and MSM, this forum hasn't failed me yet!

I have included a subreport in the group header of my main report. The purpose of the subreport is to populate shared variables to be displayed and used in calculations in the main report. These things need to occur in the group footer of the main report. The subreport is returning the desired...

Thanks Ken for suggesting yet another great alternative. My plate is full for consideration. This forum site has proven to be a great resource tool!

Thanks Peter. A great suggestion and a likely solution. Although the user will still be viewing designer, this would certainly minimize the problem/confusion with toolbars.

Thanks for the link synapsevampire.

I am running Crystal v8.5. For users to be able to execute existing reports as needed, is there any way to shortcut from a report selection menu directly to execution or to a requisite parameter values screen without the design screen being displayed? I have users who find having to view this...

Aha! The old Group Selection Formula technique! Thankyou Ken for pointing me toward the light!

Thanks for responding. I expected some performance degradation across the platforms, just surprised that it was so significant. You are right in questioning if this can all be done in one report from Informix. I think it most likely can but being initially unsuccessful in that approach, I was...

Hi, Using CR v8.5, I queried my real estate customer table, filtering for customer IDs that were attached to more than a single real estate parcel. I exported this output to an Access 2000 db to use as an input driver file in a followup CR query (not a subreport). My main data file is an...

I'm new to Crystal and learning. What is the best technique for generating an input record count and displaying the incremented count for each record? I suspect that it involves a formula with a variable and is really quite simple. Assuming that I am correct, I believe that I can handle the...