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

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

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

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

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

I have a dynamic cascading parameter that I created through a business view. One part of the parameter selection is Log On Rights (if you want to see users with Log On Rights, without or both) and the other part of the parameter selection gives you a list of users depending on what you chose for...

I have a report that I need to show only the inactive users (where {table.action} = 'I') and their userids. The problem is that some of the users have mulitple entries in the database with mulitple dates and differing {table.action} types. For example, user BBear has one entry on January 1...