Console app with Report Builder
I have a small ppSMTP auto mailer that goes out twice a day. It sends two
PDF's. It runs silently and seems to function reasonbly well though for
unknown reasons, has failed to run sometimes.
I was advised to re-design it as a console app. I have never written a
report as a console app before though I do know I can find much of the
parameters required by studying the DFM of my current app.
Is this a practical approach? I have a single series dbTee-chart on one
report and the other is an expanded drill down. I also have our and my
customers company logo.
Will I gain much in performance? The queries are very involved (Frequency
distribution for ~260,000 records). I already run with SHowMain set to
false.
Thanks
PDF's. It runs silently and seems to function reasonbly well though for
unknown reasons, has failed to run sometimes.
I was advised to re-design it as a console app. I have never written a
report as a console app before though I do know I can find much of the
parameters required by studying the DFM of my current app.
Is this a practical approach? I have a single series dbTee-chart on one
report and the other is an expanded drill down. I also have our and my
customers company logo.
Will I gain much in performance? The queries are very involved (Frequency
distribution for ~260,000 records). I already run with SHowMain set to
false.
Thanks
This discussion has been closed.
Comments
I'm not sure about how much performance gain your will receive simply by
moving to a console app. Since your current app runs silently you are
already gaining the advantage of running without any UI code. My suggestion
would be to give it a try and see how it goes. It should not be very
difficult to convert your app especially if you are loading templates which
will set up the report properties when they are loaded.
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com