Grouping on fields which have a space in the table name

I am attempting to run a 8.5 report in VS2005. There seems to be a problem with grouping on a field when it's table name has a space in it. The actual table name is {ccArea Types} in crystal and my dataset. I get the following message:

Error in formula <G_netsf>.
'Sum({ccArea_Types.SM_N_AREA},{ccArea_Types.SORTORDER)'
There must be a group that matches this field

Notice that an underbar has replaced the space in the tablename. I have run simular reports without a problem when the tablename does not contain a space.

Any ideas

Thanks

Answer this question

Grouping on fields which have a space in the table name

haitham ibrahim
Keith,

I tried to verify. no help. see attached code & output.

Thanks
Steve

fn = "S:\SMW\unitreports\un_OT_bldst.rpt"
rpt.Load(fn)

For Each Tbl In rpt.Database.Tables
Debug.Print(Tbl.Name & " " & Tbl.Location)
command = "Select * from [" & Tbl.Location & "]"
Dim adapter As New OleDbDataAdapter(command, connection)
Dim tmpdada As New DataSet
adapter.Fill(tmpdada)
tmpdada.Tables(0).TableName = Tbl.Location
dada.Tables.Add(tmpdada.Tables(0).Copy)
adapter = Nothing
tmpdada = Nothing
Next

rpt.SetDataSource(dada)
rpt.VerifyDatabase()

For Each Tbl In rpt.Database.Tables
Debug.Print(Tbl.Name & " " & Tbl.Location)
Next

BLDG BLDG
CATEGORY CATEGORY
SPTYPE SPTYPE
ccArea Types ccArea Types

BLDG BLDG
CATEGORY CATEGORY
SPTYPE SPTYPE
ccarea_types ccArea Types
spkeller
Hello,

Have you tried verifying the database of the report The query engine did change from the version used in Crystal Report 8.5.

Verifying the database and mapping any tables/fields that need be updated will ensure that the report runs properly. You can verify the database by right clicking on the report and selecting Database|Verify Database.

Keith - Business Objects
Grouping on fields which have a space in the table name

Answer this question