| Summary: | Parameter queries in reports do not work | ||
|---|---|---|---|
| Product: | [Applications] KEXI | Reporter: | Ian Whitfield <whitfield> |
| Component: | Reports and Printouts | Assignee: | Adam Pigg <adam> |
| Status: | CLOSED FIXED | ||
| Severity: | major | CC: | adam, inksi, staniek |
| Priority: | NOR | ||
| Version: | 3.1.0 Alpha | ||
| Target Milestone: | 3.1 | ||
| Platform: | Appimage | ||
| OS: | Linux | ||
| URL: | https://phabricator.kde.org/D15438 | ||
| Latest Commit: | https://phabricator.kde.org/R71:719ee0c4ef068ce9837becce3bb6cd8abebcd821 | Version Fixed In: | 3.2.0 |
| Sentry Crash Report: | |||
| Attachments: |
Sample table
Parameter query Parameter query in report Report for query limited to 1 record |
||
|
Description
Ian Whitfield
2017-05-10 12:58:31 UTC
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 |