| group by data block [message #234717] |
Thu, 03 May 2007 00:50  |
zshanalig1
Messages: 4
Registered: March 2007
Location: pakistan
|
Junior Member |
|
|
AS SALAM O ALAIKUM!
HOW ARE U?
WELL I WANT TO SET THE DATA BLOCK GROUP BY CLAUSE SO HOW CAN I DO THAT IN FORM 6I PLZ REPLY ME AS SOON AS POSSIBLE
THANX
ZEESHAN HUSSAIN
|
|
|
|
| Re: group by data block [message #234780 is a reply to message #234717] |
Thu, 03 May 2007 02:43  |
sameer_am2002
Messages: 129
Registered: September 2002
|
Senior Member |
|
|
Create a block manually
Set Query Data Source Type to From Clause Query
In Query Data Source Name write your SQL statement . in my case it is (SELECT DEPTNO , SUM(SAL) SAL FROM EMP GROUP BY DEPTNO)
Create two items Deptno - Database Item with Column Name Deptno, Sal - Database Item with Column name Sal and set deptno as primary key. Run the form and execute query. Hope this is what your requirement.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
