nardmoseley

Comments

• 
  ppDPTeeChart1.Chart[0].DataSource
  
  --
  Nard Moseley
  Digital Metaphors
  http://www.digital-metaphors.com
  

  in cannot connect ppDBTeeChart to pipeline Comment by nardmoseley January 2004
• 
  This is limitation of the TeeChart version that comes bundled with Delphi.
  The registered version does not have this limiration. For details, see the
  RBuilder.hlp, select the table of contents and then select ReportBuilder
  Refer…

  in cannot connect ppDBTeeChart to pipeline Comment by nardmoseley January 2004
• 
  I do not understand the question. Yes, ReportBuilder works the same for the
  end-user as it does for the Delphi developer.
  
  Simplest way to create a crosstab is to use the crosstab wizard. But you can
  easily do it manually a…

  in Multiple Crosstab acros report behaviour Comment by nardmoseley January 2004
• 
  You need to set the Report.DataPipeline to nil (). The detail band
  will print once for each record in the Report.DataPipeline. Then the
  crosstab will traverse the Crosstab.DataPipeline and build a crosstab.
  
  Try using the …

  in Multiple Crosstab acros report behaviour Comment by nardmoseley January 2004
• 
  See the RBuilder.hlp for TppReportExplorer, there are methods such as
  GetFolders and GetChildFolders. See RBuilder\Source\ppRptExp.pas and
  ppExpFrm.pas for the source code to the report explorer. That is the only
  example that w…

  in Iteration through directory nodes using your functions Comment by nardmoseley January 2004
• 
  For future reference, please post RAP related questions to the RAP
  newsgroup.
  
  You can extend RAP with custom functions the do whatever need. See article
  below...
  
  -------------------------------------------------…

  in create tchart series at runtime Comment by nardmoseley January 2004
• 
  The TppTeeChart component has a Chart property that provides access to the
  TeeChart. So you should be able to use standard TeeChart methods. Contact
  tee chart tech support if you need help on how to dynamically create chart
  seri…

  in create tchart series at runtime Comment by nardmoseley January 2004
• 
  1. During the first pass all of the pagination for the report is determined.
  That is how the report engine works, there is no way around it. If you
  dyanmically build your list while the report is executing, perhaps you can
  use t…

  in End user report with TOC Comment by nardmoseley January 2004
• 
  1. Set Memo.Stretch to True.
  
  2. Set Report.PassSetting to psTwoPass.
  
  3. You can try using a TStringList and then assigning it to the Memo.Lines
  in the before print event.
  
  4. In the module section of the ma…

  in End user report with TOC Comment by nardmoseley January 2004
• 
  The DataDictionary has three tables: Tables, Fields, Joins. You should be
  able to use the DataDictionary Builder to populate the tables or you can
  populate them by writing your own code to generate the entries. Use of the
  Join t…

  in Problems with Views in Joins Comment by nardmoseley February 2004
• 
  I do not understand the question.
  
  If the clients report is stored in an .rtm file, you can load it using
  
  myReport.Template.FileName := 'myClientsReport.rtm';
  myReport.Template.LoadFromFile;
  
  If the clients …

  in Using a report modified by the client instead of original report Comment by nardmoseley February 2004
• 
  If you have a horizontal line at the bottom and want it to print only after
  the stretching memo completes printing, then place the horizontal line
  inside a TppRegion. Configure the Region to not print a border and to
  ShiftRelati…

  in Detailband, memos & overflow Comment by nardmoseley February 2004
• 
  Thanks for the feedback.
  
  ReportBuilder is powerful and flexible - it can do many complex reports that
  other tools cannot. However, it is not a perfect tool - like all software it
  can be improved infinitely.
  
  You …

  in Group start only ODD new page Comment by nardmoseley February 2004
• 
  1. I do not know why RAP would compile and then not work properly. You are
  correct in that should not happen.
  
  2. I think you need to add some more logic to the event-handlers. You need
  to add some add some code in the oute…

  in Group start only ODD new page Comment by nardmoseley February 2004
• 
  As always, first get it working using Delphi code.
  
  Not all properties and methods are defined to RAP - t…

  in Group start only ODD new page Comment by nardmoseley February 2004
• 
  I experimented with another technique that might be work better. Try using
  the GroupHeader.BeforePrint to check whether the header should print and set
  Band.OutOfSpace if it should generated a page break.
  
  Example:
  

  in Group start only ODD new page Comment by nardmoseley February 2004
• 
  
  I created a simple example that you can download.
  
  http://www.digital-metaphors.com/tips/StartGroupsOnOddPages.zip
  
  
  

  in Group start only ODD new page Comment by nardmoseley February 2004
• 
  In your function declaration you need a semicolon at the end. Should be like
  this:
  
  'function Odd(X : longint) : boolean;'
  
  
  
  --
  Nard Moseley
  Digital Metaphors
  in Group start only ODD new page Comment by nardmoseley February 2004
• 
  See article below. First get it working using Delphi code. Then you can
  modify it to work in RAP.
  
  ------------------------------------------------------
  Article: Forcing Group Headers to Start on Odd Pages
  -----------…

  in Group start only ODD new page Comment by nardmoseley February 2004
• 
  Other possible approaches that I can think of
  
  1. Set Crosstab.Draw to False. Then the crosstab engine will build its
  internal matrix but will not render it. You can access the matrix
  programmatically and use the values in …

  in End-user who whishes to print Year info Comment by nardmoseley February 2004
• 
  Have you consider using a crosstab report? If your query result set looks
  like this:
  
  CustID CustName Year Total
  
  Then you can create a crosstab report that summarizes the total information
  by customer and year (…

  in End-user who whishes to print Year info Comment by nardmoseley February 2004
• 
  I think you need to create a query that uses the SQL Between operator:
  Select deb_rek.Totals,
  where deb_rek.Date BETWEEN '1/1/2001' and '12/31/2003'
  
  You can do this via the RB Query Designer. On the Search page add th…

  in End-user who whishes to print Year info Comment by nardmoseley February 2004
• 
  Just tried a simple test here using RB 7.03 and the
  Report.OnPrintingComplete works properly. Try creating a new application.
  Place a TppReport on a form and a button. Implment the the
  Report.OnPrintingComplete aned ButtonClick…

  in Checking whether the report is still printing or not and handling printing errors Comment by nardmoseley February 2004
• 
  ReportBuilder and other Windows applications never wait for the printer to
  actually print the pages, instead the rendered pages are stored in the
  print queue as part of a Windows print job.
  
  ReportBuilder uses Windows API …

  in Checking whether the report is still printing or not and handling printing errors Comment by nardmoseley February 2004
• 
  I think the problem is that the ppRichText1.RichText contains the formatted
  RichText and as part of this there is an end of file indicator.
  
  Try breaking this into two parts. In the first part build up a TStringList
  of the …

  in Richtext Rap example Comment by nardmoseley February 2004
• 
  It should look like this:
  
  main report (datapipeline set to )
  section (datapipeline set to )
  report (datapipeline connected to master)
  
  When the Report/ChildReport DataPipeline is set to none, RB should
  

  in Title-page Comment by nardmoseley February 2004
• 
  Try the following configuration:
  
  Create a main report with no header or footer, only a detail band. Leave the
  datapipeline unassigned. In the detail band place two sectiion style
  subreports. Use the first to print the tit…

  in Title-page Comment by nardmoseley February 2004
• 
  It would be a nice feature, though I think quite difficult to implement.
  
  You can manually edit the SQL and add the Having. This will disable the
  linking ability. You can programmatically create the links, as shown in the
  f…

  in Having, Limit Comment by nardmoseley February 2004
• 
  If you are performing a join, it could be related to joining in a detail
  record too many times.
  
  The other possibility is that it is related to the linking SQL.
  
  Linking DataViews in the ReportBuilder Data workspace (D…

  in Having, Limit Comment by nardmoseley February 2004
• 
  The Query Designer does not support either of those. Having is a SQL
  standard, but is not supported. Limit, is not a SQL standard, but I think
  some database products have added support for it.
  
  You link query dataviews, by …

  in Having, Limit Comment by nardmoseley February 2004
More Comments