Recent content by kanau

Hi In VB, insert these two lines just after open report rpt.Database.LogOnServer "pdssql.dll", "dbServerName", "DbName", "UserName", "Password" rpt.Database.Verify Hope this can help! Kan

Hi try Report.PrintOut True/False, [NoOfCopies] Where true/false will prompt the user or not Hope this can help! Kan

Hi, If you need ranged value, you can try two parameters in Crystal Report and in VB pass one value for each parameter. If you need multi / discrete, please make RecordSelectionFormual yourself in your VB program. No parameter is required. For example, the record selection formula would look...

Hi, dbielenda You may go to the machine with CE installed and then click Start > Settings > Printers and check wheather these printers are the same printers as your Report Designers machine. Then check the properties of each printer. Using ActiveX viewer should print everything correctly. Do...

Hi, 1. Do you print your report Correctly (with Correct Margin ...) when designing Report ? 2. Do your CE Server have the same printers installed, and do they have same settings with your Report Designer's machine ? Hope this can help! Kan

Hi, Do you have Correct System DSN on CE Server (which should be the same ODBC name as in your SQL Designer). When you design report using query file, where it save ? When put to CE environment, have you put the file in same location as at the time of designing reports ? You can search for...

Hi, Bessebo It is the best option if you can make a testing server installed with CE, then import all SI object with "Crystal Import Wizard". It will migrate all your SI 7.0 objects, folders, users and user group into your CE. Then use CR to open and save the reports to lastest...

Hi Have you tried "Scheduled Task" or "at" command under Windows NT / 2000 to schedule the .exe file Kan

myniguez, Insert a parameter, giva a name to it. From the "Report" Menu, select "Select Export" then choose the "CustomerID" field, value "is equal to" "yourParameterName" That is! Hope this can help Kan

Insert a formula, say "UserNameGroup" set the value equal to Job1 field. Then insert a group which is group by "UserNameGroup" Insert Three more formula, say "WhoDoJob1", "WhoDoJob2" and "DisplayIt" set "WhoDoJob1" value to if Job1...

Hi, Jim {table.date1} <= {?datetime_param1} and {table.date2} <= {?datetime_param2} all selection done in Database Server. {table.date1} <= datetime(2099,12,31)and {table.date2} <= datetime(2099,12,31) download all the data to local machine and make selection. Also &quot;and&quot; condition...

Hi, EssMB I think you have to add each [year][month][day] members one by one using calculated members for Year to date, or Month to date. Hope this can help!

Hi, It seems the JobServer works properly since it responsible for Scheduled Job. But the PageServer not function very well. Try to run the CacheServer, PageServer and JobServer with Console mode. To perform this, you can go to Crystal Management Console stop these three servers check the...

Hi, Sam Configure the System DSN of Client Access, in the General Tab, click &quot;Connection Options&quot; and select &quot;Use Windows user ID ....&quot; Hope this can solve your problem ! Kan :-)

Hi, Krist I have been used Crystal Report with Btrieve/Pervasive data for long time. Crystal Report requires FILE.DDF, FILED.DDF and INDEX.DDF to access Btrieve data. I am not sure if there is any tools can build these three files easily. It may come with your database application. Hope this...