bound parameter in reporting service
Hi Surbakti, I think you should find this very straight forward... 1st. Create the parameter (entityCode) then choose that the param is populated from a Query on Available Values tab, Select the dataset (dsParameter) then select the Value to be EntityCode, and the Label to be entityName. Thats it... Param now shows in report for user to select. Happy Days!
January 22nd, 2011 8:25pm

You are on the right track, what you need to do next is to create parameters for your first data set check out this article from msdn http://blogs.msdn.com/b/davidlean/archive/2009/01/30/sql-reporting-how-to-color-coding-based-on-data-values-for-tables-charts-1-n.aspx video link from youtube - http://www.youtube.com/watch?v=vB9iDurRtRM
Free Windows Admin Tool Kit Click here and download it now
January 22nd, 2011 8:28pm

i want add a parameter to my report. call that parameter entityCode. but i want this parameter added by user. so i create 2 dataset. i call dsMain and dsParameter. my query in dsMain like " select * from TR_transaction where entityCode=@entityCode" and in dsparameter "select entityCode,entityName from MS_entity" i want that dsParameter show in a dropdownlist so user can choose parameter before generate report. what must i do? please help Thanks Surbakti
January 22nd, 2011 8:44pm

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

Other recent topics Other recent topics