Search results for query: *

Hello, A coleague of mine has asked me how to do this, so I told him I would look into it for him. Does anyone know how to convert an Access report into a Word document? Thanks in advance!

I have a client that wants to be able to access the data fields on a PDF form. They want to be able to add info to a form or select info from a form field...does anyone know how to go about this? I am new to the world of Adobe, so please be kind!

Hello, I have a client that is wondering if MS Office 2003 can be installed and run on a server (this product seems to have exactly what they need, only it needs be installed on a server). I know MS has discouraged this practice in the past with previous versions of Office, but I have heard...

I have a function that is trying to filter an ADO recordset. It works just fine until I try to filter the recordset on a value that contains an apostrophe. Is there anyway of getting around this? The code I am using looks like the following: adoCloneRS.Filter = "descr = '" &...

When I have a recordset come back from the database (LockType = adLockBatchOptimistic, CursorType = adOpenStatic and CursorLocation = adUseClient) I know it is probably good practice to do a recordset.MoveFirst on that recordset before performing any actions with it, but I am just curious as to...

I am new to web development and I am trying to set up a project in Interdev. I am having problems with my machine...everyone else seems to be getting along just fine and are not able to produce this error using the exact same steps. When I try to set up Interdev, I am getting the following...

We have a report that was working fine for the longest hitting our test database. Our DBA took a fresh copy of production data and put it onto our test database and now the report is not working correctly. I checked the stored procs, using Query Analyzer and they are working correctly and...

I have a formula set up that basically says: If COUNT(MyRecordsetName.Value) = 0 THEN 0 ELSE (MyRecordsetName.Value) This doesn't seem to be working. When the recordset does not return a recordset, I would like to have 0 displayed on the report, but when a recorset is returned I...

Is this as simple as going into each report and setting the location of the connection to our prod box or do I have to go through each individual stored proc and change it to the corresponding one on our prod box? For example I have an OLEDB connection called Justice that is pointing to our...

I have a report where I need to display a zero if the datasource does not return any records. Is there someway to perform a record count...and if it is equal to zero then I can display a zero on the report?

I designed a report using Crystal Reports 9.0 (Professional). On this report I have text that is supposed to be displayed vertically. It does this correctly when viewed in the design tool, but when I publish the report to our Crystal Enterprise server, the text is not displayed vertically. I...

I am trying to create an edit mask so the user can only enter alphabetic characters...can anyone tell me how to set this mask up. For example: I need the user to enter 5 alphabetic characters...it absolutely cannot be numeric. Thanks in advance.

The problem I am having is this...my user is seeing the below information on a report (there is a lot more info, but this should be good enough for an example) Case Party D.O.B. Charge(s) 123 Smith, John 01/01/1973 124-A 123 Smith, John 01/01/1973 466-13C 123...

Is there any possible way of passing an array to the select expert and parsing the values out and building a where clause? The problem I seem to be running into is that the user can basically select an undetermined number of parameters from a list box. I would like to take these values from...

I am building a number of reports for a client. After she saw the reports, she indicated to me that she would like to see the parameter dialog box changed, i.e make it a little nicer. Is it possible to customize the appearance of the parameter dialogue box in Crystal Reports 9.0?

I need to have all the data in each group (group header/ details/group footer) to stay together on a single page. If the any part of the information in the group should spill over to a new page, then I would like the entire group to move onto the next page. Can someone help me out and tell me...

I am trying to build a report that has a standard letter head at the top of each page...this isn't a problem. Below that, I want to display some address information that should only appear on the first page. I have separated out the letter head and the address information into two page...

I am using Crystal Reports 9.0 and I want to use a stored proc as my data source. I set up an ODBC connection and I have SP's checked off in the options, but I don't see stored procs under my connection. I can see system and user tables along with views, but no stored procs. Is there a step...

I want to use a stored procedure as my data source, but when I set up an ODBC connection, I am unable to see the stored procs under that connection. I do have stored procedures checked off in the options, but they are not appearing. I can see system tables, user tables, and views, but no...

I am using Crystal 9.0 and I have been building the query through Crystal by using the linking expert and select expert. The problem I am having is that I need to manipulate the sql a bit, and when I go through the menu options Database, Show SQL, I am not able to edit the query. Basically...