Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: how to write this formula Post Reply Post New Topic
Author Message
abenipal
Newbie
Newbie


Joined: 09 May 2010
Location: Canada
Online Status: Offline
Posts: 1
Quote abenipal Replybullet Topic: how to write this formula
    Posted: 09 May 2010 at 2:21pm
need to write 2 formulas :
 
(1) there is an original survey which contains a previous survey field, so if previous survey field is defined and has at least one hotel record with “hotel used” marked (hotel used is a checkbox) then display report.

 

(2) Display the hotel information for each hotel where “hotel used” marked.

IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 10 May 2010 at 3:47am

if I understand correctly you need to keep track of a survey field across multiple records.  If so, a shared or global variable should do the trick.  You could use an array, but I tend to keep things simple and use a delimited string and then search for the value in the string.  Easy to search (INSTR()  ),easy to manipulate/maintain (LEFT() & MID() )

Second question seems vague...as it would seem you would just link to the hotel.  If it is to be in summary, you would probably want to use a subreport (you might want to pass via shared variable a list of hotels to filter against), if it is to be displayed as the report as generated, link to the table and display.
 
HTH
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.016 seconds.