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 column referenced,
'[Database View].[ResourceAssignment].[Remaining Start Date]'
is not found in the defined data store.
Double check the data object items.
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
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
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.