I have a Members Database and from this, with a Query, I select a Group of the Members. I then created a Report to print out or email a Report for each of these selected Members. Problem 1 - I have >300 Members and the one Group is about 150 of these. I can not find a way to select a particular Member to bring up the Report for him??!! The counter shows only how many in the selected Group and not the Table Record No. I CAN do it manually by clicking through ALL the records one-by-one until I find the one I want. But this is a VERY slow method. Problem 2 - Once I have the Report I want on screen I select "Report > Export as > PDF" BUT it prints out the FIRST Report in the Group and NOT the one on-screen. To do a lot of these it would be better if you could trigger the Report for the current Record on-screen from the Form. Is this possible??
Answering for #1. I am copying the Problem #2 to another bug entry. Next time please use one entry per issue, OK?
Ian, Changed the summary to "Selecting record for printing". The other problem is addressed at https://bugs.kde.org/show_bug.cgi?id=379737
Created attachment 105461 [details] Sample table
Created attachment 105462 [details] Parameter query
Created attachment 105463 [details] Parameter query in report
So to select a record you can use parameter queries: http://www.kexi-project.org/pics/1.1.1/parameter_query/parameter_query.html
Example follows: 1. Table persons created: https://bugs.kde.org/attachment.cgi?id=105461&action=edit 2. Parameter query created from this table, note that for the Criteria for ID I entered [Enter Person's ID] 3. Kexi asks for ID when the query is previewed. You enter 1 and record "Ian" appears. 4. Then create report based on the query. The report should ask for the parameter for the query then just one record should be displayed in the report. Current issue: Step 4 does not work. (I changed the bug summary - most practical)
Created attachment 105464 [details] Report for query limited to 1 record
Current workaround for you Ian: Once you find the record you want to print, copy the ID to clipboard, go to the query design, paste the ID in the criteria box for the ID field. Save the query, then open report based on the query (to refresh it you can go to design and switch back to data). Result: one record should be previewed. See https://bugs.kde.org/attachment.cgi?id=105464&action=edit
Not getting this at all Jaroslaw!! I have a 300+ members Database With a Query I select out a specific Group (Appoox 150) I then design a Report for these Members The Report correctly only has 150 listings So How do I get to any specific Report to print out?? (Other problem is that if I click through to get to the one I want it still prints out the FIRST record in this Group!!!)
OK but please define what do you mean by REPORT and GROUP here. Report is a single document in the project, like form or query is. There is no GROUP term in Kexi.
"Report" is a Report created in Kexi. "Group" is the Group of Members (with a particular status in the Database (ie all those who have not yet paid their fee or all of those in a particular area etc) and have been select from the Database with a Query.
So do you want to print out one record out of these selected (approx. 150 records)?
No Jaroslaw One for each of them.
One per page i.e. 150 pages?
Yes - It is a once a year thing that has to be done For the rest of the year there is just the need to do this whenever new people join the Organization. I have also noticed that 'Print to Text File' does nothing. Could not a 'Print' button be added to the Report screen to print (or save) the currently displayed Report??
@Ian Please use another report for this another topic, thanks.
Log: git diff --stat f352f4ae9f17c18b5eef3af9ca226964b9c556af..719ee0c4ef068ce9837becce3bb6cd8abebcd821 src/plugins/reports/KexiDBReportDataSource.cpp | 20 +++++++++++++++----- 1 file changed, 15 insertions(+), 5 deletions(-) https://phabricator.kde.org/D15438