Solved

VB.NET 2010 Reporting Help

Posted on 2011-09-16
3
471 Views
Last Modified: 2012-06-27
Hey All,

I'm making the transition to VB.NET 2010 from VB6 and I'm really missing my old busted VB6 right now. I was using ActiveReports for reporting, and basically, I just had to design the report using the field names I knew I'd need from my database, fill a recordset appropriately on the fly, and call the report, sending it the populated dataset to work with.

I'm totally and completely lost when trying to do reports with ReportViewer. I'm also on a deadline. Eventually, I'll learn all I need to know to make this work, but for now, I'm wondering...

Is there a reporting tool for .NET that will allow me to design reports using field names from my database, then when it's time to call a report, just pass the report the name of the database I want to use and the SQL necessary to populate it? I don't want to mess w/ all of the myriad of data connection stuff. I just want to pass a couple of parameters to the report and then see magic happen.

Shouldn't it be that easy?

Any help/insight will be appreciated.

Thanks,
Bret
0
Comment
Question by:FOS-Bret
3 Comments
 
LVL 27

Accepted Solution

by:
planocz earned 250 total points
ID: 36554555

you can still upgrade your activereports or get Cystral Reports or if you get a SQL server just add-on the SSRS reporting services and then you can make your reports.
I use SSRS reports and all you have to do is  make a shared connection that all your reports can use and then make a stored procedure to make the dataset for your report.
If you have Visual Studio you can do a add-on called BIDS that you can physically see and create reports from there or a reportviewer.
0
 
LVL 100

Assisted Solution

by:mlmcc
mlmcc earned 250 total points
ID: 36554987
Here is a method of feeding a dataset to a Crystal Report

http://www.emoreau.com/Entries/Articles/2006/09/Feeding-Crystal-Reports-from-your-application.aspx

mlmcc
0
 

Author Closing Comment

by:FOS-Bret
ID: 36556611
Thanks guys. I'm splitting the points between the two of you. I didn't realize that Crystal Reports is still free, so planocz' comment prompted me to take another look at it. The link that mlmcc provided got me started in getting the data sources dynamically assigned and now I'm good to go.

-Bret
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

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

Suggested Solutions

Title # Comments Views Activity
SSIS On fail action 5 37
jquery tab header text 1 22
Need syntax help building hyperlink 2 20
Amazon S3 Images with .Net 3 10
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…
The ECB site provides FX rates for major currencies since its inception in 1999 in the form of an XML feed. The files have the following format (reducted for brevity) (CODE) There are three files available HERE (http://www.ecb.europa.eu/stats/exch…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

792 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