Recent content by Roscoe307

I have a left outer join from tableA to tableB on a field named {CODE}. TableA has one extra value under {CODE} which is '5'. '5' means that the {CODE} is unknown. TableB has the same codes EXCEPT for the '5'. Now when {CODE} = '5' in tableA the field {CODE_DESC} in tableB is empty. ({CODE_DESC}...

Thanks! That worked perfectly. =)

Our fiscal year is from Oct 1 - Sept 30.

Our fiscal year is Oct 1 - Sept 30.

Where should the FY dates be defined? Just in a formula that's included in my record selection that's used to filter the records? Sorry, sometimes I tend to make things harder than they really are. Thanks lbass for your help!

I have a report where the user enters a fiscal year (by typing it in a parameter in the following format YYYY). I need to only show data for the specified fiscal year depending on the dates of two fields ({PERF_START_DATE} and {PERF_END_DATE}). These fields should be used to determine the fiscal...

Sorry, first time posting a question about software. I will make sure to NEVER do that again..... I am using CR XI R2. Thanks Groggle!

That worked, thanks lbass!! I really appreciate all of your help. -SS

Thanks lbass! I'm getting a little closer to having this done. The only thing is now I'm getting the error "A subscript must be between 1 and the size of the array." This happens if I don't select all 8 fields. E.G., if I only choose 3 out of the possible 8 fields to display.

Does anyone know why a field {Fiscal Year}which contains years (2003-2008) only displays all of the years when pulled into the report but doesn't show all of them when you 'Browse Data' or use the field as a parameter selection. I can only see up to year 2006 when I browse or try to use it as a...

lbass, I'm using the thread that you directed me to, my question is, am I supposed to have 26 parameters from which the user has to select each field they want to display? E.G., For {param1} the user selects Fiscal Year {param2} user selects Office {param3} user elects Plan Title...

I have a parameter that will allow users to pick up to 8 fields to display in the report. There are a total of 26 fields that the user can choose from. The question I have is, is there any way to format the report so that regardless of what fields the user chooses the report is still formatted...

I figured it out. Thanks anyways!

I see 'N/A'.

I need to display the current status of an application. I first need to look at numbers (AWD_DOC_NUM, SOL_DOC_NUM, REQ_DOC_NUM, PLAN_DOC_NUM) to see if there is a number populated in that field. If there is no number then the field automatically populates 'N/A'. So to begin I want to look at...