Report Parameter as Integer

How come I can't assing an ID as type Integer to any of my report
parameters? It always tells me that the datatype is wrong.
I want to make sure I am using the report parameters correctly. How do you
add a parameter to a report that will either be selected from a drop down or
passed in via the querystring?
Thanks in advance,
JoeyThe default is string, click anywhere in the body of the report and go to
Report menu, parameters. Set the datatype as integer. This is also where you
setup dropdown lists.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Joey Fox" <joefoxman@.comcast.net> wrote in message
news:eStHyXkWFHA.2060@.tk2msftngp13.phx.gbl...
> How come I can't assing an ID as type Integer to any of my report
> parameters? It always tells me that the datatype is wrong.
> I want to make sure I am using the report parameters correctly. How do
> you add a parameter to a report that will either be selected from a drop
> down or passed in via the querystring?
> Thanks in advance,
> Joey
>

Report looking at wrong (old) data source

Hi,
I've changed some reports to use a different data source. To do so I
created a new shared data souce called ReportsTest, and changed the
data source for some reports to now point to ReportsTest instead of
the original Reports data source. However I am getting the following
error.
An error has occurred during report processing. (rsProcessingAborted)
Get Online Help
Cannot create a connection to data source 'Reports'.
(rsErrorOpeningConnection) Get Online Help
SQL Server does not exist or access denied.
It's as if the report is still trying to use the original data source
for some reason' It still exists, but I want this report to use the
other data source that I've created. Why is this happening and how
can I fix it'Sorry, just hoping to get some feedback on this. If a report has to
use a particular data source does this data source have to be created
in the report designer and linked to the report here?
Is the name of the data source used by a report hardcoded into the
.rdl file of a report somehow, and not able to be changed in the
report manager'
gearoid_healy@.yahoo.com (Gearoid) wrote in message news:<3d6ebe80.0411050413.1fc8bcfb@.posting.google.com>...
> Hi,
> I've changed some reports to use a different data source. To do so I
> created a new shared data souce called ReportsTest, and changed the
> data source for some reports to now point to ReportsTest instead of
> the original Reports data source. However I am getting the following
> error.
>
> An error has occurred during report processing. (rsProcessingAborted)
> Get Online Help
> Cannot create a connection to data source 'Reports'.
> (rsErrorOpeningConnection) Get Online Help
> SQL Server does not exist or access denied.
>
> It's as if the report is still trying to use the original data source
> for some reason' It still exists, but I want this report to use the
> other data source that I've created. Why is this happening and how
> can I fix it'

Report Headers & Footers

I see the Page Header and Page footer, but what about Report Header and Report Footers? Doesn't look like ssrs has this ability, am I wrong?

I was able to accomplish what I want by following the suggestion in this post:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=377566&SiteID=1

IMO, this is lame. Come on, even Access has a Report Header & Report Footer, what were they thinking? Seems like to get simple stuff done in ssrs you have to basically find hacks and workarounds. Not impressed.

|||

Hello,

Would the table header/footer work for you?

Jarret

|||

Yes, I ended having to use the table header/footer like it is described in the link in my previous post. I still think this is kind of a hack and am wondering why ReportHeader & ReportFooter were left out.

|||

The link in your previous post takes me to another post by you for Parameter Validation Failed. Oh well, glad you got it working.

Maybe I am missing something, but I can't think of any reason why they wouldn't be considered synonymous. Can you give me an example of something a report header can do that a table header can't (or vice versa), just for my knowledge?

Jarret

|||Sorry about that! I have fixed the link to point to the correct article, thanks for pointing that out.