How to pass parameter value to the Dataset


hello,

i did create new parameter,  "start_date_category" (which highlighted in blue color) , hardcoded 3 values ( date project logged, date advertised, on hold start date) (label , value same) "available values" in report parameter properties. above mentioned values column names in report. whenver select column name in parameter dropdown, should retrive data accordingly.these 3 values ( column names ) contains date.
till did (as per online articles), did right click on main dataset , selected dataset properties , selected query tab, click on "fx"( expression) next query. and  inserted following expression:


="select [job title], [task grade], [group], department, [business unit], [line manager], [date project logged], [date advertised], [closing date], [team leader], practitioner,
                      [project status], comments, [ciboodle ref no/ reference number], on_hold_start_date, on_hold_end_date, [advert type], [on-hold comment],
                      [successful candidate], dbo.fngetbusinessdays([date project logged], [closing date], [project status]) [days fill], dbo.fngetbusinessdayshold(on_hold_start_date, on_hold_end_date) [days on hold], attachments from  hr_recruitment_status              where  practitioner=" & "'"& join(parameters!practitioner.value,",")&"' , [group]="& "'"& join(parameters!group.value,",")&"' , [team leader]="& "'"& join(parameters!team_leader.value,",")&"' , [advert type]="& "'"& join(parameters!advert_type.value,",")&"' , [project status]="& "'"& join(parameters!status.value,",")&"'and [" &parameters!start_date_category.value &"] between " &"'" &parameters!date_range_start.value & "' , '" & parameters!date_range_end.value &"'"

i need multi select, that's why did use "join" ( not sure functionality), think there mistake in expression.

could please me, thanks.

hello,

sorry, code snipplet isn't readable.

anyway, shouldn't create sql statement dynamically; should use real sql parameter @para here:

  select ... from ... where column = @para       and ...

wizard recognize sql parameter , can assign report paramater sql parameter.

olaf helper
* cogito ergo sum * errare humanum est * quote erat demonstrandum *
wenn ich denke, ist das ein fehler und das beweise ich täglich
blog xing


SQL Server  >  SQL Server Reporting Services, Power View



Comments

Post a Comment

Popular posts from this blog

SQL Server PSProvider SQL Server Authentication

greetings: i'm trying use sql psprovider powershell.  can make work management studio by right-clicking next database object.  however, unnable external powershell session. note: i have tried using suggested method msdn ( initializesqlprovider.ps1 , function sqldrive ) i following error: new-psdrive : sql server powershell provider error: not connect 'emtyb06\default+bca_empresarial'. [object ref erence not set instance of object.] @ line:1 char:12 + new-psdrive  <<<< "sqlauth" -psprovider sqlserver -root "sqlserver:\sql\emtyb06\default+bca_empresarial" -credential $cred -scope 1 new-psdrive : sql server powershell provider error: path sqlserver:\sql\emtyb06\default+bca_empresarial not exist.  please specify valid path. @ line:1 char:12 + new-psdrive  <<<< "sqlauth" -psprovider sqlserver -root "sqlserver:\sql\emtyb06\default+bca_empresarial" -cred...
Read more

BIT Version

  hi,     knows how find out ther bit version in sql  , windows os (32 or 64)   regards, s.balavenkatesh   microsoft sql server 2005 - 9.00.1399.06 (intel x86) oct 14 2005 00:33:37 copyright (c) 1988-2005 microsoft corporation standard edition on windows nt 5.2 (build 3790: service pack 2)     intel x86)   -- says sql server 32 bit   madhu SQL Server  >  SQL Server Tools
Read more

How to calculate the delta size while diffing the files in TeamFoundationServer ?

currently, need calculate delta size while diffing files in teamfoundationserver, don't know wheter there are existed tfs api in msdn. far did not find it. familiar it? or deliver suggestions? thanks in advance !! thanks materials !! here solution below: private int calsinglefiledelta(string strbase, string strshelve) { int nfiledelta = 0; arraylist alorgstart = new arraylist(); arraylist aldesstart = new arraylist(); arraylist alunchangedlen = new arraylist(); diffsegment diffseg = difference.difffiles(strbase, encoding.ascii.codepage, strshelve, encoding.ascii.codepage, new diffoptions()); if (diffseg != null) { alorgstart.add(diffseg.originalstart); aldesstart.add(diffseg.modifiedstart); alunchangedlen.add(diffseg.modifiedlength); while (diffseg.next != null) { diffseg = diffseg.next; alorgstart.add(diffseg.originalstart); ...
Read more