Search results for query: *

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

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

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.

Do you have any null condition that you have not been catered?

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

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

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

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

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

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

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

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

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

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

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