Search results for query: *

Hi I use an MSSQL application that generates Excel spreadsheets. I can't use auto-filter in these spreadsheets. It appears to work and the tick appears beside AutoFilter on the menu but the drop downs don't appear. If I copy the data to a new spreadsheet, it is ok. Any ideas? Fiona

I'm using CR 9. I am doing a report of pupils applying to high schools. The first section is their name, address, date of birth and so on. I have put this in a group header. Then their contacts. They may have more than one, so I have put them in the detail. Then come the names and addresses...

I often have to create reports that look like an existing Word or Excel document. Is there any way to import these into Access? I have tried copying a Word documentt and pasting it as a picture but a. it is very bulky and b. it is very fiddly getting fields to line up properly becasue you...

I am using CR9 and I have got two subreports each passing a shared variable back to the main report so that I can do some arithmetic with them in them main report. I don't want the subreports to show so I have tried supressing them, supressing the objects in the subreport and supressing the...

I have a report grouped by school (CR 8.5). The group footer which shows: @OnRollDate1 sum({@CountOnRollFirstDate},{tblSCHOOL.SCH_NAME}) - @CountOnRollFirstDate is 1 or 0 for each pupil depending on whether they were on roll at the time NetCapacity a database field @Surplus...

I want to report on everyone who has had more than one address. I created a formula, CountAddresses as DistinctCount ({tblPUPIL_ADDRESS.tblADDRESS},{tblPERSON.PER_ID}) which seems to work. I have got the report grouped by PER_ID. When I put {@CountAddresses}>1 in the group selection I...

Hi all I want to base a pick list for a parameter field on a selection of values in a table - it's a table of schools and I only want the ones in our borough to appear in the list. I also need options for all schools, all high school and all primary schools. I've got round it by exporting a...

Hi all I am writing a report in Crstal Reports 8.5 which contains information from a number of linked tables. Somewhere along the line I come to a point where there may or may not be a corresponding record. I put a left outer join in here and I got the record displayed whether or not there was...