Generate Fancy Report - (Moved)

[gahhon]

Is there any resource/sample to generating a fancy report?

I was downloaded this resource and try the example, but it failed to execution due to function not define. PDF

My simple idea of generating the report would be like this:-

Read data from excel instead of database, then generate PDF report based on my custom design.

Any better ideas is much appreciate to share with me here

Thanks.

[water]

Please post the exact message you get in the SciTE output pane.

[Gianni]

in that udf, the "function not defined" error, is caused by the lack of the _Iif() function.
have a look to this post (https://www.autoitscript.com/forum/topic/187723-create-a-pdf-with-own-style/?do=findComment&comment=1348757) for a workaround to that problem and also as an easy example to generate "fancy" reports.

 

Edited January 18, 2019 by Chimp

[JLogan3o13]

Moved to the appropriate forum, as the AutoIt Example Scripts forum very clearly states:

Quote

Share your cool AutoIt scripts, UDFs and applications with others.

---

Do not post general support questions here, instead use the AutoIt Help and Support forums.

Moderation Team

[Vincor]

@gahhon Give also an example of Excel data - is it named fields, columns, etc, or how do you find your data in your spreadsheet?

What kind of report do you need? Is it a single-page, lots of numbers kind of thing, or a many-pages bla-bla report?

Does the output of the script need to be a PDF, or could it be e.g. Word, which you then "print" to a PDF?

[gahhon]

14 hours ago, Chimp said:

in that udf, the "function not defined" error, is caused by the lack of the _Iif() function.
have a look to this post (https://www.autoitscript.com/forum/topic/187723-create-a-pdf-with-own-style/?do=findComment&comment=1348757) for a workaround to that problem and also as an easy example to generate "fancy" reports.

 

Indeed. And I test run your example script is not what I am looking for.
Your script is return a PDF with Calendar print on graph paper.

What I am looking for is normal blank background with printed data.

2 hours ago, Vincor said:

@gahhon Give also an example of Excel data - is it named fields, columns, etc, or how do you find your data in your spreadsheet?

What kind of report do you need? Is it a single-page, lots of numbers kind of thing, or a many-pages bla-bla report?

Does the output of the script need to be a PDF, or could it be e.g. Word, which you then "print" to a PDF?

Usually the Excel is act like a table right. So in the Excel file there should be Header Row and Header Left Column, and within of them there should be have their appropriate data.

Regarding the paging, I cannot say is single page or multiple page, it still have to depending the volume of the data.

I think PDF would be the common report format?

12 hours ago, JLogan3o13 said:

Moved to the appropriate forum, as the AutoIt Example Scripts forum very clearly states:

Moderation Team

Thanks for moving the topic.

[water]

As you seem to have Excel installed on your computer I assume the same for Word.
It should be simple to copy/paste data from Excel to Word, arrange/format it and then save it as PDF.