Home > Archive > Clarion > May 2004 > I will be replacing the view engine in my reports discussion welcome
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
I will be replacing the view engine in my reports discussion welcome
|
|
| john nairn 2004-05-04, 11:34 am |
| HI,
My customers have large sql databases. The view engine in Clarion
reports seems to be too slow and limited because :-
- I can not specify group criteria in the view,
- It always returns all data in the view even if some report layouts
do not need all the data,
- The view sql structure can be changed but in very limited manner,
- The view structure has to contain all tables that exist in the
dictionary. At runtime I need to report on many tables outside the
dictionary.
At the moment I wrote my own report generator and designer using
clarion interface objects to return the results from sql queries. Then
loop through the results and pump the data out to excel. This allows
any query from any number of tables to be defined as part of the
report design. Ie each design has a layout and a view.
It works well but I need to expand it or something like it to work
with normal clarion reports and other report designers.
Has anyone done anything similar or have any comments on approaching
this problem.
| |
| Leonid Chudakov 2004-05-04, 11:34 am |
| Hi John,
Try Crystal Reports.
--
--
Leonid Chudakov
chudakov@klarisoft.com
Cool tools and Clarion examples at
http://www.klarisoft.com
"john nairn" <john@readysell.com.au> wrote in message
news:f2c55eef.0405031642.5fd9c529@posting.google.com...
> HI,
>
> My customers have large sql databases. The view engine in Clarion
> reports seems to be too slow and limited because :-
> - I can not specify group criteria in the view,
> - It always returns all data in the view even if some report layouts
> do not need all the data,
> - The view sql structure can be changed but in very limited manner,
> - The view structure has to contain all tables that exist in the
> dictionary. At runtime I need to report on many tables outside the
> dictionary.
>
> At the moment I wrote my own report generator and designer using
> clarion interface objects to return the results from sql queries. Then
> loop through the results and pump the data out to excel. This allows
> any query from any number of tables to be defined as part of the
> report design. Ie each design has a layout and a view.
>
> It works well but I need to expand it or something like it to work
> with normal clarion reports and other report designers.
>
> Has anyone done anything similar or have any comments on approaching
> this problem.
|
|
|
|
|