Search results for query: *

I want to create a report that works like a spreadsheet in that I want to have more columns that can fit on a page. I want the other columns to go on page 2, page 3 etc. Can this be done w/o a cross-tab? Thanks Jay

When there is both Group AND record selection, which happens first or do they happen simultaneously? Thanks Jay

Hi We have a very large table of patient visits to Hospitals (40 million records) covering 2005 through 2008. In order to improve on how long it takes the reports to run through all this data, we are thinking of segmenting the data into four separate tables (one for each year), since we...

Hi I have a report with two tables. A client demographic table which contains a unique Patient ID and a visits table which contains the visit date. The data is grouped by patient ID. I can use a running total or formula to display the earliest visit for each patient. 1) How can I select only...

How do I change fonts for incoming e-mail? Can I do this for all e-mail and not only plain text messaging? Thanks Jay

I am running windows Vista. Outlook 2007 is our e-mail client. There are two people using this computer. Both need vastly different Outlook configurations. Profiles does not seem to help. When I change font size and other features after I log in using my profile, I find that the settings are...

How can I write a manual counter, using variable and "WhilePrintingRecords" that resets itself upon each change of group? I want to get a group count. Thanks in advance. Jay

We are using Crystal XI, to analyze data that is submitted to us by community health centers. We would like to write Crystal reports that the health centers can run, without having to purchase a Copy of Crystal Reports. We do not want to do this in the context of VB. We just want to give...

Hi I would like to compute how long it takes a report to run from the time I click on the refress symbol to when the report finishes and displays on the screen. Can this be done? If so how? Thanks, Jay

My report has a graph on the last page (page footer b). It graphs healothcare providers on the x axis and client totals on the Y axis. With 20 health care centers, things get a bit cramped in portrait mode. While portrait mode suits the rest of the report, I would like to print the last page...

I want to select patients who had two or more medical visits within the past year AND at least one of the visits must be within the last 6 months. I use record selection with date parameters to select patients with medical visits during the last year. I then use running totals (distinctcount)...

I have a situation with about 300 organizations and each organization may have several programs. I am trying to create a dynamic cascading popup, where the user can choose the organization and then the program or programs the user wants to see data on. When I create a dynamic cascading popup...

Hi I have a report that shows clients who were served by a group of 12 specific hospitals who had one medical visit in the past year in that hospital. The report gives the client ID, the type of medical misit and the visit date and groups the data by Hospital. I them want to match those...

Hi All- I have many reports, where the user selects an agency name from a popup. where default agency names have been pre-set at report creation. The parameter is set to display the agencyName field in the agency table {agency.agencyname}. This worked fairly well when I had five reports and...

The website is more promo and fluff in my opinion. Its hard to tell whether there are really enough new features in Crystal Reports V 10 to make an upgrade worth it. We are NOT using the enterprise version and will not be. Can somebody highlight what they key new features are for someone...

Hi I have a report with two main tables in a one to many relationship. The first table {Client} contains the client_ID field. This is the "parent" table. The "child" table {event} contains several fields including {event_Type}, {event_Date} and {client_ID}, which is the linking field. The...

I have a report that groups on client ID and then Health Care Agency name. The report gives the client ID and then the number and names of Health Care Agencies serving the client (unduplicated). This is done by running total that gives a distinct count of client ID and resetting the count for...

Hi. CR 9 is supposed to allow percentages. I can't figure out where to go to enable this. Can anyboby walk me through how to do percentages? Basically I have two summary fields A and B in each cell. Both are running totals (distinct counts). I would also like to display what % A is of B in...

1) Which takes precidence? 2) How does the presence of BOTH record and group selection effect the selected records? 3) If you have both Record and Group Selection, how does this effect the computation of percentages? Thanks in Advance, Jay

I want to write a report using paremeters, where the user is able to select from default names for Hospitals. The default values can come from the Hospital names field in the hospital table. {hospital.name}. That is easy to do? Once the user selects a hospital, I want the user to then have a...