Andreas Saeger wrote:
Additional note: Datapilots created from datasource are not accessible
through the API. Macros don't see them.
3) Also, building this Calc sheet and the Base database we found short
comings that will probe usefull in further developing both applications.
(for those still interested:
Oh, yes. All my database reports are formatted spreadsheets and data pilots.
That exactly what I mean: Database reports normally don't do what you
need them to do. So we need to use a spreadsheet. Maybe, when I get to
understand the power of the new report designer..... :-)
*Using form filters on boolean fields produce an error that an integer
can not be compared to a boolean. Funny, Base nows that the field in the
table is a boolean, because is dislays a checkbox, but when you want to
set the form filter on "Billable" it add the filter Billable = 1
Thank you for this information. This may save some hour of time since it
is one of those "what-am-I-doing-wrong?" issues.
If you pop up the filter dialog (instead of the Filter by Form) you can
manually type in false where there would otherwise be 0, and then it
filters OK. How to explain the end user....
I wanted to use use a control then, to filter the data in the table
control. Much the way when you select * where something = :avariable.
Then you normally get a dialog box requesting a value for avariable. But
I didn't find a way to prevent the dialog box from appearing and
avariable being filled with the value from the control.
When do we see a simple solution to this?
*In the datapilot you want to generate a bill for a customer (a project)
over a certain period. Whoopie, I can select the project, tasks,
billable hours and get totals for everything I need. Unfortunately, I
can only select the time frame by manually excluding each date outside
of the period. I appears the datapilot handles data field as text
(showing each and allowing them to be excluded, instead of values that
can be included between a start and end date)
Select a date/time-cell in the pilot and call Data>Outline>Group (key
F12). You can split up the date/time into minutes, hours, ..., years.
Hey, that's great! Glad I'm still hanging in here
(for those still interested):
* Time stamp fields from data sources are imported as empty data pilot
fields.
http://www.openoffice.org/issues/show_bug.cgi?id=81848
I have separate date and time fields. It works well, with the jdbc
driver (postgresql). Other drivers varying results.
* In Calc you can set refresh periods for imported database ranges, but
not in the GUI.
* You can import from data source by SQL SELECT, but not in the GUI.
With a little bit of scripting you can build parameter queries from
spreadsheet cells.
Very quick and dirty proof of concept:
http://www.mediafire.com/download.php?ft4thvzoztx
Now this is a cool thing! I was already wondering how to do that, and
got demotivated by the steep learning curve: using buttons on a
spreadsheet, passing queries, retrieving the data. It's all here, thanks!
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
