master data from sale table and detail data from phone table
there is no relation between two table only one field is common in two table that is country code.
in the first page i want to show data regarding UK like
UK details it is title country wise
-----------------------------------------------------------------------
Toral Sale : 112300 Diag sale: 1300 Reman sale : 10000
Caller Name incomming call out going call call transfer
---------------- --------------------- ------------------- ----------------
keith 5 5 2
john 3 2 1
sam 8 4 5
in the next page same data will come but USA data will show. so in this way country specific data will show in each page.
i am new in ssrs so i am not getting any idea how to design this report with ssrs
my store will supply data and it will take only one parameter like country code. if i pass country code like 'GB,US,DE' then my sp will return two result set first result set will fetch data from sale table for country GB,US and DE like
total_sale, diag_sale, Reman_Sale, countrycode
112300 1300 10000 GB
10200 1200 4700 US
4200 1500 5600 DE
first result will look like above output
second result set will look like
callername incommingcall outgoingcall calltransfer countrycode
keith 5 5 5 GB
john 3 2 1 US
sam 8 4 5 DE
so discuss in detail how could i design this type of report with ssrs.
mou_inn
Participant
780 Points
955 Posts
Need help regarding a specific type of report design by ssrs
Feb 20, 2012 04:59 PM|LINK
i want to show one master and one detail data.
master data from sale table and detail data from phone table
there is no relation between two table only one field is common in two table that is country code.
in the first page i want to show data regarding UK like
UK details it is title country wise
-----------------------------------------------------------------------
Toral Sale : 112300 Diag sale: 1300 Reman sale : 10000
Caller Name incomming call out going call call transfer
---------------- --------------------- ------------------- ----------------
keith 5 5 2
john 3 2 1
sam 8 4 5
in the next page same data will come but USA data will show. so in this way country specific data will show in each page.
i am new in ssrs so i am not getting any idea how to design this report with ssrs
my store will supply data and it will take only one parameter like country code. if i pass country code like 'GB,US,DE' then my sp will return two result set first result set will fetch data from sale table for country GB,US and DE like
total_sale, diag_sale, Reman_Sale, countrycode
112300 1300 10000 GB
10200 1200 4700 US
4200 1500 5600 DE
first result will look like above output
second result set will look like
callername incommingcall outgoingcall calltransfer countrycode
keith 5 5 5 GB
john 3 2 1 US
sam 8 4 5 DE
so discuss in detail how could i design this type of report with ssrs.
kushpaw
Member
512 Points
123 Posts
Re: Need help regarding a specific type of report design by ssrs
Feb 20, 2012 05:57 PM|LINK
You could either create a master/detail report or a drill down report. Have a look at this link http://msdn.microsoft.com/en-us/library/ms160348(v=SQL.100).aspx.