printing all fields
Hi,
I have a table with up to 20 fields, i said "up" because each customer
has a different table - made for himself. So i need to build a report that
fit all my customers needs. My report should display all fields of this
particular table, but i remember that each customer has a different table
structure. Here is the results i wish for.
"Total" can be calculated by SQL if needed.
CustomerA:
----------------------------------------------------------------
ECF MainValue T1 T2 T3 T4 Total
----------------------------------------------------------------
001 500 10,00 12,36 2,23 0,00 24,59
002 100 21,00 12,58 2,00 0,60 36,18
----------------------------------------------------------------
31,00 24,94 4,23 0,60
60,77
CustomerB:
-----------------------------------------------------------------------
ECF MainValue T1 T2 T3 T4 T5
Total
-----------------------------------------------------------------------
001 500 10,00 12,36 2,23 0,00 12,36
36,95
002 100 21,00 12,58 2,00 0,60 12,85
49,03
-----------------------------------------------------------------------
31,00 24,94 4,23 0,60 25,21
85,98
--
I hope somebody can help me.
--
Edilson Vasconcelos de Melo Junior
dirso@jrsoftwares.com.br
www.jrsoftwares.com.br
Diretor de Projetos
Tel.: +55 (19) 3243-4403
Cel.: +55 (19) 9111-9345
I have a table with up to 20 fields, i said "up" because each customer
has a different table - made for himself. So i need to build a report that
fit all my customers needs. My report should display all fields of this
particular table, but i remember that each customer has a different table
structure. Here is the results i wish for.
"Total" can be calculated by SQL if needed.
CustomerA:
----------------------------------------------------------------
ECF MainValue T1 T2 T3 T4 Total
----------------------------------------------------------------
001 500 10,00 12,36 2,23 0,00 24,59
002 100 21,00 12,58 2,00 0,60 36,18
----------------------------------------------------------------
31,00 24,94 4,23 0,60
60,77
CustomerB:
-----------------------------------------------------------------------
ECF MainValue T1 T2 T3 T4 T5
Total
-----------------------------------------------------------------------
001 500 10,00 12,36 2,23 0,00 12,36
36,95
002 100 21,00 12,58 2,00 0,60 12,85
49,03
-----------------------------------------------------------------------
31,00 24,94 4,23 0,60 25,21
85,98
--
I hope somebody can help me.
--
Edilson Vasconcelos de Melo Junior
dirso@jrsoftwares.com.br
www.jrsoftwares.com.br
Diretor de Projetos
Tel.: +55 (19) 3243-4403
Cel.: +55 (19) 9111-9345
This discussion has been closed.
Comments
I would recommend checking out the AutoSearch capabilities of ReportBuilder.
This allow you to filter a dataset during the print process so you won't
have to include different datasets for each customer. You can also set up
AutoSearch criteria that your customers will never see and have no control
over. See the AutoSearch demos located in the \RBuilder\Demos\5.
AutoSearch\... directory.
--
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com