Search results for query: *

Steve, Create a calculated column, named MaxRec, as " MAXIMUM([date] for [employee]) ". Then create a filter: MaxRec = [date] This will ony show those row(s) where the [date] equals the hightest date for the [employee]. SLN

I assume you have a "Transaction Date" of some kind on your database row. In the filter for the report add: [TRANSACTION_DATE] = _add_days(current_date,-1) SLN

The prompt wizard allows for easy filtering when using a prompted parameter. It's a simple process when adding a "Value prompt" for example. SLN

The column referenced, '[Database View].[ResourceAssignment].[Remaining Start Date]' is not found in the defined data store. Double check the data object items. SLN

uday..., Try using: _add_days(date-exp, integer) [Business View].[ProjectSpread].[End Date] <= _add_days([Business View].[Project].[Data Date],43) SLN

uday.., Select the column of your date, In the Properties pane -select "Data Format" and open the "Data Format" panel, Set the "Format Type" to DATE, Set "Display Years" to "Hide Century" Set "Display Months" to "Short Name" Set "Display Days" to "None" Ought to do it. SLN

Try: CASE WHEN ([JOB].[EMAIL_JOBS_E].[EMAIL_TYPE] IN (1,2,4,8,10,12,15) or [LIST_ID] IN (225,226,227,228,229,230,231)) THEN [JOB].[LIST].[DESCRIPTION] WHEN ([JOB].[EMAIL_JOBS_E].[EMAIL_TYPE] = 11) THEN 'E-Mail' ELSE 'N/A' END SLN

Simply MOVE UNPACKED-NUMBER to PACKED_NUMBER. Then work with PACKED-NUMBER. SLN

blom0344 has it right. An automated DB or ETL solution is far more desired than manual actions/tasks......but sometimes necessary. SLN

To do this a few things need to be created. 1. Create your Report with 2 columns: Part Number, Description 2. Add a 2 row table in the header area, make the first row, 1st column .25" in height and 1.5" width. 3. Put a Value Prompt in the 1st Column, 2nd Row. Make id a "Radio Button" type...

recog, We currently use the Report Studio o/p to .csv from one of our ERP data warehouses. (in ORACLE) Then open the file in EXCEL 2007, then save as a Tab Delimited .txt file. Then FTP that file to our mainframe, and a DB2 load utility reads the file, as a delimited file, and loads directly to...

BLOM, The final query, while containing 3 rows each, will be reduced to 1, when the report studio report groups on all 4 columns. It will reduce the result to 1 row by NAME, TYPE1, TYPE2, TYPE3. Auto-Aggregation might do that anyway. It will essentially be: SELECT NAME, TYPE1...

Jack, Create 3 queries: Name, Home_PH, Work_PH, Mobile_PH Where each populates the Name column, and one of the 3 Phone Number types. Union the 3 queries together. Group by Name, Home_PH, Work_PH, Mobile_PH Joe, XXX-XXXX, 'spaces', 'spaces' Joe, 'spaces', XXX-XXXX, 'spaces' Joe, 'spaces'...

I've performed this same operation of "Conditianally Formatting" the view/do-not-view columns based on radio buttons from a prompt page. It works. I used Report Studio from v8.2 I'm not sure if your v1.1 would work the same (I assume so). Would you like more info on this operation? Steve N...

If all of the values contain only numerics, then casting the varchar field to a number, then using the data format property will work. If a cell has a alphabetic or non-numeric value, then the conversion will not be successful. Steve N. State of Ohio, MIS

SUBSTR is a beautiful instruction, isn't it? Steve N. State of Ohio, MIS

kernal, Yes, change your "TO_CHAR" statement of "TO_CHAR(A.STARTDATE,'YYYY-MM-DD')" to "TO_CHAR(A.STARTDATE,'YYYY-MM-DD HH24:MM:SS')" Check out these formats using your sql tool to see how different they look. Steve N. State of Ohio, MIS

xyphos, It is perfectly valid to join non-dimensional, de-normalized, reporting tables in FM. Just be accurate with your join columns between tables. Left-Outer-Join is allowed ( 1..1 ---> 0..n ) Inner (Equi) Join also ( 1..1 ---> 1..n (or 1..1) ) Hopefully, your denormalized tables are...

Drepso, The generated SQL from Report Studio is created prior to actually being submitted to run. Therefore, no runtime error. The project model needs to have all joins between tables created in Framework Manager.....even if you have all of the join where-clause items identified in the...

If possible, you'll have to keep your result sets lower than the 65000 row count. Not much else you can do. Try to aggregate your results if you can. Steve N. State of Ohio, MIS