Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Need Help? Expand / Collapse
Author
Message
Posted Thursday, February 20, 2014 6:07 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, September 15, 2014 7:41 AM
Points: 9, Visits: 88
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.
Post #1543446
Posted Thursday, February 20, 2014 6:40 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 9:41 AM
Points: 461, Visits: 1,414
Just to clarify.

You select one, the income statement for that selected company displays.
You select more than one. What happens on the report?

Post #1543455
Posted Thursday, February 20, 2014 6:44 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, September 15, 2014 7:41 AM
Points: 9, Visits: 88
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
Post #1543457
Posted Thursday, February 20, 2014 6:46 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 9:41 AM
Points: 461, Visits: 1,414
Ok, so what happens if you only select say 3 or 4 companies?
Post #1543459
Posted Thursday, February 20, 2014 7:01 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, September 15, 2014 7:41 AM
Points: 9, Visits: 88
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 ....
Post #1543464
Posted Thursday, February 20, 2014 7:03 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 9:41 AM
Points: 461, Visits: 1,414
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"
Post #1543465
Posted Thursday, February 20, 2014 7:05 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, September 15, 2014 7:41 AM
Points: 9, Visits: 88
yes
Post #1543467
Posted Thursday, February 20, 2014 7:07 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 9:41 AM
Points: 461, Visits: 1,414
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
Post #1543469
Posted Thursday, February 20, 2014 8:34 AM This worked for the OP Answer marked as solution
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, September 15, 2014 7:41 AM
Points: 9, Visits: 88
hi,

i have done this problem
thanks for your support.
Post #1543545
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse