Search results for query: *

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

I found a function that solves my prob! Minimum (x) Maximum (x) I love CR functions! :) Zach

great!...that fixed it..thanks Zach

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

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

thanks...There's only one field I can use to link the two reports, and it's not the field that has the A, B, C values But, I just realized you can link the subreport to the container report on more than one field....i'll give it a try. thanks! Zach

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

thanks for the help......you're right it does not distinguish between single and double quotes......but here's what I get when I try your code (slighty modified though) '//10.60.13.80/documents/' + {HWIN_IMAGE_DETAILS.FOLDER_NUMBER}+ '/' + {HWIN_IMAGE_DETAILS.FILE_NAME} + ' ' +...

thanks for the help......you're right it does not distinguish between single and double quotes......but here's what i get when I try your code (slighty modified though) '//10.60.13.80/documents/' + {HWIN_IMAGE_DETAILS.FOLDER_NUMBER}+ '/' + {HWIN_IMAGE_DETAILS.FILE_NAME} + ' ' +...

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

ok...sorted it out! thanks for the help! :D

OK....it sort of works....but not quite...here's what it's doing.. I followed your instructions...but when the chart draws what CR does is uses the value I set in @Threshold and ADDS it to the corresponding data point for the series. So, essentially, the threshold line is identical to the...

thanks! will give it whirl and report back! :)

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

great...just downloaded the demo....so far it looks a bit complicated, in that I need to use macros.....but i'll give it a shot! thanks!

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

crappy....that's what I did not want to hear :( i'm on CR XI R2 I did find this link....some guy created a PPT slide show....anyone tried this? can any of you CR pros check it out and see if it's worth looking into? http://sfarea.org/Whiskers.ppt thanks! Zach

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.

but still, if you were to choose 'for each record' why would you not be able to sort the values before they're placed on the chart? thanks for the help though!

lbass: good stuf!! I had it set up to show the data 'for each record' ...the 'order' button was not available to me... I changed it to 'On change of' and the order button was now available.....and the chart shows up in proper chronological order!!! But that begs the question....what's the...