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 TouchToneTommy 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: *

  • Users: ZacharyR
  • Content: Threads
  • Order by date
  1. ZacharyR

    Chart sort order not working with a function of a function

    Hi, I have a bunch of dates in this format MM/DD/YYYY. I created a function called @DateMonth and used 'Month (x)' to get the month only - the values are returned as a number, that is 1 is January, 2 is February, etc. When I chart this out on the X axis, the months appear in perfect ascending...
  2. ZacharyR

    Displaying a parameter field value when set to accept range values

    Hi, I set up a paramter field in my report, which I can then use to display to the user when the report is run. That is, when a user inputs '150' in the parameter field, I can then use that parameter field and have it display the '150' to the user when the report is run. However, when I change...
  3. ZacharyR

    How to group by month only when the date field is MM/DD/YYYY

    Hi....I need to group records by month only, for all years. The records each have a date field that contains values in the MM/DD/YYYY format. I recognize that i need to use a formula as the group sort order to only grab the month value and ignore everything else Example of how I want the...
  4. ZacharyR

    Suppress record in sub-report based on value in container report?

    Hi, What is the syntax to suppress the display of a record in a sub-report based on a value of the corresponding record in the container report? Example....I have a table with values of A, B, C Currently, if I select only A to be displayed in the container report, the subreport will still...
  5. ZacharyR

    Need help with HTML syntax in the Formula Workshop

    Hi, I am trying to add a bit of HTML code to a formula for a hyperlink. The forumla i've come up with uses quotation marks to concatenate various text strings and fields to build the hyperlink. However, I want to add the HTML code to spawn a new browser window - target="_blank" The problem...
  6. ZacharyR

    Adding a red-line/threshold to a chart....just for context

    sorry for all these chart questions....this one is really simple...for what it's worth, I do not think this is possible, but I just want to make sure. I have sample data for water quality....i've charted it without any problems (X axis shows the date the sample was taken, and the Y axis shows...
  7. ZacharyR

    Creating a stacked chart

    Hi again...have another chart question...can't seem to solve it (but I know it has to be possible!) I have some water data...basically sample results (ie. pollutant concentration) over various sampling dates. The results were acquired using 4 different sampling types. How can I place a stacked...
  8. ZacharyR

    Box and Whisker plot capability for Crystal XI??

    Just a quick question...is there a plugin for CR XI out there than can produce standard box and whisker plots ?? something along the lines of this: http://www.avalanche.org/~moonstone/images2/gr000220.jpg thanks! Zach.
  9. ZacharyR

    Field is sorted, but chart of does not show the sorted data!

    Hi! quick question.....I have built a simple report....one of the fields shows dates, so I naturally set it to sort and display in ascending order....works like a charm. The problem is the chart that is showing the same data is NOT reflecting this sorting.....the date (X) axis is just randomly...
  10. ZacharyR

    Colour Highlighting on a Line Chart is not working

    Hi, I have been trying to figure out what is going wrong with my line chart in CRXI-R2. I have a line chart showing a series of samples values (for water tests). Each sample was taken on a certain date. The chart shows 10 years of data. I used the 'colour highlight' tab under the chart...

Part and Inventory Search

Back
Top