Creating reports and dashboards | Stimulsoft community forum

I'm curious how much SQL is supported in Dateband Filter expressions. It seems to be supported partially, but limited. I would like to use the IN and LIKE operators, with wildcard characters as in the following expression: tablename.fieldname IN ("AA","BB","CC") AND NOT tablename.fieldname LIKE "%RR%"

Any suggestions?

Hello.

djm000111 wrote:I'm curious how much SQL is supported in Dateband Filter expressions. It seems to be supported partially, but limited. I would like to use the IN and LIKE operators, with wildcard characters as in the following expression: tablename.fieldname IN ("AA","BB","CC") AND NOT tablename.fieldname LIKE "%RR%"

SQL queries is used only in Data Sources.
There are no SQL queries in filers in Data Bands. They are processing all incoming data for a condition in situ using C#/VB syntax.

Thank you.

Would you mind giving me more information about the sentence: "They are processing all incoming data for a condition in situ using C#/VB syntax." I assume you are talking about the filters. Are you suggesting that writing a function in VB would extend the capabilities of the filters? Would it be practical for me to write a VB function using SQL to return a filter string?

Hello.

djm000111 wrote:Would you mind giving me more information about the sentence: "They are processing all incoming data for a condition in situ using C#/VB syntax." I assume you are talking about the filters. Are you suggesting that writing a function in VB would extend the capabilities of the filters? Would it be practical for me to write a VB function using SQL to return a filter string?

I meant that Data Band receives all data from Data Source and displays only data which is matching the condition of filter.
Maybe you want to set the filter using data from SQL query.
Sorry, maybe we did not exactly understand your question. Could you explain your issue in more details?

Thank you.

HighAley, thank you for your reply. Here is more explanation about what I would like to do.

I would like to create a VB function that contains a SQL statement that returns a dataset containing just the information needed.

If it is not possible using a VB function, would you tell me why?

Also, if it is not possible using a VB function, how can I set the filter using data from SQL query?


Thank you.

Hello.

djm000111 wrote:I would like to create a VB function that contains a SQL statement that returns a dataset containing just the information needed.

If it is not possible using a VB function, would you tell me why?

Also, if it is not possible using a VB function, how can I set the filter using data from SQL query?

As we understand you can use SQL query in your Data Source.

Thank you.

Thank you for your patience.

Hello,

Let us know if you have additional questions.

Thank you.