Who is online?  0 guests and 2 members
Home  »  search results

Search Results: Multivalue

15 results found
  • Building a Report from the Ground Up - Part 6: Cascading and Multivalue Parameters
    In Part 6 of Building a Report from the Ground Up, Dustin shows you how to create cascading and multivalue parameters.
    Author: DustinRyan DustinRyan     Date: 12/1/2009     Section: Article
    tags : SSRS, Parameters
  • Notes on Parameters in SSRS Session
    Last weekend, I presented a session on basic parameters in SSRS at SQL Saturday #38 in Jacksonville. First off, I would like to thank everyone who attended. I just wanted to go over a few notes from the presentation. Always use parameters in your reports.
    Author: ShawnHarrison ShawnHarrison     Date: 5/11/2010     Section: Blog
  • Parameter multivalues
    I want to pass the parameter in the URL and I know I can pass &parName=100 for a valuue of 100 against the parameter parName. What is the syntax for passing the (Select All) value at the top of the dropdown for the multivalue parameter?
    Author: syale syale     Date: 8/29/2011     Section: Forum
  • passing param from main to subreport
    hi, thanks for your response. i have made my parameter multivalued in both reports. ex. in my main report i have sp ,which has field id, when this sp run,it gives you 5 id in id field. id 1 2 3 4 5 now in my sub report , ihave another sp, which has parame
    Author: ssrsnew ssrsnew     Date: 6/27/2012     Section: Forum
  • Passing multivalue parameters in ssrs
    http://hardik-bhavsar.blogspot.com/2011/02/passing-multivalue-parameters-in-ssrs.html In most of the reports, we use multivalue parameters and for that we can directly write sql query in a separate data sets and modify the main dataset. It works fine for
    Author: hardikabhavsar hardikabhavsar     Date: 3/8/2011     Section: Blog
  • Join function for a field in a dataset? (SSRS 2005)
    Yup -- I managed to come up with a work around using a hidden, multivalued parameter -- setting the default value to a field in the dataset, and then using the Join function to string the values into a single field. Initially, this workaround seemed odd,
    Author: peterzeke peterzeke     Date: 12/12/2011     Section: Forum
  • Displaying report parameters
    I want to display the selected report parameters in the report. I have this in a textbox at the top of the report: ="History: " + Parameters!parHistory.Value + vbcrlf + "Server: " + join(Parameters!parServer.Value,",") + vbcrlf + "DSN: " + join(Parameters
    Author: syale syale     Date: 5/19/2011     Section: Forum
  • SSRS -- Optional Parameters
    But this would work If I have to select only one value of the parameter...How about selecting multivalue at a time....Like from the drop down list I want to select several values.....
    Author: domshar domshar     Date: 3/6/2012     Section: Forum
  • SSRS -- Optional Parameters
    Leigh Anne, In this situation, I would load those multivalue parameters with an option for 'ALL'. You would do this in your dataset using a UNION (like shown below). Then in your select statement you check for the existing of ALL or IN the supplied list.
    Author: briankmcdonald briankmcdonald     Date: 7/18/2011     Section: Forum
  • Bridge Table, dimension or fact? updating from a snapshot
    If thats the case, how do i populate it? Like i do normal fact tables increment? What about the changes in Account and Customers? I just read in Kimball ETL toolkit, he suggest to take it as dimension table, do the SCD Type 2 update. He refer to it as Mul
    Author: lalas2000 lalas2000     Date: 9/23/2010     Section: Forum
  • Parameter multivalues
    Parameters are sent in a long querystring to drill through reports. You cannot pass a comma separated list from one report to another. It has to pass in the param=val pair for each pair selected. However, when the parameter goes to a query in the same rep
    Author: briankmcdonald briankmcdonald     Date: 8/30/2011     Section: Forum
  • Join function for a field in a dataset? (SSRS 2005)
    I'm trying to figure out if there's a way in SSRS 2005 to concantenate values from a field in a dataset. For example, if a table contains three rows where one of the fields is called "ID", I would like to concantenate the three ID values into a single str
    Author: peterzeke peterzeke     Date: 12/12/2011     Section: Forum
  • Optional and multiple-value filters. SSRS 2005. Help needed.
    Hi bidn-ers, In my report i would like to create an optional multivalue filter for @accessVar. However my biggest problem is that available values of @accessVar makes use of wildcards. e.g 'BT%'. It will be ok if i does not allow multiple selection. But i
    Author: user155306 user155306     Date: 12/14/2012     Section: Forum
  • sorting in ssrs
    i dnt need interactive sorting. i have 1 multivalue param so when i run report i m seeing option like sort by : (1) account (2) mv so whatever option user select,repoirt should sort by that only. my param like this label value accout act market mv how to
    Author: ssrsnew ssrsnew     Date: 4/4/2012     Section: Forum
  • passing param from main to subreport
    no i cant chnage my sp. my multivalue sparam is integer in main report and its single integer in subreport
    Author: ssrsnew ssrsnew     Date: 6/29/2012     Section: Forum
Page 1 of 1 (15 items)