Search results for query: *

Hi, I'm looking for a script to find all tables, columns in a tablespace which use lobs and details of the lob settings, such as In Row etc. Thanks Phil

Hi From my site i'm displaying a html report to the user. Is it possible to save the html report as for example a word document or a pdf file? At the moment i can only save the page as a htm file using <a href="javascript:doSaveAs()">save this page</a> which isn't ideal. Many Thanks Phil

Hi I'm creating a stylesheet at the moment. I need to set the font size which seems ok using: font-size: 7pt; But i've also seen the following statement used: font-size: 1em; Please can you confirm when em should be used and what affect it has on the font size. Many Thanks Phil

Hi I'm trying to access a database, where the database name has a space in the name: ICore DB This is causing an issue is Query Analyser when I attempt to run a query such as select count(*) from ICore DB.dbo.tblCountry Is there a way to alias the Database name or can the syntax above be...

Hi, I'm attempting to configure a ODBC connection for connect to an Informix database, but i'm getting a driver error. Do I need to install the Informix client software on the sql server to make this work? Or is there an easier way to do this with SQL Server 2000? Thanks Phil

Hi I need to run the following script via an application whose service has to start via the Local System account. var url = "http://" + host + ":" + port + "/" + action + "/"; var query = "client_id=" + client_id + "&text=" + escape(text) + "&destaddr="+ destaddr + "&password=" + password...

Hi I'm able to successfully run the following script when logged on to a server with an admin account. var host = ""; var port = ""; var action = ""; var client_id = ""; var text = ""; var destaddr = ""; var password = ""; var url = "http://" + host + ":" + port + "/" + action + "/"; var...

Hi, Is it possible to run a database backup and exclude a particular table from the backup file. We have a large database but most of the space is taken up by one table which we would like to exlude from the backup. Thanks Phil

Hi, I am currently setting up a new server and I want to copy our existing CE8 database onto our new server. This seems fine I have done a backup and then restored the CE8 database to the new server, this is based on SQL 2000. But I need to know how to update all of the references to the...

Hi, We want to swap our production server which is currently running SQL 7 with another server which runs SQL 2000. To move the data we were going to backup the production server and then restore the database to our new SQL 2000 server. I gave it a try but received the following error msg...

Hi, I need to create a Cross tab based on a field 'Step Name'. This is ok and is currently ordered alphabetically by the Step Name field. But I need the cross tab to be ordered by the field 'Step' which is an integer. The field Step should not be display in the cross tab. Current Cross tab...

Hi, I want to concatenate a list of variables which are then written to another field and display them in neat columns. I've used the tab character below but if one field is too long it shifts all other fields to the right. set @Ticket_Details = @Ticket_Details + @Ticket_No + char (9) +...

Hi, I'm trying to create a graph against data which is grouped by Product and Severity. As a report I can produce summary details of the percentage of issues which were fixed on time grouped by Product and Severity. Eg Product A, Severity 1, 50% of the issues were fixed on time Product A...

Hi, Has anyone got a good solution for calculating the number of days in a month, which will work for all years. I need to perform a calculation based on the number of minutes in a month but I don't know how to return the number of days in that month. Thanks Phil

Hi, I'm sure this is easy but I'm very new to crystal. A record will contain date fields A, B, C. I need to compare the fields and pick up the earliest date. I've used a formula field to print the date but am not sure how to use variables within a formula. The function will then be: local...

Hi All, I know there is a restriction with Crystal Enterprise that once a report has been created the parameters are static. We have many customer based reports and our customer list is constantly changing. I want to write a web interface so users can run reports and the customers lists etc...

Hi, I'm new to Crystal but I am baffled why I can't make this work!! All I need to do is link 2 tables. I have set up a link using the Visual Linking expert from table A to B. But when I attempt to generate a report I receive an ODBC error Column found in multiple tables. I would be very...

Hi, I have only recently taken over the role of reporting within my organisation and know very little about Crystal. We are constantly receiving the following error msg when running reports. Error encountered by Crystal PageServer The error message returned is: Data on the Page Server may...

Hi, I have recently taken over the responsibility for reporting using Crystal for my Organisation. We have a large number of reports which use customer parameters, our customer list is constantly being amended. I was informed by the person that previously looked after reporting that the if...

Hi, I have recently taken over the responsibility for reporting using Crystal for my Organisation. We have a large number of reports which use customer parameters, our customer list is constantly being amended. I was informed by the person that previously looked after reporting that the if...