Search results for query: *

Great tip! Thanks for the help!! jennifer.giemza@uwmf.wisc.edu

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

Did you ever find the answer to this question? I am exporting from the web using Acrobat and getting the same error. Thanks! jennifer.giemza@uwmf.wisc.edu

Sorry for the multiple threads!!! I made a mistake in the example data on this thread. Please ignore this one and look at the other thread by the same name - thread 767-919260 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...

Thanks again for the help lbass! I really appreciate it! It doesn't seem to me that there is a pattern of error - the first dr is correct, the middle 4 are incorrect and the remaining are correct. The following is the detail. If the APPT_TIME field is blank, that's what I mean when I say...

I'm sorry to keep asking for help on this one - I hope you wouldn't mind contributing a few more minutes of time lbass. It seems like just when I think it's working, I spot something that isn't. I have the report split into two reports - one for AM and one for PM - because if I have both sets...

Duh!! Sorry about that!! It was right in front of me the whole time and I looked right past it!! Thank you!! Thank you!! For sharing your amazing talent at Crystal with the rest of us!! jennifer.giemza@uwmf.wisc.edu

HEEEELLLLLLPPP LBASS!! (or anyone else that might be able to see what I'm doing wrong!) It seems that the AM formulas are working perfectly but the PM formulas for minutes are not. I've checked all the formulas over and over and over again to see if there are any differences other than what...

Thanks so much for the help lbass!! It works beautifully! jennifer.giemza@uwmf.wisc.edu

Thanks for the input! It doesn't look like OnFirstRecord will work because for 6/9, the first record is an AM session, so I'm not sure how I would get to the PM sessions. jennifer.giemza@uwmf.wisc.edu

I can, but I don't know how to get it to look at each "date of appt" group and only count 1 record even though there's 3 records that qualify and then end up with a count of 2 at the doctor level. jennifer.giemza@uwmf.wisc.edu

If I do that at a detail level, I can't summarize it because, for instance, I would get 900 minutes for 6/7. I can get it to work at the "date of appt" level, but not at the other levels. Thanks for the thoughts - wish it were that easy! :) jennifer.giemza@uwmf.wisc.edu

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

That's perfectly EXACTLY what I needed!! Thanks! I don't know why I never think of crosstabs on my own - but I appreciate the input! jennifer.giemza@uwmf.wisc.edu

Oops - sorry! Using v9 jennifer.giemza@uwmf.wisc.edu

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