Search results for query: *

It seems to me you could try to actually create a formula that gives you the total you need - {@f_PresRd_kWhT}+{@f_G3Footer} - and then use the running total expert to sum it up, resetting on group 2 and evaluating on change in group 4... -jcrawford- Not in word only, but in deed also... 1Jn3:18

Thank you for vindicating that I have not lost my mind completely :) -jcrawford- Not in word only, but in deed also... 1Jn3:18

My apologies, I guess that's a habit I've gotten in. I seemed to recall coming into some issues previously where without a control the split formula would error out, but the specifics must have been different than they are in this situation. -jcrawford- Not in word only, but in deed also...

A very valuable evaluation tool indeed! I'm glad I could help show you another tool to place in your tool box MCuthill [hammer] -jcrawford- Not in word only, but in deed also... 1Jn3:18

CoSpringsGuy - you'll want to have a control in case there is no second word in the string, something like this: if instr({myTable.MyField}," ")<1 then {myTable.MyField} else split({myTable.MyField}," ")[1] -jcrawford- Not in word only, but in deed also... 1Jn3:18

Try: Sum ({CashRecDetail.Amount-Deposit-Applied}, {CashRecDetail.Postage-Deposit}, 'True') It's looking for the actual string that the boolean returns, and so the True needs to be in quotes... -jcrawford- Not in word only, but in deed also... 1Jn3:18

Hi All, Working with CR 2008 on a SQL server. Essentially I have two reports that show financial calculations for the same metrics, the report consumer wants to see all the data in a singular report. Unfortunately because of the diverse table structures between the two, placing it all within...

Thanks Brian, It worked pretty good, I did have to mix up the order a bit, as there are some instances which we have not yet received any funds, and therefore need to display "$0.00" - I had to move the variable declaration around a little to get it to display properly, so it was augmented as...

Alright, so I made it this far, which will display $0 if no payment has been received: currencyvar money; local stringvar x:={My_Field.Comments}; local numbervar i; local numbervar cnt; local numbervar cntslsh; for i:=1 to len(x) do(if x[i] = ["$"] then cnt:=cnt+1; if x[i]=["|"] then...

Hi all, the basics - running CR XI in a SQL environment I've got a conundrum for you: A comment field where users will enter the amounts of payments received in the following format: $10567.56|$112.52|$57.12 I need to sum off of this field and display in currency format; however, there...

See the attached report; I have a very odd workaround for listing "None" on the subreports if there indeed isn't any Medicare or Medicaid number found for a given provider. It's based on a Null Check display formula, a "None" text field, and conditional suppression. The only sub-report that has...

Presently this report is just being used to do a massive export for another system to import; we are changing our software vendor and so we're rather limited on changing the arrangement of columns. There are about 480 or so Drs. on the report, one row per doc, and then their respective...

They are instances of the same field; my apologies for convoluting it with simplifications: Name NPI License Medicare DMAP Dr. A 123 456 789 912 Dr. B 234 567 890 123 Dr. C 345 678 901 234 The NPI, License, Medicare, and DMAP numbers are all recurring...

Hi all, I'm Running CR XIR2 in a SQL environment; The report I'm working on needs four seperate ID Numbers displayed, for ease, lets call them: Num1 Num2 Num3 Num4 These are contained in table "Provider_IDNums" that we have linked to the primary "Provider" table...

Essentially the majority of our workflows are not dependent on approval date, these are the only two workflows we have that are - hence why I need the information to only affect them and also why I am bringing all this information together in sub-report form. There are two ways that files are...

It is actually the second Tuesday of every odd month; unfortunately, although this is the standard, scheduled time, committees are subject to change. For now I have the dates specified out using dateserial, then using if/then logic to establish the grouping of the subreport i.e.: if...

Alternately you could try: cstr(Datevalue({Command.INV_DATE})) this will force it to recognize the short format of your date-time field, and then allow you to reference it in your string formula -jcrawford- Not in word only, but in deed also... 1Jn3:18

The main container report actually has NO tables in it, so I was thinking of just having a formula in the container report that would specify the dates needed, and then use that formula to link to the two subreports... I know it's an odd set up, but essentially the other subreports that pull...

Unfortunately, I have it as a scheduled report off of our server, so that it will run automatically. Since it is scheduled, parameters are a no-go. My thought was to simply have an array style formula in the main report that the user simply edits from the container and then it links to the two...

Hi All, Running CR XI R2 in a SQL environment... I have a main report that is essentially just a display interface for several summary style sub-reports contained on it. Two of the subreports have a grouping formulas that are dependent upon a series of dates. I'd like to have it where I...