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

Thanks - but apologies for the length of this post: Crystal Reports V9.0 MSSQL database - it's a 3rd party product so I'm stuck with the structure as it is. Tables (I have only inlcuded the relevant fields): tblPupil PUP_ID PER_ID tblPerson PER_ID tblLU_PER_TITLE PER_FNAME PER_MNAME PER_SNAME...

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

Thanks - it's working now Fiona

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

Thanks - I got there!

Well I've got a little closer. Using lbass's suggestion, the first formula averages the surpluses for all the schools printed so far, but what I need is the average of all the schools in each group footer. I'm not sure which variable it ends up displaying. The second formula gives me zero...

Thanks Brian, but I can't quite see how this helps. Am I missing something? I would still have to average the sum which, from your reply, is what I can't do. Fiona

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

Thanks- you're right.

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

Thanks for the advice - I think it will have to be manual Fiona

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

Thanks for your help - I have used a subreport which seems to be the best solution given the circumstances. However, I would like ot suppress printing of the address in the subreport if it is the same as the address in the main report and I can't work out how. Any ideas? Also - what's SQL...

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