Report Filter 1

[kellog1]

Hello Everyone,
I am looking for some help in getting the right query creating this report. Here is my scenario….

I have 2 tables class and student name

Student A enrolled in History, Economics and Gym Class
Student B enrolled in History, Gym and Aerobics class

The report should like something like this…

Gym Class Aerobics Class
History class 2 1

Economics 1 0

Please help me figure out.

Thanks in Advance

PS

 

[rtveen]

2 items of class:
exciting classes: if ([class] in ('Gym Class'; 'Aerobics Class') then ([class]) else null
dull classes: if ([class] in ('History class'; 'Economics') then ([class]) else null
an item named NoS (number of Students). The formula (hang on, it's tough): 1

Good luck!

 

[chinnaseenu]

Hey I just got an idea I don’t know wether it works or not


I assumed say 4 classes class xx,yy,zz,mm and 4 students A, B,C,D

The data you have is
Calss student
xx A
xx C
yy A
yy D
zz C
mm B


You want is
yy mm
xx 1 0
zz 0 0

IF this is the scenario

In the query create 2 data items(item_yy,item_mm)


Item_yy-expression: check that particular student is in the list of Class yy ‘s Students list(if he’s present value is 1 else 0)

Item_mm-expression: check that particular student is in the list of Class mm ‘s Students list(if he’s present value is 1 else 0)

Class Student Item_yy Item_mm
xx A 1 0
xx C 0 0
zz C 0 0

Now do summary by grouping on ‘class’
Now make it cross tab at summary level

class Item_yy Item-mm
xx 1 0
zz 0 0


I also never did any thing like this ,just the idea I got.
Let me know if it works.