Custom code capabilities in SSRS 2008 R2
Hello Intellects I have a situation where I want to return dataset using custom code, the requirement is I want to display lot of metadata for my graph as a tool tip for every value inside my series so I want to pass a parameter and it will return the about 30 fields with line feed Is that possible ever in SSRS 2008 can I use Custom code I am open to any suggestion Best RegardsDhawal
June 27th, 2012 8:46pm

Hi There Thanks for your posting I am afraid you would not be able to do this in current version of SSRS however Why dont you write somthing like this create another dataset for your Metadate togather and use lookupset to get that =join(lookupset(Fields!Country.Value,Fields!Country.Value,Fields!city.Value,"DataSet2"),"" + vbcrlf) We use lookupset when we have one to many relationship inside the source and destination What it does it will create a new line feed for every values you have inside your dataset2 so for exampel if you have many cities or Postal code in your contry it will join them and create a line feed for every values I hope this will resolve your problem Many Thanks Syed Qazafi Anjum Please have a look similar thread http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/c9defc9f-7190-41f3-9b7d-440140fd4c49/
Free Windows Admin Tool Kit Click here and download it now
June 27th, 2012 9:01pm

Thanks Syed this is what I am after, It worked beautifullyDhawal
July 14th, 2012 8:07pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics