sql server reporting services: I want to clarify.. -- sql server reporting services

I want to clarify..

Alex
6/22/2005 11:44:01 PM

sql server reporting services:

Can we declare any variables in the sql server 2000 reporting services?
because I need to make an array for my tables, for ex: in my database(sql
server) it has many tables like tble27,tble28,tble29,tble30.. etc. all of
the fields inside the tables are the same. every table has
name,age,sex,address. just different records. I was planning on making an
array like tble(i) so i can use the report parameter to just use the
variable for an easy access to whatever my client would prefer to view.

Also just telling me how, and where to declare variables would be a great
help, if it is possible.. advance thank you. please do help me
Diff. Question:
Also how will i access a table from database1 as my report parameter and and
view the records from database2?
--

RE: I want to clarify..

Jan Pieter Posthuma
6/23/2005 2:05:03 AM

Hi,

For your first question you should consider a stored procedure based on a
parameter which returns the proper underlying table. Then you can create a
dataset and use the sp to retrieve the data. Declare in the properties of the
dataset the mapping of the ReportParameter and the parameter nessesary for
the sp.

Every dataset you create in SRS has it's own connection. And those
connection can point to different datasources. So just create two datasources
to your servers and retrieve the information.

Jan Pieter Posthuma

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.