Search results for query: *

Hi I have copy/ pasted some columns from a colleagues spreadsheet into one of my own. He has used some elaborate colour-coding on his sheet by adding fill in different shades. I want to get rid of that in mine and have no fill but I can't change any of the fills. My colleague can't remember...

Hello I have the following piece of code in a macro Range("C2").Select ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-1],TLIST,2,FALSE)" Selection.AutoFill Destination:=Range("C2:C10") This is fine for the 10 rows of data I used for testing but how do I repeat this function where I don't know...

Hi I have created 3 named lists of values: 'RESI' 'COMM' and 'OTHER' I want to know the syntax for looking a value returned on a master sheet up in each of these 3 lists and returning the name of the list it is found in. I am familiar with VLOOKUP and LOOKUP but not sure how to nest IFs nor...

Hello I am trying to find the number of holidays between any two given days using the following code, but it is calculating the holidays incorrectly (always less than the days available in the table "Holidays"). When I am using the start date as 1/1/2006 and end date as 31/1/2006,the result...

I have a simple query which returns data between 2 dates based on parameters entered at runtime: Between [Start] And [Finish] But when I try to write a report based on this query and graph the results I get error messages 'The Microsoft Jet database engine does not recognise [Start] as a...

Hi I have a simple 40 page procedural document which contains about 60 screenshots from an Access database. As I have been compiling this its performance each time I open it has slowly deteriorated from taking about a minute to open (including trying to fire up my DVD drive!) to crashing Word...

Hello I have a variable length spreadsheet sorted by department (col B) and containing 8 columns of data. From this master sheet 'Access Classes' I want to create a worksheet based on each change in col B and copy the relevant rows from the master to that sheet. The dept names in col B are...

Hello Can Crystal reports automatically output a series of .pdf files based on report grouping? Currently I have a report which people run about 100 times inputting a different runtime parameter for 'Subject Area' each time and then outputting each of these reports to .pdf I'm proposing the...

I have a 10 column spreadsheet used to record quality improvement issues, who they're assigned to and what actions are being taken. I have one row of data for every update that is made. There are currently 18 issues with a total of 72 updates. I am interested in presenting a 1 line snapshot...

Hi I have designed a spreadsheet to track employees various leave allowances (ie annual, sick, bereavement etc). I have a sheet for each employee with a starting balance (ie the number of days leave due as at today) a work area where any days leave taken are recorded and finally a running...

Hello I am cross-tabbing and charting sales by product group for current year to date and last full year. The datetime field I am calculating from is called Sales_Order.so_processing_date. What should the formula be? Presumably once I return the data set I can crosstab and chart by year......

I have a report which produces a dozen bar charts which show how many service calls have been allocated to a group of people and individuals within that group. I have categorised the due date of the service calls as 'Today' 'Tomorrow' and 'Overdue' via a formula. How can I get consistent...

Hi Some time ago I asked for help with the formula to bring back 2 months worth of data. bdreed35 kindly came back with: {Orders.Order Date} in dateadd("m",-1,minimum(lastfullmonth)) to maximum(lastfullmonth) but now what if I want to run the report on the 1st of each month (or in effect at...

Hello I have a cross tab which calculates distinct counts and % of total for certain job types over a month. I can't get the % to show 2 or more decimal places so where the counts are small I get a number but the % is always 0% ie (total is 970) count of 1 gives 0% (should be .001%) count of...

I have a very simple report which tabulates service calls logged by their urgency. I have a parameter for the date and I have the Company ID 'hard-coded' (although this too may become a parameter). Now I want to add a sub-report which simply lists a few details about all the priority 1 calls...

I see there is something called 'Report Part Drilldown Option' but no option to create a drilldown report from scratch in V10. Has anyone used the above? The help on this seems quite complicated and I'm not sure it works the same as creating a plain old drilldown report.....

Hi I have a report which counts the number of service calls a user logs each month. I run it for the previous month for the top 20% of users. I now want to create a rolling 13 month report which plots the highest count per month. I have the formula for 13 months in my record selection and I...

Hello I am trying to emulate an Excel pivot/ spreadsheet in Crystal V10 and am getting tied in knots... I have a crosstab which summarises hours spent by groups and individuals (rows) across a range of activities (columns) I have a formula @CallType for the columns which states if...

Hello I am trying to write a parameter on a date/ time field where I want the user to choose a beginning and an end date. I can write the parameter ok but when I assign it to a selection I can only get the parameter viewable if my selection is "is equal to". If I try to assign it to that field...

Hi I have a monthly report which counts the number of service calls logged by each individual each month (runs as Last Full Month). Some clients who receive this report are only interested in anyone who logs more than 5 calls, some more than 10 others more than 25 etc. I have a parameter to...