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!

Register Log in
  • Congratulations derfloh 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. jcrawford08

    Dynamic Shared Variable Naming?

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

    Running total off of comment field...

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

    Alias Tables and LOJs or SubReports...

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

    Specifying Date Array in Main report for use in subreports

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

    imaginary parenthesis, and null subreport...

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

    Masking a number parameter...

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

    Converting String to a numeric value

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

    Bad Date String Format... with null and date controls in place...

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

    Controlling for bad data entry in a string

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

    Using a case select with an array portion of comment field

    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)...
  11. jcrawford08

    String Formula Not Displaying Properly...

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

    Spliting a long txt string into two parts at a variable mark

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

    Researching Presentation Tools...

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

    Print time formula charting using shared variables...

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

    Data series displaying incorrectly in chart area

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

    Print Page Footers at bottom of page...

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

    record based table selection...

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

    Can you force Column Breaks in CR XI

    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?
  19. jcrawford08

    Alternating shading properly within a multi-column report

    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 +...
  20. jcrawford08

    Using parameters to Group on variable data types...

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

Part and Inventory Search

Back
Top