access the Sql server: services

Showing posts with label services. Show all posts

Friday, March 30, 2012

How to author reports for Reporting Services?

I have installed and am using Reporting Services.

I can create RDL files using Visual Studio.NET, but like to offload this task to a minion who does not have VS.NET.

Is there a stripped down something-or-other to make reports that and end user or business analyst could use and then upload the reports?

Thanks.You might consider Soft Artisans'OfficeWriter. I personally don't have any experience using Reporting Services with OfficeWriter; I have only used their ExcelWriter product and was very pleased with both it and their customer service.

Terri

Wednesday, March 21, 2012

how to allow anonymous login to rep services on local machine ?

Hi,
I cant seem to allow reporting services on 2003 SBS to accept anonymous
logon (i.e im always prompted for user/pass from windows).
I added EVERYONE and ANONYMOUS LOGON with full control to INETPUB and
C:\program files\Microsoft SQL server dirs and made sure these settings
replaced all child dirs security i.e cascaded down.
Its a stand alone machine for demos so im not worried about security.
Can someone help ?
Thanks
Scottok sorted it using the IIS dir security options.
scott

How to align the text in justify format with SQL Server Reporting Services?

How to align the text in justify format In SQL server Reporting Services? Is there any code to do so?

Hi,

I suppose that with justify you mean "fit to entire line" format. This is not available in reporting services. There is only Left, Center and Right.

Greetz,

Geert

Geert Verhoeven
Consultant @. Ausy Belgium

My Personal Blog

|||

Hi,

Thank you for your reply. Yes, of course, i knew there was no option to justify the text in SQL Server Reporting Services. But i am in need to apply justify format for my text in one of my reports. Hence i also ask "Is there any code to do so?". If u came to know about this, kindly do reply me.

Kalaivani.

|||

Hi,

I'm afraid that if you want to have this kind of functionality, you will need to write a custom control. Here is an example: http://msdn2.microsoft.com/en-us/library/ms345265.aspx. The issue with custom controls is that it needs to be known by all the reportservers that will render your report.

Greetz,

Geert

Geert Verhoeven
Consultant @. Ausy Belgium

My Personal Blog

|||

Hi,

Thanks for your suggestion. I will try that way.

Kalaivani.

|||

Hello Everybody,

is there any other way to justify text on both sides , i am having the same problem as Kalaivani.

I appreciate ur response.

Ramzan

How to align the text in justify format with SQL Server Reporting Services?

How to align the text in justify format In SQL server Reporting Services? Is there any code to do so?

Hi,

I suppose that with justify you mean "fit to entire line" format. This is not available in reporting services. There is only Left, Center and Right.

Greetz,

Geert

Geert Verhoeven
Consultant @. Ausy Belgium

My Personal Blog

|||

Hi,

Kalaivani.

|||

Hi,

Greetz,

Geert

Geert Verhoeven
Consultant @. Ausy Belgium

My Personal Blog

|||

Hi,

Thanks for your suggestion. I will try that way.

Kalaivani.

|||

Hello Everybody,

is there any other way to justify text on both sides , i am having the same problem as Kalaivani.

I appreciate ur response.

Ramzan

How to align the text in Justify format with SQL Reports?

When i was working with SQL reporting services of MS SQLSERVER 2005, I am not able to align the text in Justify format, since there is no such option in it. But i need to align the text in justify format. How do i align it?

You may want to try this post in the Reporting Services area - this forum has to do with documentation.

Monday, March 19, 2012

How to add services to SQL Server Service Manager

I have 2 SQL Servers.
On the 1st server, when I go to the Service Manager, I can se all the 4
services:
1. Distributed Transaction Coordinator
2. Microsoft Search
3. SQL Server
4. SQL Server Agent
On the 2nd server, when I go to the Service Manager, I only see the last two
services! How can I add the DTC and the MS Search to the Service manager?
Thank you
BlackpitHi
Have you checked that these are installed?
John
"blackpit" wrote:
> I have 2 SQL Servers.
> On the 1st server, when I go to the Service Manager, I can se all the 4
> services:
> 1. Distributed Transaction Coordinator
> 2. Microsoft Search
> 3. SQL Server
> 4. SQL Server Agent
> On the 2nd server, when I go to the Service Manager, I only see the last two
> services! How can I add the DTC and the MS Search to the Service manager?
> Thank you
> Blackpit|||Hello John!
I did checked this out and, yes, they are installed.
Actually I have a suspicion that the fault is on the Security Policy applied
to the server that misses these 2 services on the Service Manager. The 2
servers are in diffferent Active Directory OUs, so different security
policies are applied in each case.
The problem is that I don't know what the exact security issue is the one
that creates the problem (e.g. NTFS permissions? Where and for Who?). If I
did, I could let the System Administrator know and he would be able to help
me grant/revoke the necessary privileges.
Do you have any idea, who needs What privileges on Where so that the 2
missing services can appear in the Service Manager?
Thank you for your time.
Vagelis
Î? Ï?Ï?Î®Ï?Ï?Î·Ï? "John Bell" ÎÎ³Î³Ï?Î±Ï?Îµ:
> Hi
> Have you checked that these are installed?
> John
> "blackpit" wrote:
> > I have 2 SQL Servers.
> >
> > On the 1st server, when I go to the Service Manager, I can se all the 4
> > services:
> > 1. Distributed Transaction Coordinator
> > 2. Microsoft Search
> > 3. SQL Server
> > 4. SQL Server Agent
> >
> > On the 2nd server, when I go to the Service Manager, I only see the last two
> > services! How can I add the DTC and the MS Search to the Service manager?
> >
> > Thank you
> > Blackpit|||Hi
I am not sure where the permissions could be causing a problem, but I would
guess it would be permissions on a specific registry entry that causes this.
Can you stop/start these services from the services applet on the
administrators menu?
John
"blackpit" wrote:
> Hello John!
> I did checked this out and, yes, they are installed.
> Actually I have a suspicion that the fault is on the Security Policy applied
> to the server that misses these 2 services on the Service Manager. The 2
> servers are in diffferent Active Directory OUs, so different security
> policies are applied in each case.
> The problem is that I don't know what the exact security issue is the one
> that creates the problem (e.g. NTFS permissions? Where and for Who?). If I
> did, I could let the System Administrator know and he would be able to help
> me grant/revoke the necessary privileges.
> Do you have any idea, who needs What privileges on Where so that the 2
> missing services can appear in the Service Manager?
> Thank you for your time.
> Vagelis
> Î? Ï?Ï?Î®Ï?Ï?Î·Ï? "John Bell" ÎÎ³Î³Ï?Î±Ï?Îµ:
> > Hi
> >
> > Have you checked that these are installed?
> >
> > John
> >
> > "blackpit" wrote:
> >
> > > I have 2 SQL Servers.
> > >
> > > On the 1st server, when I go to the Service Manager, I can se all the 4
> > > services:
> > > 1. Distributed Transaction Coordinator
> > > 2. Microsoft Search
> > > 3. SQL Server
> > > 4. SQL Server Agent
> > >
> > > On the 2nd server, when I go to the Service Manager, I only see the last two
> > > services! How can I add the DTC and the MS Search to the Service manager?
> > >
> > > Thank you
> > > Blackpit|||When I tried to start the Microsoft Search Service (via services applet)
using the same account that the MSSQLSERVER service starts, it didn't
startup. I guess I must find out where to give permissions for this account.
At least we found out that it is a security issue.
I will update the post when I find out the exact grants.
Thanks for your help.
Î? Ï?Ï?Î®Ï?Ï?Î·Ï? "John Bell" ÎÎ³Î³Ï?Î±Ï?Îµ:
> Hi
> I am not sure where the permissions could be causing a problem, but I would
> guess it would be permissions on a specific registry entry that causes this.
> Can you stop/start these services from the services applet on the
> administrators menu?
> John
> "blackpit" wrote:
> > Hello John!
> >
> > I did checked this out and, yes, they are installed.
> >
> > Actually I have a suspicion that the fault is on the Security Policy applied
> > to the server that misses these 2 services on the Service Manager. The 2
> > servers are in diffferent Active Directory OUs, so different security
> > policies are applied in each case.
> >
> > The problem is that I don't know what the exact security issue is the one
> > that creates the problem (e.g. NTFS permissions? Where and for Who?). If I
> > did, I could let the System Administrator know and he would be able to help
> > me grant/revoke the necessary privileges.
> >
> > Do you have any idea, who needs What privileges on Where so that the 2
> > missing services can appear in the Service Manager?
> >
> > Thank you for your time.
> > Vagelis
> >
> > Î? Ï?Ï?Î®Ï?Ï?Î·Ï? "John Bell" ÎÎ³Î³Ï?Î±Ï?Îµ:
> >
> > > Hi
> > >
> > > Have you checked that these are installed?
> > >
> > > John
> > >
> > > "blackpit" wrote:
> > >
> > > > I have 2 SQL Servers.
> > > >
> > > > On the 1st server, when I go to the Service Manager, I can se all the 4
> > > > services:
> > > > 1. Distributed Transaction Coordinator
> > > > 2. Microsoft Search
> > > > 3. SQL Server
> > > > 4. SQL Server Agent
> > > >
> > > > On the 2nd server, when I go to the Service Manager, I only see the last two
> > > > services! How can I add the DTC and the MS Search to the Service manager?
> > > >
> > > > Thank you
> > > > Blackpit

How to Add Reporting Services in Microsoft Dynamics CRM 3.0

What do you mean by "add reporting services in [...] CRM"? SRS is a prerequisite for CRM (if you want reports to work) so you ususally install it on the SQL Server before installing CRM. During CRM setup you get to specify the URL to your reporting server.

|||

Dear Mattias,

When I click http://localhost:5555/ReportServer , I am getting error as follows:

An error has occured. For more information, contact your system administrator.

Also when I click on System Settings, it gives me same error as above.

|||

I'm getting the same message.

I found a reason why it shows: my default web-site has been stopped for security reasons, and CRM have link to http://localhost/Reports in it's registry under LOCAL_MACHINE\Software\Microsoft\MSCRM.

Also I found there a record RSInstalled = 0. I think it means that Report Services has not been used during CRM installation (I had SQL 2005 installed with RS before CRM, but default web has been stopped). I've provided correct URL during CRM installation to local report services, still it set http://localhost/reports to the registry.

So now I'm looking how to "add" reports to the CRM.

If you will get an answer, could you share it, please?

|||

In the CRM,

You are able to import your RDL file in your settings area, you can then select which entities you want to have access to that report. Note, you will have to update your config file if you want to report to run from a menu should as "Orders", "Accounts", and "Contacts"

Ham

|||

Hi Subodhs,

Please Help me out, i am also not able to open System settings and getting the same error as you are getting if you know the solution,please let me know ASAP...Its URGENT....gentle request

Thanks & Regards,

kunal

|||

Download SQLReportPackCRM.msi and SQL2KRSSP2-ENG.EXE, it will start working.

Cheers,

Subodh

|||a CRM 1.2 file and a SQL2k fix? Either package did not install on my servers. the question was regarding crm 3.0 and sql 2005. Any ideas?|||

Hello Josh

Have you got help with this, or have you solved this issue?

How to Add Reporting Services in Microsoft Dynamics CRM 3.0

|||

Dear Mattias,

When I click http://localhost:5555/ReportServer , I am getting error as follows:

An error has occured. For more information, contact your system administrator.

Also when I click on System Settings, it gives me same error as above.

|||

I'm getting the same message.

I found a reason why it shows: my default web-site has been stopped for security reasons, and CRM have link to http://localhost/Reports in it's registry under LOCAL_MACHINE\Software\Microsoft\MSCRM.

So now I'm looking how to "add" reports to the CRM.

If you will get an answer, could you share it, please?

|||

In the CRM,

Ham

|||

Hi Subodhs,

Please Help me out, i am also not able to open System settings and getting the same error as you are getting if you know the solution,please let me know ASAP...Its URGENT....gentle request

Thanks & Regards,

kunal

|||

Download SQLReportPackCRM.msi and SQL2KRSSP2-ENG.EXE, it will start working.

Cheers,

Subodh

|||a CRM 1.2 file and a SQL2k fix? Either package did not install on my servers. the question was regarding crm 3.0 and sql 2005. Any ideas?|||

Hello Josh

Have you got help with this, or have you solved this issue?

How to Add Reporting Services in Microsoft Dynamics CRM 3.0

|||

Dear Mattias,

When I click http://localhost:5555/ReportServer , I am getting error as follows:

An error has occured. For more information, contact your system administrator.

Also when I click on System Settings, it gives me same error as above.

|||

I'm getting the same message.

I found a reason why it shows: my default web-site has been stopped for security reasons, and CRM have link to http://localhost/Reports in it's registry under LOCAL_MACHINE\Software\Microsoft\MSCRM.

So now I'm looking how to "add" reports to the CRM.

If you will get an answer, could you share it, please?

|||

In the CRM,

Ham

|||

Hi Subodhs,

Please Help me out, i am also not able to open System settings and getting the same error as you are getting if you know the solution,please let me know ASAP...Its URGENT....gentle request

Thanks & Regards,

kunal

|||

Download SQLReportPackCRM.msi and SQL2KRSSP2-ENG.EXE, it will start working.

Cheers,

Subodh

|||a CRM 1.2 file and a SQL2k fix? Either package did not install on my servers. the question was regarding crm 3.0 and sql 2005. Any ideas?|||

Hello Josh

Have you got help with this, or have you solved this issue?

Monday, March 12, 2012

How to add parameters and filters?

Hi,

I would like to ask a few questions about Reporting Services.

1. Can we add new parameters (by code on VS2005) at runtime when the report it's on a server? Since the job of the Report Viewer only allow to get/set parameters and not add new parameter, i wonder if there is a way to add parameter without adding manually on the report design mode.

2. Can i add some filter to change the data show on the report? (To be more specific, I didnt mean to add filter at the design mode on VS2005, I want to be able to add filter by code)

3. Can i change the query (dataset) of a report at runtime (once again i mean by code) which it's on the reportserver? (Since we can change the query on a rdlc report , i wonder if we can do the same on a rdl.)

Thanks in advance

1. No, you can only change the # of parameters by republishing the RDL.

2. No, you can only add filters in the RDL. You can affect the filter by runtime parameters, though.

3. You can change the connection string at runtime via a parameter, but not the query. That would require republishing an updated RDL.

BTW, you can call SetReportDefinition programatically, so you can achieve all your objectives roundabout by crafting an updated RDL and republishing in code or with script.

Friday, March 9, 2012

How to add fields to Report Designer from a Web Service or something equivalent?

Hello,

I am trying to add some fields to my report (Using SQL Server 2005 Reporting Services, Visual Studio 2005).

As of now I can only use fields from one of my tables, or use functions within SQL DBMS. However, sometimes I wish to do more complicated things which can not be done (or at least I don't know how to do) withing SQL DBMS.

I wish to write a C# function (Web service) which takes a bunch of parameters and spits out some text. Is it possible to add a field to the report which calls this Web service, sends a bunch of parameters and displays the result of the function.

If not, Is there any way at all to manipulate some data using C# and display the result in the report.

Thanks in advance,

Any help is much appreciated

Amir

If what you are asking is "Can report items be dynamically added to a report"? then the answer is yes.

You can dynamikcally add fields to a report by loading the RDL via a memory stream to the report viewer control in local mode. Prior to loading the RDL you will need to parse the XML in order to add the the field.

How to add columns dynamically based on number of groups used.

How to add columns dynamically based on number of groups used.
Hi,
I am pretty new to the Microsoft Reporting services. I wanted to know if
this is possible to design in the reporting server.
I have a requirement to take the number of groups in my report as input. So
if there are two groups I will have two columns and if I have three groups I
will have three colums. Is there any way I can dynamically set the number of
columns based on the input.
Currently I am having to design different report for different number of
groups. This causes more maintenance in case of frequent report design
changes.
Thanks in advance,The matrix control add columns dynamically.
"Ragz" wrote:
> How to add columns dynamically based on number of groups used.
>
> Hi,
> I am pretty new to the Microsoft Reporting services. I wanted to know if
> this is possible to design in the reporting server.
> I have a requirement to take the number of groups in my report as input. So
> if there are two groups I will have two columns and if I have three groups I
> will have three colums. Is there any way I can dynamically set the number of
> columns based on the input.
> Currently I am having to design different report for different number of
> groups. This causes more maintenance in case of frequent report design
> changes.
>
> Thanks in advance,
>
>

How to add columns dynamically based on number of groups used.

Hi,

I am pretty new to the Microsoft Reporting services. I wanted to know if this is possible to design in the reporting server.

I have a requirement to take the number of groups in my report as input. So if there are two groups I will have two columns and if I have three groups I will have three colums. Is there any way I can dynamically set the number of columns based on the input.

Currently I am having to design different report for different number of groups. This causes more maintenance in case of frequent report design changes.
Thanks in advance,
Ragz.To Elaborate further on this question.

If I have a table like

Employee(EmployeeName varchar(100),EmployeeManagerName varchar(100),team varchar(100),experience int)

I take the following inputs:
The number of groups and what to group on.

For example one input might be:
No of groups:1
group-on:EmployeeName.
The resulting report will have
Employee-Name experience
xxxx yyyy
But If I have Number of Groups as 2 and
group-on as
EmployeName and EmployeemanagerName
then i will have three columns Employee-name Employee-manager-name experience

The questions is how can I generate these columns dynamically ?|||Yes, you can do this. The way to do this is:
1) Create a report parameter that specifies the number of groups
2) to add a calculated field to your data set (right click on the Fields window and choose add).
2.1) the expression for the field would select which of the three groups you'd have (e.g. 1, 2, or 3... or what ever you need)
3) Create a matrix report
3.1) group the columns on your constructed parameter

That should probably work.

-Lukasz

How to add Calender control in SQL Reports

I am trying to find out on how to insert the calendar control into the
SQL Reports using SQL 2005 Reporting Services. Can someone let me know
on how to perfom this operation.
Thanks.Hi Dani, how are you?
You don't need to crate a calendar control. Just define an input
parameter as datetime and a calendar control will appear just next to
the text box to input the date.
I hope this works for you.
Dani vient de nous annoncer :
> I am trying to find out on how to insert the calendar control into the
> SQL Reports using SQL 2005 Reporting Services. Can someone let me know
> on how to perfom this operation.
> Thanks.|||On Dec 26, 12:57=A0pm, Ciro Daniele <c...@.geosolution.com.ar> wrote:
> Hi Dani, how are you?
> You don't need to crate a calendar control. Just define an input
> parameter as datetime and a calendar control will appear just next to
> the text box to input the date.
> I hope this works for you.
> Dani vient de nous annoncer :
>
> > I am trying to find out on how to insert the calendar control into the
> > SQL Reports using SQL 2005 Reporting Services. Can someone let me know
> > on how to perfom this operation.
> > Thanks.- Hide quoted text -
> - Show quoted text -
Thanks a lot, Ciro. It worked!

Wednesday, March 7, 2012

How to add a URL to a ASP page into the Reporting Services folder

I want to add the URL to a ASP page into the Reporting Services Folder.
We are sort of using the Reporting Services as a portal to our other
reporting applications. I want to include the URL to a ASP page in a
reporting services folder not sure how to do this.
Please help with a simple URL scenario.
Thanks
Karenfirst add a web reference to ASP project
then define parameters of Reporting Service.render()
the url is a parameter of that function.
it works well on ASP.NET
but i do not know whether it is available on ASP|||Sorry, all I want to do is add an HTML page URL link to a reporting
services folder. I could not find much information on how to do this in
report manager.
Thanks
Karen|||the url is like that http://localhost/ReportServer?/sample
rs/Nametag&rs:Format=pdf
some of the url parameters are BookimakrID,DocMap, EndFind,FallbackPage|||So how do I publish the link to a URL into the Report Folder
Thanks
Karen|||All I want to do is put URLs to other applications and HTML pages into
the RS Folder. So sort of I want to use it as a portal not just as a
means to reach only reports
Thanks
Karen|||The only way I am aware of how to do this is to add a page that has the
links. You can create an HTML page and then add it to your report project
and deploy it.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<karenmiddleol@.yahoo.com> wrote in message
news:1131673239.202311.213960@.f14g2000cwb.googlegroups.com...
> All I want to do is put URLs to other applications and HTML pages into
> the RS Folder. So sort of I want to use it as a portal not just as a
> means to reach only reports
> Thanks
> Karen
>

How to add a reference to a report?

Hi:

I am bulding a report in VS 2005 using the reporting services. I like to know how to add a new reference to my report?

Ben

What do you mean by a reference?

|||

Like .NET 2003 where under Project Properties you have "References" where you add references to other dlls). I have a 3rd party application that I like to add its dll to my report and use its features.

|||

In solution explorer, right click your project name then click add reference.

|||I don't have this option in VS 2005 (reporting services).

|||

Oh I didn't know you were talking about Business Intelligence Studio.

In the main menu (top of the screen) click report -> report properties. Then click the references tab.

How to add a New Server Registration for Reporting Services

I am trying to add a new server registration for Reporting Services. I am
using the Microsoft SQL Server Management Studio (SQL Server 2005). I also
have SQL Server 2000 installed. I placed 'LT-L31896\SQL05' in the 'Server
name:' field in the New Server Registration dialog and when I press the Test
button at the bottom, I receive the message
'Testing the registered server failed. Verify the server name, login
credentials. and database, and then click Test again.
Additional Information:
The Report Services WMI Provider is not installed or is misconfigured'
SQL Server 2000 uses the default instance name while I named the SQL Server
2005 instance 'LT-L31896\SQL05'.
Sorry if I didn't explain this correctly, I'm a developer and have limited
knowledge of SQL Server.
--
Dave B.are you sure that the server admin has granted you the appropriate
permissions ? double check with them.
Don't forget, you can register servers inside of VS 2005
"dmbuso" <dmbuso1@.community.nospam> wrote in message
news:E8F9244E-C283-49B7-92F8-D2A0E2B291F8@.microsoft.com...
>I am trying to add a new server registration for Reporting Services. I am
> using the Microsoft SQL Server Management Studio (SQL Server 2005). I also
> have SQL Server 2000 installed. I placed 'LT-L31896\SQL05' in the 'Server
> name:' field in the New Server Registration dialog and when I press the
> Test
> button at the bottom, I receive the message
> 'Testing the registered server failed. Verify the server name, login
> credentials. and database, and then click Test again.
> Additional Information:
> The Report Services WMI Provider is not installed or is misconfigured'
> SQL Server 2000 uses the default instance name while I named the SQL
> Server
> 2005 instance 'LT-L31896\SQL05'.
> Sorry if I didn't explain this correctly, I'm a developer and have limited
> knowledge of SQL Server.
> --
> Dave B.|||Hello Dave,
Could you please go to the Services to find the SQL Reporting Services.
What's the instance name after that service?
If is SQL05, then please contact your admin to grant your proper permission
to connect to the Reporting Services instance.
Also, please remember, the management studio could not connect to the SQL
2000 Reporting Services.
Hope this helps.
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.)|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Thank you Wei Lu, this was helpful to me. It turns out that my demo version
of EE SQL2005 had no instance of Reporting Services running as a service. I
must have overlooked that when installing.
Question; I installed the EE so that I could learn. I recently discovered
the Developers Edition of SQL Server (x64) will allow me to learn, build, and
experience just as much as the EE. The problem is that in less than 6 months
my demo will expire. Can I retain all of my work, reports, stored procedures
and such by installing either the Standard Edition or the Developers Edition
when the time comes?
"Wei Lu [MSFT]" wrote:
> Hi ,
> How is everything going? Please feel free to let me know if you need any
> assistance.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>

How to add a line chart while building report

This is my first time with Reporting Services. I was using the wizard and it
only had the options of Matrix or tabular.
I want to add a line chart instead. How can I do so ?
ThanksInstead of using the report wizard, create a blank report. Then add a chart
from the toolbox.
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"Hassan" <hassan@.test.com> wrote in message
news:OAbD2FjYIHA.6140@.TK2MSFTNGP02.phx.gbl...
> This is my first time with Reporting Services. I was using the wizard and
> it only had the options of Matrix or tabular.
> I want to add a line chart instead. How can I do so ?
> Thanks

Friday, February 24, 2012

How to Add a Calculated Column in Report Builder using a Model Based on a SSAS Cube

I am trying to add a calculated field / column in Report Builder when working with a Report Model built from anAnalysis Services Cube. I can create the calculated Field/Columns, but I get an error whenever I try to use it in a report.

Is there a way to create a report builder calculated column on report models built from a SSAS cube? Is this supported?

Thanks,

Some functions are not supported for calculated fields when running against an SSAS cube, in particular the aggregate functions like Sum, Count, Average, etc. The error message should provide some details on this.

Hope that helps!

|||

The support for calculated fields in an SSAS model is better than Bob lets on. Most functions work. The trick is that you need to install Excel 2003 on the Analysis Services server. (Not sure if other versions like Excel 2007 work, but I know Excel 2003 does the trick.)

Report Builder builds MDX that use Excel functions, and for those functions to succeed, Excel has to be installed on the server.

If you agree with me that this is a terrible architecture, vote for this issue:

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=124864

|||Are there any online documentation about this? Our IT policy is not to install office or office application on SQL Server boxes.|||

Common policy. Vote for that issue at connect.microsoft.com and maybe MS will change this in Katmai.

As for documentation:

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

And documentation of the excel functions that are supported. (Don't know if there's a 2005 version of this page, but they're the same):

http://msdn2.microsoft.com/en-us/library/aa178231(SQL.80).aspx

I suppose one workaround is to code the Excel functions yourself and register them as specified here:

http://geekswithblogs.net/darrengosbell/archive/2006/12/13/100998.aspx

If you have interest in going that route, let me know because there are some gotchas.

Friday, March 30, 2012

How to author reports for Reporting Services?

Wednesday, March 21, 2012

how to allow anonymous login to rep services on local machine ?

How to align the text in justify format with SQL Server Reporting Services?

How to align the text in justify format with SQL Server Reporting Services?

How to align the text in Justify format with SQL Reports?

Monday, March 19, 2012

How to add services to SQL Server Service Manager

How to add services to SQL Server Service Manager

How to Add Reporting Services in Microsoft Dynamics CRM 3.0

How to Add Reporting Services in Microsoft Dynamics CRM 3.0

How to Add Reporting Services in Microsoft Dynamics CRM 3.0

Monday, March 12, 2012

How to add parameters and filters?

Friday, March 9, 2012

How to add fields to Report Designer from a Web Service or something equivalent?

How to add columns dynamically based on number of groups used.

How to add columns dynamically based on number of groups used.

How to add Calender control in SQL Reports

Wednesday, March 7, 2012

How to add a URL to a ASP page into the Reporting Services folder

How to add a reference to a report?

How to add a New Server Registration for Reporting Services

How to add a line chart while building report

Friday, February 24, 2012

How to Add a Calculated Column in Report Builder using a Model Based on a SSAS Cube

access the Sql server

Blog Archive

About Me