| Author |
Topic |
|
abhit_kumar
Posting Yak Master
147 Posts |
 Posted - 2010-08-21 : 06:06:16
|
| Hello All Experts,I have made one matrix report, in which i have taken one column group named as "Branch".It will display dynamically all the branches. Now in that column group i have added two sub columnas "PO", "SO". In column "PO" i have given link of anther report with the paramtere also.Now there is a hyperlink in PO column which is display for all the branches, i want that the hyperlink should be there for only branch name "AHD", for other branches there should not be any hyperlink to go another report.Is this possible? if yes then how can we do this?Regards,AKM |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-08-21 : 13:23:13
|
| its possible. just change navigation option as=IIF(Fields!Branch.name = "AHD","your navigation report name",Nothing)------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
abhit_kumar
Posting Yak Master
147 Posts |
Posted - 2010-08-23 : 03:04:51
|
| thanks visakh |
|
|
|
abhit_kumar
Posting Yak Master
147 Posts |
Posted - 2010-08-23 : 04:33:01
|
| Also i want to know,suppose parent column grp have two subgrp.Now if suppose i want to display only one subgrp for branch "AHD" and for other it will display as two subgrp.How it can be done? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-08-23 : 05:08:57
|
| sorry didnt get that. can you post a screenshot of how you want output?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
abhit_kumar
Posting Yak Master
147 Posts |
Posted - 2010-08-23 : 05:20:06
|
ok,but doesnt know how to put image in post.AHD SRT HYD SO PO SO PO SO PO Look AHD have SO and PO and SRT and HYD also PO and SO.Now i want that only AHD should display SO and PO and SRT & HYD should display only SO. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-08-23 : 08:52:25
|
| you can change the hidden property of the PO column for that. give an expression for hidden property like =IIF(Fields!MainField.Value="AHD",False,True)------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
abhit_kumar
Posting Yak Master
147 Posts |
Posted - 2010-08-25 : 00:16:09
|
This method i have alrady applied,this method doesnt hide the PO column, its still display with blank column. I dont want to display it except for AHD. See below. AHD SRT HYD SO PO SO SO |
|
|
|
|
Restrict hyperlink in Report