Solved

Reporting in ASP.NET website

Posted on 2013-02-07
4
442 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
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

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

Suggested Solutions

Written by Valentino Vranken. Introduction: The first step of creating a SQL Server Reporting Services (SSRS) report involves setting up a connection to the data source and programming a dataset to retrieve data from that data source.  The data…
Wouldn’t it be nice if you could test whether an element is contained in an array by using a Contains method just like the one available on List objects? Wouldn’t it be good if you could write code like this? (CODE) In .NET 3.5, this is possible…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

821 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