Search results for query: *

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...

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 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...

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...

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

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...

I am using sql server 2000. I am developing a star schema for a dwh. there are two problem tables, sales and categories. sales is made up of key fields from the other tables EG... sales.categoryid = category.id However, i have a problem Select * from sales RETURNS 20,862,231 records...

One of the columns in my .imp report is composed of numerous "element codes". The desired result is that on DrillThrough the DRILL.imp will show all of the elements that make up the amount in the orignal column. However, at the moment, the DRILL.imp only shows the first element of...