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

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

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

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

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

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

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 am currently using Crystal Reports version 7 and I have customers who use access 97 and sql server. I currently have to desing 2 seperate reports, is there a later version of Crystal report which allows me to define a report that will run against Access97 and SQL Server without doing two reports?

Is there a limit to how many subreports you can have in one report? I have a main report which has two subreports, if I run it with only one, it runs fine, if I try to run it with both subreports I get an error message '20599 Cannot ope SQL Server' Can anyone help on this please? Thanks

I have a report which has two subreports in it and it was designed using an odbc connection to an ~Access 97 db. The data source name is VMLive and the db name is db1.mdb. If I run it through a VB programe I get the following error message. 20515 Error in formula <Record_Selection>...

I have got a report which has two supreports in it. When a customer tries to run it they get an error message. Cannot open SQL server. This runs fine on my machine. I have pinned it down to the odbc connection but I can't figure out what I have done wrong. The connection when designing the...

If a VB6 program passes a parameter into a crystal report is there any way I can tell the report to look for the parameter and populate the report based on the parameter?

I am trying to insert a sub report within a sub report but when I click on insert the subreport bit is greyed out. Can't you put a sub report within a sub report? Thanks in advance.

I have the following two rows held in a db table ID 18 Area ACTON Level PARISH ID 18 Area COPPENHALL Level District Ward I need to write a formula in which I can say print the Area name where the Level = District Ward. Can anyone help me with this? Thanks in advance

I write crystal reports which run through a VB program using Access 97 database. How do I export a report to a HTML file, or schedule a report to print at a later time or choose a printer other than the default when the report has already been previewed. Any help would be great. Thanks in advance