Storing No Of Records in a variable

Comments

• seshadri

  August 2006 edited 4:04PM

  This is my 5th question and no response
  from FR Forum..
  Somebody lpz answer NEwbies question....
  
  PS:
  Den i hav seen u answering some comlpex queries,
  these questions may not be of ur level.still for me it is important
  
  Regards
  seshadri.r
• gordk St.Catherines On. Canada.

  August 2006 edited 4:04PM

  Please give more info version of fr, where you are trying to write code in report script or delphi. Since you are a newbie I suggest that you read the user manual and try the examples, the programmers manual, as well as compile and run the main demo, it contains many example reports, covering about 90% of most requirements.
  
• seshadri

  August 2006 edited 4:04PM

  Thanx gordk,
  
  i'm using FR3.17.
  
  I'm writing the code in Basic Scripts inside fast Report.
  
  
  I just want to get the count of records in a masterdata band
  and store it in a variable.
  
  The COUNT(MasterData1) gives the coutn but i'm not able to store them
  in a variable and use it.
  
  1. one more query was to move the cursor to next record.
  2. Wat is the syntax for End Of File if any in BAsic Scripts??
  
  i have gone through Manual but i think these points are not available
• gordk St.Catherines On. Canada.

  August 2006 edited 4:04PM

  from your reply i assume you are using studio version and vbscript as the language is this correct ? or are you using delphi ide and basic script language in the
  code page?
  in what event are you writing this code?
  
• seshadri

  August 2006 edited 4:04PM

  ur right gordk
  
  i'm using studio version and basic script as language.
  
  i'm writing in OnBeforeMasterData1Print
• gordk St.Catherines On. Canada.

  August 2006 edited 4:04PM

  you should really be posting in the studio forum.
  im a delphi pascal person and i am not sure of all available in studio edition.
  generally
  be careful where you try to retrieve aggregate values they aren't available until after something has been processed
  ie a memo in a footer might contain
  [COUNT(MAsterdata1)]
  
  declare your variable as integer, you may also want to declare it at the start of the code page so it is available globally rather than in an event .where it exists only for the life of the event.
  and use the correct function to display it in showmessage.
  
  normally a master band is connected to data through the dataset property of the band( choice of available datasets) which are usually frdbdatasets,or using specific internal dbengine controls.
  this controls the number of times the band appears,
  memos within the band are connected to a datafield of the dataset and display the value of the current record. You only setrowcount property when you do not have the band connected to a dataset.
  So unless you are doing some fancy manipulation you should not need to try to move to the next record.
  hope this helps
  
  
  
  
  
  
• seshadri

  August 2006 edited 4:04PM

  Yup gordk,
  
  got it.actually i have changed the delimiter and trying
  with diferent delimiter.Thts the problem..
  Thanx for your gyan on FR3..
  
  NExt time will post in appropriate forum.