Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Tenloe

  1. Tenloe

    Drilll Doqwn on Group Header

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

    Drilll Doqwn on Group Header

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

    Drilll Doqwn on Group Header

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

    Failed to Open a Rowset

    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 & "." &...
  5. Tenloe

    Failed to Open a Rowset

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

    Failed to Open a Rowset

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

    Failed to Open a Rowset

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

    Invalid Autorization Specification

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

    Adding a suppression condition to a group.

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

    Invalid Autorization Specification

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

    Adding a suppression condition to a group.

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

    There must be a group that matches this field

    no change - why is it only the date fields?
  13. Tenloe

    There must be a group that matches this field

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

    There must be a group that matches this field

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

Part and Inventory Search

Back
Top