SQL Server Report Builder 3.0, and I can't get the data to the formated report.

[David Edey]

I have data from my dataset appearing in the Query Designer when I execute the query.

The Query Designer asks for parameter, I fill them in and I get data returned. It's a simple SQL query against one view; no joins.

So, the next step is to place a table on the report page to summarise the data, and I get nothing, nada, zip, zilch, zero. I've tried using a matrix and just placing

What am I forgetting?

[ck9663]

You inserted a table on your report, added columns and added fields from the dataset, and you're saying it's not showing anything?


~~ CK

[DEdey]

Yup.

I've since started connecting with someone else's ID (it's a dev environment so security is low) and everything works fine.

So, at this point it's got to be a security issue.

I'll keep poking away at the DBA to give me rights that match the other ID and that should solve the issue.

Thanks,
David...