Dynamic Search with Field that is not in SQL Query

Scriptcase 8 Discussion
#1

Hi,
I’m a little bit new with Scriptcase.
I’am trying to make a Ranking Report that you can filter by dates.
The Date field is not present in the SQL Query but i need that the user can use it to make a filter.

I try to add the field manually to de grid application, then in Search i select that field to use it with dynamic search, i configure the toolbar adding the dynamic search button, but the button is not showing.

Am i missing something?
Is it possible to do what i want to do?

Thank you very much in advance.
Maxi

#2

How should the ranking be filtered by date when their is no date in the database ?
This makes no sense for me.

#3

Gerd, there is a date in the database. I just can’t put the Date field in the select list of the query because i cause a wrong result.
Here is the query i am using.

SELECT TOP 20
ARTICLE,
SUM(AMOUNT) AS AMOUNT
FROM
dbo.SALES_RANKING
GROUP BY ARTICLE
ORDER BY SUM(AMOUNT) DESC

The SQL View has a field name DATE but i cannot put it in the select list becaus if i do that i have to add it to the group by clause and that generates wrong results.
Do you know how can i make a filter without puting the field in the select list with scriptcase?

Thank you very much!
Regards,

Maxi