Please update your forum profile with a real handle instead of "0e9e46fd-1b89-44c9-bba1-6271454a2ebd".
i am newbie and hard to find the place to implement the function....
I am doing a kind of transcript application that will report different terms of the results I have used the form before and it only display one row of the result by a PK if I create a view like this
|ID | Term | Sub |Grade |
|1001 |201301 | BIO | A |
|1001 |201301 | CHEM | B |
|1001 |201309 | HIS | C |
|1001 |201401 | ENG | F |
which type of page in apex can help me to generate a multi-row report?like that:
sub : Grade:
if user insert new row for new term and grade ,the report should add the new term partition.
Do you require a report (read-only) or a tabular form (for data entry)? Personally, I do not recommend the use of tabular forms, particularly by inexperienced APEX developers...
For a read-only report, use a classic SQL report region with a custom named column report template. The report query should use analytic functions to determine when new ID and term partitions start, and conditional row templates to display the appropriate row structure/contents accordingly.
Here's a detailed (if rather complex) example.
yes ,i need a read-only report only
Best of luck,
I'm not sure, but I get the feeling you may be overthinking this. One of the main features of Apex is that you can achieve quite acceptable results without having to delve too deeply into the technology stack.
In order to create a multirow report, create a query that gives you the data you require, then use one of the wizards to create either a classic report or an interactive report, accepting defaults as you go through the wizard. Once you are comfortable with the wizard, you can then start exploring the various options that are available to you in the wizard process. After this you will then find there is a huge amount of options in the builder part of Apex for customising the look and feel and functionality of your report, all without having to touch a line of code, or maybe a line here or there.
I hope I've understood your situation correctly.
i am going to user the custom named column templates
as the above example ,each row contain a term value #2
buy i only want it show once
and the table can create a new header when there is new term
is it write something at the row template expression ?
Yes, exactly that. Look at the example linked to above: Row Template 1 is displayed to start a new row group when the row template expression using column values computed in the query evaluates to true. If the row template expression is false, then the default Row Template 2 is used.
Here's another example (Row Template with rowspan II) that uses analytics in a diferent way to provide report breaks using rowspan.