Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. SBSMedicalTech

    Help with a Crystal Report to determine Percentage change between formula and static value

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

    Help needed to replace cross tab

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

    Help needed to replace cross tab

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

    Help with Date Formula

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

    how to format group x axis ?

    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!!
  6. SBSMedicalTech

    Is it possible to change the colors on a stacked area vertical chart?

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

    Stacked Area Chart

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

    Running Total - formula help needed.

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

    Stacked Area Chart

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

    Running Total - formula help needed.

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

    Cross Tab Report - Gridlines not displaying

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

    Issues with Legend in chart. Need to add trendline to legend.

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

    Chart question

    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!
  14. SBSMedicalTech

    Chart question

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

    Chart question

    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??
  16. SBSMedicalTech

    Evaluation Time Functions - not sure how I can get results as I need.

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

    A date-time is required here warning.

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

    Is it possible to add a footer to a Pie Chart and pull based a value??

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

Part and Inventory Search

Back
Top