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...
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,
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.
Fast question, I am using the Chart Wizzard and using the "Side by Side bar chart" to report back monthly charges and collections on a 13 month basis. Is it possible in any way to add in a collection average Trend line to my chart??
I am unsure how to tell my side by side bar chart to ignore a 01/01/1900 MonthYear value. I tried to create a fomula to ignore anything with a 01/01/1900, however when it layed out my graph it did not lay them out in the months I needed rather it passed a True and False value. How can I pass all...
I am getting the following message on my formula: "A date-time is required here."
{data.MonthYear} <> '01/01/1900'
I am trying to create a formula to exclude transactions with a MonthYear = 01/01/1900 in a side by side bar chart. Any help is appreciated.
Is it possible to add a footer to the bottom of a Pie Chart and have it pull the name based off a report parameter?
In my report, I have two pie charts displaying the top ten payers for the Month to Date and Year To Date. When the {Data.Indicator} = "M", I would like to have the footer equal...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.