Passing parameter from a webpage to a report RSS

• • Reply
  

  msfriend

  Member

  55 Points

  11 Posts

  Passing parameter from a webpage to a report

  Mar 16, 2005 10:16 AM|LINK

  I am developing a website which need to allow user to pass through several webpages for criteria selection and generate a report base on the selected criteria finally. Anyone know how to pass the selected value from a webpage to the SQL statement or stored procedure which used to generate the report? Or there are other methods to do so?
• • Reply
  

  ndinakar

  All-Star

  49092 Points

  6868 Posts

  Moderator

  MVP

  Re: Passing parameter from a webpage to a report

  Mar 18, 2005 03:22 PM|LINK

  look at the rendering methods of RS - there's one by URL where you can pass the parameters via URL and request the report.
  ***********************
  Dinakar Nethi
  Life is short. Enjoy it.
  ***********************
• • Reply
  

  pjmcb

  Contributor

  2234 Points

  459 Posts

  Re: Passing parameter from a webpage to a report

  Mar 18, 2005 05:16 PM|LINK

  I believe you simply build a querystring and append the parameters and values to the end of the querystring.
  -pjm
  
  I never gave a damn about the meterman until I was the man who had to read the meter.
• • Reply
  

  msfriend

  Member

  55 Points

  11 Posts

  Re: Passing parameter from a webpage to a report

  Mar 20, 2005 03:27 PM|LINK

  Thanks for your kindly reply. I have another related question see whether anyone can help. Base on my current knowledge, I know that we can pass one value for each parameter. E.g. countryID=20. If I want to pass multiple values for this parameter, e.g. countryID=20, 21, 25, .... How can I do so? Also, how should I set it in report designer for this purpose?
• • Reply
  

  ndinakar

  All-Star

  49092 Points

  6868 Posts

  Moderator

  MVP

  Re: Passing parameter from a webpage to a report

  Mar 21, 2005 02:49 PM|LINK

  Can you explain little more in detail (perhaps with some sampoe) ? Is your data in the format 20,21,25 for each record ?
  ***********************
  Dinakar Nethi
  Life is short. Enjoy it.
  ***********************
• • Reply
  

  pjmcb

  Contributor

  2234 Points

  459 Posts

  Re: Passing parameter from a webpage to a report

  Mar 21, 2005 03:09 PM|LINK

  You could pass in a string like you describe. You would need to have logic in your report or stored procedure to handle such a request, though...
  -pjm
  
  I never gave a damn about the meterman until I was the man who had to read the meter.
• • Reply
  

  msfriend

  Member

  55 Points

  11 Posts

  Re: Passing parameter from a webpage to a report

  Mar 22, 2005 03:14 AM|LINK

  In my report, there is a chart to compare sales performance between several products which are selected by user. The number of selected products is not fixed. I need to pass multiple productID into the report. Also, I face a problem that ...seem I can't pass parameters into SQL functions to build dataset. Is it a rule? The error msg is "Syntax error or access violation.". My statement is as follows: select * from getTable(@productID) Notes: getTable is a user-defined function.
• • Reply
  

  ksminhas

  Member

  95 Points

  22 Posts

  Re: Passing parameter from a webpage to a report

  Mar 22, 2005 03:02 PM|LINK

  so what u can do Select * from table where productid in (@productid)
• • Reply
  

  msfriend

  Member

  55 Points

  11 Posts

  Re: Passing parameter from a webpage to a report

  Mar 23, 2005 01:53 AM|LINK

  In the following statement, getTable is a function with many calculation. select * from getTable(@productID) If I use the one below, I can't get what I want. Also, seem can't be a string e.g. "12, 13, 14" Select * from table where productid in (@productid)
• • Reply
  

  ksminhas

  Member

  95 Points

  22 Posts

  Re: Passing parameter from a webpage to a report

  Mar 23, 2005 08:33 AM|LINK

  so just pass the value in paenthesis like '12,13,14'. it will definitely work. If it is a function. then it should return the value same as u mentioned like "12,13,14" if u can make it " '12,13,14' " . Then you can pass on values.