Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
 Posted - 2010-02-04 : 03:36:34
|
| Hello,The existing 2005 report is populated by a stored procedure (sp) which takes the parameters of @Begindate and @EndDate. This sp does several calculations and it calculates several sum(Amount) ...The Sum(Amount) values are going into the textboxes appropriately...This report is working fine. Question:I have to create another report i.e. DetailedReport so that it shows the details of the figures that made up the sum(Amount) in each textbox.Is there a way to be able to click on a textbox in the report and then to be redirected to another report which shows the detailed figures?Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-02-04 : 04:18:16
|
| yup. its possible. create the detail report with required parameters, deploy it and call it from jump to report or jump to url options available from textbox properties of main report. |
 |
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2010-02-04 : 06:06:21
|
| Let's say textbox1 has value of 100. The sp has calculated this figure based on 10 different records...textbox2 has been populated with a value of say 200. The sp has calculated this figure based on several other recordsand so on...Question:How would the system know that depending on which textbox you click on then the appropriate query is run?Thanks |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-02-04 : 06:10:56
|
quote:
Originally posted by arkiboys
Let's say textbox1 has value of 100. The sp has calculated this figure based on 10 different records...textbox2 has been populated with a value of say 200. The sp has calculated this figure based on several other recordsand so on...Question:How would the system know that depending on which textbox you click on then the appropriate query is run?Thanks
you will define jump to report properties for each textbox with each passing different set of values for parameters (depends on what all values it considered while calculating measures like 100,200,etc) of the navigation report |
|
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2010-02-08 : 03:06:04
|
| Thank you |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-02-08 : 04:51:58
|
| welcome |
|
|
|
santu
Starting Member
3 Posts |
Posted - 2010-06-01 : 23:16:17
|
| Hi,I need to create drill down report on the matrix.I have one table likeCREATE TABLE [dbo].[MonthlyPMworkload]( [Date] [datetime] NULL, [WOStatus] [varchar](40) NULL, [WOCount] [int] NULL, [Footage] [decimal](30, 8) NULL) ON [PRIMARY]insert into [dbo].[MonthlyPMworkload]values('06/01/2010', 'New', 1327, '679567')insert into [dbo].[MonthlyPMworkload]values('05/01/2010', 'Completed', 1355, '679567')insert into [dbo].[MonthlyPMworkload]values('06/01/2010', 'Late', 685, '679567')Status May JuneNew 0 1327Late 0 685Completed 1355 0 If we clikc on the New I want to see all the detailed data of the New work orders like that.Thanks,Santhoshi |
|
|
|
tking1
Starting Member
22 Posts |
Posted - 2010-06-02 : 09:50:53
|
| Add the detail data as a row group to your matrix, then right click on the data field for the detail group and go to properties/visibility. Select hidden, then check box that says allow to be toggled by another report item.Here's a URL to more details.http://www.mssqltips.com/tip.asp?tip=1329 |
|
|
|
|
|
|
|
|
drilldown