Friday, February 24, 2012

Does a table REQUIRE a dataset?

Why is it not possible for me to create a static table in Reporting
services?
I have a table that will be making some calls to a custom assembly, but it
requires NO database queries to build itself. When i leave the "dataset"
area blank, the report will not compile.
Is it really impossible to create static tables in Reporting Services?
Any help would be appreciated.
Thanks!
BrianYou can create what you want, but you still need to have a "dataset" name.
Create a new dataset ( default microsoft sql server type ) then for your
query here's an example.
Select 1 as Col#, 'A' as Col$
Union
Select 2 as Col#, 'B' as Col$
Union
Select 3 as Col#, 'C' as Col$
Union
Select 4 as Col#, 'D' as Col$
Union
Select 5 as Col#, 'E' as Col$
or am i off track on what you want to accomplish?
"G" wrote:
> Why is it not possible for me to create a static table in Reporting
> services?
> I have a table that will be making some calls to a custom assembly, but it
> requires NO database queries to build itself. When i leave the "dataset"
> area blank, the report will not compile.
> Is it really impossible to create static tables in Reporting Services?
> Any help would be appreciated.
> Thanks!
> Brian
>
>

No comments:

Post a Comment