Setting Database environment variables

edited January 2017 in FastReport .NET
Hi there;

I'm a few days evaluating fast report; using it with C#/MVC/ RAZOR;

I already read programmer's manual and search lot (this forum using google) ; and no results for this case;


I want to execute one stored procedure every time FastReport connect to my database (oracle);

This stored procedure will set some oracle's session variables, whose will be used at my oracle's view's layer;
so I need to pass some parameter into it, too;

Until this stored procedure is executed , my views wont return any row !

It is possible to execute a non-returning-row procedure; at the same connection used by Report's / Form's dataSets in fast report c# script? using loads events?

Fowards Thanks

Marcos;

Comments

  • edited January 2017
    how do you push data from database to fastreport?
  • edited January 2017
    ipong wrote: »
    how do you push data from database to fastreport?

    Hi;

    my sql's are always like

    Select *
    from someView



    I would like to use FastReport embedded connection and FastReport Queries;

    As much as fastReport inheritances capabilites
  • edited 4:40AM
    there are two queries, one for report and one for authentication, if authenticated, you can pass parameter to fastreport
  • edited January 2017
    Maybe I missunderstood or I'm not making myself clear;

    Procedure that must be executed before returning any rows from database view layer;
    this procedure does not return any row it is just for setting oracle session variables;

    So, I must to be sure that all times FastReport connect it execute my "set_active_user";


    begin
    app_core.set_active_user('DomainName\Username'); <<-- parameter here
    end;



    Passing parameters it's ok, I almost do it;
    By the way, I can use


    System.Environment.UserDomainName ;
    System.Environment.UserName



    Sql Queries are all against my database view's always ( select * from someView );

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.