| Author |
how to make reports ?? |
kasper
Member
Posts: 219
Location: Tennessee, USA
Joined: 16.01.06 |
| Posted on 16-01-2006 23:35 |
|
|
hi all ,
i want to know how to make reports with Limnor ??
i have finished my queries and almost everything in my program , except the reports !!!
i hope that making reports with limnor be easy, like making microsoft access reports |
|
| Author |
RE: how to make reports ?? |
yw
Administrator
Posts: 670
Location: ***
Joined: 23.06.05 |
| Posted on 17-01-2006 01:45 |
|
|
|
There are requests for Limnor to have report-making features. We are still doing research on what features to implement. On the market there are lots of report makers. For example, http://www.logixml.com, Crystal Reports, etc. |
|
| Author |
RE: how to make reports ?? |
kasper
Member
Posts: 219
Location: Tennessee, USA
Joined: 16.01.06 |
| Posted on 17-01-2006 09:04 |
|
|
there are lots of report makers , but how can i work with it from Limnor ??
Crystal Reports , for example, supports microsoft VB & C# . how can i make Crystal Reports support Limnor ?? |
|
| Author |
RE: how to make reports ?? |
yw
Administrator
Posts: 670
Location: ***
Joined: 23.06.05 |
| Posted on 17-01-2006 11:32 |
|
|
Most report makers are not programming systems. They do not need a programming system to work. They work directly over databases.
The most important features of report makers includes:
1. Visual page design. The difference between a report page design and a programming page design is that a report page is a print page. There should not be scrollbars because once printed out on a page, you cannot scroll to view hidden data.
2. Report delivery formats. Some report maker may deliver reports in PDF, HTML, XML, and other file formats.
3. Scheduling of report. Some report maker may allow the user to schedule a report to automatically generate the same report periodically.
What are the report features you needed? |
|
| Author |
RE: how to make reports ?? |
kasper
Member
Posts: 219
Location: Tennessee, USA
Joined: 16.01.06 |
| Posted on 17-01-2006 12:38 |
|
|
i am making a program to do some calculations and queries , i want the end-user to be able to print these calculations on paper. So i need to make reports in my program.
But , before he print these reports , the user must be able to make prin preview.
i need to make a report like that found in Microsoft access.
i want the user to open these reports from my program.
i hope that the user dont need any any program ,or exe file, except that found in my exe prgram made by Limnor.
So , in summary, i need to make reports that can be viewed from my program. |
|
| Author |
RE: how to make reports ?? |
yw
Administrator
Posts: 670
Location: ***
Joined: 23.06.05 |
| Posted on 17-01-2006 14:16 |
|
|
I see your reporting requirements are typical. We are adding these features.
For now, if you have Microsoft Office 2003, you may use the Word11a Performer to make a report. Basically, you create a DOC file with tables and fields in it. Load the DOC file into the performer by setting its Filename property. Inside your application, you may sustitute the fields with data from databases and fill tables with data from databases. Since it is a DOC file, you can freely format it.
See http://www.limnor.com/downloads/Lesson9.pdf. There is a section describing how to merge data from databases into a WORD doc file |
|
| Author |
RE: how to make reports ?? |
kasper
Member
Posts: 219
Location: Tennessee, USA
Joined: 16.01.06 |
| Posted on 17-01-2006 16:14 |
|
|
I tried "word11a Performer" , but still didnt get what i need.
I need , for example , to print all the orders of a company at once.
it is about 3,000 orders and the user cant press the print button 3000 times to print these orders.
i think "word11a Performer" cant make these orders in one mocrosoft file.
So, i think , the only solution is to find a program like "Crystal Reports" which can work with Limnor perfectly !!
 |
|
| Author |
RE: how to make reports ?? |
kasper
Member
Posts: 219
Location: Tennessee, USA
Joined: 16.01.06 |
| Posted on 17-01-2006 17:12 |
|
|
|
In summary , i want to create reports and integrate them into my application. |
|
| Author |
RE: how to make reports ?? |
yw
Administrator
Posts: 670
Location: ***
Joined: 23.06.05 |
| Posted on 17-01-2006 18:48 |
|
|
|
See section "9.17.3. Copy data to tables" in http://www.limnor.com/downloads/Lesson9.doc. It gives an example of copying a DataTable to a table in a Word document. That is exactly what you want to do. Suppose you have a DataTable containing 3,000 orders, it will copy all 3,000 orders (rows) to the table in your Word document. So your Word document will contain a table with 3,000 rows. |
|
| Author |
RE: how to make reports ?? |
kasper
Member
Posts: 219
Location: Tennessee, USA
Joined: 16.01.06 |
| Posted on 17-01-2006 19:32 |
|
|
i have read the Lessons many times before i send my first Thread , but didnt find what i want.
i want to print each order on a separate page , so each company can take its order page.
Hence , i need to print 3,000 pages with " one button press & one print job ".
You may imagine this like :
i have a table with students names , math grades , science grades
and i want to print a page for each student that have his name and grades.
This is also like :
i want to print one access form on 3,000 pages , but each page have different data - which is records data-.
|
|
| Author |
RE: how to make reports ?? |
yw
Administrator
Posts: 670
Location: ***
Joined: 23.06.05 |
| Posted on 18-01-2006 00:50 |
|
|
Sorry, I misunderstood your reporting format.
In your case, things become easier because your Limnor page can be the report page. You do not have scrolling problem.
You may design a page using Labels, Text Boxes, Picture Boxes, Chart, etc., to design the report layout.
Section 9.9 in http://www.limnor.com/downloads/Lesson9.doc described it. Its title. Data Input Design, is misleading. The technic it described, data-binding, is not just for data input. It can be used for data viewing record by record, as well. Exactly just as what you want.
Here you may design a page exectly the size of a print page (A4 for example).
If you want to print 3,000 pages, you do not need to let the user click a print button 3,000 times. DataTable performer has a method "BatchExecute" which will execute an action or action list on every record.
Suppose you use the page's Print method to create an action to print the page, let's name the action PageReport.Print. You may want to use True for the parameter ClientOnly because you do not want to print the page border (or maybe you want. Anyway, you can try different parameters of the Print method).
Now you may create an action using the DataTable's "BatchExecute" method. Let's call this action DataTable1.BatchExecute.PrintAllReport. When you create this action, you need to give it an action or action list as a parameter. You use the action PageReport.Print for this parameter. So, executing DataTable1.BatchExecute.PrintAllReport will execute PageReport.Print 3,000 times, each for one record.
Suppose you assign DataTable1.BatchExecute.PrintAllReport to the Click event of a button, then one click of this button will print all 3,000 orders, each on one page. |
|
| Author |
RE: how to make reports ?? |
kasper
Member
Posts: 219
Location: Tennessee, USA
Joined: 16.01.06 |
| Posted on 18-01-2006 01:46 |
|
|
i am really grateful for your help
Still a point !!
when i use the "Print" method , i set its "DefultPrinter" property to "False".
This is to be able to :
1 - select a printer and
2- select print properties , like print quality.
when i run my program , it asks me 3,000 times to select the "printer" (and "printer properties" if i want too)
So, what could i do to make this 3,000 press ----> a one press
|
|
| Author |
RE: how to make reports ?? |
yw
Administrator
Posts: 670
Location: ***
Joined: 23.06.05 |
| Posted on 18-01-2006 03:32 |
|
|
The DefultPrinter should be True. That means we need to set the default printer. I'll do some search...
Edited by yw on 19-01-2006 12:52 |
|
| Author |
RE: how to make reports ?? |
kasper
Member
Posts: 219
Location: Tennessee, USA
Joined: 16.01.06 |
| Posted on 18-01-2006 04:05 |
|
|
Ok, thank you.
i really want to thank you very much
And i hope that Limnor has a visual reporting feathuer like crytall reports or microsoft access.
i am waiting your reply for my problem (printing) very sooon !! |
|
| Author |
RE: how to make reports ?? |
yw
Administrator
Posts: 670
Location: ***
Joined: 23.06.05 |
| Posted on 18-01-2006 12:36 |
|
|
It was my pleasure 
The printing problem is easy to solve: we need an action to show a list of available printers and let the user to select one as the default printer. I'll post the solution here. |
|
| Author |
RE: how to make reports ?? |
kasper
Member
Posts: 219
Location: Tennessee, USA
Joined: 16.01.06 |
| Posted on 18-01-2006 14:38 |
|
|
It was my pleasure too
i am waiting your actoin very soon
|
|
| Author |
RE: how to make reports ?? |
kasper
Member
Posts: 219
Location: Tennessee, USA
Joined: 16.01.06 |
| Posted on 19-01-2006 00:39 |
|
|
Beside selecting the default printer , i wish to be able to select the printer properties.
Thank you again |
|
| Author |
RE: how to make reports ?? |
yw
Administrator
Posts: 670
Location: ***
Joined: 23.06.05 |
| Posted on 19-01-2006 03:22 |
|
|
Please try the new beta at http://www.limnor.com/downloads/limnor.msi. The PrintWatcher performer has a method "SetDefaultPrinter". You may use this method to create an action, suppose this action is named PrintWatcher1.SetDefaultPrinter.
You may create a new action list to include the following two actions:
PrintWatcher1.SetDefaultPrinter
DataTable1.BatchExecute.PrintAllReport
Now assign this new action list to the Click event of a button. Then clicking this button will show all available printers to let the user select a printer. The selected printer will be set as the default printer. Then all orders will be printed using this printer.
Of cause you may use other ways, for example a menu, to let the user set default printer.
For setting the printer properties, let me check it...
Edited by yw on 19-01-2006 03:23 |
|
| Author |
RE: how to make reports ?? |
kasper
Member
Posts: 219
Location: Tennessee, USA
Joined: 16.01.06 |
| Posted on 19-01-2006 09:11 |
|
|
I have tried the beta version , and "select default printer" problem was solved.
For "printer properties" , i wish to hear good news from you very soon.
i have a suggestion for Limnor group , i wish to find a performer or action to open the "print window" like that found in microsoft word or access (click File-->Print)
Thank you again |
|
| Author |
RE: how to make reports ?? |
skylight
Member
Posts: 9
Location:
Joined: 26.06.05 |
| Posted on 19-01-2006 13:14 |
|
|
|
You may use Menu performer to do that. Drop a Menu performer to your page. Set its properties. Then set the MainMenu property of the page to this Menu performer. |
|
