I have to create reports in a web application.I have no prior experience in working with reports in asp.net.
is it necessaey that we must use only crystal reports ,if so is it like there is any licensing for it?I have no idea about this.
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
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?
View 2 RepliesI 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?
View 2 RepliesWe 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)}
e.g
Server name
Database name
user
password
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.
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.
View 4 RepliesI develop web pages in Visual Studio 2005 in Visual Basic. I want to create reports in MS Word (text and several Tables also). How can do it.
View 1 RepliesHow to create graphs using crystal reportin ASP.NET C# ??
View 1 RepliesTrying 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>
The application basically displays a list of reports and allows the user to select a particular report to run. Once the report is selected, the appropriate parameter screen is displayed. The parameter screen contains options for displaying the report either as an Excel Spreadsheet or a PDF document.
When I run the application from within visual studio, it works fine. The reports display correctly in both formats.
THe problem is that once I publish the application (via msi installation file) to a Windows 2003 web server, the reports won't display. THe system just hangs. I added debug statements and the code is hanging during the ReportDocument.Load(Server.MapPath("/assetreport.rpt") command.
My deployment project includes the correct msm for Crystal Report 12 and the Web server also has the full blown version of Crystal Reports 12 installed.
Is there a way to dynamically create a report?I have the following tables:
[Code]....
Obviously, this is quite straight forward if I could restrict the limit of the sizes, but they want the flexibility to add sizes, particularly with footwear or if they should need to add women's dress sizes.So the problem is that I'm generating dynamic table columns (the number unknown) during run-time.
I am trying to create a report using crystal report 11 and asp.net 2.0(C#) and Oracle10g. My requirement is to create a report which contains 6 pages with each pages different and is connected to different datasource. I pass three parameter (1)USER_ID, (II)YEAR and (III)TYPE. Based on these parament i'd like to construct a report with different layout on different pages with different datasource. Can i do it in single .rpt file or do i need to nested with sub reports. I am trying to create 6 subreports with their own datasource and put it in one parent report to display data, but not able to do it.
View 2 RepliesI want to create header for reports(.rdls).Now i am designing reports ,all reports have same header ...so i want to create fixed header file for all of my reports.
View 1 RepliesI have written an article about How to create a Crystal Reports invoice and export it as PDF
View 1 RepliesI want to know that is it possible to create crystal report without database as datasource?
because i am having database but the data that i want to show in report is not a direct values from database...
Actually i am having one attendance table now i want to show the total no of rows(attendance table has 50 rows then report should display just "50" instead of displaying each rows) in the report...how can i show that?
attendance table(sub_code,status,roll_no,date)
subjects(sub_code_sub_name)
my report format is like :(sub_name,total lectures,present lectures)
for example:-report should look like....
(sub_name,total lectures,present lectures)-This total lectures can be counted using attendance table but how can i diplay in report thats what i want to know?
Sub-1 | 20 | 15
Sub-2 | 45 | 4
Sub-2 | 33 | 3
My goal is to create some Excel reports that users can download from my asp.net site. The data for the reports will come from an SQL database. I am using Visual Studio 2010 and the reports will be for Excel 2007.
View 2 Replieshow to create a report in C# Form and able to save the report to pdf file or word ?
View 1 RepliesI am getting error as below
Could not load file or assembly 'CrystalDecisions.CrystalReports.Engine,
Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304'
or one of its dependencies. The system cannot find the file specified
I have a VB.Net application which generates quite a few Crystal Reports. One report in particular has a Group Section. What I am trying to do with my VB.Net app is pass a value (a sql server column name used in the report). This value is represented by radio buttons. For example, the user may check either "ZipCode" or "State" or "Category" or "Type" or "Vendor". Each of these options represent a column in the database table used in the report. I simply want to be able to write the "SelectionFormula" using one of these options but not sure how to go about it.
View 1 RepliesI am building an stock exchange sort of application. I would like to know Is it possible to create graphs using crystal reports or is there any other technology in .NET for building a graph which we usually see in stock exchange application.
View 1 RepliesI have an SQL Server database.I am using Microsoft Visual Web Developer 2008 Express to develop my application. What I seem to be lacking is the ability to create reports. Is there any report generation software that will work with 2008 Express?
View 9 RepliesI was told to build a rest web service using asp.net so does the code below represent the same
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Services;
[Code] ......
I have to implement broker and dealer socket connection like in share market i.e. it should connect at 9 AM and stop at 3.30 PM and repeat in next morning ...
so following is my requirement
1) i have to create application object once in day at 9 AM and destroyed at particular end day 3.30 PM.
My question is how to destroyed application object at given particular time ... i think this can be done in application_end handler in global.asax ... but my question is when no request is made at that time then what happened..