Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Reporting in ASP.NET website

Posted on 2013-02-07
4
Medium Priority
?
489 Views
Last Modified: 2013-02-08
I need to create some reports using SSRS for my ASP.NET websites. I'm very new to SSRS.
Can you provide some general guide how to approach this project?
First I installed Reporting Service in SQL server and I'm fooling around with BID tool and got far to where I know how to publish to http. But I feel this BID is somewhat limited in creating report. I like to know how other report developers work with and how the production and development environments are set up so that I start up in the right direction.
0
Comment
Question by:crcsupport
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 1

Author Comment

by:crcsupport
ID: 38864960
And also in Expression, Can I use all .Net Framework functions and properties? I'm comfortable using C# instead of Visual Basic. I saw a couple of tutorials where Expression editor allows to use .net Visual Basic funtions, I wonder if I'm also open to use all .net C# codes such as string, regex and others.
0
 
LVL 19

Assisted Solution

by:Manoj Patil
Manoj Patil earned 664 total points
ID: 38865228
0
 
LVL 10

Accepted Solution

by:
Monica P earned 668 total points
ID: 38867018
0
 
LVL 37

Assisted Solution

by:ValentinoV
ValentinoV earned 668 total points
ID: 38867117
Developers are using BIDS for their report development, it is the recommended tool to use. Is it limited?  Well, every tool has its limits, right?  But my opinion is that you can actually get quite a lot done using BIDS for SSRS development.  It's just a matter of getting used to, and experience.

The language to use for expressions is indeed limited to VB, no C#.  But the expression functions are not limited to what's mentioned in the Expression builder.  You can indeed make use of the .NET framework.

Here's an example that uses the Regex class.  Matches is a static method so doesn't require a class instantiation:

=System.Text.RegularExpressions.Regex.Matches("Who writes these notes?", "\b\w+es\b").Count

Open in new window

(example based on Regex.Matches Method example)

The example above should result in 2.

Can you use the whole .NET framework?  Well, probably not.  As these are running on the SSRS server, there are some security (and other) issues if that would be allowed.  But the following should be supported at least:

You can write expressions that use functions from the Microsoft Visual Basic run-time library, and from the System.Convert and System.Math namespaces. You can add references to functions from other assemblies or custom code. You can also use classes from the Microsoft .NET Framework, including System.Text.RegularExpressions.

More info: Expression Examples

If the above does not satisfy your needs, or you really want to use C#, that's possible as well.  It can be done by developing a custom assembly (in C#) and then add it to your report.  But I wouldn't recommend this because it makes deployment and maintenance more complicated.

More info: Custom Code and Assembly References in Expressions in Report Designer
0

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to use Variables  and Custom code in SSRS report and Assembly reference to use compile shared code in SSRS. Its big question for all who are working with SSRS. It is easy to create assembly and refer in SSRS report, still there are some steps…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

618 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question