How Can I Rename a Reportin Service Folder using Code

Using Reporting Service Web service

It is possible to create folder and delete folder. But I couldn't rename the folder using code it tried with setProperties method but name is ready only property. Please help me to resolve the issue.

Thanks in Advance.

Krishna kumar.M

hi all,

Later I found if use the rs.MoveItem we can achive the same

sql

How can I programmatically know if RS is installed on a server or not

Hi,,
I have a list of SQL servers available in our network in a ComboBox ,I want
to show a message if there is no reporting service installed on a server of
user choice ,I tried to use listChildern ,,but when there is no RS ,,it
thows an Exception inside the web referenc.
ThanksOne suggestion would be to put the code calling ListChildren inside of
a Try Catch block. If you catch the exception you can display a
message box saying reporting services was not found.
More info on Try Catch can be found here:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconusingtrycatchblocktocatchexceptions.asp
The problem with this approach is you'll have to set the Url property
of the web reference and assume the report server is installed at the
default location (http://machinename/reportserver). If someone
installed the report server at a different location you'll need a more
robust mechanism to find it. I'd suggest trying WMI (windows
management instrumentation). There is an example in the docs showing
how to connect to a remote report server:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_prog_wmi_6iua.asp
Note: the sample code in the docs also needs a try / catch in case the
server does not have SSRS installed.
--
Scott
http://www.OdeToCode.com/blogs/scott/
On Fri, 12 Nov 2004 11:25:32 -0800, "ALI-R" <newbie@.microsoft.com>
wrote:
>Hi,,
>I have a list of SQL servers available in our network in a ComboBox ,I want
>to show a message if there is no reporting service installed on a server of
>user choice ,I tried to use listChildern ,,but when there is no RS ,,it
>thows an Exception inside the web referenc.
>Thanks
>

How can I programatically set the minimum and maximum x axis values?

I am using reporting services 2000 and would like to know if there is
a way of programatically setting the x-axis minimum and maximum
values.
The Minimum and Maximum Scale X axis textboxes do not have an "fx"
next to them, so I cannot set an expression for them. Can it be done
at all?On Jun 3, 8:39 am, nicko <nickos...@.hotmail.com> wrote:
> I am using reporting services 2000 and would like to know if there is
> a way of programatically setting the x-axis minimum and maximum
> values.
> The Minimum and Maximum Scale X axis textboxes do not have an "fx"
> next to them, so I cannot set an expression for them. Can it be done
> at all?
If I'm understanding you correctly, you will most likely need to
create the RDL file programmatically via a custom ASP.NET application.
Sorry that I could not be of greater assistance.
Regards,
Enrique Martinez
Sr. Software Consultant|||On Jun 4, 11:22 am, EMartinez <emartinez...@.gmail.com> wrote:
> On Jun 3, 8:39 am, nicko <nickos...@.hotmail.com> wrote:
> > I am using reporting services 2000 and would like to know if there is
> > a way of programatically setting the x-axis minimum and maximum
> > values.
> > The Minimum and Maximum Scale X axis textboxes do not have an "fx"
> > next to them, so I cannot set an expression for them. Can it be done
> > at all?
> If I'm understanding you correctly, you will most likely need to
> create the RDL file programmatically via a custom ASP.NET application.
> Sorry that I could not be of greater assistance.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
Thanks Enrique.
I will be creating this report via an asp.net web application.
Does anyone know how to do this programatically? Do I create the rdl
file and then just edit the xml <min>0</min> and <max></max> values or
is there a different way to do this? Can someone point me to an
example of this...?|||You can load the RDL up as an XML document object. Then you use
SelectSingleNode on the document to get a reference to the appropriate node,
and change its value. If you have trouble designing the XPath expression to
feed SelectSingleNode, just ask...
>L<
"nicko" <nickostle@.hotmail.com> wrote in message
news:1180923958.337003.322260@.x35g2000prf.googlegroups.com...
> On Jun 4, 11:22 am, EMartinez <emartinez...@.gmail.com> wrote:
>> On Jun 3, 8:39 am, nicko <nickos...@.hotmail.com> wrote:
>> > I am using reporting services 2000 and would like to know if there is
>> > a way of programatically setting the x-axis minimum and maximum
>> > values.
>> > The Minimum and Maximum Scale X axis textboxes do not have an "fx"
>> > next to them, so I cannot set an expression for them. Can it be done
>> > at all?
>> If I'm understanding you correctly, you will most likely need to
>> create the RDL file programmatically via a custom ASP.NET application.
>> Sorry that I could not be of greater assistance.
>> Regards,
>> Enrique Martinez
>> Sr. Software Consultant
> Thanks Enrique.
> I will be creating this report via an asp.net web application.
> Does anyone know how to do this programatically? Do I create the rdl
> file and then just edit the xml <min>0</min> and <max></max> values or
> is there a different way to do this? Can someone point me to an
> example of this...?
>sql

how can i install SQL 2005 reporting services in XP Home

Hi,

I have windows XP home with SP2. i am planning to work with sql 2005 reporting services. when i am doing so it is asking me to install IIS. but IIS will now support to XP home edition.

SO is it mandatory for SQL 2005 reporting services need to have IIS. Plz let me know can i install SQL 2005 expression edition with reporting services

Thanks

DK

Reporting Services requires IIS and IIS is not part of XP Home.

You need tp update your OS...

|||

UseSQL Server 2005 Express Edition with Advanced Services

http://msdn2.microsoft.com/en-us/express/aa718379.aspx

you are limited to data out of this DB only but it is a good exercise.

If you have lots of memory, install virtual PC with win 2003 in it to test all your services.

how can i install reporting services 2005

Hi,
I installed sql server 2005 enterprise edition and visual studion 2005
professional.
but i am unable to create any projects. how can i create a report project '
(i cant find a business intelligence project anyw here
thanks in advanceYou need to install the BI client tools from the SQL Server CD/DVD.
Note that you did not need VS 2005 unless you are writing custom assemblies
or using VS specific tools (like the new controls found in VS 2005).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"RP" <RP@.discussions.microsoft.com> wrote in message
news:D06128B6-9838-47EE-A853-3BAD7187B66F@.microsoft.com...
> Hi,
> I installed sql server 2005 enterprise edition and visual studion 2005
> professional.
> but i am unable to create any projects. how can i create a report project
> '
> (i cant find a business intelligence project anyw here
> thanks in advance|||Bruce,
Can you tell me what options i have to select when installing sql server to
select BIclient tools ?
Thanks
"Bruce L-C [MVP]" wrote:
> You need to install the BI client tools from the SQL Server CD/DVD.
> Note that you did not need VS 2005 unless you are writing custom assemblies
> or using VS specific tools (like the new controls found in VS 2005).
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "RP" <RP@.discussions.microsoft.com> wrote in message
> news:D06128B6-9838-47EE-A853-3BAD7187B66F@.microsoft.com...
> > Hi,
> > I installed sql server 2005 enterprise edition and visual studion 2005
> > professional.
> > but i am unable to create any projects. how can i create a report project
> > '
> > (i cant find a business intelligence project anyw here
> > thanks in advance
>
>|||I haven't installed it for awhile but it was obvious at the time.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"RP" <RP@.discussions.microsoft.com> wrote in message
news:410BFD9A-F285-434A-985B-D18837488701@.microsoft.com...
> Bruce,
> Can you tell me what options i have to select when installing sql server
> to
> select BIclient tools ?
> Thanks
> "Bruce L-C [MVP]" wrote:
>> You need to install the BI client tools from the SQL Server CD/DVD.
>> Note that you did not need VS 2005 unless you are writing custom
>> assemblies
>> or using VS specific tools (like the new controls found in VS 2005).
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "RP" <RP@.discussions.microsoft.com> wrote in message
>> news:D06128B6-9838-47EE-A853-3BAD7187B66F@.microsoft.com...
>> > Hi,
>> > I installed sql server 2005 enterprise edition and visual studion 2005
>> > professional.
>> > but i am unable to create any projects. how can i create a report
>> > project
>> > '
>> > (i cant find a business intelligence project anyw here
>> > thanks in advance
>>

How can I install Report Server without VS.NET?

VS.NET 2003 is required for the installation of the reporting services.
Question is how can I install the Reporting Server on a staging or
production box?
Thanks,
-StanVS.NET 2003 is ONLY required only for the report design components.
In your case, it sounds like you're only interested in installing the Report
Manager and RS Web Services, so you can install without VS.NET 2003. That
message you see when you go to install is only a warning that you will not
be able to use the design components without VS.NET 2003.
Best Regards,
Benjamin Pierce
"Stan" <nospam@.yahoo.com> wrote in message
news:OPmYMsmbEHA.4092@.TK2MSFTNGP11.phx.gbl...
> VS.NET 2003 is required for the installation of the reporting services.
> Question is how can I install the Reporting Server on a staging or
> production box?
> Thanks,
> -Stan
>

how can i hide subreports and datasource in 'ReportingServer' bro

Hi,
I am very new to reporting services.And i did't work on any reporting tool
b4 this.
(1):
Now my problem is how can i hide subreports and datasource in ReportServer
browser?
(2):
I am sending http://myservername/Reportserver to all the end users.
is it correct way or is there any differnt way the users can watch reports.
plz give me detail discription
Any help will be appriciate
Thanks!All I do is click on Show Details button
Go to the properties of the data source or report (just to the right of the
checkbox is where you can click to get to the properties).
You will see a checkbox for hide in list view.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"simmi" <simmi@.discussions.microsoft.com> wrote in message
news:9BAC278F-31EA-4A2C-A817-1318ED2F8723@.microsoft.com...
> Hi,
> I am very new to reporting services.And i did't work on any reporting tool
> b4 this.
> (1):
> Now my problem is how can i hide subreports and datasource in
ReportServer
> browser?
> (2):
> I am sending http://myservername/Reportserver to all the end users.
> is it correct way or is there any differnt way the users can watch
reports.
> plz give me detail discription
> Any help will be appriciate
> Thanks!
>|||Hi Thanks for ur answer.
I am not talking about " ReportManager" browser .I am tallking about
"ReportServer".
I tried the same .But i am getting the same problem .
"Bruce L-C [MVP]" wrote:
> All I do is click on Show Details button
> Go to the properties of the data source or report (just to the right of the
> checkbox is where you can click to get to the properties).
> You will see a checkbox for hide in list view.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "simmi" <simmi@.discussions.microsoft.com> wrote in message
> news:9BAC278F-31EA-4A2C-A817-1318ED2F8723@.microsoft.com...
> > Hi,
> >
> > I am very new to reporting services.And i did't work on any reporting tool
> > b4 this.
> >
> > (1):
> > Now my problem is how can i hide subreports and datasource in
> ReportServer
> > browser?
> >
> > (2):
> >
> > I am sending http://myservername/Reportserver to all the end users.
> > is it correct way or is there any differnt way the users can watch
> reports.
> >
> > plz give me detail discription
> >
> > Any help will be appriciate
> >
> > Thanks!
> >
> >
>
>|||Are you opening up your website this way?
http://yourservernamehere/Reports/Pages/Folder.aspx
If so, then the instructions I gave you are what you want to do.
If you are doing it this way:
http://yourservernamehere/Reportserver
Then the question I have is why. The first is the way you get the portal
provided by MS and is the user friendly way to get to the reports. If you
want to do it the second way then I have no solution for you.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"simmi" <simmi@.discussions.microsoft.com> wrote in message
news:40C0320F-55F1-40AC-B58C-0A9A7853F935@.microsoft.com...
> Hi Thanks for ur answer.
> I am not talking about " ReportManager" browser .I am tallking about
> "ReportServer".
> I tried the same .But i am getting the same problem .
> "Bruce L-C [MVP]" wrote:
> > All I do is click on Show Details button
> > Go to the properties of the data source or report (just to the right of
the
> > checkbox is where you can click to get to the properties).
> >
> > You will see a checkbox for hide in list view.
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> >
> > "simmi" <simmi@.discussions.microsoft.com> wrote in message
> > news:9BAC278F-31EA-4A2C-A817-1318ED2F8723@.microsoft.com...
> > > Hi,
> > >
> > > I am very new to reporting services.And i did't work on any reporting
tool
> > > b4 this.
> > >
> > > (1):
> > > Now my problem is how can i hide subreports and datasource in
> > ReportServer
> > > browser?
> > >
> > > (2):
> > >
> > > I am sending http://myservername/Reportserver to all the end users.
> > > is it correct way or is there any differnt way the users can watch
> > reports.
> > >
> > > plz give me detail discription
> > >
> > > Any help will be appriciate
> > >
> > > Thanks!
> > >
> > >
> >
> >
> >

how can i give customize dataset to sql report

hi
i am new to sql reporting service, i am using for financial reporting,
in one of my requirement i have to calculate how much year customer's fund
will last and i have to show each year's balance.
in crystal report i get directly assign dataset, but how can i
assign dataset in reporting service, plz so urgentIn SSRS, you can assign an application dataset to server-based report only
if you use a custom dataset extension. In your case, I will gravitate toward
performing the data manipulation at the data source level, e.g. inside a
stored procedure. If you use SQL Server 2005 as a data source, consider
using a CLR stored procedure.
I demonstrate how this could be done in this code sample
(http://www.prologika.com/downloads/Pass/). The report invokes a CLR stored
procedure that uses data mining for sales forecasting.
As a side note, for financial reporting, I strongly suggest you evaluate
Analysis Services especially if you need to support account charts where
values substract or add (income, expenses, etc). Otherwise, you may find
yourself reinventing the wheel. I know from personal experience.
HTH
--
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
"Lovenish" <Lovenish@.discussions.microsoft.com> wrote in message
news:CE811BDF-1C05-4C34-9853-166E60A39D65@.microsoft.com...
> hi
> i am new to sql reporting service, i am using for financial reporting,
> in one of my requirement i have to calculate how much year customer's fund
> will last and i have to show each year's balance.
> in crystal report i get directly assign dataset, but how can i
> assign dataset in reporting service, plz so urgent|||Thx Teo Lachev,
but the code you have send is i think in visual studio 2005, i am
using 2003. so can u help me further,
u were talking about customize dataset extension but i cant get how to use
this so plz plz help me

How Can I generate a rdl file from a mdx query in VB.net or C#.net?

Is there some methods to generate the rdl file or reporting html page from a given mdx query language
For instance, I have a mdx query:
select dim1.a on rows, dim2.b on columns from cub1
How can I generate the corresponding rdl file to generate report html page with VB.net or C#.net?

I know that one can use xmltextwriter to write the rdl file but it is a difficult work.Is there some internal class in Vistual Studio have some methods to generate the rdl file?

Thanks

There's a good article here on this:

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

There's also some 3rd party libraries out there.

http://www.rdlcomponents.com/