Creating reports and dashboards | Stimulsoft community forum

well here is something i have been looking for well i have designed a report in designer and have named all the fields as such {sp_CustomForms_UCAF.ProviderName} where sp_CustomForms_UCAF is supposed to be the name of the data source in the report and "ProviderName" as the column name now what i want to do is to pass the values for these columns from the source of my project in the shape of a sql dataset hence making this much more usable for us. i am attaching the report here please guide me how it is possible . my manager has asked me to do something like it happened in Crystal reports design in the designer and pass data from the source please help in this issue.

Hello,

You can use the following code.
New connection string: Add DataSources: Add Columns: Thank you.

Can i Add a Sql Dataset in StiSqlSource or can i execute a stored procedure and pass parameters instead of using a select command ??

this all is done but how can i bind data with it via a dataset when report has to be viewed

remember that in my report the fields are done as "{sp_CustomForms_UCAF.AccountName}" so the name of the datasource should be -sp_CustomForms_UCAF and i am till now doing the following it is opening the report in reportviewer without loading loading any data please help

sp_CustomForms is the dataset which contains the feilds and data

Dim Con As String = "Data Source=.;Initial Catalog=Standard_Hospital; Asynchronous Processing=true ;User ID=sa"

Rep.Dictionary.Databases.Clear()
Rep.Dictionary.Databases.Add(New Stimulsoft.Report.Dictionary.StiSqlDatabase("Connection", Con))

Dim sp_CustomForms_UCAF = New StiSqlSource("Connection", "sp_CustomForms_UCAF", "sp_CustomForms_UCAF", "execute sp_CustomForms_UCAF", True, False)
Rep.Dictionary.DataSources.Add(sp_CustomForms_UCAF)

For Each col In sp_CustomForms.Columns

sp_CustomForms_UCAF.Columns.Add(col.ColumnName, col.DataType)

Next

Rep.RegData("Connection", ds)
Rep.Compile()

Me.StiWebViewer1.Report = Rep

Hello,

Sorry, maybe we did not exactly understand your question. Could you explain your issue in more details?

Thank you.