Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Advice required - Memo Fields Post Reply Post New Topic
Author Message
anu009
Newbie
Newbie


Joined: 18 Aug 2010
Online Status: Offline
Posts: 28
Quote anu009 Replybullet Topic: Advice required - Memo Fields
    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


Edited by anu009 - 20 Dec 2010 at 11:56am
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3701
Quote hilfy Replybullet 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
www.protiviti.com/US-en/data-management-advanced-analytics
IP IP Logged
anu009
Newbie
Newbie


Joined: 18 Aug 2010
Online Status: Offline
Posts: 28
Quote anu009 Replybullet 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


Edited by anu009 - 21 Dec 2010 at 6:00am
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3701
Quote hilfy Replybullet 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
www.protiviti.com/US-en/data-management-advanced-analytics
IP IP Logged
anushka
Newbie
Newbie
Avatar

Joined: 10 Apr 2008
Online Status: Offline
Posts: 29
Quote anushka Replybullet 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.


Edited by anushka - 11 Jan 2011 at 8:21am
Learning can be fun.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump 		You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.017 seconds.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.