ariacom / seal-report Goto Github PK

Hello,
I am running the Project using SealWebServer as Start Up Project. But I keep on getting error related to TypeScript.Tasks.CheckFileSystemCaseSensitive. I updated all the packages and tried everything I could. Please help me how to get rid of that error. For your clear understanding I am copying the complete error below.

The "TypeScript.Tasks.CheckFileSystemCaseSensitive" task could not be loaded from the assembly D:\DashBoards\Seal-Report-master\Projects\packages\Microsoft.TypeScript.MSBuild.2.7.2\build\..\tools\net45\TypeScript.Tasks.dll. Confirm that the declaration is correct, that the assembly and all its dependencies are available, and that the task contains a public class that implements Microsoft.Build.Framework.ITask.

Thanks.

Can we use PostgreSQL. Is there any work around.

Hello,
I see on github changelog there are updates on XLSX and PDF renderers. But those are available only to users who purchased a commercial license, right?

i want to use sharphsql as datasource it uses ado.net is it possible

If there is a way in which users can be managed in seal reporting tool like creating user, creating role, creating privileges, assigning privileges to roles, assigning roles to users and so on...

Hi,
As I see from samples, it's possible to get data from noSQL data sources as xml or csv files.
Is there any way / plans to retreive data from noSQL database, e.q. Influx DB via GET queries?

Thanks.

I have reporting working well on my dev machine using the mysql odbc drivers however how would that be done when running on .net core in linux connecting to a local mysql database?

or is that not possible?

Hi can you check in updated .NET 6

Hello
SealReport whether to support the use of MySQL 64 bit odbc.

Does it support multiple languages and can it support Chinese?

When using the report designer with a database that has multiple schemas, pulling tables into the model does not retain the schema of the table. In addition, when you check the SQL generated, as well as the schema being missing, table and/or column names are not wrapped in square brackets.

The result being that if any columns have 'special' names (eg. name, rule, etc) or the table is a member of a schema, the generated SQL is invalid.

An example of the invalid generated SQL would be (real example from a database that I'm testing Seal-Report against):

SELECT
  Tenant.TenantName AS C0,
  Parameters.Rule AS C1,
  Site.LocalReadingTime AS C2,
  Sum(Site.FeedDensityRollingAvg) AS C3
FROM 
(Tenant INNER JOIN 
(Parameters INNER JOIN Site
 ON Parameters.SiteId = Site.SiteId)
 ON Tenant.TenantId = Parameters.TenantId)
GROUP BY Tenant.TenantName,Parameters.SiteName,Site.LocalReadingTime
ORDER BY Tenant.TenantName ASC,Parameters.SiteName ASC,Site.LocalReadingTime ASC,Sum(Site.FeedDensityRollingAvg) ASC

This is the corrected SQL (after copy & pasting into SSMS and resolving the errors):

SELECT
  Tenant.TenantName AS C0,
  Parameters.[Rule] AS C1,
  Site.LocalReadingTime AS C2,
  Sum(Site.FeedDensityRollingAvg) AS C3
FROM 
(Users.Tenant INNER JOIN 
(Site.Parameters INNER JOIN Readings.Site
 ON Parameters.SiteId = Site.SiteId)
 ON Tenant.TenantId = Parameters.TenantId)
GROUP BY Tenant.TenantName,Parameters.SiteName,Site.LocalReadingTime
ORDER BY Tenant.TenantName ASC,Parameters.SiteName ASC,Site.LocalReadingTime ASC,Sum(Site.FeedDensityRollingAvg) ASC

Hi,

Can we integrate highcharts.com charts. it would be great if you can suggest on which modules to work on to get in integrated.

Regards

Arvind

I want to used jquery
but i used the js
the report can't saw
want wrong on it

src='http://cdn.staticfile.org/jquery/2.1.1/jquery.min.js'></script>

Line 1: <%@ Application Codebehind="Global.asax.cs" Inherits="SealWebServer.MvcApplication" Language="C#" %>

--

The value in the Inherits attribute of your Global.asax file must match a type that is derived from System.Web.HttpApplication

Hi, in the near future, we are considering to give up the Northwind MS Access database and migrate the demonstration reports to SQLServer (with a data source pointing to a demo database in the cloud)...
Thus, is the 32bit distribution of Seal Report still relevant for the future ? Are you using it ?

Thanks to share your opinions...

Hello, quick couple things, I am trying to run it on Linux natively or test separately on docker. On the help page I was looking for installation guide and setup, but it said .net 4.7

• 1. is this .NET Core 5.1 I would like to try it on Linux.
• 2. would be helpful if there was a docker image.

Hi! It's nice for you to provide this excelent tool for us! I got a problem as below:
Table "HoldInfo" has 3 columns "Reason" , "TxnUserID" while "TxnUserID" and "HoldToUserID" can be null.
Table "UserInfo" has 2 columns "UserID" and "UserName". I want to get.a datatable like "Reason","Txn User Name","HoldUserName". But the generated sql is not correct : SELECT ... FROM (UserInfo1 Left out join (HoldInfo Left Outer Join UserInfo 2 on. .) on. ..),So I can not get the datas whose txnuserid is null.
I.have config 3 tables "HoldInfo","UserInfo1","UserInfo2" and 2 left out joins in designer.
Can you help to fix it!

I cannot build head revision from source
In file swi-main.ts i get urecognized type SWIDashboard
error message is:
Cannot find name 'SWIDashboard'. Did you mean 'hasDashboard'? swi-main.ts 144
TS2552 (TS) Cannot find name 'SWIDashboard'. Did you mean 'hasDashboard'?

Report result runs good in Seal Report Designer, and log is normal

But when runs in IIS, there is no result data, and log lack of 'Executing main query...', did I left something?

Thanks for the answers!

In Seal Report Designer, normal

In IIS, no data

In Seal Report Designer, normal

In IIS, lack of 'Executing main query...'

HI, is there a way to run seal report on a Windows Server 2012 to generate multiple reports from SQl Server database on a monthly basis.
I ask this because the only implementations I've seen from the available online documentations are through the Report Designer and using with a web application project.
Please an urgent respond would be appreciated.
Thanks.

There are files structure in SealWebServer.csproj
but no 'Images' folder in code

录入数据源时不能保存密码,始终都是空.

Consider cross-platform, please use cross-ping data driver, I use log output in linux "System.Data.OleDb is not supported on this platform."

Hi,

I am completely new to Seal Report and report generators in general. I am trying to set up a local Seal Report server on my machine to experiment with the Seal Web Interface, but I am struggling with it. I have created a new data source with the property "Server is Local (No internet)" set to true. I have also added a table to the tables folder. However, I am not really sure how to proceed from here. I have tried running "F7 Check Connection" on my Connection but it gives me this error: [UNEXPECTED ERROR RECEIVED]
Path cannot be the empty string or all whitespace. (Parameter 'path').

Any help with this will be appreciated.

Hello,

I've recently begun using seal report and it seems like a great reporting tool. I however seem to constantly have a challenge with the website published on IIS from the Seal Server manager. Instead of showing the reports which I created with the server manager and designer, it just keeps showing the default seal demo reports.
Is there anywhere that I need to update a connection string or is there something not being done right? An urgent response would be really appreciated.
thanks.

Can't compile project in Visual Studio 2017. Any Idea ?

Hi guys,

Can the above method on the REST service return CSV results? According to the documentation, it can do HTML, Print, PDF and Excel (using the converter) - but I need it to return CSV for a specific project.

Thanks,
D

Hi,

Thank you for making report viewer screen responsive. as i was testing found that datatables require some work to make them responsive. its basically hiding some columns. instead of adding plus button to see value of those columns.

Hi
the version 6.5 SealTaskScheduler.exeraising the following error:
Error:
An assembly specified in the application dependencies manifest (SealTaskScheduler.deps.json) was not found:
package: 'Microsoft.Win32.SystemEvents', version: '5.0.0'
path: 'runtimes/win/lib/netcoreapp3.0/Microsoft.Win32.SystemEvents.dll'
(with 6.1 there is no such problem at me)
Can you create a new build resolving this issue?
Thank you
Regards,
Peter

I have downloaded SEALREPORT 5.5 and installed successfully.

Source database = SQL Server 64bit

1. can create connection oledb to sql server. F7 check ok
2. Adding table, hit return and it come back with error, below. please advise
   Error opening database connection:
   A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - The remote computer refused the network connection.)
   SELECT * FROM t1 WHERE 1=0

I have installed the latest version of SealReport which is 5.5. I am trying to create sub-report from Report Designer tool but I am getting this error "Unable to create the detail report. Please save the data source first...". I'm not sure what it is asking specifically but I think I have saved the data source. I did try an alternative by creating a sub-report from Server Manager tool. But when I try to link with an existing sub-report, it give this error - "Unable to add this sub-report: The report doesn't contain any restriction." I double check that it does contain restriction. I have tried to similar thing with Northwind Database but I'm getting the same issues. I tried to link Customer.Customer ID with a sub-report Customer Details that contains Customer ID as restriction with Prompt at execution. It would be really helpful if you can guide me or help out in this matter.

Hello, when will it be added to oracle's official MySql.Data driver?

Hi.
I've installed the open source version.
Everything is ok if I go to reports and load it.
What I'm not able to do is to show a widget in the dashboard page.
I don't know that I'm doing bad.
No message or error and no log to check

VS2019

How to add support for Excel 64-bit？

Hi,
I am able to create the reports with report designer and run them. But I wonder, is there any way we can integrate the reports with Visual Studio like the SSRS. Can we run the reports directly in visual studio.
Please let me know.

Thanks.

Can you add support for viewing reports on mobile phones?

SEAL report is great, there is no plan to support. NET core, easy to run on Linux

At current there is only a picture of a seal and some UML diagrams on the main project homepage.

This could be improved by showing the actual product.

Hi Team,
I have downloaded the Seal solution.
Opened it in VS 2017.
Set SealWebServer as the startup project. I have cleaned and built the solution.
Stuck with the following error

Have tried all suggestions provided in the following link. But no luck.

https://stackoverflow.com/questions/11682216/parser-error-message-could-not-load-type-in-global-asax

How do I resolve this ? Please help.

Forum registration error
Hello, after clicking Register on the forum to agree to the agreement, an error page appears.

After hosting to IIS getting "HTTP Error 500.19 - Internal Server Error". Reports are viewable in Seal Report Designer. Can anyone assist to fix this issue? Attaching necessary screenshots for the same

.

The excel file is used as the data source. I can preview it in "Report Designer", but an error occurs in IIS publishing

Is there any tutorial other than quick tutorial, which is good for start, but where to find answers to slightly difficult questions like

1. how to create columns like year / month of date columns.
2. how to create columns like amount which is computed by a formula.
3. how to create drill-down report.

all these samples are available in code but how to create on your tables, right from scratch is my question.

64-bit was used when SealWebServer was released, the following error occurred, but no error occurred when using ANY CPU。
[BadImageFormatException: 未能加载文件或程序集“SealWebServer”或它的某一个依赖项。试图加载格式不正确的程序。]
System.Reflection.RuntimeAssembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, RuntimeAssembly locationHint, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks) +0
System.Reflection.RuntimeAssembly.nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, RuntimeAssembly locationHint, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks) +37
System.Reflection.RuntimeAssembly.InternalLoadAssemblyName(AssemblyName assemblyRef, Evidence assemblySecurity, RuntimeAssembly reqAssembly, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks) +159
System.Reflection.RuntimeAssembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean forIntrospection) +80
System.Reflection.RuntimeAssembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection) +22
System.Reflection.Assembly.Load(String assemblyString) +29
System.Web.Configuration.CompilationSection.LoadAssemblyHelper(String assemblyName, Boolean starDirective) +39

[ConfigurationErrorsException: 未能加载文件或程序集“SealWebServer”或它的某一个依赖项。试图加载格式不正确的程序。]
System.Web.Configuration.CompilationSection.LoadAssemblyHelper(String assemblyName, Boolean starDirective) +777
System.Web.Configuration.CompilationSection.LoadAllAssembliesFromAppDomainBinDirectory() +229
System.Web.Configuration.CompilationSection.LoadAssembly(AssemblyInfo ai) +140
System.Web.Compilation.BuildManager.GetReferencedAssemblies(CompilationSection compConfig) +176
System.Web.Compilation.BuildManager.GetPreStartInitMethodsFromReferencedAssemblies() +99
System.Web.Compilation.BuildManager.CallPreStartInitMethods(String preStartInitListPath, Boolean& isRefAssemblyLoaded) +310
System.Web.Compilation.BuildManager.ExecutePreAppStart() +165
System.Web.Hosting.HostingEnvironment.Initialize(ApplicationManager appManager, IApplicationHost appHost, IConfigMapPathFactory configMapPathFactory, HostingEnvironmentParameters hostingParameters, PolicyLevel policyLevel, Exception appDomainCreationException) +590

[HttpException (0x80004005): 未能加载文件或程序集“SealWebServer”或它的某一个依赖项。试图加载格式不正确的程序。]
System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +10085064
System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +99
System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context) +263

I am using 64-bit SealReportDesigner as the data source is EXCEL, preview is achievable, but when using SealWebServer, an error occurs

Can the login module join the OpenId Connect protocol?

Hello.
Thank you for youur work.

There is an exception The connection string is not defined for this Model. when I try to build a report using odbc connection.

It looks like Connection.OdbcConnectionString check is missing in the function Seal.Model.ReportModel.FillResultTable() in the SealLibrary

First, thanks for the software! I'm really enjoying using it. You can tell you put a ton of thought into designing it to be dynamic and customizable. Kudos

I'm trying to create a report in v4.0.1.0 that will query results based solely on date as a restriction. The field, named 'date_time', is a standard MSSQL datetime type. I'm using a custom SQL on the restriction to convert the records to yyyy-MM-dd format using convert(char(10), date_time, 120). I set a custom format for the same. The restriction selector is displaying the custom format properly; however, the generated SQL statement is not using this custom format to only query for the date. It appends the time. I tried the pre-defined format types of short and long dates with the same result - the time is appended.

Below is a screenshot of the restriction with the options I've entered and the generated SQL statement:

Below is screenshot showing one date_time field and converted field as used in the the custom SQL option. At the bottom of the screenshot, is an example of the desired SQL statement/results:

Thanks!

Edit for clarity: The custom SQL conversion is how the product handles this internally, which is painfully slow. In the final report, I'll most likely use no custom SQL and yyyyMMdd custom format for quicker execution and to be syntactically correct.

After added one or more dashboard, I can't edit anymore.
Why?

For MSSQL, tables with reserved words (ie column called 'Order') will throw an error on the generated SQL. It would be useful if the native database delimiters could be used on columns (ie for MSQL square brackets).

Workaround is to set the Custom SQL value to [Order](in this example) to get a correct SQL query syntax.