Hello All,
I need to create stored procedure that will output information created 3
months after the record was created. For example: if the stored procedure was
run today or based on a date parameter I would like it to output all records

I have successfully used the technique from SQL Server MVP, Erland
Sommarskog to change the multi-value parameter string into a table
with
SELECT ...   WHERE (tblPECGLI.EMPLOYEE_ID IN (SELECT str FROM

Hi,
I am desparate and need any help that I can get on this.  Here is my
problem.  
I've installed SQL 2000 Enterprise and Reporting Services 2000 Enterprise.

I've got the problem that http://myserver/Reports works perfect. I get
the folders and I get the reports.
However, when I try to call http://myserver/ReportServer I do get the
first folder listing, but as soon as I click into a folder I get a

I have a report that I have been redoing.  The underlying T-SQL SP code was
2500 lines.  I have started rewriting it and have wittled a large section of
it down to +/- 50 lines with the help of some of the programming forum
subscribers.  That said, the reason I had such a huge SP ...

I have a report the group is a people name and the detail is their personal
informations. I wuold like insert a row numer in the group, try but in the
list sometime jump a numeber. For example:
...

Is there any way to reuse Objects that returns a collection to my
report in SSRS?
Is it practical? Will it perform okay if I need to join the output
from that object with other data? Say I have a vb.net object that

Is there anyway in SQL2005RS to have optional parameters?
Eg supposing we have a report where we want the user to be able to
select a category, but if the user makes no selection we see ALL
catagories. Is this possible.

I am trying to create a drilthrough report in report designer.  I know
ho to do it if I have a single query but I do not know how to do it if
I have multiple.  What is happening is that I tried to create a signle
query where I can then create a groupings and then have the report

Can you pass a DataSet into the custom code?
If so are there any examples
Thanks

We are testing SQL2008 reporting services on a 2008 server.   We setup RS
for all domain users to have read access.
However, everybody still receives a login prompt when they attempt to first
access RS.   Is this a  security enhancement or a configuration error

I have a textbox with a hyperlink navigation set up to jump to another
report.  the called report has several parameters that I've set up.  The
hyperlink runs fine.  Now I've been asked to have that called report always
run in CSV format.

I have a report where the 2nd parameter dropdown list is populated as a
result of what is selected in the dropdown list 1st parameter.
I find that after I select a value for the 1st parameter, I have to click
"View Report" to populate the values into the 2nd paramater dropdown ...

I am just learning SSRS.  I am coming from a Crystal Reports background.  In
the app that I am upgrading to SSRS, I had a generic report viewer that I
fed the name of the report.  The viewer than opened the report pulled out
the data source and set it and passed through any ...

Can we Have two or three DataSet in one list?
...