report problem [message #589230] |
Wed, 03 July 2013 09:48 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/5738132065e1f6f280b73f17ee569063?s=64&d=mm&r=g) |
reallyoldturtle
Messages: 15 Registered: June 2013
|
Junior Member |
|
|
Hi!
I have a payment table that has the ids of cds that has being sold in the past month. From there I want to make a demand wise report. I am aware of the report wizard in the oracle forms but I dont want to use it. Any tips? Here are the tables in a bit more details.
payment: id_cd, price, dateofsell
cd_details: id_cd, name, price, language.
|
|
|
|
|
Re: report problem [message #589233 is a reply to message #589232] |
Wed, 03 July 2013 10:04 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
One option is to create a view (which would join two tables you mentioned) and display data in a manner you are interested in. Then, in a form, you'd create a (data) block based on that view. Another, control block, would be used for a list of "demands"; for example, sort by number of sold copies, sort by prices ascending/descending, etc. You'd use radio buttons to do that. Based on a selection, using SET_BLOCK_PROPERTY, you'd set datablock's ORDER BY property and, finally, execute query.
|
|
|
|
|
Re: report problem [message #589239 is a reply to message #589234] |
Wed, 03 July 2013 10:35 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
cookiemonster
Messages: 13937 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
As littlefoot already said - create a view.
count(id_cd) will be one of the columns of the view.
Then you can just set the order by property of the block.
|
|
|