Creating reports?

Paulo

Hi, how can I create web reports? I need to create grouping, subtotals,
totals, etc...

Must I use gridview? Generating <tableand <tris the best solution?

Using asp.net C# 2.0

Thanks

Oct 8 '07 #1

Subscribe Reply

1771

arti_kapila

On Oct 8, 7:15 pm, "Paulo" <prbs...@uol.co m.brwrote:

Hi, how can I create web reports? I need to create grouping, subtotals,
totals, etc...

Must I use gridview? Generating <tableand <tris the best solution?

Using asp.net C# 2.0

Thanks

hi

use crystal reports.

Oct 8 '07 #2

sloan

Asking "how should I generate reports?" is kinda like asking
"What kind of car should I buy?"

There are several different ways to do it.

Homegrown ( asp:repeater , asp:gridview) (as you've alluded to)
Crystal Reports
Active Reports
Sql Server Reporting

You do NOT want to generate <table><trstate ments.
I'm gonna suggest this article:
http://www.codeproject.com/useritems...talReports.asp

with emphasis on "WITH A DATASET".

A (strong) dataset is kind of a mini-setup of you database.
You might have 100 tables in your database, but if you need a report of
Employees and which Department they are in, you only need to deal with 2 or
3 tables to make this report.
Employee (database table) and Department (database table) and maybe a
EmployeeDepartm entLink (database table)(if Employees are in more than 1
department).
The dataset would also (and only) have these 2/3 tables in it.
Then you create some kind of select (or stored procedure) method to populate
the dataset.

THEN (and only after you get the data you need in the dataset) you open
Crystal Reports (CR) and start working with the data, as the URL/Link I gave
you shows.

ActiveReports is like CrystalReports, but you have to buy/pay for it.
But I prefer AR over CR.
(like some people prefer Chevrolet over Ford).
But that'll get you going.

"Paulo" <pr*****@uol.co m.brwrote in message
news:Or******** ******@TK2MSFTN GP05.phx.gbl...

Hi, how can I create web reports? I need to create grouping, subtotals,
totals, etc...

Must I use gridview? Generating <tableand <tris the best solution?

Using asp.net C# 2.0

Thanks

Oct 8 '07 #3

sloan

This explains it a little better.

http://www.codeproject.com/aspnet/crystal_report.asp

You def want to go with the PUSH method.

PULL will get you into trouble fast. PULL is very non-maintainable, and if
you ever want to switch to something besides CR, PULL will screw you.

"Paulo" <pr*****@uol.co m.brwrote in message
news:Or******** ******@TK2MSFTN GP05.phx.gbl...

Hi, how can I create web reports? I need to create grouping, subtotals,
totals, etc...

Must I use gridview? Generating <tableand <tris the best solution?

Using asp.net C# 2.0

Thanks

Oct 8 '07 #4

Similar topics

2917

Having difficulty creating reports with query parameters set from form controls

by: longtim | last post by:

I have been having endless difficulty creating reports/queries that set any relevent parameters from controls in forms. I am creating an application under access 2003 but will target access 2000. The access file is in access 2000 format. I have a form that will hold the relevent parameters for the query/report that reports the statistics for all job records that match a certain criteria. These are: - A Customer Name.

Microsoft Access / VBA

6103

creating a dynamic ODBC connection in C#

by: Mike | last post by:

I am writing a .NET application in C# that uses Crystal Reports. I want the crystal reports to grab information from a database no matter where the database is located. To do this, I want to create an ODBC connection to the database at runtime in order for the report to grab data from the database. Does anyone have a code snippet that shows how to do this? Thank you very much for your reply. Mike

C# / C Sharp

4690

Creating a plugin architecture

by: Joe_Black | last post by:

Hi all, I want to create an MDI app that allows reporting on XML data files downloaded from the equipment that we manufacture, this MDI app will have several default reports but due to the nature of the data different people will want to see it in different ways. What I would like to do is have several standard reports/graphing MDI Children that come as standard, then allow the user to apply a plugin that will allow them to view their...

C# / C Sharp

1879

Best practices for creating reports

by: Przemo | last post by:

Hi, I have an ASP.NET 2.0 application. I need to generate some documents (reports) like invoices, orders, etc. Users need them to preview and print. Which of methods is the best for doing it: 1. Creating HTML page containing data (problems with rendering and unexpected behavior when dynamic text is too long), 2. Creating invoice as a XML and then transforming it into ready document using XSLT 3. Rendering document as a GIF just writing...

ASP.NET

1669

Having problem creating an SQL stat. for a report

by: erick-flores | last post by:

Hello all I am creating an Expense Report. There are to types of expenses: Company expenses and Reimb Expeneses. The company expenses is under "Expense Details Co" table and Reimb Expenses is under "Expense Details" table. So I am creating this final report to see both type of expenses separately but I CANT. I got this report design from a website, but it only came with one "Expense Details" table, so I add the Expense Details Co. The...

Microsoft Access / VBA

6895

Checking if a Folder Exists and if not, creating it.

by: Argonath | last post by:

Hi, I'm afraid this will no doubt horrendously basic as I'm a complete newbie to VB and have dived in without learning to do much... Start in the deep end and all. So if anyone could help, I'd appreciate it; I've got this bit of code and I couldn't for the life of me tell you why it doesn't work, if anyone else can I'd appreciate it! Cheers

Visual Basic 4 / 5 / 6

3679

Creating bmp file from VB.NET

by: Andy Baker | last post by:

I have a utility that captures a signature on a handheld device and stores it as as string containing a series of points. I want to recreate this signature as a bmp file using VB.NET code. To do this, I have created a bitmap object using the following code Dim bmpSignature as Bitmap bmpSignature = New BitMap(240, 80) and I then use the graphics object to replot the points on the new bitmap, and save it using...