If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
dynamic report
Can I create a report dynamically during runtime? If so, how? Thanks.
|
#2
|
|||
|
|||
dynamic report
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. |
#3
|
|||
|
|||
dynamic report
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. |
#4
|
|||
|
|||
dynamic report
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] |
#5
|
|||
|
|||
dynamic report
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] |
#6
|
|||
|
|||
dynamic report
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. |
#7
|
|||
|
|||
dynamic report
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. |
#8
|
|||
|
|||
dynamic report
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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Parameter thru Form Dialog Box for REPORT | Sandy | Setting Up & Running Reports | 16 | January 10th, 2006 10:06 AM |
Has anyone seen this behaviour? What might it be? | tw | General Discussion | 4 | June 30th, 2005 03:23 PM |
To Sharkbyte and all: Calculate a total values in group level | Ally | General Discussion | 6 | June 13th, 2005 08:16 PM |
Save Report With CreateReport Coding Issue | Jeff Conrad | Setting Up & Running Reports | 8 | July 12th, 2004 08:39 AM |
Label | SRIT | General Discussion | 2 | June 22nd, 2004 09:42 PM |