Create a Report with Report Builder.

Posted by rogeliolt on 13-Feb-2012 10:48

Hello My friends... I have a pair of question...

I'm create a Reprot from a Window, I know, I need create a filter with the information, just like a "FOR EACH".

My sintaxs is...

  "p-filter = "servs where servs.fol >=" string(number_fol)

                        + " and servs.fol <=" string (number_fol)

                        + " and (servs.empl[1] = " string(number_employ)

                        + "   or  servs.empl[2] =  "string(number_employ) + ")".

This sinaxis, work fine, because a run my app and show me informtation, but I need make an inner join in this filter, example:


"p-filter = "servs where servs.fol >=" string(number_fol)

                        + " and servs.fol <=" string (number_fol)

                        + " and (servs.empl[1] = " string(number_employ)

                        + "   or  servs.empl[2] =  "string(number_employ) + "),"

                 + " each rut where rud.cod = " string(servs.cod).

first question:

    this is posible??'??...

Second Question:

   is rigth the sintaxis????...

Can you help me, please...

All Replies

This thread is closed