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!

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

Search results for query: *

  1. thomasyu

    Crystal report 6 behaviour

    The following are my findings on sub-report problems during the past 3 weeks The crystal report by default will abstract the db name from the DSN and put it as name your reference. i.e. If you refer to a table MyTable of Mydb, the object reference will be Mydb.dbo.MyTable. Under this...
  2. thomasyu

    Exported report Does Not Have Page Header and Line

    User can view a crystal report with runtime installed and provided that you develop a tiny application to call the runtime. (just like a VB Application calling a runtime) I am not a CRW 8 user. I am not sure whether it can output pdf. If you have a adobe acrobat, you can print it the the...
  3. thomasyu

    Current Date vs. Same Date Last Month

    For the behaviour of no matching day of the month, try to follow the convention of what DateAdd Does instead of defining your new convention.
  4. thomasyu

    SQL Query help

    Do you have any null condition that you have not been catered?
  5. thomasyu

    Connecting Access 2000 and Crystal Reports

    Have you try it the other way round? thru ODBC.
  6. thomasyu

    Subreport: cannot/don't know how to refresh subreport dbname thru VB

    The line of code that I am using to connect to the database of the main report are as follows abstract of crystal report invoke common routine With MyCrystalReport .ReportFileName = strFileName .Connect = gstrConnect 'i.e. DSN = ...;UID= ...;PWD= ...;DSQ=...
  7. thomasyu

    Problem with updating date field

    create a common public function in VBA as follows ' Access always look for date format in m/d/y despite of windows setting Function AccessDate(ByVal datDate As Date) As String AccessDate = "#" & Format(datDate, "m/d/yy") & "#" End Function Change your statement...
  8. thomasyu

    How to read existing querydef object in a mdb that require parameters

    I already define a querydef called ABCDelete in MS Access mdb which have the following definition. PARAMETERS [param1] date, [param2] text; DELETE FROM ...... How can I execute and supply the parameters by means of DAO in VB or VBA? The following cause runtime error at the CreateQueryDef - too...
  9. thomasyu

    Always get an extra blank paper during printing

    As a general recommendation, set all margin to 0.3" or above. Most printer has non-printable area of 0.2x"
  10. thomasyu

    Crystal Reports VS. MS Access

    Your choice at end-user pt of view ================================== CRW is a good choice in terms of Application integration. It has server option and ease to deploy to clients. End user using Access in general need more skill so it is recommended for casual users. CRW can do web reporting...
  11. thomasyu

    Count duplicates

    If you want to print duplicate only, add the following after the group clause. Group by .... Having count(*) > 0;
  12. thomasyu

    Count duplicates

    It seems not a CRW question. Try approach the issue in the SQL Level. Change your query to SELECT DISTINCT System, Component, Item, Module, Count(*) AS [counter] FROM Table1 GROUP BY System, Component, Item, Module; If you are using SQL server, Oracle, you may create a view to simplify the...
  13. thomasyu

    Subreport: cannot/don't know how to refresh subreport dbname thru VB

    The setLocation has to be done on the fly and not at the crystal report designer because the db connection to determined by the login page of a VB exe. How can I arhieve that? Also, I cannot perform SetLocation with crw designer as it seems to be embedded inside the master report and not...
  14. thomasyu

    Subreport: cannot/don't know how to refresh subreport dbname thru VB

    Environment ========== I have a CRW6 report with 2 sub-report that retrieves data from SQL server. The report is running as a .rpt file and is triggered by a Visual Basic exe. Symptom ======= The report produces error stating that dbname.table.field not found when the sub-report is present...
  15. thomasyu

    Unable to refresh DBName of subreport

    I have a rpt of CRW 6.0 which contain a sub-report. I invoke the rpt file thru a VB executable with connect property of the OCX set to the proper database. It is because the report is intended to run under different db, a testing db, a UAT db, a production db. I have downloaded a utility in...

Part and Inventory Search

Back
Top