Recent content by MartinDurant

That's the badger! Thanks very much - it's quite straight forward when you know how. I don't understand why my text field counts as a formula rather than a parameter. Thanks again. Martin.

Dave, I am happy to try any way that works! I have made the changes above and now get an 'Invalid name' error on this line. crpEventRegister.FormulaFields.GetItemByName("SelectedEvent").Text = Chr(34) & strSelected & Chr(34) I have checked all the spelling in both VB and CR. Martin PS Your...

Dave Gave this a go. With the prompt switched off, the parameter doesn't get passed. With the prompt on, the Enter Parameter Values dialog box is displayed, but with nothing in the Discrete Value field. Either way, still no passed parameter in my report. Martin

Dave I gave is a go, and it stopped the the prompt. It also stopped the parameter being passed too. To my mind this is a fairly simple objective and I can't see why it's so difficult. I can pass shed loads of data from a database, but I can't pass a simple text field. Thanks anyway, Martin

I am using VB6 and CR8.5. I have a report which is an event register - a list of names and a tick box to allow attendance to be recorded. The list of names is coming from my database, but I need to put the event name at the top of the report. The event name is being selected by the user from a...

I've answered my own question by finding the ADO Connection Methods Demo example on the Crystal Decisions Knowledge Base...

Hello, I am passing an ADO recordset to an RDC (version 8.5)report in VB6 using the Active Data Driver (AD0). However this will not allow me to use Memo fields in my report. How do I get memo fields to my report? Thanks.

I guess I was getting lazy there. The obvious solution is to put the Report Viewer on my data selection form and hide it till it's needed. No need for a seperate display form at all then. Thanks again for all your help. Martin.

Thanks. This is all coming together nicely now. I've imported my report, however, it looks as though I have to have one form with a CRViewer control on it for each report. The Report Designer generates a new report display form every time I add a report. Is there a way round this?

I think I've got it sorted! I've had to rebuild my report inside VB, but as it was only mail labels it was not too much work. My other report is more complex and has already taken a considerable amount of time to build. Is there any way to import a .rpt file into the designer in VB? Thanks for...

I believe I'm using ADO. In VB, I select names from a multi-select list box, match the names with their address and process the address fields into a single string conmtaining the name and address. This is then appended to an empty database table. My mail label report points to this table. The...

I am using Crsytal Reports 8.5, and I downloaded and installed the service pack for this before I started. My record selection formula looks like this: SELECT rptMailLabel.`MailLabel` FROM `rptMailLabel` rptMailLabel I am selecting a single field from the table having done all my...

I have taken out the refresh and the while loop and performance is unchanged. I am using a local Access database via ADODB. If I don't click the refresh button, the report form is displayed with no data in it. Only when I click the refresh button after a few seconds, does my data appear. I'm...

Thanks. I'm not sure it's made much difference, but anything's an improvement. I don't mind that the report displays with no data if the data would appear automatically when it's ready. It annoys me that I (and subsequently my users) will select a report and then have to keep clicking Refresh...

I am calling a report from my VB app using the RDC and the report is displayed before the data is ready despite looping while CRViewer1.IsBusy is true. I have to hit the refresh button until the data appears. The relevant bits of code are below: Print Button [code]Set cReport =...