logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
jswartz  
#1 Posted : Thursday, December 28, 2017 10:46:15 PM(UTC)
jswartz

Rank: Newbie

Groups: Registered
Joined: 12/13/2017(UTC)
Posts: 0
United States
Location: Portland OR

Thanks: 1 times
Hello,

I've been exploring Seal Reports and love what you've done. I've delved into things quite a bit, yet feel that I've only really scratched the surface. Initially we showed some basic ideas to our corporate office having pushed aggregated data to a central SQL database from multiple locations. The feedback interest was more along the lines of accessing site specific data directly by individual location users.

Right now we are just using the seal generated web site under IIS and have used the utility to create a few reports, but I'm thinking about management of a centralized report repository, ie creating a base report template that is then used for different locations (different data sources), different email recipients, and filtering parameters. I've considered creating an app or applications that can modify a base report and copy it to individual sites (or a site folder) changing the connection string in the report xml or the like, but am wondering if:

1.) Is there already something your company has beyond the open source stuff that is more for enterprise level solutions that we may want to encourage our company to purchase (why reinvent the wheel).

2.) Am I thinking about this wrong, and is there a different direction I should take.

Admittedly I haven't yet done due diligence in exploring all of your source code, so I may thinking in entirely the wrong direction here.
epf  
#2 Posted : Friday, December 29, 2017 3:47:10 PM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 476
Switzerland

Thanks: 7 times
Was thanked: 68 time(s) in 66 post(s)
Hi and thank you for your comment, it is always interesting to discuss on end-users needs/architecture...

As far as In have understood your requirements, it is difficult to give a simple answer. Here are some remarks related:
  • Installing multiple-instance on your server allows you to have different configuration and repositories, etc. http://forum.sealreport....g=posts&t=91#post177
  • If you have a well defined security (and you should have one I guess) and if you know C# and the SR models, you can customize some scripts to create dynamically the default values you want: e.g. SMTP Server, Data Sources). The 2 general scripts that can be interesting are in: Server Manager->Configuration->Configure Server...
    Then depending on the user connected, you can customize what you want at report creation and report execution.
    The other interesting script is of course the Custom Security Script of the Security Provider (Server Manager->Configuration->Configure Web Security...) where you can set default depending on the user profile/rights...


Note that we do not have any tools/layer above the current SR to publish different repositories...could be a feature request but according to me you could do all you need playing with the scripts...

Edited by user Friday, December 29, 2017 3:51:31 PM(UTC)  | Reason: Not specified

thanks 1 user thanked epf for this useful post.
jswartz on 12/29/2017(UTC)
jswartz  
#3 Posted : Friday, December 29, 2017 8:35:43 PM(UTC)
jswartz

Rank: Newbie

Groups: Registered
Joined: 12/13/2017(UTC)
Posts: 0
United States
Location: Portland OR

Thanks: 1 times
Thanks, I hadn't discovered the multi-instance aspect yet. I'm thinking multiple sites pointing at the same repository (the data sources for each site being different, but the same structure).
epf  
#4 Posted : Saturday, December 30, 2017 9:23:47 AM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 476
Switzerland

Thanks: 7 times
Was thanked: 68 time(s) in 66 post(s)
So the second option seems the simplest, you can centralize and master everything with a few lines of code...
You just have to dive in the Seal Report models....
Good luck.
Users browsing this topic
Guest (2)
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.

Powered by YAF 2.0.0 | YAF © 2003-2018, Yet Another Forum.NET
This page was generated in 0.079 seconds.