This discussion is archived
7 Replies Latest reply: Feb 13, 2013 6:27 PM by 990508 RSS

CSV file no data found

990508 Newbie
Currently Being Moderated
Hi all

I am new to APEX development. please help in below

I have two report pages (interactive reports). Let say

Page1 : Department Page (List of Departments) link to Page2

Page 2: List of Employee for selected Department - PageItem (P_DEPARTMENT)
this report table has source as (select * from emp where department_id = : P_DEPARTMENT)

Now when i click 'Download' and select 'Excel' format -> I can see data is getting downloaded for Page1
but not for Page2 for this page..when i download i see blank data in excel sheet.

I have seen couple of old threads on this same TOPIC
Re: Strange caching error in exporting a report to csv (AppEx v2.0)
http://apex.oracle.com/pls/otn/f?p=31517:1:4124351071686

Suggestion is "compute your items on load - before header. This means to set the items to a kind
of a default value they should have at the start"

I was not very clear on above statement and can any one suggest me how to proceed to solve this issue

i.e how to 'compute your items on load - before header' I am trying to export data in PAGE2 into an excel file.

THanks
  • 1. Re: CSV file no data found
    scott.wesley Guru
    Currently Being Moderated
    The threads you found a regarding session state typically in Classic Reports - and if this is a parameter coming from another and you already see data in your IR on the page, then you have a different problem.

    And your other problem may be trickier to track - a search on "oracle apex blank interactive report csv" found these
    download IR to excel produces an empty report -- automatic csv encoding - what's your language?
    blank csv from interactive report -- process removing data - unlikely in your case, but see how different these issues are?

    Can you set up a test case on apex.oracle.com?

    Scott

    blog: [url grassroots-oracle.com]grassroots-oracle.com
    twitter: [url twitter.com/swesley_perth]@swesley_perth
  • 2. Re: CSV file no data found
    990508 Newbie
    Currently Being Moderated
    Thanks for response!

    Yes parameter value coming from another page and i already see data in second the page ..issue with is only while download the data in second page.

    i.e

    Page 1 -> query data all departments ..click on department name..(link style ..set the parameter P_DEPARTMENT_ID)

    Page -> show employee_names for above selected department.(select * from emp where department_id = P_DEPARTMENT_ID)

    I can see the data in the screen..no issues...( issue is only while i click on Action -> download -> CSV ..no data is shown in CSV file)

    Automatic CSV encoding is set 'Yes'

    Edited by: 987505 on Feb 11, 2013 8:09 PM
  • 3. Re: CSV file no data found
    990508 Newbie
    Currently Being Moderated
    Scott -

    Please check the scenario in


    http://apex.oracle.com/pls/apex/f?p=66204:2:21589524284762::NO:::
    username : guest
    pwd : test1234


    department page..Select any 'department' name and go employee page..click on 'Action' -> Download -> CSV ..you dont see any data


    Please review

    Thanks for all help
  • 4. Re: CSV file no data found
    scott.wesley Guru
    Currently Being Moderated
    Something to do with your end - I get content:
    "Department Id","Department Name"
    "3","Police"
    "2","Purchasing"
    "3","Police"
    "4","Finance"
    "1","Information Systems">

    Scott
  • 5. Re: CSV file no data found
    990728 Newbie
    Currently Being Moderated
    Scott -

    Please click on 'Department Name' and navigate to second page and try to download in CSV

    My original post
    "I can see data is getting downloaded for Page1 but not for Page2. for this page..when i download i see blank data in excel sheet."
  • 6. Re: CSV file no data found
    scott.wesley Guru
    Currently Being Moderated
    Sorry - I was a step ahead of myself.

    I have the same issue - would need to see underlying page to suggest anything else.

    Only other thing that comes to mind is to you have any VPD controls?
  • 7. Re: CSV file no data found
    990508 Newbie
    Currently Being Moderated
    No I dont have any controls

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points