Tuesday, March 20, 2012
[web Service] Rename a Report
i used ReportingService2005.SetProperties Method but when
i try with
Property.Name = "Name";
Property.Value = "myNewName"
i can't update the report name => RS2005 say the property 'name' is readonly
this method is ok with property "description"
How todo to rename report ?On Mar 16, 3:55 am, jeff <j...@.discussions.microsoft.com> wrote:
> i try to rename a report with web services.
> i used ReportingService2005.SetProperties Method but when
> i try with
> Property.Name = "Name";
> Property.Value = "myNewName"
> i can't update the report name => RS2005 say the property 'name' is readonly
> this method is ok with property "description"
> How todo to rename report ?
There are a couple of different ways to do it. Either change it in the
Properties tab in the Report Manager -or- change it at the file level.
So programmatically (option 2), you could do something like this in a
stored prcoedure that the report is using, etc:
exec xp_cmdshell 'rename c:\OriginalReportName.rdl NewReportName.rdl'
Hope this helps.
Regards,
Enrique Martinez
Sr. SQL Server Developer|||i wouldlike use Webservice ..... ( i create a soft that manage reporting
services 2005 with webservices )
"EMartinez" wrote:
> On Mar 16, 3:55 am, jeff <j...@.discussions.microsoft.com> wrote:
> > i try to rename a report with web services.
> >
> > i used ReportingService2005.SetProperties Method but when
> > i try with
> > Property.Name = "Name";
> > Property.Value = "myNewName"
> > i can't update the report name => RS2005 say the property 'name' is readonly
> > this method is ok with property "description"
> >
> > How todo to rename report ?
> There are a couple of different ways to do it. Either change it in the
> Properties tab in the Report Manager -or- change it at the file level.
> So programmatically (option 2), you could do something like this in a
> stored prcoedure that the report is using, etc:
> exec xp_cmdshell 'rename c:\OriginalReportName.rdl NewReportName.rdl'
> Hope this helps.
> Regards,
> Enrique Martinez
> Sr. SQL Server Developer
>
Sunday, March 11, 2012
[SBS2003 Premium R2] Reporting services problem
When I try configure report data source to connect to database on another
SQL Server 200 i receive message:
The feature: "Remote access to report data sources and/or the report server
database" is not supported in this edition of Reporting Services.
What can I do with thiss message?
Please help me
Best regards
AdamOn Jun 29, 1:57 am, "Adam Kobylinski" <akobylin@.NO_SPAM.op.pl> wrote:
> Hi!
> When I try configure report data source to connect to database on another
> SQL Server 200 i receive message:
> The feature: "Remote access to report data sources and/or the report server
> database" is not supported in this edition of Reporting Services.
> What can I do with thiss message?
> Please help me
> Best regards
> Adam
If you are running SQL Server 2005 Express Edition (w/Advanced
Services), this is one of the limitations. Otherwise, you will want to
open the local SQL Server Surface Area Configuration tool and select
Surface Area Configuration for Services and Connections -> View by
Instance -> MSSQLSERVER (or the local instance name) -> Database
Engine -> Remote Connections and make sure that it is set to: Local
and remote connections. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||User "EMartinez" <emartinez.pr1@.gmail.com>
> On Jun 29, 1:57 am, "Adam Kobylinski" <akobylin@.NO_SPAM.op.pl> wrote:
>> Hi!
>> When I try configure report data source to connect to database on another
>> SQL Server 200 i receive message:
>> The feature: "Remote access to report data sources and/or the report
>> server
>> database" is not supported in this edition of Reporting Services.
>> What can I do with thiss message?
>> Please help me
>> Best regards
>> Adam
>
> If you are running SQL Server 2005 Express Edition (w/Advanced
> Services), this is one of the limitations. Otherwise, you will want to
> open the local SQL Server Surface Area Configuration tool and select
> Surface Area Configuration for Services and Connections -> View by
> Instance -> MSSQLSERVER (or the local instance name) -> Database
> Engine -> Remote Connections and make sure that it is set to: Local
> and remote connections. Hope this helps.
>
Unfortunately it doesn't work, i already have remote connections selected,
SQL server 2000 on other computer is Standard Edition and i can connect
remotely from other applications.
Have you any idea?
Regards
Adam
Thursday, March 8, 2012
[PROBLEM] : Using RS Web Services to Render Report containing Toggle Item
I have two problems with Toggle Items when I render my Reports using the RS Web Service.
First, the URL when I click on the + / - image will redirect me to the Report Server URL
ex :
The page that display the report is at : http://localhost/report/default.aspx
If i click on one of the +/- image, it will redirect to something like this : http://localhost/ReportServer?/myreport&myparam=testvalue&rc:streamRoot=//&rc:section=0&rs:format=HTML4.0&rs:ShowHideToggleItem=44&rs:SnapShot:isnull=True
Is there a solution to this problem ? (with a replace ?)
Then, If in the Render Method, I put a valid ShowHideToggle ID, when the report renders, the selected toggle item won't be expanded ...
Here's a sample of my code :
string ShowHideToggle = null;
// The rs:ShowHideToggle parameter is valid, but it wont' change anything ...
if(HttpContext.Current.Request["rs:ShowHideToggle"] != null)
ShowHideToggle = HttpContext.Current.Request["rs:ShowHideToggle"];
bResult = oRS.Render(_sName, "HTML4.0", null, "<DeviceInfo><StreamRoot>/" + _sFolder +"/</StreamRoot></DeviceInfo>", _oParameters, null, ShowHideToggle , out sOptionalString, out sOptionalString, out _oParameters, out oOptionalWarnings, out sStreamIDs);
Encoding oEnc = System.Text.Encoding.UTF8;
string sHTMLFlow = oEnc.GetString(bResult);
// This way, it won't redirect to the Report Server URL but the "+/-" image won't diplay anymore ...
sHTMLFlow = sHTMLFlow.Replace(sReportServerUrl.Replace("/ReportService.asmx", "?"), "http://" + HttpContext.Current.Request["SERVER_NAME"] + HttpContext.Current.Request["SCRIPT_NAME"] + "?Report=");
Any Help would be appreciated :)
That thing is killing me :(
Thanks for your help
You didn't say what version of SRS you're using.On RS 2000 - this is a known limitation - toggles will point back to the report server virtual directory.
On RS 2005 - if you use the Reporting controls from VS 2005 or the new reportexecution APIs, you will get server-side ASP.NET events for all interractivity in the report
Thanks
Tudor|||
Tudor
Would you be able to provide an example of how to use showHideToggle using the reportexecution APIs in RS 2005. I have been looking to see how to specify showHideToggle in place of the old Render call, but have not been able to find anything.
Any tips would be much appreciated.
Thank you.
mike
|||Call LoadReport only when ShowHideToggle is null.
after the first Render save ReportExecutionService intance into the Session.set the objReportExecutionService to the object in the Session.
for the succeeding calls if ShowHideToggle is not null set objReportExecutionService.ToggleItem to the ShowHideToggle value. then call the render method again.That should just work.
|||Aldwin, I'm not sure what you mean here. Can you provide a code sample?Thanks,
Paul
[PROBLEM] : Using RS Web Services to Render Report containing Toggle Item
I have two problems with Toggle Items when I render my Reports using the RS Web Service.
First, the URL when I click on the + / - image will redirect me to the Report Server URL
ex :
The page that display the report is at : http://localhost/report/default.aspx
If i click on one of the +/- image, it will redirect to something like this : http://localhost/ReportServer?/myreport&myparam=testvalue&rc:streamRoot=//&rc:section=0&rs:format=HTML4.0&rs:ShowHideToggleItem=44&rs:SnapShot:isnull=True
Is there a solution to this problem ? (with a replace ?)
Then, If in the Render Method, I put a valid ShowHideToggle ID, when the report renders, the selected toggle item won't be expanded ...
Here's a sample of my code :
string ShowHideToggle = null;
// The rs:ShowHideToggle parameter is valid, but it wont' change anything ...
if(HttpContext.Current.Request["rs:ShowHideToggle"] != null)
ShowHideToggle = HttpContext.Current.Request["rs:ShowHideToggle"];
bResult = oRS.Render(_sName, "HTML4.0", null, "<DeviceInfo><StreamRoot>/" + _sFolder +"/</StreamRoot></DeviceInfo>", _oParameters, null, ShowHideToggle , out sOptionalString, out sOptionalString, out _oParameters, out oOptionalWarnings, out sStreamIDs);
Encoding oEnc = System.Text.Encoding.UTF8;
string sHTMLFlow = oEnc.GetString(bResult);
// This way, it won't redirect to the Report Server URL but the "+/-" image won't diplay anymore ...
sHTMLFlow = sHTMLFlow.Replace(sReportServerUrl.Replace("/ReportService.asmx", "?"), "http://" + HttpContext.Current.Request["SERVER_NAME"] + HttpContext.Current.Request["SCRIPT_NAME"] + "?Report=");
Any Help would be appreciated :)
That thing is killing me :(
Thanks for your help
You didn't say what version of SRS you're using.On RS 2000 - this is a known limitation - toggles will point back to the report server virtual directory.
On RS 2005 - if you use the Reporting controls from VS 2005 or the new reportexecution APIs, you will get server-side ASP.NET events for all interractivity in the report
Thanks
Tudor|||
Tudor
Would you be able to provide an example of how to use showHideToggle using the reportexecution APIs in RS 2005. I have been looking to see how to specify showHideToggle in place of the old Render call, but have not been able to find anything.
Any tips would be much appreciated.
Thank you.
mike
|||Call LoadReport only when ShowHideToggle is null.
after the first Render save ReportExecutionService intance into the Session.set the objReportExecutionService to the object in the Session.
for the succeeding calls if ShowHideToggle is not null set objReportExecutionService.ToggleItem to the ShowHideToggle value. then call the render method again.That should just work.
|||Aldwin, I'm not sure what you mean here. Can you provide a code sample?Thanks,
Paul
[PROBLEM] : Using RS Web Services to Render Report containing Toggle Item
I have two problems with Toggle Items when I render my Reports using the RS Web Service.
First, the URL when I click on the + / - image will redirect me to the Report Server URL
ex :
The page that display the report is at : http://localhost/report/default.aspx
If i click on one of the +/- image, it will redirect to something like this : http://localhost/ReportServer?/myreport&myparam=testvalue&rc:streamRoot=//&rc:section=0&rs:format=HTML4.0&rs:ShowHideToggleItem=44&rs:SnapShot:isnull=True
Is there a solution to this problem ? (with a replace ?)
Then, If in the Render Method, I put a valid ShowHideToggle ID, when the report renders, the selected toggle item won't be expanded ...
Here's a sample of my code :
string ShowHideToggle = null;
// The rs:ShowHideToggle parameter is valid, but it wont' change anything ...
if(HttpContext.Current.Request["rs:ShowHideToggle"] != null)
ShowHideToggle = HttpContext.Current.Request["rs:ShowHideToggle"];
bResult = oRS.Render(_sName, "HTML4.0", null, "<DeviceInfo><StreamRoot>/" + _sFolder +"/</StreamRoot></DeviceInfo>", _oParameters, null, ShowHideToggle , out sOptionalString, out sOptionalString, out _oParameters, out oOptionalWarnings, out sStreamIDs);
Encoding oEnc = System.Text.Encoding.UTF8;
string sHTMLFlow = oEnc.GetString(bResult);
// This way, it won't redirect to the Report Server URL but the "+/-" image won't diplay anymore ...
sHTMLFlow = sHTMLFlow.Replace(sReportServerUrl.Replace("/ReportService.asmx", "?"), "http://" + HttpContext.Current.Request["SERVER_NAME"] + HttpContext.Current.Request["SCRIPT_NAME"] + "?Report=");
Any Help would be appreciated :)
That thing is killing me :(
Thanks for your help
You didn't say what version of SRS you're using.On RS 2000 - this is a known limitation - toggles will point back to the report server virtual directory.
On RS 2005 - if you use the Reporting controls from VS 2005 or the new reportexecution APIs, you will get server-side ASP.NET events for all interractivity in the report
Thanks
Tudor|||
Tudor
Would you be able to provide an example of how to use showHideToggle using the reportexecution APIs in RS 2005. I have been looking to see how to specify showHideToggle in place of the old Render call, but have not been able to find anything.
Any tips would be much appreciated.
Thank you.
mike
|||Call LoadReport only when ShowHideToggle is null.
after the first Render save ReportExecutionService intance into the Session.set the objReportExecutionService to the object in the Session.
for the succeeding calls if ShowHideToggle is not null set objReportExecutionService.ToggleItem to the ShowHideToggle value. then call the render method again.That should just work.
|||Aldwin, I'm not sure what you mean here. Can you provide a code sample?Thanks,
Paul
[PROBLEM] : Using RS Web Services to Render Report containing Toggle Item
I have two problems with Toggle Items when I render my Reports using the RS Web Service.
First, the URL when I click on the + / - image will redirect me to the Report Server URL
ex :
The page that display the report is at : http://localhost/report/default.aspx
If i click on one of the +/- image, it will redirect to something like this : http://localhost/ReportServer?/myreport&myparam=testvalue&rc:streamRoot=//&rc:section=0&rs:format=HTML4.0&rs:ShowHideToggleItem=44&rs:SnapShot:isnull=True
Is there a solution to this problem ? (with a replace ?)
Then, If in the Render Method, I put a valid ShowHideToggle ID, when the report renders, the selected toggle item won't be expanded ...
Here's a sample of my code :
string ShowHideToggle = null;
// The rs:ShowHideToggle parameter is valid, but it wont' change anything ...
if(HttpContext.Current.Request["rs:ShowHideToggle"] != null)
ShowHideToggle = HttpContext.Current.Request["rs:ShowHideToggle"];
bResult = oRS.Render(_sName, "HTML4.0", null, "<DeviceInfo><StreamRoot>/" + _sFolder +"/</StreamRoot></DeviceInfo>", _oParameters, null, ShowHideToggle , out sOptionalString, out sOptionalString, out _oParameters, out oOptionalWarnings, out sStreamIDs);
Encoding oEnc = System.Text.Encoding.UTF8;
string sHTMLFlow = oEnc.GetString(bResult);
// This way, it won't redirect to the Report Server URL but the "+/-" image won't diplay anymore ...
sHTMLFlow = sHTMLFlow.Replace(sReportServerUrl.Replace("/ReportService.asmx", "?"), "http://" + HttpContext.Current.Request["SERVER_NAME"] + HttpContext.Current.Request["SCRIPT_NAME"] + "?Report=");
Any Help would be appreciated :)
That thing is killing me :(
Thanks for your help
You didn't say what version of SRS you're using.On RS 2000 - this is a known limitation - toggles will point back to the report server virtual directory.
On RS 2005 - if you use the Reporting controls from VS 2005 or the new reportexecution APIs, you will get server-side ASP.NET events for all interractivity in the report
Thanks
Tudor|||
Tudor
Would you be able to provide an example of how to use showHideToggle using the reportexecution APIs in RS 2005. I have been looking to see how to specify showHideToggle in place of the old Render call, but have not been able to find anything.
Any tips would be much appreciated.
Thank you.
mike
|||Call LoadReport only when ShowHideToggle is null.
after the first Render save ReportExecutionService intance into the Session.set the objReportExecutionService to the object in the Session.
for the succeeding calls if ShowHideToggle is not null set objReportExecutionService.ToggleItem to the ShowHideToggle value. then call the render method again.That should just work.
|||Aldwin, I'm not sure what you mean here. Can you provide a code sample?Thanks,
Paul
Friday, February 24, 2012
[HELP] How can I start an Analysis Services service
Hi all,
at Surface Area Configuration in my SQL Server 2005 I noticed that I have Database Engine, Reporting Services and SQL Server Browser services. I want to deploy a cube modelled at SQL Server Business Intelligence Development Studio and I'm getting connection errors.
I checked at Management Studio that I don't have an instance of Analysis Services. Only Database Engine and Reporting Services.
How can I create an instance of Analysis Services.
Does anyone could help me please?
Thanks a lot.
Another way to verify if you have Analysis Services installed or not, is to look in Services for "SQL Server Analysis Services". To install it, re-run the Setup and there is an option for Analysis Services.
Adrian Dumitrascu
Monday, February 13, 2012
[2.0] web service method to list the reports ?
Hello,
I'd like to use the Reporting Services 2005 Web Service to list all the reports on the server, but I don't know which method to use ?
I found many web methods to do all sort of things but not to get a list of reports.
Any idea ?
Ok I found the method of the Reporting Web Service : ListChildren(...)
But when I make a call to the WS on my web app, I got the error :HTTP status 401: Access Denied.
My Web App use Form authentication.
My ASPNET user is member of the ReportinsServicesWebServiceUser role so it should work.
I try to use impersonation, but still the same result...
|||
Have you tried allowing anonymous access to the site in IIS and adding
service.Credentials = System.Net.CredentialCache.DefaultCredentials
in code?
|||I tried this and it's ok !
There was another security problem with RS which make a DCOM access to NetMan component with Network Services
Weird but it seems ok now, thanks.
[+]/[-] inconsistency
SQL Server 2005, Reporting Services 2005, Windows Server 2003.
It looks like in report matrix the start icon for collaspsing/expanding subgroups is always [+], regardless of whether subgroups are hidden or visible by default.
In report table it is vice versa [-].
Expected behavior: [-] when group is expanded, [+] when contracted.
So to get that behavior I'm forced to hide all subgroups in report matrix, and expand in report tables.
What am I doing wrong?
Is there a way to control which icon appears when group is expanded/contracted?
Was it resolved in one of Service Packs?
BTW. Can I assign my own icon images?
Thanks, Andrei.
ToggleImage property on the textbox that toggles the subgroups controls what the start icon is. If you haven't set anything for this property, the default should be [+], in both table and matrix. Can you check what value this property currently has in your table and matrix? You can right-click on the textbox, in the properties dialog go to the Visibility tab, and look at the "initial appearance of the toggle image for this report item".
Being able to assign your own icon images is not currently supported. It's on our wishlist for a future release.
[?] Error accessing from internet
Authentication Sample ) with SSL.
Everything works fine in intranet environment.
Now I'm trying to publish this server in internet, but it doesn't work:
when I call the server url I can see the login form, but when I press the
"Login" button nothing happens.
I debugged the application and see the request coming in correctly, the
login credentials are authenticated but the redirect to the
"/Pages/Folder.aspx" is wrong.
It seems like the report manager and the report server can't communicate
each other when accessed from internet.
May the SSL certificate be released on Netbios name but the internet access
is something like www.myserver.com ?
Thanks for responses.
MorenoI had a similar problem. What I did was add a entry into my host file
on the server. Make sure your internal ip for the server matches your
domain name. Hope this helps.
Example:
10.0.0.1 yourssldomain.com
"Moreno" <movendra@.yahoo.com> wrote in message news:<#Q$tpBtWEHA.3800@.TK2MSFTNGP11.phx.gbl>...
> I've installed Reporting Services and customized the authentication ( Forms
> Authentication Sample ) with SSL.
> Everything works fine in intranet environment.
> Now I'm trying to publish this server in internet, but it doesn't work:
> when I call the server url I can see the login form, but when I press the
> "Login" button nothing happens.
> I debugged the application and see the request coming in correctly, the
> login credentials are authenticated but the redirect to the
> "/Pages/Folder.aspx" is wrong.
> It seems like the report manager and the report server can't communicate
> each other when accessed from internet.
> May the SSL certificate be released on Netbios name but the internet access
> is something like www.myserver.com ?
> Thanks for responses.
> Moreno
[ URGENTlY URGENT ] PARAMETER LENGTH 1024
I got a parametrized report in Reporting Services.The problem is that i got Really large paramteres which are exceeding 1024 limit and if that probolem is not solved..please let me know a hotel where a waiter is Needed on good Pay and Respect.
Or try using a table to store parameters based on user id & look up after the fact.
More information around application & parameter types would help.
URLs don't really support that much information, so you're better off saving the parameter to a database, then using an id field to retrieve the information in a stored procedure.|||Does this mean that there is a 1024 limit on the report parameters of RS?
[ URGENTlY URGENT ] PARAMETER LENGTH 1024
I got a parametrized report in Reporting Services.The problem is that i got Really large paramteres which are exceeding 1024 limit and if that probolem is not solved..please let me know a hotel where a waiter is Needed on good Pay and Respect.
Or try using a table to store parameters based on user id & look up after the fact.
More information around application & parameter types would help.
URLs don't really support that much information, so you're better off saving the parameter to a database, then using an id field to retrieve the information in a stored procedure.|||Does this mean that there is a 1024 limit on the report parameters of RS?