Search results for query: *

I have a report that is a summary report that drills down to a group header field, works fine but I can't get rid of the column headers which are in the group heading section as well, Suppress if duplicated doesn't work as it is in the Group Header section.

I am using vb 6,Crystal XI and SQLServer 2000. I have a report that when using the CRAXDDRT. The sql that it is producing in the .sqlquerystring is: SELECT "PG_CERT"."CANCELDAYS, "PG_CERT"."INSURERE" FROM "PG_CERT" "PG_CERT" WHERE "PG_CERT"."CERT_ID"=3 ORDER BY "PG_CERT"."CERT_ID" I...

I am using VB6 and Crystal XI an dam getting this error when trying to connect. Here is my code. Dim ADOConnection As ADODB.Connection Dim ADOCommand As ADODB.Command Set ADOConnection = New ADODB.Connection ADOConnection.Open sConnectString Set ADOCommand = New...

I am writing an upgrade utility in VB so that people don't have to do all of the upgrade manually. I am on Crystal 11. I have added this code for the group. Private Sub AddOccGroup(objRpt As CRAXDRT.Report) Dim strGroup As String strGroup = "XXXPCLM.OCCURNUM" objRpt.AddGroup 5, strGroup...

Can anyone explain to me exactly what this error means and the best ways to go about fixing the issue. It only happens when I group by any date fields, all of the other string fields work fine. Thanks in advance for any help

I have read throught the threads on how to do this and I almost have mine working but not quite. I have a detail section within GH/GF5 that will return a 1 if I wan't to get rid of the GF5. Works just fine. What I want to do is get rid of GH/GF1 if all of the GH/GF5's are all supressed. I...

I am trying to use the export to text function in Crystal but I get overlapping - cut off columns when any heading has more than one word as the heading. I tried taking the space out to see if thats whats causing it and indeed it is. If anyone else is having this issue - how did you fix it...

I have created a view in Oracle. When I run the Crystal report I get no rows returned. If I use any columns from the non view tables I get data back, can anyone help. If I take the sql out of Crystal and run it in SQL Navigator, I get the data back just fine, it also runs fine in SQL server.

I am getting this error message when I try to group by a date, when group on any string variable it works just fine. My column looks like this, if sum({@CurrentPeriodIncurred}) = 0 then 0 else sum({@CurrentPeriodIncurred},{@GROUPBY1})%sum({@CurrentPeriodIncurred}) Where current period...