Solved

Reporting in ASP.NET website

Posted on 2013-02-07
4
459 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 166 total points
ID: 38865228
0
 
LVL 10

Accepted Solution

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

Assisted Solution

by:ValentinoV
ValentinoV earned 167 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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

More often than not, we developers are confronted with a need: a need to make some kind of magic happen via code. Whether it is for a client, for the boss, or for our own personal projects, the need must be satisfied. Most of the time, the Framework…
Introduction In the following article I’ll be discussing and demonstrating several different ways of how images can be put on a report. I’m using SQL Server Reporting Services 2008 R2 CTP, more precisely version 10.50.1352.12, but the methods ex…

756 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