Recent content by shortstuff2212

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