My crystal report contain hyperlinks to the Event Video file (i.e..avi files).

Its format is somewhat like -

"EventVideos/EventVideo_" + {DataTable1.EventId} + ".avi"

     As I create hyperlink at design time, it remains active for all the events. But the case is that my all events do not have Event Video associated with it. So, such events also have link for event video which is not expected.
     To avoid this, I have to delete or disable the hyperlink for such events.

My question is - Is it possible to delete or disable the hyperlink at runtime in Crystal Report? If yes, can you please explain me how?

It will be great help. I will appreciate it.

Thanks in advance. 

 

    I do not have such fields in my database. At run time I come to know which event has event video and which not.

 

    Any idea, how can I sort out this problem?

 

Appreciate your help.

 

Thanks.

==>yes.

 

  Actualy i have 1 table in database, which has EventID and VideoData(binary data) columns.  Single EventID can have more than 1 VideoData.

  At runtime for each event I check if it has more than 1 VideoData in that table or not. If yes then I store those Videodata as Event Video (i.e. .avi file). If not then no Event Video will be stored.

      Have I explained my points clearly?

 

Appreciate your help.

 

Thanks in advance.

 

   Need to do trial and errors.

 

Thanks.