Creating Ad-Hoc Report at run-time? 
Author Message
 Creating Ad-Hoc Report at run-time?

Hi all.

I have been looking at Crystal Reports within VB.  I know it is not
possible to allow a report to be fully designed by the user at
run-time, but I was wondering if it is possible to make small
modifications to the report design (in code) at run-time.

My problem is that the report I need will be very basic.  The actual
"layout" will not change, however, in my application, the user can
select a database at run-time, and choose up to 10 fields from that
database to report on.  I need to be able to dynamically change the
fields that are reported on.  (BTW, the databases are ODBC-databases
opened in a Jet workspace with DAO)

I am aware of a different product called "ActiveReports" (from Data
Dynamics - http://www.*-*-*.com/ ) which looks very good indeed
(I have the evaluation copy) - However, I would really like to be able
to achieve what I'm after with Crystal Reports (I already have Crystal
Reports Pro v6.0) or even with some other product that wouldn't
require me to invest further cash. (ie. Free! :)

If anyone has ANY information on this subject, or knows of a solution
or "work-around" to my problem, then please let me know.  I would
appreciate it if you could email me as well as posting here.  My email

Many thanks for your time...

-Craig.



Fri, 16 Mar 2001 03:00:00 GMT  
 Creating Ad-Hoc Report at run-time?
Create a template database and transfer your selected data to the template.
fld1, fld2 fld3, fld1Heading, fld2Heading Then report against the Template.
Nick



Quote:
> Hi all.

> I have been looking at Crystal Reports within VB.  I know it is not
> possible to allow a report to be fully designed by the user at
> run-time, but I was wondering if it is possible to make small
> modifications to the report design (in code) at run-time.

> My problem is that the report I need will be very basic.  The actual
> "layout" will not change, however, in my application, the user can
> select a database at run-time, and choose up to 10 fields from that
> database to report on.  I need to be able to dynamically change the
> fields that are reported on.  (BTW, the databases are ODBC-databases
> opened in a Jet workspace with DAO)

> I am aware of a different product called "ActiveReports" (from Data
> Dynamics - http://www.datadynamics.com) which looks very good indeed
> (I have the evaluation copy) - However, I would really like to be able
> to achieve what I'm after with Crystal Reports (I already have Crystal
> Reports Pro v6.0) or even with some other product that wouldn't
> require me to invest further cash. (ie. Free! :)

> If anyone has ANY information on this subject, or knows of a solution
> or "work-around" to my problem, then please let me know.  I would
> appreciate it if you could email me as well as posting here.  My email

> Many thanks for your time...

> -Craig.



Sat, 17 Mar 2001 03:00:00 GMT  
 Creating Ad-Hoc Report at run-time?

A good idea, Nick, if not the most "elegant" solution.  Mark DeFreitas
also suggested this in an email.   The problem is, and I admit I
didn't make this clear in my original post, is that one of these
fields is an OLE-Object (Long Binary) field type (It's used to store a
graphical picture).  As far as I can see, when creating a field
definition (or template), Crystal Reports will not allow you to
designate a field as an OLE-Object field.

Is this correct?   Can another field-type be substituted, but still
work for OLE-Objects?

Thanks in advance, again!

-Craig.


this message.  Thanks)

On 29 Sep 1998 08:56:28 +1000, "Nick Kirlew"

Quote:

>Create a template database and transfer your selected data to the template.
>fld1, fld2 fld3, fld1Heading, fld2Heading Then report against the Template.
>Nick



>> Hi all.

>> I have been looking at Crystal Reports within VB.  I know it is not
>> possible to allow a report to be fully designed by the user at
>> run-time, but I was wondering if it is possible to make small
>> modifications to the report design (in code) at run-time.

>> My problem is that the report I need will be very basic.  The actual
>> "layout" will not change, however, in my application, the user can
>> select a database at run-time, and choose up to 10 fields from that
>> database to report on.  I need to be able to dynamically change the
>> fields that are reported on.  (BTW, the databases are ODBC-databases
>> opened in a Jet workspace with DAO)

>> I am aware of a different product called "ActiveReports" (from Data
>> Dynamics - http://www.datadynamics.com) which looks very good indeed
>> (I have the evaluation copy) - However, I would really like to be able
>> to achieve what I'm after with Crystal Reports (I already have Crystal
>> Reports Pro v6.0) or even with some other product that wouldn't
>> require me to invest further cash. (ie. Free! :)

>> If anyone has ANY information on this subject, or knows of a solution
>> or "work-around" to my problem, then please let me know.  I would
>> appreciate it if you could email me as well as posting here.  My email

>> Many thanks for your time...

>> -Craig.



Sun, 18 Mar 2001 03:00:00 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. Creating Ad-Hoc Report at run-time?

2. Creating Ad-Hoc Report at run-time?

3. Creating Ad Hoc Reports

4. creating reports from ad-hoc queries

5. Ad-Hoc Web Reporting Via Crystal Reports?

6. VB5, Crystal Reports, Ad Hoc Reports

7. Ad Hoc Report Generator

8. Creating controls Ad Hoc

9. Ad hoc reporting?

10. Ad Hoc Reports, Searching Text, Wizards

11. Ad-Hoc Reporting

12. AD HOC reporting?

 

 
Powered by phpBB® Forum Software