Rank: Newbie
Groups: Registered
Joined: 11/4/2015(UTC) Posts: 0  Location: Aberdeen Thanks: 1 times
|
Hi,
I was looking around for reporting tools that I could use for a test system, which clients could possibly use to monitor their own employees records that we store on our database.
The reports generated via the Seal Report generator look exactly like what we are looking for, however; we would need to integrate the report generation mechanism with the system we are building, whilst ensuring that only their employee data is returned.
As far as I can see, there are a couple of tools that sit on the server that generate reports, but the report builder seems to be standalone. Which is fine if I can hide data and store client specific reports somewhere.
Is this something that is currently possible with Seal Report?
Kind regards
Richard
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209  Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
|
Well this is a generic question. There are several ways to integrate Seal Report in your system depending on your needs and skills. I imagine you want to use the Web Report Server as the Report Designer remain a fat client without security. If you want to filter the data in reports, you have first to set up an authentication mode (several authentication providers can be used and configured using the Server Manager), then once the user is authenticated, you might use his name and group to add dynamic restrictions in the property 'Additional WHERE clause' of the table you want to filter. Thus the restriction will be applied dynamically to all your reports. You have a small script sample to do that: Code:@using Seal.Model
@using Seal.Helpers
@{
MetaTable table = Model;
string restriction = Environment.UserName;
if (table.Source.Report != null && table.Source.Report.SecurityContext != null)
{
restriction = table.Source.Report.SecurityContext.Name;
}
string result = string.Format("aColumnName={0}", Helper.QuoteSingle(restriction));
}
@Raw(result)
Another issue can be how to authenticate your user automatically from your system. There is no simple interface/protocol in the current version, but you can sent Post Http Request to the Web Server to automate this.... Or if your source system is in the .Net framework, you can also list and execute directly the reports by your own, here is the code sample to do that: https://sealreport.org/forum/default.aspx?g=posts&t=102#post226Good luck. Edited by user Wednesday, November 4, 2015 11:21:39 AM(UTC)
| Reason: Not specified
|
 1 user thanked epf for this useful post.
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 3/1/2018(UTC) Posts: 7  Location: ahmedabad
|
Originally Posted by: epf  Well this is a generic question. There are several ways to integrate Seal Report in your system depending on your needs and skills. I imagine you want to use the Web Report Server as the Report Designer remain a fat client without security. If you want to filter the data in reports, you have first to set up an authentication mode (several authentication providers can be used and configured using the Server Manager), then once the user is authenticated, you might use his name and group to add dynamic restrictions in the property 'Additional WHERE clause' of the table you want to filter. Thus the restriction will be applied dynamically to all your reports. You have a small script sample to do that: Code:@using Seal.Model
@using Seal.Helpers
@{
MetaTable table = Model;
string restriction = Environment.UserName;
if (table.Source.Report != null && table.Source.Report.SecurityContext != null)
{
restriction = table.Source.Report.SecurityContext.Name;
}
string result = string.Format("aColumnName={0}", Helper.QuoteSingle(restriction));
}
@Raw(result)
Another issue can be how to authenticate your user automatically from your system. There is no simple interface/protocol in the current version, but you can sent Post Http Request to the Web Server to automate this.... Or if your source system is in the .Net framework, you can also list and execute directly the reports by your own, here is the code sample to do that: https://sealreport.org/forum/default.aspx?g=posts&t=102#post226Good luck. Please give me Samples report
|
|
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 3/1/2018(UTC) Posts: 7 Location: ahmedabad
|
Originally Posted by: epf Well this is a generic question. There are several ways to integrate Seal Report in your system depending on your needs and skills. I imagine you want to use the Web Report Server as the Report Designer remain a fat client without security. If you want to filter the data in reports, you have first to set up an authentication mode (several authentication providers can be used and configured using the Server Manager), then once the user is authenticated, you might use his name and group to add dynamic restrictions in the property 'Additional WHERE clause' of the table you want to filter. Thus the restriction will be applied dynamically to all your reports. You have a small script sample to do that: Code:@using Seal.Model
@using Seal.Helpers
@{
MetaTable table = Model;
string restriction = Environment.UserName;
if (table.Source.Report != null && table.Source.Report.SecurityContext != null)
{
restriction = table.Source.Report.SecurityContext.Name;
}
string result = string.Format("aColumnName={0}", Helper.QuoteSingle(restriction));
}
@Raw(result)
Another issue can be how to authenticate your user automatically from your system. There is no simple interface/protocol in the current version, but you can sent Post Http Request to the Web Server to automate this.... Or if your source system is in the .Net framework, you can also list and execute directly the reports by your own, here is the code sample to do that: https://sealreport.org/forum/default.aspx?g=posts&t=102#post226Good luck. Please give me Samples report
|
|
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
