Solved

Reporting in ASP.NET website

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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

738 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