Adding table to report file

I am very new to the SQL report server, but have used other reporting tools before where I could add (or import) a new table of information directly into a report itself. I would do this when I required information in the report that is not part of the datasources tables.

For example, I use it for tying into the report complex sales budget numbers that are not included anywhere in the main datasource. I would simply add the table to my query I created, create my links, and I have a sales vs budget report.

Do you know if this is possible using the SQL reporting tools, or does the table need to be part of the main datasource ?

Thank you in advance.....

Chris B.

hi,

You can create a new dataset with different data source, then embed the table into your report as a subreport.

regards,

Janos

|||

Thanks Janos,

I have not tried it yet, so I will have to play with it a bit to see if that will work for me.

So I assume I can link the sub report based on sales rep, month, category, and customer....

Thanks,

Chris B