Search results for query: *

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

I would create a command that says: SELECT STATE_NAME FROM SCHEMA.STATE_TABLE UNION SELECT 'ALL' FROM SCHEMA.STATE_TABLE Then in your parameter editor make sure that you've selected this new command as your data source and also allow multiple values to be selected. This way you get whatever...

Thanks so much lbass!!

I need to create a formula that will combine four comment fields into one. I tried to concatenate them like this - {AWRD_TXT}&{PLAN_TXT}&{REQ_TXT}&{SOL_TXT} but the formula field shows up blank in the report even though the {PLAN_TXT} field has data. How can I get the formula to display the...

Am I inserting the summaries(='AMT1')and the request number group(group #1)? Also, (sorry these requirements are coming in as we speak) I need to take that dollar amount 'AMT1' (where the request is associated to multiple awards) and compare that to another dollar amount 'AMT2' that is...

I have a long list of request numbers that are tied to contract numbers. Some of request numbers can be tied to multiple contract numbers. I need to find where this is true and then add the dollar amounts associated with those contracts together. This might be really simple and I'm just over...