Recent content by SBSMedicalTech

Thanks!

I need help calculating the percentage difference between two fields. In my report, I have the following formula fields set up: Est1 Actual % Est2 Actual % Est3 Actual % Est4 Actual % Est5 Actual % I also have 5 static percentages for each of these I need to get a percentage difference for...

Ian, You made my DAY! THANK YOU a MILLION TIMES over!!! That fixed my issue on several reports. I was not aware of that setting.

I am using Crystal Reports version 11.5.12.1838 In my report, I have 2 Groups Group 1: {ado.Company} Group 2: {ado.Doctor} My SQL Report is retuning 9 months of summarized data on 4 CPT code categories (New Patient, Established Patient, Consult and OB Global). For each of these CPT code...

I am currently using crystal reports 11.5. I need help with a crystal report formula. In my SQL dataset, I have a field titled 'LastDayOfMonth' and 'Month'. My data set should always return 10 rows. I need a formula that will take the date value in 'LastDayOfMonth' and change it to read...

Crystal Reports version 11.5.12.1838 I currently have a side by side bar chart in my report and my Group X (Axis) labels are reading as such: 05/01/2011 06/01/2011 07/01/2011 08/01/2011 .... etc How can I change these to read as May-11 Jun-11 Jul-11 Aug-11 Any help is appreciated!!

I am hoping someone has an answer to this problem I am having. I am currenly utilizing Crystal Reports version 11.5.12.1838. In my report, I am using a Stacked Area Chart and have it set to Vertical. I have two groupings set - Group 1: Data.CompanyName and Group 2: Data.Doctor. On the data...

Ok, this one took me some time and a lot of monkeying around with settings, but I found out the issues. I had to go into the group axis settings and over to the scales tab and I had to uncheck the "Value Axis Crosses between groups". That seems to fix the issue for me. Please disregard this...

I was able to solve this issue with a formula If Month=1 then (my values) else 0 and summed on them. Please disregard this question as I no longer need assistance. Thanks you.

In my report, I am using a Stacked Area Chart. In the report output, I am retuning 10 months of data. My chart image is starting after the first month and ends on the 9th month (right before the 10th month). How can I extend my chart for the entire length of the chart grid so I don't have empty...

I am working on a report that takes 10 months of aging data for a medical practice. In the crystal report I have tied to this report, I am grouping by the Company then by the doctor. In my group 2 header for the Doctor, I need to return ONLY the most recent month's aging information. In my data...

I am using Crystal Reports version 11.5.12.1838 I am dropping a cross tab report into my Group 1b footer that has one column (LastDayOfMonth) and 8 summarized fields (Total Balance 0-30, Total Balance 31-60, Total Balance 61-90, Total Balance 91-120, Total Balance 121-150, Total Balance...

I am using crystal reports version 11.5.10.1263. In my report, I have a side by side bar chart. My chart is returing 13 months of data on collections and charges. With some wonerful help from "lbass", I was able to add in a trendline to give me the mean of the collections and the charges. I am...

lbass, please disregard, I had to double click on it for it to finally take and allow me to add it over. Will test now. Thanks!

lbass, When I right click on the bar and go to "Trendlines", I see "mean" and other choices, however the arrow to let me add it is grayed out. Not sure what I missed to get that added. I am using Crystal Reports version 11.5.10.1263.