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

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.

Show quoteHide quote

William (Bill) Vaughn wrote:
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

Show quoteHide quote

View Excel Document in VB.Net Form
ADO.net Code contest
(C#/2.0) ORA-01036 Error When Upd/Ins/Del from Gridview
TableAdapter Garbage
adapter.fill and progress bar