Report Output only current data

[Schlingmeier]

I'm currently working on the report builder. How can I create a report that only outputs the data record that is in focus. Can I use custom sql for this? But how do I then transfer the current data record number?
Thank you, greetings Olaf

[barrymavin]

You can set a filter on the report section if that’s what you are using.

[Schlingmeier]

When I try to create a filter in the report I get the message "You cannot set filters when custom SQL is specified". As you can see in the picture, I have not stored an SQL entry. What would the command look like page1.section1.field10.value = employees.employeeid.? (page1.section1.field10 would contain the employeeid)
Thanks Olaf

[barrymavin]

The report builder is a self contained tool. You cannot use it in deployed runtime applications.

Why are you trying to filter what is included in the report from active data in an app?

You use a report section for that purpose, not the report builder. Specify the report name that you have designed in the report builder in the report section. You can then specify a filter to relate the employees section to the report section.

In this example i selected the report which loads all the report definition attributes for the report section. I then disabled "selectable" so the user cannot switch reports.

Note last that that the Query Builder can be used to filter data that is displayed in a report section.



You can speify the filter in the section attribute. This can of cource include {macros}.

[barrymavin]

There was an issue with specifying the filter in the Report Builder which i have fixed in 9.3.2.

The error message "You cannot set filters when custom SQL is specified" is now not being displayed.

[Schlingmeier]

Thank you Barry for your support. I want the current data record that I display in the form to be printed on the printer. There is a printer symbol in the form that is displayed. But with this printout only what is visible in the form is printed. If a rich text or html text is set in the form, the invisible information about the printer symbol will not be printed out. To do this you then have to switch to the report generator. Now I need to choose a setting in the report generator that only outputs the current record and not all other records. I hope I was able to express myself clearly. Greetings Olaf

[barrymavin]

There is a custom print delegate which gets called when you click the print icon.

In that print delegate you can format an html page of all of the data and print it out using a WebView.

[barrymavin]

After reading your requirements again it seems an ArticleView section does exactly what you want.