RR 10 SQL

[Ken_Waring_(Guest)]

I am trying to convert reports from R&R Xbase to R&R SQL. I am an expert at xbase but a rookie at SQL.____Many of my R&R Reports use formatted hiscope() and loscope() for date reanges at the top of the report.____With the SQL databases this concept does not exist in the same manner with the external indexes. Therefore it must be driven into the query.____Is this correct?____What is the most elegant way of having a start/end date on the top of the report without the other info in the query being displayed? It is relevant to the end user to see start and end dates but much of the other query info is unnecessary and confusing.____Another issue is that query cannot be used with other functions so it appears that it is not possible to parse it into pieces.____Thx.__Ken Waring.

[kfleming]

If you make the start and end dates either calculated fields or parameteRR fields then they can be placed on the layout and can also be used in the filter.____Kathleen__R&R Support

[Ken_Waring_(Guest)]

Thank you.