3 Replies Latest reply on Apr 15, 2014 11:28 AM by Joe_990933

    report "No data found"

    Joe_990933

      Hello together,

       

      I am using Apex 4.2.4 with a XE DB on Windows.

       

      I am creating a mobile application.

       

      I've created a report which shows, based on the logged on user, specific information.

      Sometimes it is possible that there are no information available. In this case the report is showing the message/exception "No data found".

       

      Is there a solution to hide this message?

       

      My plan is, to show data only if they are available and to show nothing when no data found.

      For the user it should look like that there isn't a report if no data are available.

       

      I do not want to see the message "No data found".

       

      Thanks for your help

       

      Joe

        • 1. Re: report "No data found"
          AndyH

          You can change/remove the message in the Messages section of your report.

           

          Alternatively, you can make the region conditional on some value/role/whatever with the Conditions section in the region.

          1 person found this helpful
          • 2. Re: report "No data found"
            fac586

            Joe_990933 wrote:

             

            I am using Apex 4.2.4 with a XE DB on Windows.

             

            My plan is, to show data only if they are available and to show nothing when no data found.

            For the user it should look like that there isn't a report if no data are available.

            Control whether the report region appears using an Exists (SQL query returns at least one row) condition with a query that will return at least one row if the report will contain data.

            • 3. Re: report "No data found"
              Joe_990933

              Hi AndyH,

              hi fac586

               

              thanks for your answer.

              That was to easy.

               

              My Solution:

               

              Edit the Report and go to section "Conditions".

               

              Condition Type: Exists (SQL query returen at least one row)

              Expression1: select 1 from ..... where ....

               

               

              Note: In this case the where clause should be the same as the where clause of the report.

               

              Result: If the report return min. one row you will see the result. If the report return no row you are getting no message etc. It looks like the report doesn't exist.

               

              regards

               

              Joe