Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsFree MagazinesWhite PapersSubmit Content
Discussion GroupsASP.NETWindows FormsLanguages.NET FrameworkVisual Studio.NET
Articles.NET FrameworkASP.NETToolsWindows Forms
.NET DirectoryOpen Source ProjectsUser GroupsWeb Resources
Related Topics
Visual Basic 6SQL ServerMS AccessOther DB ProductsMS Server ProductsMore Topics ...

.NET Forum / .NET Framework / ADO.NET / January 2006

Tip: Looking for answers? Try searching our database.

Reports

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Ilya Dyoshin - 13 Jan 2006 05:54 GMT
Hi all!

I'm writting a simpe application. User enters an SQL query, and he
receives the query result in report like table.

I have a question: can I solve this problem with Crystal Report?

If so, some code somples would be greate. For example I'd appreciate
code on how to add columns and data from DataSet.Tables[i] to the report
(not exactly from database).

Thanks
William (Bill) Vaughn - 13 Jan 2006 18:30 GMT
While I'm neither a fan nor an expert on Crystal, I do know a bit about
reports. The ReportViewer control in VS2005 or Reporting Services (now
included with all versions of SQL Server) would probably work just fine.

Signature

____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

> Hi all!
>
[quoted text clipped - 8 lines]
>
> Thanks
Ilya Dyoshin - 14 Jan 2006 09:57 GMT
> While I'm neither a fan nor an expert on Crystal, I do know a bit about
> reports. The ReportViewer control in VS2005 or Reporting Services (now
> included with all versions of SQL Server) would probably work just fine.

Well, thanks for information.

I'm using ReportViewer control. The question is how to create report
while program is running. I can't say exact table structure during
developing. And so I need some code sample how to create table in Report
 on the fly.
William (Bill) Vaughn - 15 Jan 2006 00:45 GMT
Ah, well that's an ambitious goal, but reachable. I won't write the code for
you but it's all doable.
I would start with an RDLc (XML-format report definition) template. I would
put target tags therein to help insert your own structure. This will be a
challenge, but it's just XML. I expect you can manage it with the DOM.
Next, as to data, the Report Viewer simply expects a rowset that has the
columns specified in the RDLc. The Report Viewer control can be completely
programmed on the fly--setting the data source and parameters.
We'll have several examples of most of this in our book--but it won't be out
for awhile yet.

hth

Signature

____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

>> While I'm neither a fan nor an expert on Crystal, I do know a bit about
>> reports. The ReportViewer control in VS2005 or Reporting Services (now
[quoted text clipped - 5 lines]
> program is running. I can't say exact table structure during developing.
> And so I need some code sample how to create table in Report on the fly.

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.