DBCross-tab add 2 new columns

Comments

• Mick.pl

  July 2011 edited 2:51PM

  Does a solution of your issue should look like this one below in my example?
  
  Mick
  
• Jimmy Van den Bliek

  July 2011 edited 2:51PM

  Yes! It looks like very close to what I'm looking for... How can I add these 2 extra columns? Thank you
• Mick.pl

  July 2011 edited 2:51PM

  Have a look at the FR file below.
  My solution is based on DBCross property NextCross. This next cross has NO row header, NextCrossGap is set to 0, and I use another ADOQuery to fill this second cross.
  
  Mick
• Mildy

  August 2011 edited 2:51PM

  Mick,
  
  please, would you be so kind to take a look at attached pictures.
  I have a problem with 2 DBCrosses.
  If there are more data and report is generated on more than one page,
  second DBCross is splitted on page 2 and 3. (Example1)
  
  Whe I set "DownThenAcross" property of DBCross2, then Cross is not splitted, but
  an empty page is generated at the end of report (Example2).
  
  Attached is also FR3 file.
  
  Many thanks.
• Mick.pl

  August 2011 edited 2:51PM

  Hi Mildy,
  
  Sorry to say but I couldn't find a solution of the problem you've mentioned - I mean supressing last (additional) page [img]style_emoticons/<#EMO_DIR#>/sad.gif" style="vertical-align:middle" emoid=":(" border="0" alt="sad.gif" /> Sometimes I get such an additional page in other cases (even with no DBCross) and still my knowledge of FR script and FR objects properties isn't enough to solve these problems. Hope someone will help both of us[/img][img]style_emoticons/<#EMO_DIR#>/smile.gif" style="vertical-align:middle" emoid=":)" border="0" alt="smile.gif" /> Mick[/img]
• Mildy

  August 2011 edited 2:51PM

  Hi Mick,
  
  thank you for your time.
  As I'm displaying reports in my own client application, probably I will have to check for empty pages and delete them programatically.
  If I'll find some solution later, I'll post it here.
  
  Mildy
  
• Mick.pl

  August 2011 edited 2:51PM

  Mildy,
  
  You can search through this forum about PreviewPages.
  I remember there were several posts about how to manage (programaticaly) with prepared report and its pages before they appear in Preview.
  
  Mick
• Mildy

  August 2011 edited 2:51PM

  Thanks Mick, but there's no need to search the forum for this. I already can manage report pages from my app.
  
  I thought when I find the solution of "DBCross bug" then I'll post it here.
  
  Mildy.