dynamic report

  • Thread starter Thread starter 00KobeBrian
  • Start date Start date
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.
 
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 said:
Can I create a report dynamically during runtime? If so, how? Thanks.
Click to expand...


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.
 
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.
 
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.
 
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 said:
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]

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.
Click to expand...
Click to expand...
 
Back
Top