How to use a table with table name starting "@" symbol in dataset

Hi ,

I have a database with a table name called @.budget_tot.

When I run a query in report designer --dataset, it throws an error thinking this is a variable rather

than a table.

Same query works without error in SQL 2005 query window.

example Query;

Select T1.U_Budget From [@.budet_tot] T1

Sonny

SInce no one answered I'll give you my current workaround.

Create a parameter and either make it hidden (with null) or make it internal.

So the report runs without anyone seeing parameter.

Sonny

|||I am rather new to Reporting Services, but in other places if you will enclose your table name with square brackets the name should be accepted. Try [@.budget_tot] instead of @.budget_tot.|||

Hi Kent, Thanks for the reply. This works in SQL qoery analyser but not in report designer.

Sonny