Creating reports and dashboards | Stimulsoft community forum

To make Postgres Ole Db connection:

First, I copied these two dll's to

PgOleDb.dll
libpq.dll

C:\Windows\System\
then registered PgOleDb.dll

Used PostgreSQL OLE DB Provider to create my
connection string:

Provider=PostgreSQL OLE DB Provider;Data Source=localhost;location=MyDatabase;User ID=postgres;password=admin;

Also Added Stimulsoft.Report.PostgreSQL.dll to Referenced Assemblies

System.Dll
System.Drawing.Dll
System.Windows.Forms.Dll
System.Data.Dll
System.Xml.Dll
Stimulsoft.Controls.Dll
Stimulsoft.Base.Dll
Stimulsoft.Report.Dll
Stimulsoft.Report.PostgreSQL.dll

Got successfully connected and created datasources with no problem.
However, when I tried passing parameters to my queries.

select * from tablename
where fieldname = ?

and get "fillin values failed"

my parameter is integer type.
I tried this in SQL Server and Oracle but got no problem.

What am I missing? Need your help.

Hi.

Please try to use the named parameters.

Please see the following:

Here the links on how to use named and unnamed parameters:

Named parameters:
http://www.stimulsoft.com/livedemos/Rep ... eters.html

Unnamed parameters:
http://www.stimulsoft.com/livedemos/Rep ... ers_2.html

http://forum.stimulsoft.com/Default.aspx?g=posts&t=54

If none of above worked, then workaround is here:

http://forum.stimulsoft.com/Default.aspx?g=posts&t=504

Also please open Demo.exe sample application from the standard installation of Stimulsoft Reports.Net.

Open 'SQL' category and the report Master-Detail with Parameters. Press 'Design' button. It is also an example of using parameters.

And in C:\Program Files\Stimulsoft Reports.Net 2008.2 Trial\Samples\C#\SqlParameters\ you can find a project which describes work with parameters in Stimulsoft Reports.Net.

Thank you.