Search results for query: *

I need to convert an AR Days report that I did in Crystal Reports over to Cognos Report Studio. Most of what I need for the report is complete aside from the last calculation which was quite complex in Crystal. User lbass helped me with this great code for the Crystal report which worked very...

I have figured this out. It involves the using of a running total on change of group 1 for each record.

I mean to say, I get an inflated EBIDA calculation. Everything else works fine.

I am now doing the same report but at a more micro level. The last report was a roll up of all departments. This report is the same but at department level. Thus, my groupings are the same with the exception of department being at group 1. So, at the end of each department, I need to have ...

Thank you! I just had to alter the code to read {table.group2field}in ["Revenue","Expenses] and I'm good to go.

You mean in group 3 where I am placing the EBIDA calc. That was also something I was not sure of and could certainly be the source of the issue. It is a column that essentially has the same code all the way down in the data set, a primary key, giving me the entire data set. I just need to get...

I am doing a Profit and Loss report where I have a calculation of EBIDA (which is revenue - expenses) that must appear below expenses. It should have this order: Revenue Data Revenue Total Expenses Data Expenses total EBIDA Other Income and Expenses Net Income (EBIDA - Other inc and exp)...

I have figured out the issue for those that may come across this issue in the future. Here is the solution that worked in my case: 1)I did a right click on my chart to go into chart expert and changed my chart type from line chart to Numeric Axis, selecting the Date Axis Line Chart. 2)I...

I don't quite understand the response. I am just developing reports via Crystal using Crystal syntax and just need to know, based upon my formulas, if and how I can get it to recognize dates in chronological order. Every time a new month of data comes in, that new month is either relegated to...

I have a graph that is formatted to show the following date format: Jan-11, Feb-11, Mar-11, etc, for example. I have converted the table date data in the following manner: @ToDate = cdate({@Year},{@MonthConvert},01) where @Year = tonumber({tbl_Convert_Calendar_to_Fiscal.Calendar_Year})...

I have tried on my own but to no avail to get this graph to work. Does somebody have an idea?

Thanks for the report. However, it uses such a simplistic example and, after examining and working with it for two days, I still do not know how to get it to work with what I am trying to do. As you can see from my formulas above, there are three embedded formulas in the final calculation for AR...

Thank you very much LBass, after working through my data and changing all variables for each formula representing each hospital, I was able to get exactly report I needed. As with all my reports, I have been asked to place a graph above which I always place in the report header to provide a...

Yes, apparently, we posted at the same time. Basically, I need to show AR Days for each individual hospital in our system of hospitals (which would be a subset of the whole). The database consists of data for every hospital in the system and there is a hospital field to query on. Then, the final...

@UpdatedEndBal = Sum ({PatientSummaryTBMonthly.TB Ending Balance}, {@ToDate}) - Sum ({PatientSummaryTBMonthly.TB Ending Balance Credits}, {@ToDate}) {@MRAvgDays}= day(dateserial(year({@ToDate}),month({@ToDate})+1,0))+ (day(dateserial(year({@ToDate}),month({@ToDate}),0)))+...

Unfortunately, this did not work. I am getting numbers that are about 3 times larger than they should be. I created individual formulas for each hospital, for example, if {PatientSummaryTBMonthly.Hospital Abbreviation}="CV" then {PatientSummaryTBMonthly.TB Period Charges} and, for simplicity's...

Are referring to the {@3MRAvgCharges} formula with this line: rev[j] := tonumber(sum({PatientSummaryTBMonthly.TB Period Charges},{@ToDate})); if j < 4 then ( x := sum(rev);? So, are you saying I could have a different {@3MRAvgCharges} formula for each hospital and, upon creating the hospital...

thread767-1635183 My goal is to create a report showing the number of AR Days per month per hospital as indicated by the following array: Hosp1 Hosp2 Hosp3 Total Month1 x x x x Month2 x x x x . x x...

LBass, thank you for all of your help. I was finally able to get this to work. Per your suggestions, I did the following: {@CVPay}: if {PatientSummaryTBMonthly.Hospital Abbreviation}="CV" then {PatientSummaryTBMonthly.TB Period Payments} {@CVChg}: if {PatientSummaryTBMonthly.Hospital...

The total charges or payments, depending on the report, would be summed in the GF1 to look like: Hosp1 Hosp2 Jan sum(charges/1M) sum(charges/1M) Feb sum(charges/1M) sum(charges/1M) etc In the case of the report we are discussing, however, I will have Hosp1...