Answered Questions

  • what is the difference between a cascading report and drillthru report?why do we go for drill thru report?

    Star Read Best Answer

    Editorial / Best Answer

    binay.bk  

    • Member Since Jan-2008 | Jan 24th, 2008


    Hi

    Drill Through is used to link the master & detail reports.
    After putting drill through if you click on a link (e.g. Order ID 1234) in the master report then the details will be displayed for that particular item (Order ID 1234).

    Cascading prompt uses the value from the previous prompt to filter the value in the current prompt.

      For Cascading no need of two reports.If a report having two related columns (e.g. Country & States),then we can cascade these two columns by adding two value prompts.

    If you select a country (e.g INDIA),in the next prompt all the states will be displayed those which are under INDIA.

    If you want to see the details for the state Tamilnadu,then select TN from the list which will display all the details for TN.

    binay.bk

    • Jan 24th, 2008

    HiDrill Through is used to link the master & detail reports.After putting drill through if you click on a link (e.g. Order ID 1234) in the master report then the details will be displayed for that...

    subbu

    • Nov 4th, 2007

    Cascading report contains one report and it work based on the condition.drill through contains two reports parent report(summary),child report(detail report)child report contains a parameter that must accept the values passed from parent report.

  • how can i test report in reportnet

    Viswanath.S

    • Mar 15th, 2006

    If we wanna test the report in report net, first we can intially check by validating it in the report page. After that we can test the out put of the report Using a sql anlyser and sql query.so here we will be comparing the sql analyzer output with the output of the report viewer.

  • difference between filter and conditin

    Viswanath.S

    • Mar 15th, 2006

    I filter we just creat a parameter on which we can filter the fields.but in condition we can have the static functions like if yes then color it green,if no then color it as red etc. so here we can cr...

    Nagesh

    • Feb 27th, 2006

    The difference between Filter and Condition:Condition returns true or false Ex: if Country = 'India' then ...Filter will return two types of results1.Detail information which is equal to where clause in SQL statement2.Summary information which is equal to Group by and Having clause in SQL statement