Reports

  • Thread starter Thread starter Ilya Dyoshin
  • Start date Start date
I

Ilya Dyoshin

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 to the report
(not exactly from database).

Thanks
 
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.

--
____________________________________
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.
__________________________________
 
William said:
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.
Click to expand...

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.
 
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

--
____________________________________
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.
__________________________________
 
Back
Top