Post reply

Need Help?

  • February 20, 2014 at 6:07 am

    #288477

    Hi folks,

    i have to develop the Income statement report in report builder 3.0.one input parameter is company,in dropdown 18 companys will bind.if i select one company the income statement display for that company,if i select all company from filter income statement display the all 18 companys data.

    i have done this sql query level,need to implement in report.

    please help me on this.

  • February 20, 2014 at 6:40 am

    #1690648

    Just to clarify.

    You select one, the income statement for that selected company displays.

    You select more than one. What happens on the report?

  • February 20, 2014 at 6:44 am

    #1690650

    hi ,

    if i select one company it display for one company income statement ,

    if i select multi company(total 18 company ) it display the all company income statement

  • February 20, 2014 at 6:46 am

    #1690652

    Ok, so what happens if you only select say 3 or 4 companies?

  • February 20, 2014 at 7:01 am

    #1690656

    hi,

    if i select 1 it display 1

    or select 1,2 its display the 1,2

    or select 1,2,3 its display the 1,2,3..

    or select the 5th company its display the 5th company data like wise ....

  • February 20, 2014 at 7:03 am

    #1690657

    So surely in that case all you need to do is add a check somewhere in your SQL to say "If I have selected all 18 companies" then "Display the all companies summary"

  • February 20, 2014 at 7:05 am

    #1690658

    yes

  • February 20, 2014 at 7:07 am

    #1690660

    Ok, so what part do you need the help with. As from what you say you have the SQL which will return the individual company and also the All Company the same data should display on the report you currently have?

    Sorry for all the questions, want to make sure on the same page 😉

  • February 20, 2014 at 8:34 am

    #1690724

    hi,

    i have done this problem

    thanks for your support.

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply