Recent content by mdr

Does Anyone Know how to set a value prompt to 'ALL'? I have a report that has a type of either 'reactive' or 'proactive' and users need to filter by either. however, occasionally they will need to see data by both reactive and proactive types, and i would like to see a drop down that either has...

Thank you very much.

Hello, I would like to create a filter on my .imr with a formula that gives me data until the end of next month. eg. today = 10th nov 2004. - data returned until = 31st dec 2004 today = 10th dec 2004 - data returned until = 31 jan 2005. i have all the dates in a "sales date" column, but...

I need four averages - last month, ytd, ytdlastmonth and lastyearytd. we have categories, that i have grouped on and need a summary sheet that a glance people can see this year to date category1 average response time compared to last year to date category 1 average response time. same for...

I have downloaded the following code from this site, and have tried to adapt it to my req. I have tried to do this by adding if {field.name} in LASTFULLMONTH then //CALCULATE THE NUMBER OF BUSINESS HOURS //BETWEEN open AND closed //INCLUDING HOLIDAYS IN THE TOTAL DatetimeVar...

I would like some help with averages. I have a total average response time, which is sum of response time / number of tasks. however, can i group in an average? what i would like to see is something like this: average reponse top grouping = 15 hours average reponse middle grouping = 3 hours...

thanks will try this. I have inherited a very bizarre job tracking db, and have been using sqlserver for too long. thanks for the heads up. have done as you say and then unioned the two tables, and the data comes up trumps. thanks

Hello, We use an Access db. This db has to be archived regularly. On archive all but current - ie active records are seemingly deleted(they are stored on file as a .xls) I need to report on old and current data, so that i can report on things such as YTD V LYTD, count(*) of all jobs etc. Can...

I have some views in my SQL database, but when i try to connect to them in the tables dialogue box, i can only see catalogue tables on the right, nothing on the left. Is there any way that i can get to see the views? Help says that i should retrieve tables, but i cant find a way to do this...

I have a report that has two columns. 1 is request date, other is completed date. I need to know what Percent are complete for each group. I am grouping on a couple of levels. eg, dept and store. Can anyone tell me how to work out a % for each group in order that i can find out what the...

Thakns very much for your help. I was actually thinking of even more specific than this though. Imp is taking up about 1.5 gig of ram, and leaving sql with 500 mg. the system is then slowly grinding to a halt. arrghh.

Is there any way of limiting the ram used by impromptu? any helpwould be really aprreciated

Have you tried using a dts task?

I want to get sales from the past three months. I use a variable to get todays date: declare @Today datetime set @Today=getdate() and then try and pass that through to this formula: and datetable.datevalue between @Today and month(dateadd(m,-3, @today)) However, i am not getting any...

Thanks for that Raj. Will have a look and see if that solves my problem.