rbuser

Comments

• Brilliant, thanks. WOrks a treat.
  
  I was making a second tbl var and doing.
  
  lTbl2 := lQueryDataView.SQL.GetTableForSQLAlias('INVITEMS');
  
  Andy
  
  

  in AddCriteriaField on joined query Comment by rbuser August 2012
• D7 rb 9.
  We have hundreds of systems using the same method with an end user report
  desgner, it would be a masive change.
  The way we have works beautifuly.
  I'll get someone to look into it though. But can we access the joined tab…

  in AddCriteriaField on joined query Comment by rbuser August 2012
• That's great news Nard. Much appreciated.
  
  
  

  in Change table selection order Comment by rbuser February 2014
• Not sure if its poor etiquette or not to resurrect old requests like
  this, but now that we are finally rolling out our product with a nice
  new suite of RB reports, we have (in the first week) a customer who
  wants to run a one of ou…

  in Change table selection order Comment by rbuser February 2014
• Hello again
  
  I'm really sorry to bang on about this, but are you able to give any
  indication as to i) the likelihood of this improvement ever happening,
  and if so, ii) when (14.07, 15.01, etc)?
  
  I (reluctantly) ask be…

  in Change table selection order Comment by rbuser September 2012
• Hey, I love Report Builder but how has this one been missed for all
  these years? Its a big big headache. Its means that rather being able to
  take a single report that contains many common calculated fields,
  database links, layout f…

  in Change table selection order Comment by rbuser September 2012
• Thanks Nico - that works a treat!
  
  

  in Dictionary Changes Comment by rbuser September 2012
• Actaully, it "almost" works: when the DataViews update themselves the
  SIZE column for every field is set to 10! If I just popup the
  QueryDesigner and close it (OK btn) then this gets corrected. Any
  suggestions?
  
  
  P.S…

  in Dictionary Changes Comment by rbuser September 2012
• I worked it out myself. I would be grateful if anyone could point out
  anything I've missed or anything I'm doing that's not necessary:
  
  procedure TnxRBDesignerEngine.DoDataModuleFieldsRefresh(Sender : TObject);
  var
  l…

  in Dictionary Changes Comment by rbuser September 2012
• Hi Nico,
  
  The version is:
  
  ReportBuilder Enterprise Edition
  Version 11.05
  
  Thanks
  Ben.
  
  

  in Correct syntax for linking a parameter directly into manually "Edited SQL" Comment by rbuser March 2013
• Hi Nico,
  
  Thanks for the info, I have tried your suggestion but get the following
  error:
  
  --------------------------------
  Invalid SQL statement.
  Incorrect syntax near '<'
  --------------------------------<…

  in Correct syntax for linking a parameter directly into manually "Edited SQL" Comment by rbuser March 2013
• Great, thanks Nico.
  
  Jason.
  
  

  in Add External keyword to MS SQL reserved words Comment by rbuser May 2013
• Hi
  Can I send images with an example attached to the answer? I think it
  will help to understand my problem
  Thanks
  
  Ing. Alewaerts Ignacio
  
  
  El 17/09/2013 10:27, Nico Cizik (Digital Metaphors) escribió:
  

  in Parameters in calculated fields Comment by rbuser September 2013
• Hi
  It was my mistake when answering. I write again the problem
  
  I need to add a parameter in a calculated field in my datapipeline. I
  use the following expression to add a new field in the calculation tab
  of my datapipeline…

  in Parameters in calculated fields Comment by rbuser September 2013
• SORRY
  lLink.Parent := MASTERPIPELINE ;
  
  
  
  Sembra che Diego Rigoni abbia detto :
  

  in Link dade to exixst pipeline with rap Comment by rbuser November 2013
• I found a better pieces of code RAP, it seems works
  
  procedure ReportBeforeOpenDataPipelines;
  var
  lLink:…

  in Link dade to exixst pipeline with rap Comment by rbuser November 2013
• hi!
  thanks!
  i have a similar function " TQueryGeneric = class(TraSystemFunction) "
  and it works.
  
  but in some cases i want to add client query with DADE in Link dade to exixst pipeline with rap Comment by rbuser November 2013
• Hello Diego,
  
  some time ago we had same problems. I have solved it the following way:
  
  * create some reportbuilder-rap-functions to define a query, i.e.
  virtualquery(1, 'select * from details where id='+master['id']);
  …

  in Link dade to exixst pipeline with rap Comment by rbuser November 2013
• I'll explain better
  
  if i add this
  
  procedure ReportBeforeOpenDataPipelines;
  var lSQLBuilder: TdaS…

  in Link dade to exixst pipeline with rap Comment by rbuser November 2013
• Hi!
  I'm trying to use it... but, how can i create a master-detail link with
  TdaSQLBuilder?
  
  should i intercept every "ondetailbeforeprint" and modificy the search
  on dade query with current master value?
  
  
  …

  in Link dade to exixst pipeline with rap Comment by rbuser November 2013
• Nard Moseley (Digital Metaphors) wrote:
  
  That worked. Thank you!
  
  This solves my immediate problem, but I wonder if there is an article
  somewhere that explains parameters a little? I still am unsure of some
  of the prop…

  in How to use parameter to link one pipeline to another pipeline Comment by rbuser November 2013
• Hi.
  
  As we own RB 12 Enterprise Edition, I made a little test with the ISNULL
  function from MS SQL.
  
  In the Data tab a put manually the next SQL statement:
  SELECT *
  FROM CLIENTE
  WHERE CLIENTEID = ISNULL(:CLIE…

  in Firedac Macro Functions Comment by rbuser December 2013
• Hi.
  
  Thanks for the answer Nico.
  
  If the Select is contain it in RB. How can I do that??
  
  TIA
  
  

  in Firedac Macro Functions Comment by rbuser December 2013
• Hi Nico.
  
  Sorry for bothering you.
  
  Do you have any sample code?? or Do you have a workaround??
  
  Thank you.
  
  Merry Christmas.
  
  
  
  "Rolphy Reyes" escribió en el mensaje de noticias:52b874fd@…

  in Firedac Macro Functions Comment by rbuser December 2013
• Hi Nico.
  
  Thanks again for the answer.
  
  As you point, that's what I do before posting here.
  
  The steps:
  1.- Manually alter the SQL using the SQL tab in the Query Designer.
  2.- Go to the Design Tab
  3.- Ri…

  in Firedac Macro Functions Comment by rbuser December 2013
• Hi.
  
  Thanks Nico for the answer.
  
  I forgot to said, that I'm testing the Macro Functions as Parameters not as
  a field of the sql select.
  
  Something like:
  
  Select *
  from MyTable
  where MyField = {…

  in Firedac Macro Functions Comment by rbuser December 2013
• Sorry the correct example is
  
  procedure FechaOnPrint;
  var lParameter: TppParameter;
  lsValue1 : TDate;
  begin
  lParameter := Report.Parameters['pIntervalo'];
  
  lsValue1 := lParameter.Values[…

  in TDateParameter with soBetween search operator Comment by rbuser January 2014
• Sorry. My mistake.
  Thanks for answering so fast. I already was considering upgrading to
  the latest version to take advantage of many features you've published
  
  Thanks again
  
  
  El 03/01/2014 12:51, Nico Cizik (Dig…

  in TDateParameter with soBetween search operator Comment by rbuser January 2014
• How would it be on the Calc tab becuase with the next example
  
  procedure FechaOnPrint;
  var lParameter: TppParameter;
  lsValue1 : TDate;
  begin
  lParameter := Report.Parameters['pIntervalo'];
  
  …

  in TDateParameter with soBetween search operator Comment by rbuser January 2014
• Hi
  I know how to do it with autosearch fields but I'm using parameters
  because I need to do something with values entered by users before add a
  condition to the datapipelines. If I use the
  pDate.autosearchsettings.searchexpre…

  in TDateParameter with soBetween search operator Comment by rbuser December 2013
More Comments