Creating reports and dashboards | Stimulsoft community forum

Just a small annoyance really but I noticed that I have NEVER been able to retrieve columns in the Dataset Editor if my query contains parameters. Is there a way to have it prompt for some dummy parameters and then retrieve the columns.

Right now if I change the field list on a query I have to temporarily remove any parameters before pressing "retrieve columns".

Any help here would be great.

Hello John,

Do you mean standard sql parameters or expression in sql query? You have troubles with query to stored proc or to table.

Thank you.

If we are using a Query Like:
If we press "Retrieve Columns", we get an exception. I realize that this is due to the parameters having no value. However, if we press the "View Query" button, it prompts us for the values of all parameters in the query. I would expect kind of the same behavior from pressing "Retrieve Columns".

The only way to work around it currently is to remove all parameters from the query like so: Then press "Retrieve Columns".
Then put the parameters back in after the columns have been retrieved.

Hello John,

This is strange behavior. We will check this problem. I will inform you about progress.

Thank you.

Hi John,

The problem is fixed. Patch will be available in the next prerelease build on Monday, 21st September.

Thank you.

Just got to testing this today. Here is a picture of what happened.

Hi John,

Yes, it is true that 'Version: 2009.3.501 from 14 September 2009' did not work because this prerelease build was issued before the patch was ready.
The prerelease build from 28 of September extracts columns from SQL Server 2008 correctly, so please just download this prerelease

Please let us know if you need any help.

Thank you.

Thanks for the clarification. I must have grabbed the wrong release.

hi

Yes, it is true that 'Version: 2009.3.501 from 14 September 2009' did not work because this prerelease build was issued before the patch was ready.
The prerelease build from 28 of September

Where do I download this file؟؟

I do not find it here
http://stimulsoft.com/ReportsNetDownloads.aspx

Please guide me

Thank you

Hello,

The patch from September is not available. You may download either official release at http://www.stimulsoft.com/Downloads.aspx or the latest prerelease build at http://www.stimulsoft.com/ReportsNetDownloads.aspx .

Thank you.