Alias filed in FastReport.net

hi

i need to pass custom query to FastRepoert.net and this query is used alias field but i can't use this filed in fastreport.net
for example in this code how can use total field in my report ?

select sum(price) as total from account

Comments

  • edited 7:20PM
    hadiranji wrote: »
    hi

    i need to pass custom query to FastRepoert.net and this query is used alias field but i can't use this filed in fastreport.net
    for example in this code how can use total field in my report ?

    select sum(price) as total from account


    when creating new data source in report design in the tables choose page click "add sql query ..."
    and enter your query after this the new table with alias field is created and can be used

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.