I have no problems viewing data on local machine but for some reason I cannot view that same report on the web. When i view source of the web page I can see data inside the javascript but the page is blank. What could I be doing wrong?
View 2 RepliesI am building Reports which have twp parts-1.)Normal Report2.) Detail reportThe user is shown the NORMAL REPORT first. If user wants to see the details of that reporthe clicks that part(row) of "Normal Report" of which h/she want to see the details.The Detail report is shown after that.
View 1 RepliesI have a Registration form with two Buttons "Save" & "Report". When I click on "Save" the data will store in the Database. Now I want when click on the "Report" button the report of that particular will be produce in the Crystal report. How can I do that??
View 2 Replies[URL] ....
I followed above link to create sample Crystal Report Project. Here is my code:
string conStr = ConfigurationManager.ConnectionStrings["MasterDb"].ConnectionString.ToString();
protected void Page_Load(object sender, EventArgs e) {
ReportDocument crystalReport = new ReportDocument();
crystalReport.Load(Server.MapPath("~/CrystalReport1.rpt"));
DataSet1 ds = GetData();
crystalReport.SetDataSource(ds);
[Code] ...
When I run my project, blank page renders. No Crystal report is displayed.
I am developing we application using Csharp on Visual studio 2008.How can I pass values from Page or GridView to a Crystal Report? For example I want some details on a Default.aspx want to appear on the Crystal report when I click on it. How do I pass theses values from Page to crystal report at Runtime?
View 3 RepliesI am working with Parametrized Crystal Reports. There are only two page called Source.aspx and Target.aspx.
[code]...
Only One text box data shows Not 2nd One.Can any one help me with this by checking my code?
I create an ASP.NET Crystal Report Web application using VS.NET 2010. In ASP.NET page, I stored two values in Session state and need to pass them as input parameters to Oracle stored procedure. In Crystal reports 2010 once you connect to a stored-procedure as data source, it automatically creates the parameter fields with Crytal Report Viewer. how I pass values to store procedure at runtime automatically.
Detail code:
1. ASP.NET page store the values in the Session:
Sesion.Item("CourseNumber")
Sesion.Item("StudentNumber")
2. I like to pass above values to the store procedure with IN parameters named P_CourseNo and P_StudentNo to print out the Crytal Report with Store Procedure as data source.
using crystal report in VS 2005 C#. I want to print multiple copies(3) of a same report in a single page. Is is possible.
View 1 RepliesI have a simple crystal report created on VS 2008 .net 3.5 sp1. The report works when I run it from the local host connecting directly to the live hosted database. When I copy the files to the host server it connects with out error but at the point where the report viewer frame would appear I get a blank page and Done displayed on the browser status bar.
The host server has Crw server installed on it and other websites on the same server are working OK.
I am using Crystal Report 2010 with C#, have a web form and want to display Page N of M to user in a Label while printing crystal repots. How can I implement this?
View 2 RepliesI'm having a lot of trouble with this, and all the examples that I've found online tell me different things, so II added a DataSet to my project and added my database table to it. (DataSet should be ready)I added a CrystalReport to my project and in the Details section, I right clicked and chose "Database Expert" under "Database". I expanded "Project Data" and found my DataSet...I selected my table and added it to the "Selected Tables" list.In the CrystalReport designer, I used the "Field Explorer" to add 5 of my database fields (just for testing purposes). The report added their names to the "Page Header" and the fields to the "Details" section.On some button click, I use the following code to show the report:
[Code]....
where "conn" is my global SqlConnection.where "CrystalReportViewer1" is obviously the viewer I have put in my aspx page.where "DataSet1" is the DataSet I created and holds my table.where "CrystalReport.rpt" is obviously the report I created.and I used the following code to make sure that myDS actually was loaded with the data:
[Code]....
So the DataSet is definitely loaded with data, the CrystalReport is found (because before I was having trouble with loading into oRpt), and no exception is being thrown because the "Catch" section is never reached.I'm sure it's something dumb I'm doing, but does anyone have any suggestions? I know if I can figure this little problem out, I can expand it to the more complex things I want it to do. But currently, I can't get anything to show,
a myth has been passed to me by a senior who told me to 'always' design a crystal report using Add command and not through the table view (like selecting tables and linking them manually).I have been having a hard time writing the queries for master detail reports and making sub report links manually. It gets pretty confusing sometimes.I find it easy to design reports by just selecting two tables and dragging and dropping the link in crystal report designer.
View 1 RepliesI used push method with my crystal report. I used a dataset which on page load loads 2 seperate datatables and are added to it. Everything works fine. But if the Milestones Datatable is empty, the crystal report shows none of the data related to the Projects Datatable, as if the table is empty. The Select Method of the business logic layer objects uses querystrings of the name ProjectNo. Below is a sample code.
[Code]....
my question how to create crystal report without database, in this case i want to create the crystal report using txt file data. is ther any way?plz tell me? how is it possible?
View 1 Repliesis there a way in crystal report to remove blank space between two data field for example
Field 1 Field 2
how do i make it the distance between Field 1 and Field 2 become closer and look like this
Field 1 Field 2
without changing the position of the Field 2 in the report design... i need this cause the data in Field 1 is different for each user and i need the Field 2 to have a smaller font size than the Field 2 so i cant use formula since formula only allow 1 font size.
i need step by step procedure to prepare crystal report through Data set
View 5 RepliesMy report does not use data from a database. It uses a code generated dataset. How do I give crystal reports the necessary logon data to avoid database logon failures.
View 1 RepliesI am new to asp. I need to generate a report of a registration form in a new page. how to create a report in a blank page and download that page as a word or pdf document..
View 1 RepliesI have problem when i create a crystal report. follow the requirement from customer, i need to show a report that list all data of 3 tables that it does not have any relationship between them in only one Report. It will show:
Table A:
-- column A.1 | col A.2 | col A.3
Table B:
-- col B.1 | col B.2 | col B.3 | col B.4
Table C:
-- col C.1 | col C.2
So, how do i need to do to show the report same as above?
i cant access crysrtal report after deployment in IIS i have depolyed my website the pages where my crystal report is just blank .. how can i access crystal reports????
View 1 Repliesusing vb.net 2005 and crystal reports. in the vb.net code I am querying the database, processing the results and then binding to the crystal report.
What I need to do now in the code is this: I need to create a new page to display the results so that there is one page for each row in the dataset that I'm binding to the report.
I'm getting the "Load Report Failed" Error.
I have a web application designed using VS2008 & Crystal Reports for VS2008 (Ver. 10.5.3700). I'm using Framework 2.0 for deployment.
My development system is WinXp and my deployment system is Win2003 Server.
Here is what i have done -
1) Added a Crystal Report to my project "rptReport.rpt"
2) Added a Crystal Report Source (crSource) to my .aspx page.
3) Added Crystal Report Viewer to my page, with crSource as its Report Source.
This works fine when i run it on my development machine. But Gives a "Load Report Failed" error on my deployment machine.
This is what i have already tried doing on deployment server:
1) Giving IIS_WPG full control to temp folder.
2) Publishing with "Allow this precompiled site to be updatable." checked/unchecked.
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???
View 1 Replies<connectionStrings>
<add name="SchoolEntities" connectionString="metadata=res://*/SchoolModel.csdl|res://*/SchoolModel.ssdl|res://*/SchoolModel.msl;provider=System.Data.SqlClient;provider connection string="Data Source=.;Initial Catalog=school;User
ID=sa;MultipleActiveResultSets=True"" providerName="System.Data.EntityClient"/>
</connectionStrings>
how report read this connection string
using vs.net 2005, sql server 2005, creating windows form appI have a dataset that I bound to a crystal report as follows:
[Code]....
and in the Crystal Report in design view I added a Text Object called "myTxtObj".I am assuming that I can do something like this
[Code]....
However I'm not seeing the "myTextObj" with intellisense in the code behind in the form.so my question is: after binding a dataset to a report how to you bind column values to text objects on your crystal report?and actually one mor thing:I just ran the project and found out when I try to do the databind that i'm getting an error:"The report has no tables"how to solve this too?