Help with this linking problem

[fsreport]

Hello All
cr 9.0
MS SQL
i have this report and has one group
gr1 uni_user.uu_ref

my table are
calshed.tbl and uni_user.tbl
link
calshed.schfor = uni_user.user_id
*****************************************
and my running total are like this
Field to summarize: Calshed.schtype
Type of summary: count
Evaluate: formula
{CALSCHED.SCHTYPE} = "O" and
{UNI_USER.UU_WRK} = "00017"
Reset: on change of group uni_user.uu.ref
*************************
all is fine for the first part of my report.

the 2 part this is where it get tricky
now there asking to add extra link to the table

here is what there asking for

calshed table and uni_user table same as above
my first part of the report is link to calshed.schfor but
now i need to be able to do this
********************
calshed.schfor = uni_user.user_id
calshed.schby = uni_user.user_id

this is where i'm stuck

if i link my first part of my report

to match what need for my second part
calshed.schfor = uni_user_id
calshed.schby = uni_user_id
it mess all my records
how can i resolve this part?

Thank you




fsreport

 

[fsreport]

hi All
I try creating a command with these value
(select c.schstatus, c.schstart, c.schend, c.schtype, c.schby, c.schfor,uu.channel,uu.uu_ref,uu.uu_wrk

from calsched c, uni_user uu

where c.schby = uu.uni_user and uu.uu_wrk = '00017'

union

select c.schstatus, c.schstart, c.schend, c.schtype, c.schby, c.schfor,uu.channel,uu.uu_ref,uu.uu_wrk

from calsched c, uni_user uu

where c.schfor = uu.uni_user and uu.uu_wrk in ('00013'))


Not sure if it's fine



fsreport