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?
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?
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.
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)
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.
msfriend
Member
55 Points
11 Posts
Passing parameter from a webpage to a report
Mar 16, 2005 10:16 AM|LINK
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
Dinakar Nethi
Life is short. Enjoy it.
***********************
pjmcb
Contributor
2234 Points
459 Posts
Re: Passing parameter from a webpage to a report
Mar 18, 2005 05:16 PM|LINK
I never gave a damn about the meterman until I was the man who had to read the meter.
msfriend
Member
55 Points
11 Posts
Re: Passing parameter from a webpage to a report
Mar 20, 2005 03:27 PM|LINK
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
Dinakar Nethi
Life is short. Enjoy it.
***********************
pjmcb
Contributor
2234 Points
459 Posts
Re: Passing parameter from a webpage to a report
Mar 21, 2005 03:09 PM|LINK
I never gave a damn about the meterman until I was the man who had to read the meter.
msfriend
Member
55 Points
11 Posts
Re: Passing parameter from a webpage to a report
Mar 22, 2005 03:14 AM|LINK
ksminhas
Member
95 Points
22 Posts
Re: Passing parameter from a webpage to a report
Mar 22, 2005 03:02 PM|LINK
msfriend
Member
55 Points
11 Posts
Re: Passing parameter from a webpage to a report
Mar 23, 2005 01:53 AM|LINK
ksminhas
Member
95 Points
22 Posts
Re: Passing parameter from a webpage to a report
Mar 23, 2005 08:33 AM|LINK