-
as seen on Oracle Blogs
- Search for 'Oracle Blogs'
A while back I spoke about having to go back to BIP's original crosstabbing solution to achieve a certain layout. Hok Min has provided a 'man' page for the new crosstab/pivot builder for 10.1.3.4.1 users. This will make the documentation drop but for now, get it here!
The old, hand method is still…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
How to access crosstab formula field in another column? I have report like with Dues & total both formula fields:
Amount Dues(Done by a Formula) Total (Done by a Formula)
------ ------------------------- ---------------------------
500 20 % someAmount
Formula…
>>> More
-
as seen on Internet.com
- Search for 'Internet.com'
Rob Gravelle takes a complex SQL statement and shows you several ways to re-write it that both simplifies and shortens it, while still yielding the same results.
>>> More
-
as seen on Internet.com
- Search for 'Internet.com'
Most relational databases don't provide an easy way to create crosstabs. Rob Gravelle shows you one of several ways to create crosstabs using regular SQL.
>>> More
-
as seen on Internet.com
- Search for 'Internet.com'
MySQL's crosstabs contain aggregate functions on two or more fields, presented in a tabular format. In a multi-aggregate crosstab query, two different functions can be applied to the same field or the same function can be applied to multiple fields on the same (row or column) axis. Rob Gravelle shows…
>>> More