Apache OpenOffice Community Forum

Hi,

I have created a database for making Bank Statements. I am trying to make a report for cheque printing with that too. I have created the report all fields have been placed in the desired places. I am facing the issue of converting the cheque amount to Words to be printed on the cheque.

I have the Add-On Number Text installed and is being used in calc, but how to use it in Base Report.

Thanks,

Amit

Make a Calc report.
[Tutorial] Using registered datasources in Calc

Thanks Villeroy,

I have checked out the link provided by you. I can use the data in Calc and convert the number into words, but I need to convert it in words in report generated by Base. In reports I've created the output print as required on the cheque for 2 banks. Now I need to print the amount in words too, below the Name Field.

Amit

And my answer was that you could use a Calc report instead of an embedded Writer report. I don't know any practicable solution other than that.

How do I attach the db here, you can look at it and advise

The Upload file tab is below the Submit button on FullEditor or PostReply screens.

it only allows file upto 128 kb, the db is 216 kb

menu:Tools>SQL...
SHUTDOWN COMPACT

Thanks Villeroy.

Have attached the db after compacting and zipped the db.

Have attached the db after compacting and zipped the db.

Office documents are compressed already. They are zip archives.

Hi Villeroy,
Downloaded the file provided by you. I placed it the same folder as odb. On opening the ChequePrinter.ods, I'm getting the following error
"The data content could not be loaded.
Table not found in statement [SELECT * FROM "Filter" WHERE "FID" = 0]"

Do I need to create something in odb. I am not familiar with macros and programming.

Please advise.
Amit

amitmahajan74 wrote:Do I need to create something in odb. I am not familiar with macros and programming.

Why do you have a macro in your document then? A basic knowledge of SQL is the bare minimum if you want to do anything with databases.
In the spreadsheet I listed all steps for the database and for the spreadsheet. You need a database table named "Filter" with 2 fields and one row.

Tools>SQL... View>Refresh Tables

should create the missing table.

Then reload the spreadsheet, activate the first sheet, pick a cheque number from the list box and push the button.
We can't assign a button to some action (save, reload, navigate,...) plus running a macro at the same time. This is why I put the button on another logical form. It takes the focus, pulling the focus away from the first form which will be saved. Then the macro refreshes "Import1" and shows the print preview of the print area on sheet #2.

Thanks, it's working, will setup the page as per the Bank Cheque.

Thanks