Recent content by ZacharyR

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!