Keep a report up to date without re-running the query 1

[Olii]

Hi Ken ...I've looked in the forum but i didn't find what i'm looking for.....i'm kinda new with crystal and i have a question for you....

I have a report that's based on a query .

How can I make the report up to date without re-running the query ?

I want a one-touch report that makes the select during build-time so the data is continuously up to date.

How can I do that ? Do I absolutely need a query ? (I used one cause I have a calculated field in my select statement and it's not possible (or it is?) to do that without "plugging" on a previously made query)

here's my select : (it's not very big or complicated !)

select dept ,
cpu ,
cpu_speed ,
count(dept) as nbr
from workstat
where dept <> ''
and cpu <> ''
group by dept,
cpu,
cpu_speed

Thanks for you attention!

P.S. E-mail me if I wasn't clear enough!

Olivier Gagnon

ogagnon@microtecsecurite.com

 

[kenhamady]

From what I can tell you don't need the query. You can do the grouping and the count of dept right in the report.

If, however, you do need the query, don't save the QUERY with data. This is the defualt but you can change this in the &quot;File&quot; menu. If the query doesn't have data saved, it will rerun the query each time you run or refresh the report.



Ken Hamady

http://www.kenhamady.com/

 

[Olii]

Thanx Ken ...that's exactly what I wanted to hear !! or read !