Recent content by Shazza

Thanks for the response. Silly question time, when you place a button onto a form - how do you associate the script with the click event of the button? Thanks

I am new to ServiceCentre and am using 6.0.2.0. What I would like to do is create a stored query that a user can be prompted for a date which in turn would become part of the query, and display the results. ie. All calls closed on <enter date> Can anybody point me in the right direction on...

I was getting this error message when I hadn't completed the join between the two tables in the report - in Service Centre itself. As you need to set up the relationship in Service Centre, before trying to join the tables in Crystal. ie. If you have the probsummary and incidents joined in...

I have a document with a toolbar which brings up a dialog box in which you enter information. When this dialog box is open, and I want to alt+tab to another document that I have open - there is only one document shown. If I then close down the dialog box and alt+tab, I can see all my open...

Thanks. I hadn't thought of that.

I am accessing an access database via a vb script using ADO. I was wondering what was better 1. A predefined query in Access and then pass the parameters through the command object? 2. Return the entire table and then use rst.find? Thanks

I am new to writing XML, and I am trying to write an XML document using XmlTextWriter. I am trying to achieve the following: <app summary="addfsdf" sample="asdasdf">value of element</app> When I use the WriteAttributeString method I get the attributes added correctly, but I am unable to get...

Basically my boss has written a wizard that keeps coming up with the following error: &quot;The script does not have the necessary access writes&quot;. Here is a sample of his script ... it is quite a long wizard, but I can send you all if you wish. On Error GOTO ErrorHandler Dim lReq as...

Thanks Jason, The function amExecuteActionByName is not available from a wizard script .. or am I reading the documentation wrong?

I am trying to create a couple of wizards and would love to use the DaExecuteActionfromName function which according to documentation that I have is available in Version 1.0. When I use this, I get an error message telling me that the function is not defined. Can I use this function, or is...

When you connect to Crystal using the AssetCentre drivers, the features are supplied. If you connect to Crystal using native ODBC connection either to Oracle or SQL Server then you need to do the following to get the feature value. You need to add the corresponding feature table eg. If you...

I have the following calculation which returns 567.9099393 Set [FV_ClientBuy] = cDbl([Product.mPrice]/(1-0.7)) I would like to know if there is a function that will allow me to round this number to 2 decimal places. I am trying to populate a string field, and it needs to be a string for other...

Good thinking.. I have created a .bat file that will run all imports from an action. This way the user has the ability to run when required. Thanks for the advice, much appreciated.

Sorry, here is some more rivate oCrystal As New CRAXDRT.Application Private oReport As CRAXDRT.Report Private oExportOptions As CRAXDRT.ExportOptions Set oReport = oCrystal.OpenReport(settings.ReportPath) oCrystal.LogOnServer &quot;pdssql.dll&quot...

I have a end user that wants to run four import scripts in a row. They do not want to manually do each one, therefore I was thinking about automating the import, so they could run an action and then all text files will be imported.