SQL statement in User Prompt

arunas nesavas

I have designed quite a few reports on CoreSuite and it's a great tool!

The biggest limitation by far that I see is that there is no way to use SQL statement to select data for user prompts. This is needed for maybe 70% of reports, so users can select from the list on how to filter large amounts of data.

Is this feature planned? Maybe it's possible at least to call DLL and receive data back from it to use in User Prompts?

Philipp Knecht

Hi Arunas

I think you already know the possibility to use [SELECT Value, Description FROM Bla] in the design parameters.
Other Option:
Give the parameterform a unique formType (on the parameters tab in the layoutdefinition). Now you can define formatted searches in the paramform.

Btw. Next version is coming along very nicely with codecompletion, syntax highlighting and a much more simple way to group/sum/sort databands.
Beta should be ready end of next week.

hth