4 Replies Latest reply on Feb 11, 2011 2:08 PM by Kaps_1

    Show look up name on report

    Kaps_1

      Title

      Show look up name on report

      Post

      I have created a portal which contains a looked up field. How do I generate a report that summarises these values ?

      The portal - I want to summarise by resource name. This is a looked up value resource_id. When I put resource id on the report layout I get 11 (i.e the id rather than the name).

      see the following screenshots:-


      http://www.4shared.com/file/-WVe1e9f/script_3_2.html

      thanks

      kaps

        • 1. Re: Show look up name on report
          philmodjunk

          Can't fully decipher the relationships involved here. I can see that the second layout is based on Job_details, but don't know on which table occurrence the first layout is based nor what other table occurrences exist nor how they are related.

          In general, if you have this relationship:

          ReportLayout'sTableOccurrence::Resource_id = Resources::Resource_ID

          Then you can display the resource name by putting the Resource Name field from Resources on your Report Layout. You can also refer to Resources::ResourceName as the "sorted by" field in a sub sumary part and can sort your found set of records by this same field.

          • 2. Re: Show look up name on report
            Kaps_1

            I now have the correct label. However only the first line of the portal appears on the report. How do I get the remaining line ? Thanks

            Kaps

            • 3. Re: Show look up name on report
              philmodjunk

              On what table occurrence is your portal based?

              On what table occurence is your report layout based?

              If the report layout is based on the same table as the portal is, each portal line is a separate record and thus a separate row in the report.

              The invoices starter solution uses this approach to print an invoice listing all the entries from an invoice's portal of LineItems.

              • 4. Re: Show look up name on report
                Kaps_1

                Thanks !!!