Hi, I'm trying to build a solution with the free version to email a report as a PDF, but the solution builder says "Cannot Find Column [REF_NO]" REF_NO is the column name for our order number, which is also the parameter.

Please help! It's driving me nuts...

Hi,

When creating the rrd did you select Specified for the parameters and fill it in with a valid entry?

Thanks!
Matt

Yeah, but if I put prompt instead of specified (Yes, the specified order number is correct) it says: "Missing parameter values".

In order to email a report with a parameter you must specify the parameter. If you do that does it then run the solution correctly?

Thanks!
Matt

No, unfortunately. Not sure what to do about it. The viewer application reads the report no problem.
Solution Builder still reports these errors if it's set to just preview the file.
If I edit the file in notepad, I can change the column to include the table name, but then nothing happens...

Actually, I've just fiddled about with it.
It only works if you select "View" as the action but it won't print, save or email.
Do I need to buy the pro version?

If you want we can do a remote session so I can take a look at what is happening. You can email me at This email address is being protected from spambots. You need JavaScript enabled to view it..

Thanks!
Matt

Matt --

I am having the exact same problem with several rrd files. I may view a report on Logicity desktop and save as pdf. But if I attempt to save or email the same RRD directly, I receive a "column not found" error. What was the solution to this posting?

thanks,
Dale

and just to further define -- I have one parameter in the report that I define within the RRD.

thanks,
Dale

Good morning Dale,

I am working on a new build of Logicity and would like to track down as many bugs as possible to include fixes in the new version. Can I clear up a few things here:

1. So the issue you are seeing here is only with the E-mail, Print, and Save actions, right? If you do a View action you can press the export button to export the report to any format you like, right?

2. To clarify the parameters - your Crystal Report has only a single parameter and you have defined that parameter in your Logicity Solution File.

3. If you are using a view action with the parameter set to specified in the solution file it works without issue and does not prompt you for any additional information (database logins, other parameters, etc)

4. Is this only with a single report or have you noticed it with all reports? If you have a report without parameters does it work fine?

Lastly, can you give me a rundown of what database you are reporting against along with which version of Crystal your report was developed in?

Thanks,
Adam