printing all fields

rbuser

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

nicocizik

Hi Edilson,

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.

--