Search results for query: *

When the report is in preview the printer icon is greyed out. There is a printer attached to the machine and we can print from other applications but not the crystal report. Any help would be appreciated Kath

Hi thanks for the reply, I am using version 7.5 the field type is text and db is Access

I am trying to get an address into a formula but the fields are not listed as available to use. The field size is 200, what is the max field size you can use? Thanks Kath

We are running crystal reports through a vb6 program using the activeX control. When we preview a report and the parameters come up on screen there is a cancel button. If you click the cancel button the report runs anyway. Is there a way to stop this happening? Thanks in advance Kath

To synapsevampire That's worked thanks To Reebo99 thanks for the help Cheers Kath

Hi all I am hoping someone can help me with this. I have created a running total based on a table that has duplicate values for a specific field but the running total is only calculating the first of the duplicate values and not the following. I have not formatted the running total to...

Thanks for the help it worked

Hi Thanks for the help, I can't get this to work so have decided to go a different route. Cheers Kath

I have the following sql statement in the a report:- SELECT Election.`ElectionID`, ElectionArea.`ElectionAreaName`, ElectionArea.`PollDist_Row`, ElectionArea.`EA_Code`, Election_PollingPlace.`Polling_Place`, Election_PollingPlace.`PD_Code`, Election_PollingPlace.`PS_Num`...

It is correct but I am not sure what you mean when you say open up 3 instances of ElectoralArea and link one via EACode to DistrictWard, one via EACode to County and one Via EACode to Parish. Do you mean in the sql statement? Kath (Going mental in Manchester)

The reason I can't do that is the data in the ElectionArea table changes. Table - ElectoralArea ElectionID ElectorLevel Polldistrow EACode 1 Ward DistrictWard CAD 2 Parish Parish GED 3 County...

I have the following tables in an Access db. Table - ElectoralArea ElectionID ElectorLevel Polldistrow EACode 1 Ward DistrictWard CAD Table - PollingDistrict PDCode DistrictWard County Parish AA CAD HU ST...

I have a data table which looks like this:- PSNum Electorate From Electorate To 1 1 2899 1 3005 4000 I need to find out how many electorate are in the above table and I have a formula like this {PollingStationRange.ElectorateTo} -...

I have a report that has a record selection of Elector.`DateAdded` >= ? AND Elector.`DateAdded` < ? but when running this report through an SQL Server database I get the following error. ODBC error (Microsoft)(ODBC SQL Server Driver) COUNT field incorrect or syntax error. If I take the...

Dear Rosemary Thanks for the advice, unfortunately it didn't work. There aren't any empty records in the elector table. Thanks anyway. Cheers Kath

Thanks for replying. The properties are held in the property table and the coresponding electors are in the elector table. What I need is a formula to count the properties which do not appear in the elector table. Something like select count(*) from property where propertyref not in (select...

I have a database with the tables property and elector and I am trying to find all the vacant properties. Does anyone have any ideas? It would be great if you could help me on this I have tried all ways and nothing works. I can't use the sql statement because I need to be able to count how...

Thats worked, thanks very much for the help. Regards Kath

I have a main report which has a subreport that I only want to print when the electoral type has a '/' in it. I have tried to format it with 'instr(Election.ElectionType '/') > 0'. This does not seem to work whereever I put it. I have tried formatting all the subreport sections at the...

I have already done that, but it involves having two sets of reports, one for Access and one for SQL. With two sets of reports it is difficult to maintain version control and I just wondered if it was possible to keep just one set of reports which will work on any db