Stel uw vraag

nettings's profiel - activiteit

2016-11-07 18:33:05 +0200 badge ontvangen  Opvallende Vraag (bron)
2016-11-07 18:33:05 +0200 badge ontvangen  Beroemde vraag (bron)
2015-06-19 10:14:02 +0200 badge ontvangen  Populaire Vraag (bron)
2015-02-23 03:00:46 +0200 badge ontvangen  Tovenaar (bron)
2015-02-23 03:00:46 +0200 badge ontvangen  Leraar (bron)
2015-02-23 00:03:51 +0200 badge ontvangen  Redacteur (bron)
2015-02-23 00:02:53 +0200 beantwoorde een vraag how to generate subtotals in a report?

Add a textbox with Data Field Type "Function", choose the appropriate field from your table or query, and set Function to "Accumulate". Set the Range as required. You will find a field name like [AccumulationYourfieldYourrange], which I found can also be typed into formulas. So in order to add German VAT, you could say "=[AccumulationYourfieldYourrange]*1.19".

2015-02-22 23:52:34 +0200 beantwoorde een vraag Libre Base Errors

After suffering from severe data loss myself, I was told that the default embedded database is pretty much unusable (people from the dev community might want to comment on whether that is true, and if so, why users are still lured into using it). The recommended approach seems to be to use a so-called "split database". There is a nice explanation/howto and ready-to-use script at https://forum.openoffice.org/en/forum... .

2015-02-22 23:47:04 +0200 badge ontvangen  Organisator (bron)
2015-02-22 23:46:09 +0200 beantwoorde een vraag Query - criterion

I think I got bitten by the same thing. You must press "Enter" after typing in your criteria, otherwise the field will not be updated. If that's not the cause, it might help to tell us the type of the field you are trying to filter, and what your criteria look like.

2015-02-22 23:40:24 +0200 stelde een vraag Simpler way to add ad-hoc consecutive record numbers to queries and reports?

HI *!

I was faced with the challenge to generate a set of invoices from a database, where the invoice number had to be generated on-the-fly based on the record number. Other people are probably facing the same general problem: how to include consecutive numbers for each record into a report. None of the "Counter" options in the Oracle Report Builder of LO 4.4.0.3 seemed to be doing what I needed (they counted the Details rows, not the records as such). So here's what I did. Please laugh at me and tell me there's a simpler way...

  1. Create a query qryInvoicesDistinct to join clients and items bought between :from_date and :to_date, output only client ID as DISTINCT values, so that I get one result record per client. SELECT DISTINCT "Clients"."LastName", "Clients"."FirstName", "Clients"."ID" FROM "Purchases" "Purchases", "Clients" "Clients" WHERE "Purchases"."ClientID" = "Clients"."ID" AND "Purchases"."Date" >= :from_date AND "Purchases"."Date" <= :to_date ORDER BY "Clients"."LastName" ASC, "Clients"."FirstName" ASC, "Clients"."ID" ASC
  2. Create a second query qryInvoicesDistinctNumbered that uses the query above, plus a second result field ROWNUM() (this might not be portable, but works for hsqldb). SELECT "ID", ROWNUM( ) "RecordNumber" FROM "qryInvoicesDinstinct" "qryInvoicesDinstinct"
  3. Create a final query qryInvoices that contains all the data required for the report, ordered by the same criteria as above (important!), then join it to qryInvoicesDistinct via ID to include the record number: Now we have an ad-hoc record number at our disposal to include anywhere in the final report.

It works, at least for databases that support ROWNUM(), but it feels like jumping through burning hoops for a task that should be straightforward. Are there any better options?

Thanks, Jörn