Postgre DB to Crystal Reports Memo - Number or Text Field

Posted on 2010-08-26
Medium Priority
Last Modified: 2012-06-21
I'm connecting to a Postgre SQL DB (in linux) to create a custom report. Most if not all fields in the DB are in Memo type. Crystal Reports won't allow parameters to be created on memo type fields.

Is there any easy way around this. I'm trying to create parameters for two of the memo type fields?

Question by:RandyMFire
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 101

Expert Comment

ID: 33535977
What version of Crystal?

Are the memo fields actually limited in length?

Are you trying to use memo field values as parameter values or simply for record selection?

You might be able to use a formula like


Author Comment

ID: 33538296
I'm not at work but I have CR 2008

I'm not sure what the length of the memo field is. Like I said it is in a Postrge DB, which I'm not familiar with at all.

I'm trying to use the memo field for record selction only.

Unless I can use the formula  as a record selection parameter, I don't think that will work, although I will try it in the morning.
LVL 19

Expert Comment

ID: 33540091
Please explain in more detail your environment including version iof postgres and calrify what you are trying to do as your posts are unclear in the first post yopu mention parameters and in your last post you talk about formuals and record selection

I use Postgres 8.03 and run reports using CRXI R2 and have no issues using memo fields in the record selection formula i.e. {Table.memoField} = {?MyParam}

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.


Author Comment

ID: 33641013
Not sure asking developer on what version of Postgre
I have a Linux Server where there is a Medical Program using Postgre DB
I am using Crystal Reports 2008
I am trying 2 things now.
Accessing from a XP SP3 laptop using ODBC (RDO)

One trying to load the Stored Procedure table where the developer created a stored procedure for me to convert the 2 fields (in question) . I've tried options and checked the stored procedurs box but still not bringing up the table to move the stored procedure over form available data sources to selected tables. Ths is my first issue.

The second and original problem
 CR will not allow me to pick from the fields view to create a parameter. They show up in the Field Explorer as field type Memo. The developer stated he has made them varchar(255) type.
I need to create a parameter so the users can pick a specific record to show all of the fields I have placed in the report.
The only records I can select for a parameter right now is on the data_created field, which will bring up to many reports for any given day.

Any help would be appreciated. Sorry for the long delay. Was off for a while.
LVL 35

Expert Comment

ID: 33643971
I haven't used Postgres, but FWIW ...

 I use MS SQL and have had some problems using MS SQL Memo fields in CR.  I actually don't have any problem using one in a record selection formula or comparing it to a string parameter.

 Hmm.  Re-reading your original post, you weren't trying to create Memo type parameters, were you?  That's not an option.  Just use String parameters.

 Assuming that that wasn't the problem ...

 While I don't have any problem using Memo fields in a record selection formula, there is at least one thing that CR will not let me do with them.  CR will not let me create a group on one.  A simple workaround for me is to put the field in a formula.  I don't have to use Left () as mlmcc suggested, or anything like that.  If I just create a formula and put that field in it, with nothing else, I can then create a group on that formula.  Weird, but there you go.  :-)

 I have no idea if it will help with your problem, but it's simple enough to try.


Author Comment

ID: 33645782
No I wasn't trying to create a memo type parameter.
I was trying to create a parameter from a field showing memo in the field explorer.
The original field type in the Postrgre DB was coded as varchar (255), but when I bring in the table into CR it shows it as memo??? Which means I can't create a parameter for that field.
Is this soemthing that CR does or a bug or is my ODBC not correct??? I don't know. This is why I'm asking if there is a way around this? I thought creating a stored procedure was a way but then read on....

The other question was I had the developer of the program create a stored procedure in the DB. When I go to DB explorer the stored procedures table doesn't even show up to try and move it over with the rest of the tables I want to work with. I've already checked the check box under properties for stored procedures and that didn't make the stored procedures table visable...So I'm stuck..
LVL 19

Expert Comment

ID: 33645832
As I said in my earlier post this is not a CR issue as I do this kind of thing all the time with postgres. Did you find out what version youa re reporting against ? and what ODBC client are you using you can find out teh name and vesrion nunber from teh drivers tab in ODBC data source administrator

Author Comment

ID: 33645967
Not sure but I think this is what you are asking see attched screenshot.

Author Comment

ID: 33646040
Here are screenshots of the Data Source.
LVL 19

Accepted Solution

GJParker earned 2000 total points
ID: 33646107
Which of these drivers are you using for your connection ?

I use the ANSI version and {Table.memoField} = {?MyParam} works fine for me, when you connect to the DB can you see the memo fields ? are they in the list of available tables and fields in the record selection formula editor ?

Author Comment

ID: 33646244
Using the highlighted one Unicode. Will try using ANSI..Yes they are in the list of available fields. I can even drag and drop into the report, just won't let me use as parameter. Give me a minute to see what happens when I switch to ANSI....
LVL 19

Expert Comment

ID: 33646288
"just won't let me use as parameter"

what does this mean ? can you list the exact steps you are doing please

Author Comment

ID: 33646425
You are a frickin genius. That was exactly it. I was originally advised to set the ODBC up with the UNICODE driver. When you said yours was in ANSI, I changed mine to check, and sure enough, the fields were able to be selected from the parameter pull down. Thanks. Really do appreciate you working this out with me.
LVL 19

Expert Comment

ID: 33646454
Glad to help

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Suggested Courses

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question