Search results for query: *

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

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

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

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

Running CR XI R1, on a SQL environment... I have two dillemmas with the formula below: 1) I have looked at the parenthesis OVER and OVER and cannot see where I am missing one, but CR insists that I add one ")" to the end, just before the display clause... 2)In situations where the string...

CR XI R1, SQL environment: I have a number parameter for values, 1,2,or 3, set to display only the description, allowing no custom values, and allowing multiple selections. Essentially, I want to display the parameters on the report, however, the end user will not know what 1, 2, and 3 mean...

to preface, running CR XI R1 in a SQL envirotnment... I have a user who needs to track manual follow ups; she is prefacing a string field with a number (1-5) followed by an equal sign (=) and then some additional information. I had planned on doing a split then on the string field at the equal...

Okay, I'm stumped... I have a report that calculates days outstanding based on a date that's entered into a string field (wish it were a date field!); I have controls in my record select as follows: isdate ({Comment.Field}) and not isnull({Comment.Field}) and {@Outstanding time} >= 140.00 The...

Hi All, CR XI, SQL Environment... I have a text field, and in situations where less than 3 Chr(13)s have been entered, or the instance of ["/", ", "] is less than 3: stringvar baddata; local stringvar x:={RV_Practitioner_Office_TaxID.Comments}; local numbervar i; local numbervar cntpar; local...

Hi all, CR XI, SQL environment: I've narrowed down an issue I'm having with a string formula. Essentially, I am re-sorting a comment field to show what the data means, address line, csz line, etc. One portion, the fourth paragraph of it, simply has three characters to choose from (5,p, m)...

Hi All, I'm running CR XIR1; I'm having an issue with some rather complex user fields I'm stringing together into one massive "summary" formula. I can get each of the fields to display data themselves, so something is skewing it in the formula I'm using. When I place the formula {@Reference...

Hi all, Here is the dillemma; I have a report that has an explanation section that sometimes (unfortunately, out of necessity) carries on far longer than others. In the scenario I face today, the character count hits at 6505. The report is written so the end product is easy to follow and flows...

Hi All, I am researching some presentation tools to spruce up our basic powerpoint presentations. With basic power point a good presentation can be made, but without some in depth training they come out looking at best like an 8th grade project and at worst a holding place for all the words a...

hello all, I have an interesting conundrum; I am working on a report with no groups to it, just several subreports. Presently the report is run weekly and sent to the manager of one of our departments. The report itself showcases all areas of the department with total tasks, longest...

Hi All, I have a 2D line graph I am working on in Excel 07; it has four data series', two that show actual output, and the other two I have set up as a 'goal line' so that we can easily see how we are measuring up. My y axis goes from 0-300, and the average data series for one of the data...

I have a basic checklist report and am having some issues with page footers. The report only has GH1 - details - GH2(supressed, and then I have three page footers: PFa has a caption indicating additional data following, and is suppressed where totalpagecount<>pagenumber PFb has a signature box...

Hello All, I have a database I'm working with that records processes launched for clients; at the close of a process, all of the records regarding that process are moved to an archived table within our database. Unfortunately, that makes them mutually exclusive - to get performance data...

I have a multi-column report that I would like to keep from orphaning my group headers on the previous column. Is there any way to force the system to column break in situations where the details will be put in the next column and the group header(s) left in the previous column? Any ideas?

Hi all, Working with CR 11; I have my groups set to columns with my details and would like all data on row 1 one color and all data on row 2 a separate color etc. I have the following as a surpresssed formula in the GH2 (that's where the data is): whileprintingrecords; numbervar cnt := cnt +...

I have a report(CRXI R2) showing applications that have been sent to separate companies and their time outstanding. I would like to set up the report so that the primary grouping is based on end user's choice of either 1) Oldest time sent, 2)Person who initiated the applications, or 3)the...