How To Create Pdf Reports From Sql Server In MVC 2 Application
Dec 8, 2010
I want to be able to somehow get reports out of my Sql Server database in an MVC application. I could have developed a way to do that using xml and then transform it to fo and rendered it via an fo processor to pdf. But that would require being able to have the fo processor installed on the web server, and I'm using a web host, so that's probably not going to work.
So I've seen Reporting Services mentioned here and there. Does that include the possibility to create pdfs? And if so, how do you use it in an MVC application? I tried before to mix webforms into MVC application (if that's necessary as I've seen implied) but couldn't make it work. The routing didn't seem to recognize the web form page...
Or is there any other easier way to create pdf reports from Sql Server data? I should also mention that I only use Linq (and the Entity Framework) to access data, so hopefully there is a solution that doesn't require me to know Sql stored procedures etc
i have created several crystal report for my web application, i need to use my application to connect different database on the server which has no problem in the application but when i open the reports created using crystal report, it still connected to the database configured. how can i fix this, is there other way than to use another copy of the application and configure it manually at the each of the reports. i do have pass the logon information to the report using vb.net in which i get the info from the web.config
Dim A As ConnStr = New ConnStr With ConnInfo .ServerName = A.getServerName() .DatabaseName = A.getDBName() .UserID = A.getUser() .Password = A.getPwd() End With
my problem is how to make crystal report to uses all the logon info passed and not use the infor set in the report file
I have an vb 2005 asp application that will show a crystal report based upon a user selection which is a job number.On my development machine all work fine and the report is being shown every time.When I publish the application the web server it works for most part. Every so often for selected job numbers the report that will not display. When this happens there is a text being displayed above the business object banner:The Report Application Server failed I have checked the event log and there is no entries. Also there is no stack trace. The application seems to complete normally. I have compared the registry entries in HKEY_LOCAL_MACHINESOFTWARECrystal Decisions and they are the same id evelopment and production. I am referencingCrystalDecisions.CrystalReports.Engine version11.5.3700.0I am clueless and hoping that someone could suggest where to start looking
Iam working on a banking web application developed in asp.net 3.5 and MS SQL Server 2008.My problem is to create reports including some pre-formatted reports,summary reports and some detail reports.I want to know what is the best technique to create these reports.I don't want to use third party reporting tools as they have to be configured on the web server and some times they takes lot of time in generating reports due to their complex structure.Since its a web application having large recordsets so i need a consistent solution keeping in mind the performance and complex nature of the reports which might be demanded by the banks.Can anyone help me please in this regard?
I have master page, menu on master page, i use asp roles and trim menu item based on user roles and rights this process is working fine.
Now i have to create some reports based on user roles, and responsibility in a company like country head will view country wide reports, manager region will only view regional report and rest will view reports related to them.
How can i achieve this efficiently using asp roles.
I have got two sets of users. One set can view all information of branches from 1to 5 and the other group can view all the information of branches from 6 to 10. How do I create reports using views for these two sets of users?
We have just migrated our Application's reports from Crystal Report 10 To 12. But on conversion everything goes fine.Except the reports which are built on Typed data sets started genrating the Message "The report you requested requires further information". with the login parameters dispalying on the page.{Note: we are using Visual Studio 2005 (framework2.0)}
I'm new to Visual Studio.NET . I need to integrate the crystal reports into an ASP.NET application. I generated Crystal report with the help of crystal report XI developer edition(Stand alone version and NOT from the one which comes from visual studio).
How to integrate this report with the web application.
to print a crystal report from the server's printer with a button on the web application.Assume that I have a ASP .NET Web Application, When i press the "print" button on the web application, the server which holds the web application prints the specific crystal report with specific data set. Is this possible? How I am going to make this happened?I am sorry to say that I'm very new to all these web programming,
I created the web application using asp.net 2.0, c# and sql server 2005sometimes i am getting the following error,Message: Unable to validate data.Source: System.Web
I want to create a server because I have a fair internet speed and fair computer on the house not being used. The structure is good.The issue is, I don't know how to create the server, if I have to use Microsoft Server or if I can use an XP system.What programs do I need to install?And, furthermore, I need to know how to do everything.
I have worked on a timesheet application application in MVC 2 for internal use in our company. Now other small companies have showed interest in the application. I hadn't considered this use of the application, but it got me interested in what it might imply.
I believe I could make it work for several clients by modifying the database (Sql Server accessed by Entity Framework model). But I have read some people advocating multiple databases (one for each client).
Intuitively, this feels like a good idea, since I wouldn't risk having the data of various clients mixed up in the same database (which shouldn't happen of course, but what if it did...). But how would a multiple database solution be implemented specifically?
I.e. with a single database I could just have a client register and all the data needed would be added by the application the same way it is now when there's just one client (my own company).
But with a multiple database solution, how would I create a new database programmatically when a user registers? I have done all database stuff using Linq to Sql, and I am not very familiar with regular SQL programming...
how this could be done (as well as input on whether it is a good idea or if a single database would be better for some reason).
EDIT:
I have also seen discussions about the single database alternative, suggesting that you would then add ClientId to each table... But wouldn't that be hard to maintain in the code? I would have to add "where" conditions to a lot of linq queries I assume... And I assume having a ClientId on each table would mean that each table would have need to have a many to one relationship to the Client table? Wouldn't that be a very complex database structure? As it is right now (without the Client table) I have the following tables (1 -> * designates one to many relationship):
Also, Customer has a one to many relationship directly with TimeSegment, for convenience to simplify some queries.
This has worked very well so far. Wouldn't it be possible to simply have a Client table (or UserCompany or whatever one might call it) with a one to many relationship with Customer table? Wouldn't the data integrity be sufficient for the other tables since the rest is handled by the relationships?
In your opinion, what's the best way to create the server side to a pure Javascript application with ASP.NET? WCF rendering JSON? IHttpHandler? Update Like GMail, that runs in the browser (with a lot of Javascript) and submit and receive data with Ajax, for example.
I have created a virtual directory in IIS(7.0) to create web application using visual studio 2010 ultimate edition. But when i open the Browse option in visual studio to create http hosted website , it vs2010 keeps on teling me that i need to have IIS Component installed. below is the eror message;
To access local IIS websites, you must install the follwoing IIS components
You must run Visual studio in the context of an administrator account. For more information, press F1
NB:i have installed the IIS 7.0 and its running fine
I'm getting so frustrated with not being able to find the answers to my extremely simple (or so it seems) questions.I'm using Visual Studio 2008,and I am trying to use a non-local database as my data source.This must be possible to do somehow,but I can't figure out how.It wants to be able to connect to a database,and it's not going to be able to.
with a workaround?Would it be easier to just make an asp.net page with a gridview than trying to make an actual crystal report?
I am considering using Crystal Report 2008 as my tool of creating reports on my webpage.The only problem which I'm facing is that I have no control of the remote server which hosts my site (besides uploading files). I can't run a MSI to deploy the CR runfiles.I can't find anywhere in the CR user manual of how to deploy the runtime files without running the msi, and I'm not even sure it's possible.Have anyone deployed CR 2008 without running the MSI and without having to register any files?
How can i implement crystal reports in asp.net MVC. i dont want to use webforms and then use it in MVC . i want to use in same MVC application to create crystal report.
To be able to implement paging i need to create a helper class (as mentioned on one example in the net ); so i have created a class that encapsulate the paging logic
public class PagingList<T> : List<T> . ..
but when i reference this class in my view using the code below:-
Models.PagingList<Article>
The following error occurred. Server Error in '/' Application. Compilation Error Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately. Compiler Error Message: CS0246: The type or namespace name 'Article' could not be found (are you missing a using directive or an assembly reference?) Source Error:
[Code]....
Source File: c:UsersMohannadAppDataLocalTempTemporary ASP.NET Files oot1f3f505f568b8e69App_Web_index.aspx.82d38c66.ffjpt45i.0.cs Line: 172 Show Detailed Compiler Output:
I have developed few crystal reports using VS.2005 and now i want to deploy the same on my web server which is running Windows 2003 server and got installed only .net frame work 2.0.... so now i want to know how can i run those reports successfully and i have downloaded CRRedist2005_X86.msi and even crXIsp3 and 4 _net_server from business objects page and i do have Crystal Reports XI original CD.... while by using them can i run crystal reports on my web pages.
Trying to preview a crystal report in pdf format in web application by passing parameter but showing error message: crReportDocument.Export() missing parameter value
<CODE> Dim crExportOptions As ExportOptions Dim crDiskFileDestinationOptions As DiskFileDestinationOptions Dim Fname As String crReportDocument.Load(Session("rptFileName")) CrystalReportViewer1.ReportSource = crReportDocument CrystalReportViewer1.RefreshReport() CrystalReportViewer1.ParameterFieldInfo.Clear() Fname = "C:TempTemp.pdf" crDiskFileDestinationOptions = New DiskFileDestinationOptions() crDiskFileDestinationOptions.DiskFileName = Fname crExportOptions = crReportDocument.ExportOptions With crExportOptions .DestinationOptions = crDiskFileDestinationOptions .ExportDestinationType = ExportDestinationType.DiskFile .ExportFormatType = ExportFormatType.PortableDocFormat End With If Session("rptType") = "PrintOption0" Then ' Without Parameter ' no need to do anything ElseIf Session("rptType") = "PrintOption1" Then ' One Parameter paramField.Name = "@UserID" paramDiscreteValue1.Value = Session("rptParameter1") paramField.CurrentValues.Add(paramDiscreteValue1) paramFields.Add(paramField) CrystalReportViewer1.ParameterFieldInfo = paramFields End If crReportDocument.Export() Response.ClearContent() Response.ClearHeaders() Response.ContentType = "application/pdf" Response.WriteFile(Fname) Response.Flush() Response.Close() ' delete the exported file from disk System.IO.File.Delete(Fname) </CODE>
