dynamic report

Can I create a report dynamically during runtime? If so, how? Thanks.

You can use code like CreateReport and CreateReportControl. However this is
not an easy task. I haven't seen any experienced Access developer create
reports on-the-fly. There are a number of good querying tools that might
meet your needs. However, we don't really know what your needs are.

--
Duane Hookom
MS Access MVP


"00KobeBrian" wrote in message
...
Can I create a report dynamically during runtime? If so, how? Thanks.

Dear Kobe:

What about the report do you want to have dynamic? The query? Which
columns appear? Dynamically adjusting all column widths and the font to the
data (my favorite!)

Need to know a lot more to even begin to imagine how to answer.

Tom Ellison


"00KobeBrian" wrote in message
...
Can I create a report dynamically during runtime? If so, how? Thanks.

00KobeBrian wrote:

Can I create a report dynamically during runtime? If so, how? Thanks.


Yes, it's possible (see the CreateReport and CreateControl
functions in Help), but it's a major pain and to be avoided
if there is any conceivable way to use an existing report.

Note that creating heavy duty objects at runtime is a major
source of bloat and dramatically increases the chance of
corruption.\\Also note that those two functions are
unavailable if you try to generate an MDE.

--
Marsh
MVP [MS Access]

Thanks, Guys. I will try out with the CreateReport and CreateControl. Is
there any website which got a prototype I can take as reference? Thanks.


"Marshall Barton" wrote in message
...
00KobeBrian wrote:

Can I create a report dynamically during runtime? If so, how? Thanks.


Yes, it's possible (see the CreateReport and CreateControl
functions in Help), but it's a major pain and to be avoided
if there is any conceivable way to use an existing report.

Note that creating heavy duty objects at runtime is a major
source of bloat and dramatically increases the chance of
corruption.\\Also note that those two functions are
unavailable if you try to generate an MDE.

--
Marsh
MVP [MS Access]

I have never seen a web site with that kind of example.
Probably because it is the worst way to deal with 99.99% of
the situations where, at first glance, it seems like a way
to do something. As far as I know, the only justifiable
reason for creating a report dynamically is the Access
report wizard.
--
Marsh
MVP [MS Access]


00KobeBrian wrote:
Thanks, Guys. I will try out with the CreateReport and CreateControl. Is
there any website which got a prototype I can take as reference? Thanks.


00KobeBrian wrote:
Can I create a report dynamically during runtime? If so, how? Thanks.


"Marshall Barton" wrote
Yes, it's possible (see the CreateReport and CreateControl
functions in Help), but it's a major pain and to be avoided
if there is any conceivable way to use an existing report.

Note that creating heavy duty objects at runtime is a major
source of bloat and dramatically increases the chance of
corruption.\\Also note that those two functions are
unavailable if you try to generate an MDE.

agreed!

Normally if someone comes to a public news group with a question like this,
they aren't ready to begin create the solution. I think Tom Ellison has
posted some ideas recently in this news group.

--
Duane Hookom
MS Access MVP


"Marshall Barton" wrote in message
...
I have never seen a web site with that kind of example.
Probably because it is the worst way to deal with 99.99% of
the situations where, at first glance, it seems like a way
to do something. As far as I know, the only justifiable
reason for creating a report dynamically is the Access
report wizard.
--
Marsh
MVP [MS Access]


00KobeBrian wrote:
Thanks, Guys. I will try out with the CreateReport and CreateControl. Is
there any website which got a prototype I can take as reference? Thanks.


00KobeBrian wrote:
Can I create a report dynamically during runtime? If so, how? Thanks.


"Marshall Barton" wrote
Yes, it's possible (see the CreateReport and CreateControl
functions in Help), but it's a major pain and to be avoided
if there is any conceivable way to use an existing report.

Note that creating heavy duty objects at runtime is a major
source of bloat and dramatically increases the chance of
corruption.\\Also note that those two functions are
unavailable if you try to generate an MDE.

Ohhh ouch, that hurts Duane!
:-)

The add-in I did for Doug creates the object report completely
in code and saves it in the user's current database for future use:

http://www.accessmvp.com/djsteele/Documentor.html

--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conrad...essjunkie.html
http://www.access.qbuilt.com/html/articles.html

"Duane Hookom" wrote in message:
...

You can use code like CreateReport and CreateReportControl. However this is not an easy task. I
haven't seen any experienced Access developer create reports on-the-fly. There are a number of
good querying tools that might meet your needs. However, we don't really know what your needs are.