ĮVENTUALLY understand there are hidden form fields, change from query to sql, update the string as above, and get on with my day. MANY hours later I remember the above, but now the query won't hold - query designer keeps mangling it back to order by "Shift". In Report Wizard do the usual, and no way no how will it group properly.
It's tripping over itself.ĭays later, having moved on to other things, come back to build the report. However, change the order by to "Role 1" ASC, "First Name" ASC, "Last Name" ASC, and it all works as expected. no way, no how, would the query ever show properly sorted results. W3 Dec 17-18 – Scheduled" IS NOT NULL ORDER BY "Shift" ASC, "Name" ASC SELECT "Role 1" AS "Shift", CONCAT( "First Name", ' ', LEFT( "Last Name", 1 ), '.' ) AS "Name" FROM "PeopleTable" WHERE "Scheduling: 7. (Even assuming I have the confidence at any particular point that what I'm experiencing and what I should be experiencing aren't the same thing, and not due to user error.) With so much learning curve to go through on oo, I haven't had the time or inclination to report bugs. I have to copy it to another database, rename it, then copy it back in. I can right-click and copy a query, but not then right click a paste a copy in. Granted, the frustration with the base interface is so high that I start painting everything with the same brush - be it report builder, report wizard, base, openoffice, and so on. If one does calc /data / datapilot / start, the graphic displayed does look tantalizingly close to a typical report.Īnyone with pointers to good links, tutorials, documentation, whatever, with respect to doing such reports using data from base in calc and/or writer?īs27975 wrote:I'm finding the report builder just broken
However, I've seen references from Villeroy (I believe) where he indicates it is useful for reporting. The term 'data pilot' just seems weird, unintuitive, uninformative, and off-putting. (Aside from page headers/footers) let alone report or group headers / footers. However, it is not intuitively obvious to me how one does reports in calc or writer that involve groups or subtotals. Is there anything around with respect to doing reports in calc or writer?Īs far as I can tell, writer just doesn't have the guts to iterate through records, (linking / data refresh), while calc does. There is a fair bit of documentation about with regard to building data input and/or record browsing forms with writer, and virtually none on calc. I'm finding the report builder just broken, and getting increasingly frustrated with the Report Wizard (not builder).
0 kommentar(er)
