Need Help in Impromptu???

[anumala28]

Hi,

Here i am explaining Functionality of First Access Query,

If you write a query in Ms-Access:

Select First(empno),deptno from emp
group by deptno;

it will returns output:

Only First record by Group.

Ex data:

empNo DeptNo
1 10
2 10
3 20
4 30
5 30


Out put is :

1 10
3 10
4 30

Same like out put i need in Impromptu Reports....

please givey any solution ASAP....
Thnaks,
Sri

 

[CognosProfessional]

Did you make any groupings in the Query dialog box? You might want to try different settings in the Group tab with your deptno. Are your joins correct? Catalog, Joins.

CP

 

[anumala28]

Sorry, the out put is

1 10
2 20
4 30


In impromptu Joins, Groups are correct..

but the problem is when group on deptno i will get entire records on that group, but i need out put is firs record on that group. I think you understand my problem.


Please help out....

 

[CognosProfessional]

Can you move the Deptno to the top of the list on the Group tab and group that one first then group on empno to get correct results?

Check each association of each data item after grouping.



CP

 

[nagrajm]

In the "Summary Filter" section use the following syntax

running-count ( empNo ) = 1 (since your report is grouped on deptNo)

or

running-count ( empNo ) for deptNo = 1 (if the report is not grouped)

That should solve your problem. If that doesn't, you know where I am going. Play around with those summary functions.

Nagraj

 

[anumala28]

If we use running count it will gives only first group records only.... I think association will work....
Thanks,