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

Adding Entity after model creation

I'm woundering if and how it is possible to add a entity to a report model that is directly associated with a database table after the model has already been created?

Thanks for the help if there is any.

You will need to refresh the Data Source View (.dsv) first to pull in the schema for your new table. You can then right-click on the root node in the Model Designer and choose New->Entity. Set the Binding property of the new entity to the new table.