Search results for query: *

Hi All! I have a report that includes an unlinked subreport. When the data is refreshed in the main report, does it automatically refresh the data in the subreport or is that a separate step to ensure it happens? Thanks for your help! jennifer.giemza@uwmf.wisc.edu

Happy Friday!! I want to display info from two different records next to each other, as if they are on the same record. Example of the data: TABLE_1.TX ID TABLE_2.Line TABLE_2.Prov ID 23515696 23515697 1 100038 23515698 1 130088 23515698 2 601 There are three...

Happy Friday!! I want to display info from two different records next to each other, as if they are on the same record. Example of the data: TABLE_1.TX ID TABLE_2.Line TABLE_2.Prov ID 23515696 23515697 1 100038 23515698 1 130088 23515699 2 601 There are three...

I've wracked my brain and can't figure out how to solve this - I'm sure you guys will know right off the top of your heads! :) Using v9. Report set up: GH1 Department GH2 Doctor GH3 Date of Appt (daily) Details {Appt Time} {Appt Length} For an easy example: Sun Prairie Dr. Schmidt...

I have a pie chart in GH1 and I basically want to show only the legend, not the pie chart. I've tried to "hide" the chart by coloring all the pieces white, but formatting is still an issue because the legend likes to float around when I shrink the chart box (which you would want it to do in a...

Happy Friday! I currently have a very simple graph on my report which shows a legend. The graph is showing once for each group header 1 (there are only 2 groups in the report). It is displaying on change of CITY and is showing a value of the distinctcount of a formula {@INT_PAT_ID (MD)}...

Happy Friday! I'm not sure if I'll explain this right, so please sit tight and bear with me! I have a report with a chart that shows top 10 Diagnosis Groups by # of visits. There are many possible diagnosis groups. Obviously, only 10 of those diagnosis groups will show at any one time. The...

(Using Crystal Report v9) The crosstab layout looks like the following: 200402 200403 Prov id: 110606 $1000 $1500 Prov id: 210606 $500 $550 Prov id: 200116 $800 $880 I want to suppress the rows when the prov id starts with a 2. I can't find...

Occasionally, Crystal will generate a sqlnet.txt file and place it in the same folder the report I'm working on originated from. The latest one included the following text: Fatal NI connect error 12560, connecting to...

I'm not quite sure how to accomplish this, but maybe someone out there has an idea. I have a report which calculates the Start Date and End Date that should be pulled into the report based on the CurrentDate. If the end user picks a Start and End Date range that includes 2004,03,11 to...

This question relates to reports published to Crystal Enterprise v9. We are using Crystal Reports v9 to design the report. The majority of our reports are written on standard 8.5 X 11 (letter) paper. There are a few reports, however, that we've had to expand to 11 X 14 (legal) paper. Is there...

I have created a formula which outputs a title for the page header of a report. It returns the following: For Post Period: July to December 2003 For Last Post Period: July to December 2002 It is one formula, but I don't know how to force it to go to a second line in the middle of the formula...

Hi all! (My deadline for this, of course, is by a 1pm mtg Tues Apr 27th which gives me tomorrow, Monday and Tues morning.) I've been asked to create a list of reports according to who the report was published by. Is there an easy way to do that? (I suppose I'd like any way to do it, not just...

I have a crosstab which summarizes five different fields - charges, payments, cancellations, professional charges, and volume. Is there anyway to put labels in front of the summarized field? This is how I would like it to look: 200202 200203 200204 FamMed CHGS...

My main report and the subreport are both based on the same table. The part of the structure that's important for this report is the following: Patient Provider Appt_Made_Date Appt_Date Appt_Len Doe Bills 03/02/04 06/16/04 15 Jones Love 02/02/04...

Hi there! I have a pie chart that sometimes has up to 20 different slices showing. It is displaying in color but the printer is black and white - I don't want to display in black and white because it changes to patterns and it is too hard to read. When a slice is filled in with a light...

Hi all! I'm trying to demo the .rpt Inspector because we have a huge project coming up soon that requires lots of changes across many reports. Does anyone know if this software can change selection criteria? Any testimonials on how it's worked for you? I downloaded a trial copy to figure out...

I hope this is an easy question because I can't figure out what in the world is going on with this report! My report has five groups. For all five groups, we have implemented "flexible grouping" using parameters and formulas - the end user can pick what the groups should be at run time. They...

I have a very simple report with two groups (none hidden) and some formulas and subtotals. One of the formulas in the details section has this font color formula applied to itself: if {@Check In to Arrival to Deletion}>19 then crred else crblack The formula, {@Check In to Arrival to...

Okay - we've read all the hype about the new release of Crystal Reports. But, now I would like to hear opinions from you guys. Is it really worth upgrading again? Are there any great new features/enhancements that we should consider or that will effect everyday working life? Some of the...