Ad hoc query/query builder 
Author Message
 Ad hoc query/query builder

HI,
        I am using VB 6.0 enterprise edtion with Access as back end.
I want to create wizard/interface to user so that user can create
"ad hoc" report or some kind of "query builder". Does Crystal Report
allow these ? I like to give my user capability to create their own
reports.

I would really appriceate if somebody can answer this.

Thanks for help in advance.

  vcard.vcf
< 1K Download


Fri, 20 Apr 2001 03:00:00 GMT  
 Ad hoc query/query builder
No.
However, you may want to look into the concept of report templates.
Then through code adjust the templates, set data, etc.
Quote:

>HI,
> I am using VB 6.0 enterprise edtion with Access as back end.
>I want to create wizard/interface to user so that user can create
>"ad hoc" report or some kind of "query builder". Does crystal report
>allow these ? I like to give my user capability to create their own
>reports.

>I would really appriceate if somebody can answer this.

>Thanks for help in advance.



Fri, 20 Apr 2001 03:00:00 GMT  
 Ad hoc query/query builder
No, and this is the one thing that is keeping Cryatal Reports from becoming
a huge success in software development.  Everyone wants this!  Seagate...
get a clue!


Fri, 20 Apr 2001 03:00:00 GMT  
 Ad hoc query/query builder
I'm not sure that it does everything you might want, but Crystal/Info has a
tool called 'info views'. This allows an administrator to create user-friendly
views of data with all joins etc hidden away so that an end user can just pick
the data up and put it on a report.

If you use template reports with nice formatting in conjunction with these then
you can get a fairly user friendly environment which allows reasonably
competent people to get what they want. I guess it's a question of degrees - if
things are too structured for users then they end up loosing the flexibility
that they want (especially as they get used to using the tool). In my
experience, if a user if doesn't fancy doing ad-hoc reports because it's 'too
complicated' then it's almost impossible to make anything simple enough for
them to use !

(though having said all this, Seagate could certainly make this whole area work
better).

dt.

Quote:

> No, and this is the one thing that is keeping Cryatal Reports from becoming
> a huge success in software development.  Everyone wants this!  Seagate...
> get a clue!



Sat, 21 Apr 2001 03:00:00 GMT  
 Ad hoc query/query builder
CR has a data dictionary with some nice features. I think it may have
changed names though.
The problem with custom reporting is controlling the processing involved.
Intelligent users may understand this, its the inexperienced or stubborn
ones that don't.  Too many of them and you could see your system drag...

You may want to look into OLAP tools, like COGNOS, Platinum Forest & Trees,
Business Objects, DataDynamics, Seagate's Holos, etc. Just get ready to pay,
maybe not DataDynamics as much or Seagate's Worksheet.

I hope you liked Rubik's Cube.

Quote:

>I'm not sure that it does everything you might want, but Crystal/Info has a
>tool called 'info views'. This allows an administrator to create
user-friendly
>views of data with all joins etc hidden away so that an end user can just
pick
>the data up and put it on a report.

>If you use template reports with nice formatting in conjunction with these
then
>you can get a fairly user friendly environment which allows reasonably
>competent people to get what they want. I guess it's a question of
degrees - if
>things are too structured for users then they end up loosing the
flexibility
>that they want (especially as they get used to using the tool). In my
>experience, if a user if doesn't fancy doing ad-hoc reports because it's
'too
>complicated' then it's almost impossible to make anything simple enough for
>them to use !

>(though having said all this, Seagate could certainly make this whole area
work
>better).

>dt.


>> No, and this is the one thing that is keeping Cryatal Reports from
becoming
>> a huge success in software development.  Everyone wants this!  Seagate...
>> get a clue!



Sat, 21 Apr 2001 03:00:00 GMT  
 
 [ 5 post ] 

 Relevant Pages 

1. ad-hoc query builder/report writer

2. display ad hoc query results

3. Ad-hoc Query Toolkit

4. ad-hoc query building component.

5. creating reports from ad-hoc queries

6. ad-hoc query building component.

7. How do you build an ad-hoc query?????

8. Designing COM database objects to handle ad-hoc queries

9. Query Builder or SQL Builder

10. how can I build 2 queries in 1 query(VB SQL query)

11. Ad Hoc Report Generator

12. ActiveReports, adding page to ad hoc rpt

 

 
Powered by phpBB® Forum Software