[SSRS 2008 R2] How to search a built-in variabel Global RenderFormat.Name in another dataset

• guang1015

  Grasshopper

  Points: 15

  More actions

  November 1, 2012 at 5:21 am

  #264222

  Hi guys, I currently on a project that will implement restriction in rendering export format in SSRS 2008 R2.

  By default I want to restrict an excel export format..So, by default user can't export report to excel file.

  But there is an exception for some users that still enable to export report to excel file..The restriction here will implemented on the content of the excel file, because SSRS 2008 R2 doesn't support restriction format in each report..So, the user still able to export the report to excel file with no content at all..

  I create a table parameter that list all report name and it's corresponding format type and the restriction(allowed or not allowed)..

  I store this parameter table query in a dataset, let say DataSet2..

  And the dataset used by the report tablix is, let say DataSet1..

  So the tablix in the report is hidden based on whether the global variabel RenderFormat.Name parameter is contained in the parameter stored in DataSet2..

  Is there any built-in function that I can used in the expression for the hidden property of the tablix, that function will search the global variable RenderFormat.Name in DataSet2, but DataSet2 is not the DataSet for the tablix, the tablix used DataSet1 instead.. Can anyone have any idea? Because I can't found the function that doing this, stuck in the LookUp function but it involve 2 datasets... Realy appreciate for the help!

  Thanks in advance, guys!