Search results for query: *

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.

I have a report written in CR 8.5 and I am running this via Visual Basic 6.0 using the RDC. When I run the following code I get 'Server has not yet been opened' error message oCrystal.LogOnServer &quot;pdssql.dll&quot;, settings.Server, settings.Database, settings.Login, settings.Password The...

Is there anyway of running a .scr file from within a action script? or wizard? I have AssetCentre 3.6.

I would like to have a subreport display for every month of the year. I don't have a field in my database that will display a group for every month. Can I set up a formula that will allow me to use this to group.

I was thinking of deleting all the data and then doing the insert into query to update the table with the new data, only problem is that same of the tables have autonumber for primary keys, and these are used for reference. Is there any way of running an append query that doesn't reset the...

I was afraid of that. Is there anyway of importing a table from an existing database to the other database through code.