Reporting against SQL Server

[saurabhd]

Hi all,
I am currently evaluating the Silverlight Report Designer and Silverlight Report Viewer. I have a few questions -

1)How do I design a report that will use SQL Server as a data source?
2)Will the SQL query reside within the report file (.mrt) or do I need to externally query and supply the dataset to the report?

If you have a sample uses AdventureWorks or something similar that would be great.

thanks,
Saurabh

[Alex K.]

Hello Saurabh,

Please check the sample project in attachment.

Thank you.

[saurabhd]

Brilliant. I could get it work. I like the way how the UI brings up a list of available tables to report against.:biggrin: :biggrin:

[Andrew]

Hello,

Excellent.

Have a nice day!

[gustavo]

Can you share some silverlight sample doing this from server-side?

Dim db As New Stimulsoft.Report.Dictionary.StiSqlDatabase("NovaConexao", "NovaConexao")
db.ConnectionString = "Data Source=MyServer;Initial Catalog=MyDataBaseName;Persist Security Info=True;User ID=sa;Password=pass"
oReport.Dictionary.Databases.Add(db)

Dim dataSource As New Stimulsoft.Report.Dictionary.StiSqlSource("DataBase", "Orders", "DataBaseAlias", "SELECT * FROM dbo.Orders")
dataSource.Columns.Add("ID", "Order Id", GetType(Int32))
oReport.Dictionary.DataSources.Add(dataSource)

but no success!
why?

Is there any silverlight sample doing this in runtime?

[HighAley]

Hello.

We checked your code in the Client/Server Silverlight version. It works.
Due to the Silverlight restrictions this code won't work in the Native Silverlight.

Thank you.

[gustavo]

I founded why...
Just insert this code before InitializeComponent()

Code: Select all

Stimulsoft.Report.StiOptions.Silverlight.WCFService.UseWCFService = True

and then it appears at the Dictionary sources...

[Alex K.]

Hello,

Ok.
Let us know if you need any additional help.

Thank you.