Announcement

Collapse
No announcement yet.

Dynamic Search with Field that is not in SQL Query

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Dynamic Search with Field that is not in SQL Query

    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.

    Comment


    • #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

      Comment

      Working...
      X