join and result header

View: New views
2 Messages — Rating Filter:   Alert me  

join and result header

by Marco-57 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hello to all,

I implemented the join in this way:

"RESULT_FIELDS" "Via,label,RESPNOME"
"RESULT_HEADERS" "Via,Etichetta,Responsabile"
"RESULT_JOIN" "odbc://'':''/localhost@protc||PC_RESPONSABILE@IDRESP
@1@RESPNOME||IDRESP||0"

and it works well.
The problem is the header that not appears for the fields of the union (in
this case RESPNOME from table PC_RESPONSABILE).

The result is:

Via   |  Etichetta  |  Responsabile |
------------------------------------------------------------
via1  |  etichetta1 |                       |  respnome1
via2  |  etichetta2 |                       |  respnome2

What's wrong?

thanks
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
pmapper-users mailing list
pmapper-users@...
https://lists.sourceforge.net/lists/listinfo/pmapper-users

Re: join and result header

by Marco-57 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Ok, I resolved in this way:

"RESULT_FIELDS" "Via,label"
"RESULT_HEADERS" "Via,Etichetta,Responsabile"
"RESULT_JOIN" "odbc://'':''/localhost@protc||PC_RESPONSABILE@IDRESP
@1@RESPNOME||IDRESP||0"

On RESULT_FIELDS I deleted RESPNOME

Il 10/11/09 17.22, Marco ha scritto:

> Hello to all,
>
> I implemented the join in this way:
>
> "RESULT_FIELDS" "Via,label,RESPNOME"
> "RESULT_HEADERS" "Via,Etichetta,Responsabile"
> "RESULT_JOIN" "odbc://'':''/localhost@protc||PC_RESPONSABILE@IDRESP
> @1@RESPNOME||IDRESP||0"
>
> and it works well.
> The problem is the header that not appears for the fields of the union (in
> this case RESPNOME from table PC_RESPONSABILE).
>
> The result is:
>
> Via   |  Etichetta  |  Responsabile |
> ------------------------------------------------------------
> via1  |  etichetta1 |                       |  respnome1
> via2  |  etichetta2 |                       |  respnome2
>
> What's wrong?
>
> thanks
> ------------------------------------------------------------------------------
> Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
> trial. Simplify your report design, integration and deployment - and focus on
> what you do best, core application coding. Discover what's new with
> Crystal Reports now.  http://p.sf.net/sfu/bobj-july
> _______________________________________________
> pmapper-users mailing list
> pmapper-users@...
> https://lists.sourceforge.net/lists/listinfo/pmapper-users
>
>

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
pmapper-users mailing list
pmapper-users@...
https://lists.sourceforge.net/lists/listinfo/pmapper-users