Printing reports from an external form

[MicahSpecial]

I follow the tutorial from Chapter 9 Macros. What im trying to do is to make button function to execute the printing reports.

oDocument = StarDesktop.loadComponentFromURL(sURL, "_blank", 0, Arg() )

And I got this error

Type: com.sun.star.lang.IllegalArgumentException
Message: Unsupported URL <>: “from LoadEnv::startLoading”

[Ratslinger]

Hello,

The error is because you are using a registered DB name in the standalone form Data Source (Data tab of Form Properties). If you use a URL instead (locate via ellipsis ...) then it will work - just retested without an error.

There are other macros which do work when using a registered DB name. See:

How to open Base reports based on queries in standalone

I made standalone of form’s, its working properly but when same process used for Base reports based on queries, its open only generate column names but no output queries loaded. when open in design mode no opens found to load data. show me correct and clear steps to do standalone for reports.

or

Standalone form with macro

I have made a standalone “switchboard” with buttons to launch the individual forms in DB (hsqldb 6.4.2) and they work great. 1- I have a few buttons with macros assigned to them to launch the various reports I have. When I launch each report manually within the LO db they work fine. When I use the switchboard form within LO the User Parameter dialog box I put in my queries appears, I enter the data (a date range as an example) then it hangs. When I use the button for my reports on the standalon…

[MicahSpecial]

YOU ARE RIGHT!!! why i never think about that. THANKS ALOT