Search results for query: *

We were finally able to get it with the OnFirstRecord() function.

So would either of these methods let the headers print the first time? They are in the group section with the detailed group info, the detail section is for another drill down and works fine.

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.

Thanks, that worked adding the database name. Here is how I did it if anyone needs to do it. sDatabaseName = objReport.Database.Tables(i).LogOnDatabaseName sLogOnUserId = objReport.Database.Tables(i).LogOnUserID sName = objReport.Database.Tables(i).Location sLoc = sDatabaseName & "." &...

How would I do that without doing string manipulation in VB?

yes, it runs great in sql server. I just went in in the VB and changed the query to not use pg_cert everywhere like this: SELECT CANCELDAYS, INSURERE FROM STARS.PG_CERT PG_CERT WHERE (CERT_ID = 3) ORDER BY CERT_ID and VB took it fine so that seems to be the problem, how would I turn this off...

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 added user id and password to the connection string and I got this to work, however my report already had 12 tables in it and i just want to add two more, instead it deleted all of my tables and just added two. Also it named them ado and ado_1 where I need them to be named the database name...

Yes, in Crystal that is correct, but I need to know how to do it from VB. It is so we can upgrade Crystal reports without the user having to change all of theirs manually.

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

no change - why is it only the date fields?

yes sir

Well its definately that formula but I absoulutely have grouby4 added into the group. And groupby4 is sent in through the c++.

ok, I am supressing the groups based on Minimum({@DaysOverdueSuppression}, {@GROUPBY4}) = 1 is that causing it?

Unfourtunately we get these generic errors from Visual Basic and it doesn't tell us where. Thanks LBASS, I'll find it somewhere in here.

I only have one formula in the detail section. If Len(Cstr({XXXNOTE.DONE_DT})) = 0 and {XXXNOTE.DIARY_DT} < CurrentDate Then (nDays:= CurrentDate - {XXXNOTE.CREATE_DT}; Group1Days:= Group1Days + nDays; Group2Days:= Group2Days + nDays; Group3Days:= Group3Days + nDays...

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

Forgot to say I am on Crystal XI

ok, I have the last two rows on one page repeating at the top of the next page. I have done some different sorts so that these detail rows would move around on the page. When they are moved up they are no longer repeating so I know it doesn't have anything to do with joins or data. Has anyone...