FETCH in Reporting Services

My name is Scott Moore, I am new to this group. I have worked with RS
for the past year on a learn as I go basis. I need to find a good book
for programming RS. I primarily work in C# and know that you can use
code to create a report in RS. Unfortunatly I am someone that needs
assistance in getting started with something, but once I have that
point in the right direction I can expand on that. I hope I am somewhat
helpful to all that are here and that I can learn a lot from everyone.
HAPPY HOLIDAYS! My question is below.
I wrote a query in SQL using a fetch. It works fine when I run it in
query analyzer, but when I try to run it in RS it does not work. I get
the result from the first select query that sets the cursor. I need to
know if there is a way to get past this first select statement and get
the information I am trying to get. Any help would be appreciated.Just a suggestion - find a work around.
Write a stored procedure instead.
Or avoid using cursors at all costs, unless you're using cursor's specific
functionality.
There are better ways to do simple iterations in SQL Server, rather then
using cursors.
"samoore" <samoore30@.gmail.com> wrote in message
news:1135089582.519825.59000@.g47g2000cwa.googlegroups.com...
> My name is Scott Moore, I am new to this group. I have worked with RS
> for the past year on a learn as I go basis. I need to find a good book
> for programming RS. I primarily work in C# and know that you can use
> code to create a report in RS. Unfortunatly I am someone that needs
> assistance in getting started with something, but once I have that
> point in the right direction I can expand on that. I hope I am somewhat
> helpful to all that are here and that I can learn a lot from everyone.
> HAPPY HOLIDAYS! My question is below.
> I wrote a query in SQL using a fetch. It works fine when I run it in
> query analyzer, but when I try to run it in RS it does not work. I get
> the result from the first select query that sets the cursor. I need to
> know if there is a way to get past this first select statement and get
> the information I am trying to get. Any help would be appreciated.
>