Can't get Instanses of the Report Server through WMI using Non-Administrators access

I'm trying to conncet to Report Server with Non-Administrator user through WMI in compliance with this document: http://msdn2.microsoft.com/en-us/library/ms365170.aspx

When I try to get Instances from MSReportServer_Instance class I get an exception:

In my C# project i have an exception:

System.Runtime.InteropServices.COMException (0x8000000A) at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo) at System.Management.ManagementObjectCollection.ManagementObjectEnumerator.MoveNext()

But, when I give the account Domain Administrators rights all works ok.

What additional rights must I give to the account?

It is a bug. It will be fixed in SQL Server 2005 SP2|||

Could you send me ID number of this bug?

Thanks.

|||

443224

|||Thanks a lot!

Can't get current value of a field in table header

Ok, I give up (again). I have a report that breaks on company number.
I want to display
="Details for Company " & Fields!Company.Value
in the table header (or in a textbox within the body above the table).
However, I only get the value of the first company number in the dataset,
even when it breaks on company. How is this done?
Thank you very much,
Marc MillerAdd a table group with a grouping expression of =Fields!Company.Value
In the table group header your expression will work ="Details for Company "
& Fields!Company.Value
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Marc Miller" <mm1284@.hotmail.com> wrote in message
news:Oa7l51UgEHA.2416@.TK2MSFTNGP10.phx.gbl...
> Ok, I give up (again). I have a report that breaks on company number.
> I want to display
> ="Details for Company " & Fields!Company.Value
> in the table header (or in a textbox within the body above the table).
> However, I only get the value of the first company number in the dataset,
> even when it breaks on company. How is this done?
> Thank you very much,
> Marc Miller
>

cant get any event from FormsAuthentication Sample in the report server ?

Hi i have used

http://msdn2.microsoft.com/en-gb/library/ms160724.aspx

to enable custom security in the report server,now custom security sample is working fine with my report server,

So bigger problem is my Software manager ask me to redesighn

UILogon.aspx page ?

Now the bigger problem is when redesign the UILogon.aspx page

I am having lot of problems in the sample ,thing is i cant get any button event from the

code behind it self ?

Error is saying that

"cannot handle Event 'Public Event Click(sender As Object, e As System.Web.UI.ImageClickEventArgs)' because they do not have the same signature."

Whats is the wrong with this ?

regards

sujithf ?

The only requirement for the method that handles the event is that it must have the same signature (parameters) as the delegate that is defined as the event handler for the event...If we put the Handles clause on a method whose signature does not match the delegate, then the compiler will give us a build error saying, "Method Car_Start cannot handle Event 'Start' because they do not have the same signature."

http://www.knowdotnet.com/articles/creatingevents3.html

http://msdn2.microsoft.com/en-us/library/00wh89xa.aspx

|||

Thank you very much for the help,

now its working with the help of u r answer,,........realy helped me lot

regards

sujithf

sql

Can't Get a Hidden Parameter to Work

I am running 2000 with SP1.
Here's what I've tried so far.
I specified no prompt in the designer (put a blank) and deployed the report.
I got the following error: Parameter validation failed. It is not possible
to provide valid values for all parameters.
I then deleted the prompt in the Report Manager and tried again. It did not
work. I then unchecked the Prompt User box, and it still did not work. In
fact, it kept filling in the prompt field with the name of the parameter.
Therefore, I had to leave the Prompt User box checked. However, for both
scenarios, I got the following error: This report requires a default or
user-defined value for the report parameter 'EmployeeId'. To run or subscribe
to this report, you must provide a parameter value.
Here is the query string I used (not using SSL yet; still testing on my own
machine):
http://<computer
name>/Reports/Pages/Report.aspx?ItemPath=/Emileage/Emileage_Aging_Report_ByEmployee&EmployeeId=0000103518
The EmployeeId is a string so I was not sure how to denote that. I have
tried this with quotes and without quotes around the EmployeeId value, and
neither works.
The employee id is the third parameter. Does it need to be the first one?
Any help would be greatly appreciated.
LizMy suggestion is to first get it working without being hidden.
Your URL is wrong. Don't use /reports use reportserver like this. It will
pull up the report but it will not if I remember correctly fill in your
parameters for you. /reports is reportmanager, the portal that ships with
RS. reportserver is the actual Reporting Services asp.net application.
http://server/reportserver?/Sales/Northwest/Employee Sales
Report&rs:Command=Render&EmployeeID=1234Also make sure your parameter name
matches your case exactly, it is (unfortunately) case sensitive.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Liz" <Liz@.discussions.microsoft.com> wrote in message
news:FB6DFF78-8495-44E0-91C5-E16D81F3BF57@.microsoft.com...
>I am running 2000 with SP1.
> Here's what I've tried so far.
> I specified no prompt in the designer (put a blank) and deployed the
> report.
> I got the following error: Parameter validation failed. It is not possible
> to provide valid values for all parameters.
> I then deleted the prompt in the Report Manager and tried again. It did
> not
> work. I then unchecked the Prompt User box, and it still did not work.
> In
> fact, it kept filling in the prompt field with the name of the parameter.
> Therefore, I had to leave the Prompt User box checked. However, for both
> scenarios, I got the following error: This report requires a default or
> user-defined value for the report parameter 'EmployeeId'. To run or
> subscribe
> to this report, you must provide a parameter value.
> Here is the query string I used (not using SSL yet; still testing on my
> own
> machine):
> http://<computer
> name>/Reports/Pages/Report.aspx?ItemPath=/Emileage/Emileage_Aging_Report_ByEmployee&EmployeeId=0000103518
> The EmployeeId is a string so I was not sure how to denote that. I have
> tried this with quotes and without quotes around the EmployeeId value, and
> neither works.
> The employee id is the third parameter. Does it need to be the first
> one?
> Any help would be greatly appreciated.
> Liz
>|||Yippee! That worked!!
Where can I get some more information on hidden parameters? I looked at the
Books Online but there is almost nothing on Reporting Services. I also have
"The Hitchhiker's Guide" which is a great book, but it doesn't have enough on
hidden parameters. I will, however, go and look at it again. I might get
more out of it this time:-)
Thanks so much!
Liz
"Bruce L-C [MVP]" wrote:
> My suggestion is to first get it working without being hidden.
> Your URL is wrong. Don't use /reports use reportserver like this. It will
> pull up the report but it will not if I remember correctly fill in your
> parameters for you. /reports is reportmanager, the portal that ships with
> RS. reportserver is the actual Reporting Services asp.net application.
> http://server/reportserver?/Sales/Northwest/Employee Sales
> Report&rs:Command=Render&EmployeeID=1234Also make sure your parameter name
> matches your case exactly, it is (unfortunately) case sensitive.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Liz" <Liz@.discussions.microsoft.com> wrote in message
> news:FB6DFF78-8495-44E0-91C5-E16D81F3BF57@.microsoft.com...
> >I am running 2000 with SP1.
> >
> > Here's what I've tried so far.
> >
> > I specified no prompt in the designer (put a blank) and deployed the
> > report.
> > I got the following error: Parameter validation failed. It is not possible
> > to provide valid values for all parameters.
> >
> > I then deleted the prompt in the Report Manager and tried again. It did
> > not
> > work. I then unchecked the Prompt User box, and it still did not work.
> > In
> > fact, it kept filling in the prompt field with the name of the parameter.
> > Therefore, I had to leave the Prompt User box checked. However, for both
> > scenarios, I got the following error: This report requires a default or
> > user-defined value for the report parameter 'EmployeeId'. To run or
> > subscribe
> > to this report, you must provide a parameter value.
> >
> > Here is the query string I used (not using SSL yet; still testing on my
> > own
> > machine):
> > http://<computer
> > name>/Reports/Pages/Report.aspx?ItemPath=/Emileage/Emileage_Aging_Report_ByEmployee&EmployeeId=0000103518
> >
> > The EmployeeId is a string so I was not sure how to denote that. I have
> > tried this with quotes and without quotes around the EmployeeId value, and
> > neither works.
> >
> > The employee id is the third parameter. Does it need to be the first
> > one?
> >
> > Any help would be greatly appreciated.
> >
> > Liz
> >
> >
>
>|||I suggest searching 2005 books on-line on the microsoft site. For things
like url integration absolutely nothing has changed between 2000 and 2005.
How you do hidden parameters I believe has changed. There are some new
features (multi-select parameters, end user sorting) but that does not
affect URL integration. They have lots of good documentation on URL
integration (was not there in the 2000 docs).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Liz" <Liz@.discussions.microsoft.com> wrote in message
news:E328C5E9-1894-4C6F-AB8A-20904F1527D6@.microsoft.com...
> Yippee! That worked!!
> Where can I get some more information on hidden parameters? I looked at
> the
> Books Online but there is almost nothing on Reporting Services. I also
> have
> "The Hitchhiker's Guide" which is a great book, but it doesn't have enough
> on
> hidden parameters. I will, however, go and look at it again. I might get
> more out of it this time:-)
> Thanks so much!
> Liz
> "Bruce L-C [MVP]" wrote:
>> My suggestion is to first get it working without being hidden.
>> Your URL is wrong. Don't use /reports use reportserver like this. It will
>> pull up the report but it will not if I remember correctly fill in your
>> parameters for you. /reports is reportmanager, the portal that ships with
>> RS. reportserver is the actual Reporting Services asp.net application.
>> http://server/reportserver?/Sales/Northwest/Employee Sales
>> Report&rs:Command=Render&EmployeeID=1234Also make sure your parameter
>> name
>> matches your case exactly, it is (unfortunately) case sensitive.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Liz" <Liz@.discussions.microsoft.com> wrote in message
>> news:FB6DFF78-8495-44E0-91C5-E16D81F3BF57@.microsoft.com...
>> >I am running 2000 with SP1.
>> >
>> > Here's what I've tried so far.
>> >
>> > I specified no prompt in the designer (put a blank) and deployed the
>> > report.
>> > I got the following error: Parameter validation failed. It is not
>> > possible
>> > to provide valid values for all parameters.
>> >
>> > I then deleted the prompt in the Report Manager and tried again. It
>> > did
>> > not
>> > work. I then unchecked the Prompt User box, and it still did not work.
>> > In
>> > fact, it kept filling in the prompt field with the name of the
>> > parameter.
>> > Therefore, I had to leave the Prompt User box checked. However, for
>> > both
>> > scenarios, I got the following error: This report requires a default
>> > or
>> > user-defined value for the report parameter 'EmployeeId'. To run or
>> > subscribe
>> > to this report, you must provide a parameter value.
>> >
>> > Here is the query string I used (not using SSL yet; still testing on my
>> > own
>> > machine):
>> > http://<computer
>> > name>/Reports/Pages/Report.aspx?ItemPath=/Emileage/Emileage_Aging_Report_ByEmployee&EmployeeId=0000103518
>> >
>> > The EmployeeId is a string so I was not sure how to denote that. I
>> > have
>> > tried this with quotes and without quotes around the EmployeeId value,
>> > and
>> > neither works.
>> >
>> > The employee id is the third parameter. Does it need to be the first
>> > one?
>> >
>> > Any help would be greatly appreciated.
>> >
>> > Liz
>> >
>> >
>>

Can't generate report when there are lot of data.

Hi there,
I have a very simple report which includes only one table to reflect
"event" table in database. It works great when there are few data like
1000 rows, but when there are lot of data like 500000 rows, the report
will run about 15 minutes and give me an error "Execution
'uwug2g55hbfrtu55pqh4a1bl' cannot be found (rsExecutionNotFound)", and
at the same time one dialogue will show up to let me login to connect
to my machine. Why is that? I google the group, got no answer.
I am sure I didn't delete anything in ReportServer and
ReportServerTempDB, is there any setting I should change?
Thanks in advance.
HenryHi,
Just make sure you have created datasource and that you have given the
userid and password. if you have given, revisit the datasource and save again.
Try using pagination, ie may be you can display about 50 records in a page
so that the fetching of remaining paged records happen in the background.
Amarnath
"fanh@.tycoelectronics.com" wrote:
> Hi there,
> I have a very simple report which includes only one table to reflect
> "event" table in database. It works great when there are few data like
> 1000 rows, but when there are lot of data like 500000 rows, the report
> will run about 15 minutes and give me an error "Execution
> 'uwug2g55hbfrtu55pqh4a1bl' cannot be found (rsExecutionNotFound)", and
> at the same time one dialogue will show up to let me login to connect
> to my machine. Why is that? I google the group, got no answer.
> I am sure I didn't delete anything in ReportServer and
> ReportServerTempDB, is there any setting I should change?
> Thanks in advance.
> Henry
>|||Querying 500,000 records is nothing (I query 185 million row tables).
Returning that many can be problematic. I assume you are not looking at that
many records. You should make sure to use query parameters and bring back
only the data you need. Use query parameters instead of filters.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Amarnath" <Amarnath@.discussions.microsoft.com> wrote in message
news:B5F31853-0A41-4AAE-947C-0BF5B1565BBA@.microsoft.com...
> Hi,
> Just make sure you have created datasource and that you have given the
> userid and password. if you have given, revisit the datasource and save
> again.
> Try using pagination, ie may be you can display about 50 records in a page
> so that the fetching of remaining paged records happen in the background.
> Amarnath
>
> "fanh@.tycoelectronics.com" wrote:
>> Hi there,
>> I have a very simple report which includes only one table to reflect
>> "event" table in database. It works great when there are few data like
>> 1000 rows, but when there are lot of data like 500000 rows, the report
>> will run about 15 minutes and give me an error "Execution
>> 'uwug2g55hbfrtu55pqh4a1bl' cannot be found (rsExecutionNotFound)", and
>> at the same time one dialogue will show up to let me login to connect
>> to my machine. Why is that? I google the group, got no answer.
>> I am sure I didn't delete anything in ReportServer and
>> ReportServerTempDB, is there any setting I should change?
>> Thanks in advance.
>> Henry
>>|||I don't use any filter. It is only a simple report with a simple table.
For our system, it is very easy to have million events within a short
time(2 days or so). The machine has 1G RAM and 1.5G PF, the report
limitation is about 230K rows of data, more than that will get the
error. How can I let customer Stop if they want to check more data? Can
I write some function to check rows of data before generating the
report?
Thanks a lot.
Henry
On Oct 26, 8:36 am, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> Querying 500,000 records is nothing (I query 185 million row tables).
> Returning that many can be problematic. I assume you are not looking at that
> many records. You should make sure to use query parameters and bring back
> only the data you need. Use query parameters instead of filters.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Amarnath" <Amarn...@.discussions.microsoft.com> wrote in messagenews:B5F31853-0A41-4AAE-947C-0BF5B1565BBA@.microsoft.com...
>
> > Hi,
> > Just make sure you have created datasource and that you have given the
> > userid and password. if you have given, revisit the datasource and save
> > again.
> > Try using pagination, ie may be you can display about 50 records in a page
> > so that the fetching of remaining paged records happen in the background.
> > Amarnath
> > "f...@.tycoelectronics.com" wrote:
> >> Hi there,
> >> I have a very simple report which includes only one table to reflect
> >> "event" table in database. It works great when there are few data like
> >> 1000 rows, but when there are lot of data like 500000 rows, the report
> >> will run about 15 minutes and give me an error "Execution
> >> 'uwug2g55hbfrtu55pqh4a1bl' cannot be found (rsExecutionNotFound)", and
> >> at the same time one dialogue will show up to let me login to connect
> >> to my machine. Why is that? I google the group, got no answer.
> >> I am sure I didn't delete anything in ReportServer and
> >> ReportServerTempDB, is there any setting I should change?
> >> Thanks in advance.
> >> Henry- Hide quoted text -- Show quoted text -|||A human does not look at a million events. You should have query parameters
that allows the user to get to the timeframe or the even they are interested
in. Even if they are bringing it into another program like Excel, Excel has
a limit of 65,000 rows per sheet.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<fanh@.tycoelectronics.com> wrote in message
news:1162220059.488944.185660@.i42g2000cwa.googlegroups.com...
>I don't use any filter. It is only a simple report with a simple table.
> For our system, it is very easy to have million events within a short
> time(2 days or so). The machine has 1G RAM and 1.5G PF, the report
> limitation is about 230K rows of data, more than that will get the
> error. How can I let customer Stop if they want to check more data? Can
> I write some function to check rows of data before generating the
> report?
> Thanks a lot.
> Henry
> On Oct 26, 8:36 am, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
> wrote:
>> Querying 500,000 records is nothing (I query 185 million row tables).
>> Returning that many can be problematic. I assume you are not looking at
>> that
>> many records. You should make sure to use query parameters and bring back
>> only the data you need. Use query parameters instead of filters.
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Amarnath" <Amarn...@.discussions.microsoft.com> wrote in
>> messagenews:B5F31853-0A41-4AAE-947C-0BF5B1565BBA@.microsoft.com...
>>
>> > Hi,
>> > Just make sure you have created datasource and that you have given the
>> > userid and password. if you have given, revisit the datasource and save
>> > again.
>> > Try using pagination, ie may be you can display about 50 records in a
>> > page
>> > so that the fetching of remaining paged records happen in the
>> > background.
>> > Amarnath
>> > "f...@.tycoelectronics.com" wrote:
>> >> Hi there,
>> >> I have a very simple report which includes only one table to reflect
>> >> "event" table in database. It works great when there are few data like
>> >> 1000 rows, but when there are lot of data like 500000 rows, the report
>> >> will run about 15 minutes and give me an error "Execution
>> >> 'uwug2g55hbfrtu55pqh4a1bl' cannot be found (rsExecutionNotFound)", and
>> >> at the same time one dialogue will show up to let me login to connect
>> >> to my machine. Why is that? I google the group, got no answer.
>> >> I am sure I didn't delete anything in ReportServer and
>> >> ReportServerTempDB, is there any setting I should change?
>> >> Thanks in advance.
>> >> Henry- Hide quoted text -- Show quoted text -
>|||Henry,
what do you think you are going to do with 500,000 rows in a
report...?
I once had a customer (1993) who said the product we were selling was
no good because she could not print a list of all the customers her
company had...it was a bank...and they had 3,000,000
customers.....she could not get to grips with the idea that there is
actually nothing useful you can do with a printout of 3,000,000
customers...
Do do something useful with a report, like make a decision that makes
your company money, it generally needs to be more focused than 'all the
transactions we have had recently'...
Best Regards
Peter
fanh@.tycoelectronics.com wrote:
> I don't use any filter. It is only a simple report with a simple table.
> For our system, it is very easy to have million events within a short
> time(2 days or so). The machine has 1G RAM and 1.5G PF, the report
> limitation is about 230K rows of data, more than that will get the
> error. How can I let customer Stop if they want to check more data? Can
> I write some function to check rows of data before generating the
> report?
> Thanks a lot.
> Henry
> On Oct 26, 8:36 am, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
> wrote:
> > Querying 500,000 records is nothing (I query 185 million row tables).
> > Returning that many can be problematic. I assume you are not looking at that
> > many records. You should make sure to use query parameters and bring back
> > only the data you need. Use query parameters instead of filters.
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Amarnath" <Amarn...@.discussions.microsoft.com> wrote in messagenews:B5F31853-0A41-4AAE-947C-0BF5B1565BBA@.microsoft.com...
> >
> >
> >
> > > Hi,
> > > Just make sure you have created datasource and that you have given the
> > > userid and password. if you have given, revisit the datasource and save
> > > again.
> >
> > > Try using pagination, ie may be you can display about 50 records in a page
> > > so that the fetching of remaining paged records happen in the background.
> >
> > > Amarnath
> >
> > > "f...@.tycoelectronics.com" wrote:
> >
> > >> Hi there,
> >
> > >> I have a very simple report which includes only one table to reflect
> > >> "event" table in database. It works great when there are few data like
> > >> 1000 rows, but when there are lot of data like 500000 rows, the report
> > >> will run about 15 minutes and give me an error "Execution
> > >> 'uwug2g55hbfrtu55pqh4a1bl' cannot be found (rsExecutionNotFound)", and
> > >> at the same time one dialogue will show up to let me login to connect
> > >> to my machine. Why is that? I google the group, got no answer.
> > >> I am sure I didn't delete anything in ReportServer and
> > >> ReportServerTempDB, is there any setting I should change?
> > >> Thanks in advance.
> >
> > >> Henry- Hide quoted text -- Show quoted text -|||I agree with you, I already use a lot of parameters to limit the
report, otherwise it will be huge.
Now the question is how I can limit customers to generate a big report?
Can I write some function to count the data rows first? If more than a
specific number, then show customer a dialog? I don't know I can do
this in RS or not.
Thanks.
Henry
On Oct 30, 12:36 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> A human does not look at a million events. You should have query parameters
> that allows the user to get to the timeframe or the even they are interested
> in. Even if they are bringing it into another program like Excel, Excel has
> a limit of 65,000 rows per sheet.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> <f...@.tycoelectronics.com> wrote in messagenews:1162220059.488944.185660@.i42g2000cwa.googlegroups.com...
>
> >I don't use any filter. It is only a simple report with a simple table.
> > For our system, it is very easy to have million events within a short
> > time(2 days or so). The machine has 1G RAM and 1.5G PF, the report
> > limitation is about 230K rows of data, more than that will get the
> > error. How can I let customer Stop if they want to check more data? Can
> > I write some function to check rows of data before generating the
> > report?
> > Thanks a lot.
> > Henry
> > On Oct 26, 8:36 am, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
> > wrote:
> >> Querying 500,000 records is nothing (I query 185 million row tables).
> >> Returning that many can be problematic. I assume you are not looking at
> >> that
> >> many records. You should make sure to use query parameters and bring back
> >> only the data you need. Use query parameters instead of filters.
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >> "Amarnath" <Amarn...@.discussions.microsoft.com> wrote in
> >> messagenews:B5F31853-0A41-4AAE-947C-0BF5B1565BBA@.microsoft.com...
> >> > Hi,
> >> > Just make sure you have created datasource and that you have given the
> >> > userid and password. if you have given, revisit the datasource and save
> >> > again.
> >> > Try using pagination, ie may be you can display about 50 records in a
> >> > page
> >> > so that the fetching of remaining paged records happen in the
> >> > background.
> >> > Amarnath
> >> > "f...@.tycoelectronics.com" wrote:
> >> >> Hi there,
> >> >> I have a very simple report which includes only one table to reflect
> >> >> "event" table in database. It works great when there are few data like
> >> >> 1000 rows, but when there are lot of data like 500000 rows, the report
> >> >> will run about 15 minutes and give me an error "Execution
> >> >> 'uwug2g55hbfrtu55pqh4a1bl' cannot be found (rsExecutionNotFound)", and
> >> >> at the same time one dialogue will show up to let me login to connect
> >> >> to my machine. Why is that? I google the group, got no answer.
> >> >> I am sure I didn't delete anything in ReportServer and
> >> >> ReportServerTempDB, is there any setting I should change?
> >> >> Thanks in advance.
> >> >> Henry- Hide quoted text -- Show quoted text -- Hide quoted text -- Show quoted text -

Can't find Report Viewer/Explorer WebPart (SP v3+SQL 2005)

Hello all,
I'm new with SP v3 and the Reporting Services of SQL Server 2005.
I did a prototyp report and show it with "SQL Reporting Services
Report"-WebPart, but I can't find the WebParts Report Viewer and
Explorer in the WebPart Gallery.
Please, could somebody give me a clue where the problem could be, or
how I could isolate the problem area.
Cheers
MarcHave you uploaded the web parts to the SharePoint site? I don't think they
come preinstalled with SharePoint.
On the server with SQL Server 2005 installed, you should find the web parts
in a cab at
C:\Program Files\Microsoft SQL Server\90\Tools\Reporting
Services\SharePoint\RSWebParts.cab
Copy the Cab file to your SharePoint server and install it using Stsadm or
any other program you use to deploy web part packages (cabs).
Kaisa M. Lindahl
"Marc" <M.Thierer@.web.de> wrote in message
news:1139324142.873377.225310@.g43g2000cwa.googlegroups.com...
> Hello all,
>
> I'm new with SP v3 and the Reporting Services of SQL Server 2005.
> I did a prototyp report and show it with "SQL Reporting Services
> Report"-WebPart, but I can't find the WebParts Report Viewer and
> Explorer in the WebPart Gallery.
> Please, could somebody give me a clue where the problem could be, or
> how I could isolate the problem area.
>
> Cheers
> Marc
>

Can't find Report Designer

I think I've installed all of the required pieces (SRS, already had VS.NET
2005 installed, BI tools). But the BI tools (e.g. Report Designer) don't
appear on a menu anywhere, and the desired project type for reports doesn't
appear in VS.NET.
What might I have done wrong?
Thanks.
--
Dan Cooperstock
DONATION web site: http://www.FreeDonationSoftware.org
DONATION Support forums: http://forums.FreeDonationSoftware.org
E-mail: mailto:info@.FreeDonationSoftware.org
Home Phone: 416-423-9064If report designer was installed before VS 2005 then it will not be
integrated (that happened to me). Reinstall Report Designer from the SQL
Server 2005 media.
Note that RS 2005 comes with a version of VS so you did not have to have VS
2005 (this is different than the case with RS 2000).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Dan Cooperstock" <dancoo@.newsgroups.nospam> wrote in message
news:Xns9876ADBF155ACdcoopssympaticoca@.207.46.248.16...
>I think I've installed all of the required pieces (SRS, already had VS.NET
> 2005 installed, BI tools). But the BI tools (e.g. Report Designer) don't
> appear on a menu anywhere, and the desired project type for reports
> doesn't
> appear in VS.NET.
> What might I have done wrong?
> Thanks.
>
> --
> Dan Cooperstock
> DONATION web site: http://www.FreeDonationSoftware.org
> DONATION Support forums: http://forums.FreeDonationSoftware.org
> E-mail: mailto:info@.FreeDonationSoftware.org
> Home Phone: 416-423-9064|||"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in
news:eNhaYvEBHHA.3836@.TK2MSFTNGP02.phx.gbl:
> If report designer was installed before VS 2005 then it will not be
> integrated (that happened to me). Reinstall Report Designer from the
> SQL Server 2005 media.
> Note that RS 2005 comes with a version of VS so you did not have to
> have VS 2005 (this is different than the case with RS 2000).
>
Nope, VS.NET 2005 was installed first. I have tried installing SQL Server
(including Report Designer - via BI tools) a few times now, and nothing
appears in VS.NET.
Dan Cooperstock
DONATION web site: http://www.FreeDonationSoftware.org
DONATION Support forums: http://forums.FreeDonationSoftware.org
E-mail: mailto:info@.FreeDonationSoftware.org
Home Phone: 416-423-9064|||Not sure what to say except to make sure you are doing client tools instead
of the server but it sounds like you are doing that.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Dan Cooperstock" <dancoo@.newsgroups.nospam> wrote in message
news:Xns9876B678377E8dcoopssympaticoca@.207.46.248.16...
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in
> news:eNhaYvEBHHA.3836@.TK2MSFTNGP02.phx.gbl:
>> If report designer was installed before VS 2005 then it will not be
>> integrated (that happened to me). Reinstall Report Designer from the
>> SQL Server 2005 media.
>> Note that RS 2005 comes with a version of VS so you did not have to
>> have VS 2005 (this is different than the case with RS 2000).
>>
> Nope, VS.NET 2005 was installed first. I have tried installing SQL Server
> (including Report Designer - via BI tools) a few times now, and nothing
> appears in VS.NET.
>
> --
> Dan Cooperstock
> DONATION web site: http://www.FreeDonationSoftware.org
> DONATION Support forums: http://forums.FreeDonationSoftware.org
> E-mail: mailto:info@.FreeDonationSoftware.org
> Home Phone: 416-423-9064|||Hello Dan,
Would you please try to check whether you have the Business Intelligence
Projects under the folder
%Program Files%\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies ?
Also, please let me know your Visual Studio version.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||weilu@.online.microsoft.com (Wei Lu [MSFT]) wrote in news:ghfrDiJBHHA.4432
@.TK2MSFTNGXA01.phx.gbl:
> Please check you have the Business Intelligence projects under
> Program Files/Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies
The only thing I see there that looks relevant is
Microsoft.ReportDesigner.dll.
I can also clarify that while I don't see the project types when I go to
add a new Project to the solution (which the installer suggested I should I
have) I did discover that under adding a new Item to a project, I do have
Report, and it is indeed an SRS Report that it creates.
Dan Cooperstock
DONATION web site: http://www.FreeDonationSoftware.org
DONATION Support forums: http://forums.FreeDonationSoftware.org
E-mail: mailto:info@.FreeDonationSoftware.org
Home Phone: 416-423-9064|||When you do New Project you should have Business Intelligence Projects as a
choice.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Dan Cooperstock" <dancoo@.newsgroups.nospam> wrote in message
news:Xns987755AA3C448dcoopssympaticoca@.207.46.248.16...
> weilu@.online.microsoft.com (Wei Lu [MSFT]) wrote in news:ghfrDiJBHHA.4432
> @.TK2MSFTNGXA01.phx.gbl:
>> Please check you have the Business Intelligence projects under
>> Program Files/Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies
> The only thing I see there that looks relevant is
> Microsoft.ReportDesigner.dll.
> I can also clarify that while I don't see the project types when I go to
> add a new Project to the solution (which the installer suggested I should
> I
> have) I did discover that under adding a new Item to a project, I do have
> Report, and it is indeed an SRS Report that it creates.
>
> --
> Dan Cooperstock
> DONATION web site: http://www.FreeDonationSoftware.org
> DONATION Support forums: http://forums.FreeDonationSoftware.org
> E-mail: mailto:info@.FreeDonationSoftware.org
> Home Phone: 416-423-9064|||"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in
news:unK9bGNBHHA.3560@.TK2MSFTNGP03.phx.gbl:
> When you do New Project you should have Business Intelligence Projects
> as a choice.
>
Yes, I agree that I should. But I don't. The fact that I don't is what led
me to post about this in the first place!
Dan Cooperstock
DONATION web site: http://www.FreeDonationSoftware.org
DONATION Support forums: http://forums.FreeDonationSoftware.org
E-mail: mailto:info@.FreeDonationSoftware.org
Home Phone: 416-423-9064|||I have had people doing things with VS 2005 thinking they were using the
report designer when really they were dealing with the new controls (which
also allow designing reports). You wouldn't believe how many times people
have not installed from the SQL Server media the client BI tools. That is
why I am making sure.
I had exactly what you are talking about happen but it appeared when I
re-installed. Have you tried removing (not just re-installing) but first
removing the BI tools and then re-installing.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Dan Cooperstock" <dancoo@.newsgroups.nospam> wrote in message
news:Xns9877DF702FAE7dcoopssympaticoca@.207.46.248.16...
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in
> news:unK9bGNBHHA.3560@.TK2MSFTNGP03.phx.gbl:
>> When you do New Project you should have Business Intelligence Projects
>> as a choice.
>>
> Yes, I agree that I should. But I don't. The fact that I don't is what led
> me to post about this in the first place!
>
> --
> Dan Cooperstock
> DONATION web site: http://www.FreeDonationSoftware.org
> DONATION Support forums: http://forums.FreeDonationSoftware.org
> E-mail: mailto:info@.FreeDonationSoftware.org
> Home Phone: 416-423-9064|||"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in
news:uZSipgaBHHA.4592@.TK2MSFTNGP03.phx.gbl:
> I have had people doing things with VS 2005 thinking they were using
> the report designer when really they were dealing with the new
> controls (which also allow designing reports). You wouldn't believe
> how many times people have not installed from the SQL Server media the
> client BI tools. That is why I am making sure.
> I had exactly what you are talking about happen but it appeared when I
> re-installed. Have you tried removing (not just re-installing) but
> first removing the BI tools and then re-installing.
>
Yes, uninstalling my whole SQL Server installation and then re-installing
it fixed it - I now have the Business Intelligence projects.
Thanks!
--
Dan Cooperstock
DONATION web site: http://www.FreeDonationSoftware.org
DONATION Support forums: http://forums.FreeDonationSoftware.org
E-mail: mailto:info@.FreeDonationSoftware.org
Home Phone: 416-423-9064|||Good. Glad it is fixed.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Dan Cooperstock" <dancoo@.newsgroups.nospam> wrote in message
news:Xns987892BF57C28dcoopssympaticoca@.207.46.248.16...
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in
> news:uZSipgaBHHA.4592@.TK2MSFTNGP03.phx.gbl:
>> I have had people doing things with VS 2005 thinking they were using
>> the report designer when really they were dealing with the new
>> controls (which also allow designing reports). You wouldn't believe
>> how many times people have not installed from the SQL Server media the
>> client BI tools. That is why I am making sure.
>> I had exactly what you are talking about happen but it appeared when I
>> re-installed. Have you tried removing (not just re-installing) but
>> first removing the BI tools and then re-installing.
> Yes, uninstalling my whole SQL Server installation and then re-installing
> it fixed it - I now have the Business Intelligence projects.
> Thanks!
> --
> Dan Cooperstock
> DONATION web site: http://www.FreeDonationSoftware.org
> DONATION Support forums: http://forums.FreeDonationSoftware.org
> E-mail: mailto:info@.FreeDonationSoftware.org
> Home Phone: 416-423-9064

Can't find Report Builder

I've installed SQL Server 2005 Developer Edition along with Visual Studio 2005. The SQL management consol indicates that Reporting Services is running, but I can't seem to find the Report Builder for the life of me. Is it integrated into Visual Studio somewhere?Report Builder is a ClickOnce app that is installed and run from the web. If you go to the web interface for SSRS you should see a button towards the top of the web page that will launch Report Builder.sql

Can't find properties

This is the first time I've used SSRS. I've created a report and in preparation for deploying it I am trying to find where I set the properties. In Visual Studio 2005, in the Solution Explorer I right click on my .rdl file and select properties. The only properties listed are File Name (which is changeable) and File Path (which is not changeable). The property pages icon in the same dialog box is greyed out. Am I missing someghing? Any help would be greatly appreciated.

Thanks.

Go to the layout tab and try clicking on an area outside of the white area where you place your report objects. This should give you the report properties. Is that what you're looking for?

There is also a report properties dialog that will let you set most of the report properties. Go to the Report menu and select Report Properties. You have to have a report open in the designer for the Report menu to even be there.

|||

Thank you very much for the tip, I can see a number of properties of the report. However I still cannot find where to set the following properties

OverWriteDataSources:

TargetDataSourceFolder:

TargetRootFolder:

TargetServerURL:

I couldn't see these deployment properties where you pointed. Am I still missing something? Sorry if I seem kind of slow.

|||

These are properties of the report solution:

After you opened a report project, go to the VS Solution Explorer window. Right-click your report solution and select "Properties". The popup-dialog will contain the four properties you are looking for.

-- Robert

|||

Robert,

Thank you for the feed back. I've tried this many times now and I keep getting the same thing i.e. Open my project report, go to the VS Solution Explorer window under Reports I highlight the name of my report (Report1.rdl) right click on that report and I get a property window which only has two properties File Name: (which is editable) and File Path: (which is uneditable).

Do I possibly not have SSRS installed properly? This seems a simple thing but it is driving me crazy. Thanks for your help.

Bill

|||

Right-click on the root of the tree shown in the VS Solution Explorer. The root of the tree represents the entire report project - do not select a particular report.

-- Robert

|||

Robert,

Thank you so very much, I tried every level in the VS Solution Explorer BUT the root. Who would have thought! All of the documentation and tutorials were not as clear as your last note. Thank you again.

Bill

Can't find how to add a line feed to a textbox

Hello,
I'm creating a report with a textbox that contains a field from the dataset
and some hard text (something like =First(Fields!MyField.Value) & "
TheTextPart"). This works, but when I try to do a shift+enter (line feed) I
get an error "The value expresxsion for the textbox 'textbox7' contains an
error: [BC30648] String constants must end with a double quote".
Is there any way to add a line feed / carriage return in a text box?
Thanks!
Ricktry this:
=First(Fields!MyField.Value) & vbcrlf & "The Second Line" & vbcrlf &
"The Third Line"|||Brilliant! Thanks Sleepy!
"SleepyLab" <david.blancard@.fairmont.com> wrote in message
news:1187036726.406106.312410@.d55g2000hsg.googlegroups.com...
> try this:
> =First(Fields!MyField.Value) & vbcrlf & "The Second Line" & vbcrlf &
> "The Third Line"
>

Cant find error

I am developing a new report in VS 2005 with Reporting Services 2005
installed. I go to preview the report, and I get this:
"The definition of report blah is invalid. An internal error occurred on
the report server. See the error log for more details."
I have been looking everywhere for these error logs, and cant seem to find
one. I have checked my local event viewer and program files\mssql.3\logs, as
well as the remote Sql Server's event logs, rs logs, etc.
All the docs on Google point me to where the web server keeps their logs at
, but I am just tryign to preview a dev version locally.
Any help would be greatly appreciated.
thanks!On Aug 20, 4:50 pm, Carl Henthorn
<CarlHenth...@.discussions.microsoft.com> wrote:
> I am developing a new report in VS 2005 with Reporting Services 2005
> installed. I go to preview the report, and I get this:
> "The definition of report blah is invalid. An internal error occurred on
> the report server. See the error log for more details."
> I have been looking everywhere for these error logs, and cant seem to find
> one. I have checked my local event viewer and program files\mssql.3\logs, as
> well as the remote Sql Server's event logs, rs logs, etc.
> All the docs on Google point me to where the web server keeps their logs at
> , but I am just tryign to preview a dev version locally.
> Any help would be greatly appreciated.
> thanks!
In general, this is a very vague error. If you can remember the last
thing you changed before you got the error, that's the first place to
start. Also, depending on the number of SQL Services you have
installed (i.e., SSRS, SSIS, SSAS), it could be located in a different
MSSQL. directory. On my local machine, the SSRS logs are located in
the following location:
C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services
\LogFiles
Hope this is helpful.
Regards,
Enrique Martinez
Sr. Software Consultant

Can't export to PDF with hidden group

I have a report that uses a matrix control to display the data. After
spending hours on the report getting it to look right in Report Manager, I
went to export to PDF and could not. I got the error "Internet Explorer
cannot download format=PDF".
So I proceeded to recreate the report step by step. At each step, I
deployed, ran, and try to export to pdf.
The problem comes when I have a group make the visible property=false.
My work around is to change the Font color to white and disable growing.
Is this a known issue and is being worked on or should I report this to MS?Please email me a copy of your .rdl and .rdl.data file so I can take a look.
Also, please send me a copy of the error you're seeing in the latest log
file in your /ReportServer/LogFiles directory.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"David" <David@.discussions.microsoft.com> wrote in message
news:AC2E1B8D-CB2F-4AF5-BEF9-F72A470BC626@.microsoft.com...
>I have a report that uses a matrix control to display the data. After
> spending hours on the report getting it to look right in Report Manager, I
> went to export to PDF and could not. I got the error "Internet Explorer
> cannot download format=PDF".
> So I proceeded to recreate the report step by step. At each step, I
> deployed, ran, and try to export to pdf.
> The problem comes when I have a group make the visible property=false.
> My work around is to change the Font color to white and disable growing.
> Is this a known issue and is being worked on or should I report this to
> MS?|||I would but I need your email. You can send it to:
david_perkins a t concentra d o t com
"Donovan Smith [MSFT]" wrote:
> Please email me a copy of your .rdl and .rdl.data file so I can take a look.
> Also, please send me a copy of the error you're seeing in the latest log
> file in your /ReportServer/LogFiles directory.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "David" <David@.discussions.microsoft.com> wrote in message
> news:AC2E1B8D-CB2F-4AF5-BEF9-F72A470BC626@.microsoft.com...
> >I have a report that uses a matrix control to display the data. After
> > spending hours on the report getting it to look right in Report Manager, I
> > went to export to PDF and could not. I got the error "Internet Explorer
> > cannot download format=PDF".
> >
> > So I proceeded to recreate the report step by step. At each step, I
> > deployed, ran, and try to export to pdf.
> >
> > The problem comes when I have a group make the visible property=false.
> >
> > My work around is to change the Font color to white and disable growing.
> >
> > Is this a known issue and is being worked on or should I report this to
> > MS?
>
>|||David sent me a copy of his report and I'm investigating. A second repro
certainly wouldn't hurt anything so please email me a copy of your .rdl and
.rdl.data file so I can take a look.
Thanks.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Goncalo" <Goncalo@.discussions.microsoft.com> wrote in message
news:87CB2105-49AB-440C-9DA9-7415FCE8BD55@.microsoft.com...
> I'm having the same problem. Is there any solution to this?
> Goncalo
>
> "Donovan Smith [MSFT]" wrote:
>> Please email me a copy of your .rdl and .rdl.data file so I can take a
>> look.
>> Also, please send me a copy of the error you're seeing in the latest log
>> file in your /ReportServer/LogFiles directory.
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "David" <David@.discussions.microsoft.com> wrote in message
>> news:AC2E1B8D-CB2F-4AF5-BEF9-F72A470BC626@.microsoft.com...
>> >I have a report that uses a matrix control to display the data. After
>> > spending hours on the report getting it to look right in Report
>> > Manager, I
>> > went to export to PDF and could not. I got the error "Internet Explorer
>> > cannot download format=PDF".
>> >
>> > So I proceeded to recreate the report step by step. At each step, I
>> > deployed, ran, and try to export to pdf.
>> >
>> > The problem comes when I have a group make the visible property=false.
>> >
>> > My work around is to change the Font color to white and disable
>> > growing.
>> >
>> > Is this a known issue and is being worked on or should I report this to
>> > MS?
>>

Can't export report to CSV,XMl correctly, sql 2005 reporting service

Hi all,

I am developing reports using sql2005 report service. I can export reports in excel and pdf format, but can't export to csv and xml correctly.

The exported csv and xml files only contain some thing like the textbox,..., but no report content are there.

Anybody can help? thanks in advance.

BTW, all reports are matrix, is martrix can cause some issues?

Hi,

For most items on your report, you can define how it needs to be rendered to XML. For example the xml output for an item in a matrix can be set as follow:

select the item in the matrix|||

Thanks, Greert.

Your reply is really helpful. Now I know how to export report in xml format. But, how about CSV? I still can't export report to csv.

Thanks again

|||

Hi,

The same goes for CSV. For example if you set the Output of a column to No, you will see that the column is not included in the CSV file.

Greetz,

Geert

Geert Verhoeven
Consultant @. Ausy Belgium

My Personal Blog

|||Hi Geert,

Thanks a lot.

When I set th output of a column to yes, it works. Before, the the output of column was set to Auto.

Cant enter report manager with forms security

I implemented the sample from microsoft, but i dont know what went wrong i
can access the server but cant enter the report manager, im redirected to
the folder.aspx page but then I get back to UILogon.aspx, could it be that
when i installed RS i ddint check the SSL checkbox, or some other config
problem?Or, perhaps you access the Report Manager by using localhost instead of the
computer name?
--
Hope this helps.
----
Teo Lachev, MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
----
"Rodrigo Sánchez" <rodrigoss@.netshoreprogramming.com> wrote in message
news:OobjdyhkEHA.3556@.TK2MSFTNGP12.phx.gbl...
> I implemented the sample from microsoft, but i dont know what went wrong i
> can access the server but cant enter the report manager, im redirected to
> the folder.aspx page but then I get back to UILogon.aspx, could it be that
> when i installed RS i ddint check the SSL checkbox, or some other config
> problem?
>|||Hi all,
I have been trying ti use the Sample Forms Authentication since morning but
can not make it work still. I followed the steps and could register a user
"administrator" from LOgon.aspx page. I see this user getting created in the
Users table of UserAccounts database. I also add the sample code for username
to RSReportServer.config file as given in the sample description. Now I try
to login using the username and password but brings me back to the Logon.aspx
page. Anybody please help.
PS:- I can also see this user from ReportServer but cannot enter
ReportManager)
Thanks in advance.
Pinal.
"Teo Lachev" wrote:
> Or, perhaps you access the Report Manager by using localhost instead of the
> computer name?
> --
> Hope this helps.
> ----
> Teo Lachev, MCSD, MCT
> Author: "Microsoft Reporting Services in Action"
> Publisher website: http://www.manning.com/lachev
> Buy it from Amazon.com: http://shrinkster.com/eq
> Home page and blog: http://www.prologika.com/
> ----
> "Rodrigo Sánchez" <rodrigoss@.netshoreprogramming.com> wrote in message
> news:OobjdyhkEHA.3556@.TK2MSFTNGP12.phx.gbl...
> > I implemented the sample from microsoft, but i dont know what went wrong i
> > can access the server but cant enter the report manager, im redirected to
> > the folder.aspx page but then I get back to UILogon.aspx, could it be that
> > when i installed RS i ddint check the SSL checkbox, or some other config
> > problem?
> >
> >
>
>sql

Can't email reports

Hello
I'm trying to send the reports in Report Manager by mail, but I have always
the same message -> "Error sending email.
System.Runtime.InteropServices.COMException (0x80040211): The message could
not be sent to the SMTP server. The transport error code was 0x800ccc15. The
server response was not available."
I have installed W XP SP2, and have no firewall
When I installed Rep. Serv. I specified a valid smtp adress.
Can everyone help me pleaseSorry Bruno; it appears you have not included enough information in your
question. How are you trying to send the e-mail? Are you using the
subscription feature in Reporting Services? If so, take a look at the file
RSReportServer.config which is in the ReportServer subfolder of your
Reporting Services installation folder (this in turn is located in the folder
where your SQL Server instance is installed). In this file, there is an XML
element called RSEmailDPConfiguration. Within this element there is a
subelement called SMTPServer. This is where your SMTP server is configured.
Is this configured correctly, i.e. is it pointing to a valid SMTP server like
an Exchange Server?
I am assuming you are trying to send the report using the subscription
feature.
Charles Kangai, MCT, MCDBA
"Bruno" wrote:
> Hello
> I'm trying to send the reports in Report Manager by mail, but I have always
> the same message -> "Error sending email.
> System.Runtime.InteropServices.COMException (0x80040211): The message could
> not be sent to the SMTP server. The transport error code was 0x800ccc15. The
> server response was not available."
> I have installed W XP SP2, and have no firewall
> When I installed Rep. Serv. I specified a valid smtp adress.
>
> Can everyone help me please|||Hello Charles and thanks to help me
Yes, I am using the subcription feature to send email in report manager site.
I follow the suggestion do check the RSReportServer.config and everything is
ok as you can see above:
<RSEmailDPConfiguration>
<SMTPServer>10.250.1.123</SMTPServer> <SMTPServerPort></SMTPServerPort>
<SMTPAccountName></SMTPAccountName>
<SMTPConnectionTimeout></SMTPConnectionTimeout>
<SMTPServerPickupDirectory></SMTPServerPickupDirectory>
<SMTPUseSSL></SMTPUseSSL>
<SendUsing></SendUsing>
<SMTPAuthenticate></SMTPAuthenticate>
<From>reports@.abcorp.com</From>
..................
The smtp adress is valid, because is from the exchange server.
All the sql server services and report services are starting with a domain
account and the sql server uses the mix mode autentication.
When I installed the rep server I selected the sql autentication (sa user)
in credentials to connect to sql server.
When I depoy the reports to Report manager, I can see them perfectly, but
can't send them by mail. The error is always the same "Error sending email.
System.Runtime.InteropServices.COMException (0x80040211): The message could
not be sent to the SMTP server. The transport error code was 0x800ccc15. The
server response was not available"
Can SP2(WinXP) the problem?
Thank you for the help!!!
"Charles Kangai" wrote:
> Sorry Bruno; it appears you have not included enough information in your
> question. How are you trying to send the e-mail? Are you using the
> subscription feature in Reporting Services? If so, take a look at the file
> RSReportServer.config which is in the ReportServer subfolder of your
> Reporting Services installation folder (this in turn is located in the folder
> where your SQL Server instance is installed). In this file, there is an XML
> element called RSEmailDPConfiguration. Within this element there is a
> subelement called SMTPServer. This is where your SMTP server is configured.
> Is this configured correctly, i.e. is it pointing to a valid SMTP server like
> an Exchange Server?
> I am assuming you are trying to send the report using the subscription
> feature.
> Charles Kangai, MCT, MCDBA
> "Bruno" wrote:
> > Hello
> >
> > I'm trying to send the reports in Report Manager by mail, but I have always
> > the same message -> "Error sending email.
> > System.Runtime.InteropServices.COMException (0x80040211): The message could
> > not be sent to the SMTP server. The transport error code was 0x800ccc15. The
> > server response was not available."
> >
> > I have installed W XP SP2, and have no firewall
> > When I installed Rep. Serv. I specified a valid smtp adress.
> >
> >
> > Can everyone help me please|||The problem was in Anti-Virus (McAfee 8 Ent)
"Bruno" wrote:
> Hello
> I'm trying to send the reports in Report Manager by mail, but I have always
> the same message -> "Error sending email.
> System.Runtime.InteropServices.COMException (0x80040211): The message could
> not be sent to the SMTP server. The transport error code was 0x800ccc15. The
> server response was not available."
> I have installed W XP SP2, and have no firewall
> When I installed Rep. Serv. I specified a valid smtp adress.
>
> Can everyone help me please

Cant drill through from one report to another with report viewer

Hello all,

this is my first post to asp.net!

I am having a problem getting a drill through to work in the web report viewer. In report1 i have a table with groups and on the key field i want to drill down through i right click >properties> navigation and select jump to report. From there I select the predesigned report2 from the list and add the appropriate parameters.

It works fine when i test it in the dev enviroment and when i deploy it to the report server it works fine there. but when I debug and run it through the website itself and go to the report then click on the hyperlink it goes to a "page cannot be displayed' page.

I have been working on this for 2 days googling the heck out of it and testing several scenarios, but to no avail. I'm sure its something stupidly simple.

has anyone else had this problem?

Help!

thanks so much!

HI,CodeSquirrelMonkey:

Make sure you have put the target report in the right place which is defined in the drill through setting.

Second, you can have a try to open the target report directly on the website.

If i misunderstand you about your question, please feel free to correct me and i will try to help you with more information.

I hope the above information will be helpful. If you have any issues or concerns, please let me know. It's my pleasure to be of assistance

|||

Hi Rex,

Thanks for the response. I did make sure that the drill through report is in the right place and it didnt work on the live site either.

I did get around the problem though. I created an fresh new aspx page and dropped a fresh report viewer on it and tried it again and it works fine now. I did a comparison of the two pages' code and couldnt find anything obvious that could have caused it. It does work fine now.

the only other thing was to make sure that the page_load has an if not ispostback on it so that it would refresh and drilldown properly.

Thanks again

Craig

Can't display the report page from the Internet

Hi,

I am using SQL 2000 SP4 and Report Server SP2 on W2k3 SP1 Server.

I am having trouble displaying the report pages if I am connected from the Internet.

I have no problem if I am connected in the office (Intranet).

The frame that is not show is underneath the New Subscription bar in my report page. I can see everything above (header pages etc) and Home page etc.

I think for some reasons the request frame URL page is still https://myserver/Repor... instead https://myserver.mycompany.com/Report...

Thank's for any help

gogu

PS: Also I am able to deploy only from the Intranet with Target Server URL https://myserver/ReportServer
If I setup VS.NET deploy Target Server URL https://myserver.mycompany.com/ReportServer it comes up with "A connection could not be made ..."
If I open the Browser from the Intranet I can see the reports pages even if with https://myserver.mycompany.com/Reports...
but it ask me for Username / Password.
How can I tell VS.NET when deploy to use username/password?

I think I figure out this (PostID=499647);

I modified RSWebApplication.config see PostID=499647 above and reinstall SSL certificate with <FQDN>

What stupid think is that only the body of report page follows the key <ReportServerUrl> other frame pages are relative to browser URL?

Can't Display Sql 2005 Images

Hi!!!

I have a JPEG image into my Sql Server 2005 DB. The field type in the DB is Image.
When I try to display the image in a report, I always see a red cross instead the image...

I've tried to do: "http://msdn2.microsoft.com/en-us/library/ms156342.aspx" but it doesn't work.

Please help me!!!!

NEStorMake sure the image item source is set to Database. The Product Catalog report included with the RS sample reports demonstrates showing images from the database.

can't deploy, SSRS 2K5

Hi kids:
I'm sure this is an easy one, sorry for posting a knob question...
Whenever I attempt to deploy a report, I get prompted for a login. I
don't remember setting SSRS to run as anyting except Local System, and
the configuration tool bears that out. When I click "deploy" on my
(very simple) report, it prompts me for a username & password. If I
click cancel, it declares the deployment a failure and stops. I have
tried entering my domain\user & password, user & password, sa &
password, but all fail.
Suggestions?
Thanks;
DuncanIs RS on your machine or a different one? It doesn't matter what RS uses to
run, it implements security and you have to have the correct rights to
deploy.
First, even without a report deployed you need to be able to see Report
Manager (the portal that ships with RS). Does that work for you?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Duncan A. McRae" <google.com@.mcrae.ca> wrote in message
news:1187288669.801335.68890@.q3g2000prf.googlegroups.com...
> Hi kids:
> I'm sure this is an easy one, sorry for posting a knob question...
> Whenever I attempt to deploy a report, I get prompted for a login. I
> don't remember setting SSRS to run as anyting except Local System, and
> the configuration tool bears that out. When I click "deploy" on my
> (very simple) report, it prompts me for a username & password. If I
> click cancel, it declares the deployment a failure and stops. I have
> tried entering my domain\user & password, user & password, sa &
> password, but all fail.
> Suggestions?
> Thanks;
> Duncan
>

Can't deploy report on the reporting server

Please help -
I am trying to deploy report on the server - getting following:
===================================
A connection could not be made to the report server
http://169.35.137.96/ReportServer/. (Microsoft Report Designer)
===================================
The server committed a protocol violation. Section=ResponseStatusLine
(Microsoft.ReportingServices.Designer)
--
Program Location:
at
Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
at
Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String
methodname)
at
Microsoft.SqlServer.ReportingServices2005.RSConnection.GetItemType(String
Item)
at
Microsoft.ReportDesigner.Project.ReportServiceClient.GetItemType(String item)
at Microsoft.ReportDesigner.Project.ReportServiceClient.CheckAuthorized()
at
Microsoft.ReportDesigner.Project.ReportClientManager.GetCredentials(String
url)
at Microsoft.ReportDesigner.Project.ReportProjectDeployer.PrepareDeploy()
--
Regadrs,
Andyhello,
Can you connect to RS and Report Manager without any problems in your web
browser using this addresses
http://169.35.137.96/ReportServer/
http://169.35.137.96/Reports/
'
And if so can you deploy any files and create folders in Report Manager?
Regards,
Radoslaw Lebkowski
U¿ytkownik "andys" <asichevoy@.gmail.com.(donotspam)> napisa³ w wiadomo¶ci
news:8A5B8E82-44F9-4FE8-90EB-00F38FB6DB5D@.microsoft.com...
> Please help -
> I am trying to deploy report on the server - getting following:
> ===================================> A connection could not be made to the report server
> http://169.35.137.96/ReportServer/. (Microsoft Report Designer)
> ===================================> The server committed a protocol violation. Section=ResponseStatusLine
> (Microsoft.ReportingServices.Designer)
> --
> Program Location:
> at
> Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
> at
> Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String
> methodname)
> at
> Microsoft.SqlServer.ReportingServices2005.RSConnection.GetItemType(String
> Item)
> at
> Microsoft.ReportDesigner.Project.ReportServiceClient.GetItemType(String
> item)
> at
> Microsoft.ReportDesigner.Project.ReportServiceClient.CheckAuthorized()
> at
> Microsoft.ReportDesigner.Project.ReportClientManager.GetCredentials(String
> url)
> at
> Microsoft.ReportDesigner.Project.ReportProjectDeployer.PrepareDeploy()
>
>
> --
> Regadrs,
> Andy