I have some background in writing reports for Win32 programs using VS 2008. I now have to write a report (which will actually be a billing statement) in ASP.Net. The data for the report will be on an MSSQL server either 2005 or 2010. My question is what is the best way to access that data. I assume there are different methods for doing this. My experience is pretty much confined to ADO net, but I am open to anything that may be better
I'm working on a site that ws developed using VS 2005 and the server where the site is running has Crystal Reports for .net 2.0 (ver 10.2.36)I will be making changes. I just ported the website to my local computer, and build the site using VS 2008, that comes with Crystal R. Basic.I haven't tested all the functionality of the site, so I'm not sure since all the pages that use C. Reports work ok.My main concern is about publishing the site I compiled to the server. Will things work, if I have Crystal R. Basic and the server has Crystal R. for .net 2.0.
Runtime Error Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine. Details: To enable the details of this specific error message to be viewable on remote machines, please create a tag within a "web.config" configuration file located in the root directory of the current web application. This tag should then have its "mode" attribute set to "Off". Notes: The current error page you are seeing can be replaced by a custom error page by modifying the "defaultRedirect" attribute of the application's configuration tag to point to a custom error page URL. ----------------------------------- This error will be display when I am try to show the Crystal Report. Can anybody tell me what Property I have to ser in Windows Server 2008 R2 or in IIS7???
I'm struggling with this problem about 2 weeks and still cannot find the resolution.I was developed a .Net application with visual studio 2008 and using crystal report to generate report.It is working fine in my local machine. However, after I deployed the application to web server with microsoft server 2003 64bits server. The report cannot open and I get this error The type initialize or 'crystaldecisions.crystalreports.engine.reportdocument' threw an exception. I try to install the redistribution package from C:Program FilesMicrosoft SDKsWindowsv6.0ABootstrapperPackagesCrystalReports10_5 but it doesn't work.
When i run the application locally it works fine but when i publish it n access from it it gives the error asEither the Crystal Reports registry key permissions are insufficient or the Crystal Reports runtime is not installed correctly.
I ran the redistributional CRRedist2008_x86.msi on my web server, but when I try to browse my page it can't find the Crystal Reports assemblies: Could not load file or assembly 'CrystalDecisions.CrystalReports.Engine, Version=10.5.3700.0, Culture=neutral, PublicKeyToken=692fbea5521e1304'
I am writing a ASP.NET 4 web application running on Windows 7 Professional 64-bit and attempting to view a Crystal Reports 2008 report in the web viewer. After battling through issues with: Enabling 32-bit apps on the app pool Switching the pipeline mode of the crystalreportviewers12 folder to Classic, and Ensuring that the appropriate users have NTFS access to the windows emp folder I've finally gotten the viewer to load in the web page. However, despite the fact that the report I'm testing is tre simple, with no parameters, absolutely nothing is being displayed. This is also despite the fact that my SQL profiler shows that the correct query is being run on the database to return the data that should be showing in the report.
Thus, I am forced to ask the questions: Does Crystal Reports 2008 work on ASP.NET 4, and if so, Is there something extra I need to do to get it to work?
I have a crystal report viewer on .aspx page. When the report is loaded, the report shows but toolbar not displaying, no buttons, borders or scrollbars.But with reports which open in new blank,everything's fine..the toolbar, buttons, borders and scrollbars all show perfectly.
I have 2 parameters 1. InvoiceNum: this is array of InvoiceNumbers and 2. CompanyNickName. A single string value Now when I am passing these parameters to report only 1st record is getting displayed and not others. Ideally no. of records should be equal to no. of InvoiceNums e.g. if there are 3 invoice no. it shoudl display all 3 invoices. here is relevant code
private void SetCurrentValuesforParameterField( ArrayList InvoiceNumList) ParameterFields param = new ParameterFields(); ParameterValues vals = new ParameterValues(); ParameterField parameterfield = new ParameterField(); foreach (object submittedValue in InvoiceNumList) ParameterDiscreteValue InvoiceDiscreteVal = new ParameterDiscreteValue(); ParameterValueKind.StringParameter; //ParameterField parameterfield1 = param[1]; parameterfield =new ParameterField(); ParameterValueKind.StringParameter; ParameterDiscreteValue InvoiceDiscreteVal1 = new ParameterDiscreteValue(); new ParameterValues(); // CrystalReportViewer1.ParameterFieldInfo = param; } vals.Add(InvoiceDiscreteVal1); parameterfield.CurrentValues = vals; param.Add(parameterfield); InvoiceDiscreteVal1.Value = CompanyNickName; vals = parameterfield.Name = Parameter_Field_Name1;// 2nd Parameter CompanyNickName parameterfield.ParameterValueType = parameterfield.CurrentValues = vals; param.Add(parameterfield); }// End of Loop InvoiceDiscreteVal.Value = submittedValue.ToString(); vals.Add(InvoiceDiscreteVal); parameterfield.Name = Parameter_Field_Name; //1st Paramt name InvoiceNum parameterfield.ParameterValueType = ParameterDiscreteValue InvoiceDiscreteVal1 new ParameterDiscreteValue(); new ParameterValues(); // CrystalReportViewer1.ParameterFieldInfo = param; } vals.Add(InvoiceDiscreteVal1); parameterfield.CurrentValues = vals; param.Add(parameterfield); InvoiceDiscreteVal1.Value = CompanyNickName; vals = new ParameterValues(); // CrystalReportViewer1.ParameterFieldInfo = param; } vals.Add(InvoiceDiscreteVal1); parameterfield.CurrentValues = vals; param.Add(parameterfield);
I'm passing some parameters to a CR report programatically and it was working fine, but now that I have added a new date parameter to the report, for some reason, it is prompting me to enter that parameter on screen (the user isn't allowed to set that parameter is the system who must set it.), I haven't changed a thing other than adding the new date parameter, and all the other parameters behave normal, just the date parameter is prompted even thought I've already set a value for the parameter.
Just for the sake of things: I have checked that the parameter is indeed a date and that it is well formed. CR prompts me to enter it in the format (mm/dd/yyyy hh:mm:ss) so I pass date in that exact format (In fact I've even tried hard coding a well-formed date and it still prompts me to enter the date).
I have store procedure: ALTER PROCEDURE dbo.GetAllInfoFromUsers(@name varchar(50)) AS select id, userName,password, role from tbl_users where userName=@name
i have asp.net 2008, we add new crystal report in application,but only .rpt file is exist but not getting its class file(.vb),because i need to get object(instance )of reports class file .vb file is needed, so what could be the problem with setup or steps to genrate report class file.
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.
We have quite a few reports which were developed earlier in Crystal Reports 8.5. We are now planning to use these reports in our web application developed in VS 2008 (C#).
What dlls are needed for calling 8.5 in the application and how should they be added to the application while shipping it to the client?
They are also struggling to get the code running. Would also need the code to call the report with parameters.
I have a web application that has a report. I export this report as PDF and send it to the client. On this report I have a field that has a font set to a non-standard windows font (i.e. a barcode font). The barcode font is a TTF font. On my dev machine, I installed the font, printed the report, barcode was displayed.
On the server, I have installed the font, but when printing it, it seems to have reverted back to the Arial font. This is using the version of Crystal supplied with VS2008. I have un-installed and re-installed the font.
Im working on Visual Studio 2008 to develop a web application in asp.net. if I add a crystal report file (.rpt) in my project, I see only hexadecimal code.
I am working on a project and I am creating crystal reports.I have to print the reports.When I press the print icon on the report , 1 pop opens and it asks me to choose all pages or select page range when I press on "Ok" on this page it then opens the repost in pdf file and then I click on print button on pdf and then print comes.I want that when User click on report then without any further popup the Print should come and if it is not possible then after 1st popup print shud come. I dont want that User shud see the pdf file..and I have not written any code for printing..
I'm new to Crystal Reports and am just trying to add some simple reports to my web application. In the non-report pages I've been using SqlDataSources to retrieve data from the database and would like to do the same for the report pages. I saw a tutorial that indicated I could do this by explicitly setting the data source for the report in the Page_Load callback of the ASPX page as shown below:
[code]...
Is there a way to create "bound" fields w/o a database, since I'll be specify the database at runtime? Or is there a way to create the ".rpt" file w/ unbound fields, that get "bound" at runtime?Or is there a better way to do this altogether?
I have already generated crystal reports but i've made them static. but now i want to make the user to select the criteria for generating the reports. for eg., in one of them i want to show monthwise data so user should be able to select the month and year and that would be passed as parameter and compared to the existing data. provide me with proper exact code that can be used for giving parameters in such a report using C#.
how can i get and set crystal report formula fields from c# code behind, i use this code, double sum=reportdocument.datadefinision.formulafields[1].text but it get formula text not value
In my system Visual studio 2008 with sp1 and Crystal Reports XI Release 2.In Visaul studio 2008 ,while adding add reference it showing crystal reports version 10 instead of 11.How to solve the version problem.
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?
I have a field in my dataset with type nvarchar(1000). when I link it to crystal reports, it converts it to a field of type string with length set to 100. As a result of that, the string in that field is being truncated on the report. How can I increase the string length to 1000? (I already checked the "Can grow" option).