MasterData Asceding by...

Comments

• stefque Serbia

  January 2011 edited 9:35PM

  How about changing the query, and adding "order by salery" at the end, then the query would return them sorted...
• stol

  January 2011 edited 9:35PM

  I can't do that because the field I want to sort is a calculated field and it is quite complex calculated so I can't use it in my query.
  
• Mick.pl

  February 2011 edited 9:35PM

  Does your database allows temporary tables?
  
  If so, then insert the result of your main query into a temp table and your much calculated field will become a standard column. And then use another query reading from this temp table with sort order that you need.
  
  Mick
  
• technisoft

  February 2011 edited February 2011

  As Mick suggests. Or make the result column part of the table
  SALES COMPUTED BY ....
• stol

  February 2011 edited 9:35PM

  Actually I have used a Dialog Box in my report. So I check my customers name which are sort asceding by surname and then I want them to be appeared in my masterdata field asceding by their investments. How can I create the temporary table?
• Mick.pl

  February 2011 edited 9:35PM

  Try this:
  
  1. OnDialogActivate create empty temp table
  2. OnBitBtnClik (when your user has filled the dialog box) fill the temp table with selected customers to be print
  3. Build the final query to use content of the temp table.
  
  This depends on your database - is it allows creating temp tables. If not then create standard table, and then OnDialogActivate delete rows from that table to make it ready for newly selected customers. If more than one user can print your report at the same time (which mean they all will use the SAME working table), add UserID to the temp table and delete only User's rows.
  
  You can manage filling the temp table with creating a query on-fly, eg.
  
  MyQry.SQL.Text := 'insert iD, CalcField into tempTab select s.Id, (s.qty * s.tax / s.no) from sales s where ' + MyWhereString
  MyQry.ExecSQL
  
  And MyWhereString will be created according to CustIds selected in the dialog.
  
  Mick
  
• stol

  February 2011 edited 9:35PM

  I made it like that and it worked! Thank you very much.