Print Page | Close Window

Advice required - Memo Fields

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=11911
Printed Date: 04 May 2024 at 2:46pm


Topic: Advice required - Memo Fields
Posted By: anu009
Subject: Advice required - Memo Fields
Date Posted: 20 Dec 2010 at 11:56am
HI ALL
 
I have a memo field which contains the description of rights, i want to create a paramter on this field , which can enable the users to select the staff members based on their rights, but since you can not select memo fields in record or group selection formulas, what is the work around.
 
I have created the formual totext, but ti still doesn't work .
 
Any suugestions, its very important to have this report built.
 
Anu


Replies:
Posted By: hilfy
Date Posted: 21 Dec 2010 at 5:52am

What type of database are you using?  Do you have the option to create a command?

If the memo is NOT a BLOB but a Text (SQL Server) or CLOB (Oracle) type field, you can create a command (SQL Select statement) that has a parameter in the Where clause (DO NOT USE THE SELECT EXPERT!) to find what you're looking for.  The database will allow you to do this where Crystal will not.
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics

Posted By: anu009
Date Posted: 21 Dec 2010 at 5:55am
The database is oracle and i am not very sure how to create the command , can you explain a bit.
Should  i use the memo field to create the command or the formula field where i converted it to totext({memo.field})
Also how can i just add the parameter in the command window

Posted By: hilfy
Date Posted: 21 Dec 2010 at 7:56am
A command is a complete SQL Select statement that will be in the format: 
Select
  <all of the fields that you need for the report>
from <primary report table>
  <join any other tables for the report>
where 
  memotable.memofield like '%{?Rights}%'
  and <any other selection criteria>
In the Command Editor, you'll also create a parameter called "Rights" - you MUST create it in the command editor NOT in the regular parameters for the report, although it will appear in the parameters list in the Field Explorer.
 
If you're not familiar with writing SQL, then I would recommend working with your DBA.
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics

Posted By: anushka
Date Posted: 11 Jan 2011 at 8:18am
I cannot create a sql command as this report involves lot of joins and other tables and is not a simple select statement.
 
And the user respnse for the parameter is used  to craete seperate groups and so i used at group level.
 
Any other alternative to use the CLOB field in the report.


-------------
Learning can be fun.


Print Page | Close Window