Search results for query: *

They do not show on the report on screen, I do not think they are hidden, but are somewhere off to the right "off the page". I have found a way of changing the headers I wanted to change, via the Report Explorer, but have to do this "blind" i.e Edit text, delete each existing character one at a...

Thanks for the reply. I am using Crystal 10, sorry for not making that clear. The original report is Crystal 8.5. The columns have real data and when exported to Excel all of the data is there, I just cannot see it through Crystal. Any thoughts? I am an end user/report designer and it is...

I have been given a copy of a report (Crystal 8.5) that is used solely as a means of users extracting data to read into excel. The report on screen has, say, 20 columns, but on export to excel a further 10 columns are also present. Ideally I would like to add another column, and rename the...

I have a form and want to display a value in a text box that depends on the value selected in a combobox. This value can be found from a query, using the combobox entry. Can anyone advise me on how to do this? Cheers Les P

In our corporate environment we have some reports that are written in Crystal with data coming from an Oracle database. These can be run in two ways either within an application or alternatively directly through Crystal Enterprise. In either case if the export to pdf option is used the files do...

Did something very similar in Access 2000 recently. Previous post points to some references you'll need to "check" in your access database. Code below may help: *** Dim crxApp As CRAXDRT.Application Dim crxReport As CRAXDRT.Report Set crxApp = New CRAXDRT.Application Set crxReport...

Can anyone tell me how I can use VBA from MS Access to locate the row in Excel that holds a particular value? My recordset will have as one of the columns a code e.g. OT1. A particular column in the receiving excel spreadsheet will have this value, and what I need to do is locate the row this is...

I have a form set up with a subform, when I enter a contract number into a text box the form ReQueries and shows contract specific data in subform (the subform shows relevant items with blank volume fields). A month is entered into another text box on the main form, then data is entered in the...

I have a report that has a group total of a Formula Field. I would like to add a field into the group header that is based on these group totals, e.g. (sum of formula field 1)/(Sum of formula field 2). Can someone advise me of how to do this.

Can anyone advise me if there is a way to define a report that will show e.g. current months figures and a total for the year in the same report. Data is along lines of: Month StockCode VolumeOrdered VolumeSold Report would look something like: StockCode Month VolumeSoldinMonth...

Many thanks for responses. The way I have overcome now is to create a field that is a combination of the others in both of the source tables. Reasons being: Changing the field length of the main field still didn't seem to solve the problem. I tried creating a query in one of the MSAccess...

I have two Access databases. In order to link the two tables I need it is necessary to join on three columns/fields. The three fields are jointly Indexed in the relevant tables. When I link in Crystal, clear the smart links and then manually link on all three fields and preview the report it...

Many thanks Ken, I just put a Do Until rs.EOF loop in and scrolled through and got exactly what I needed. Thanks for your help. Les P

Many thanks Ken. I was missing the "FORM" bit. This does part of what I want, it picks up the currently selected row from the subform (Datasheet). Is there a way to pick up all records in the subform? Thanks Les P

I have a Datasheet subform to a main form. The subform picks up data from one table, user adds values where necessary, then I need to add records to another table based on the values entered on the subform. I have no problems updating a recordset from the main form but not sure how to go about...