OpenDCL Forums

OpenDCL => Studio/Dialog Editor => Topic started by: diogenes on July 11, 2008, 09:56:29 AM

Title: report
Post by: diogenes on July 11, 2008, 09:56:29 AM
   
Let me suggest a feature that I think has no Opendcl. Is it possible to make reports and that can be printed from Opendcl?

Thanks


PD sorry for my English
Title: Re: report
Post by: BazzaCAD on July 11, 2008, 10:04:48 AM
What type of report are you looking for?
The ListView control has a report style.
Or you could write some HTML & view it in the HTML control...
Title: Re: report
Post by: diogenes on July 15, 2008, 01:34:59 AM
Thank you for your reply. I am looking for a way to print lists, reports, etc. as it can make MS Access. The html format is an option but not how to do it.
PD sorry for my English
Title: Re: report
Post by: Fred Tomke on July 16, 2008, 12:00:42 PM
Hello,

then you should use html and create own reports as tables or paragraphs. I don't know if it is possible to add ms access report control as activex control in a opendcl form. Do you know any way to show access reports without opening the database in access?

Fred
Title: Re: report
Post by: Fred Tomke on July 16, 2008, 12:34:59 PM
Hello,

I thought some more minutes about it and I've found out that it could not work directly in any programming language. Why not? A report needs a database management behind because a report consists of many tables and queries. The database management executes the queries and evaluates table relations. What you can do is the following: use adodb-connection-object to get access to the mdb. Design a xsd or a xml-file (I suggest you using css-files for styles) with the structure needed for the report. When creating a report the cells of the xml/xsd-file are filled and the resulting html-file can be shown in an opendcl-form using a html file. Don't forget a javascript-print()-Method button for printing.  ;)

Please, take it seriously, when I say: it's very easy and simple at least - but it's a lot sourcecode to write.

I designed some reports from some ms access databases as html files. So that's why I know that it work this way. There was an example of mine in the show and tell section of this forum. There was shown an example of a report generated automatically at runtime.

Fred
Title: Re: report
Post by: diogenes on July 17, 2008, 01:54:33 AM
   
Thanks for your interest and explanations.

I look for at the section of the forum, but I have not found the example you say. Could you hanging again?

thanks
Title: Re: report
Post by: BazzaCAD on July 17, 2008, 05:20:28 PM
Hi diogenes,
I created a simple example project that dynamically creates a HTML file & displays it in the control.
Check it out here: http://www.opendcl.com/forum/index.php?topic=380.0 (http://www.opendcl.com/forum/index.php?topic=380.0)
Most of the HTML is hard coded, but I'm sure you'll be able to rework it to get what you're looking for.

Hope this helps,
Barry
Title: Re: report
Post by: Fred Tomke on July 18, 2008, 12:32:20 AM
Thanks Barry!

Fred
Title: Re: report
Post by: diogenes on July 18, 2008, 02:08:38 AM
Thank you to all for the help.

that's we were looking for


diogenes
Title: Re: report
Post by: BazzaCAD on July 18, 2008, 09:46:11 AM
Cool, I'm glad it helped.