I have a report, which has two sections namely Labour and Spares.In labour section no of records per page must be limited to 5 records and the Spares section have to limit to 10 records per page.If either Labour or Parts exceed the max limit the records must be shown in the next page. Limiting one section by using formulas can be done easily ...but it is very difficult control two sections simultaneously.
View 4 Repliesis there is any methos so that only the some data rows displayed in detaisview.and rest of the data row item will appear by clicking more button or link.
View 1 Repliesi've connected my crystal report to my database using database experts. now my problem is i want to display the total no of records..in each page .. i.e in database there are 50 records when i execute..it takes two page to print..now in first page there are 30 records and in second page there are 20..i want to display the value 30 at the end of page and 20 at the end of page.i.e how much the page contains the records that much it should print in page footer
View 3 RepliesActually I am developing one web application,in that application I used a gridview to display all the database records in a page. I provide hyperlink print for every row, if I click the print option, the particular record will be print in the crystal report..
View 1 RepliesI am using this code to search records from ... when I goto this page i am getting this error ...
The maximum report processing jobs limit configured by your system administrator has been reached
I couldn't find this ...
path HKEY_LOCAL_MACHINESOFTWARECRYSTAL DECISIONS10.0REPORT APPLICATION SERVERSERVERPrintJobLimit to make it -1 for unlimited print job
protected void Button2_Click(object sender, EventArgs e) {
if (TextBox2.Text == "" && TextBox3.Text == "" && TextBox4.Text == "") {
DateTime date = Convert.ToDateTime(TextBox1.Text);
SqlCommand cmd = new SqlCommand("SELECT * FROM Transactions where report_type = @report_type and dateadd(dd, datediff(dd,0, [R_date]), 0) = @R_date ");
[Code] ....
We use crystal report in our website. But we are facing a problem
"The maximum report processing jobs limit configured by your system administrator has been reached".
I can't remove temporary files from web server through
CrystalReportViewer1.Dispose();
CrystalReportViewer1 = null;
Im new in using crystal report. When I view the report, the records appear with many spaces in between of each record. How can I set then to just only one spacing after each record?
View 1 RepliesWhen 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.
View 2 Repliesi want to roundup the total salary amount of employee..e.g if employee salary is 1234.56 then it should be 1235and if 1234.34 then 1233value should be incremented when the right hand value i.e after decimal value is 50 and it should be decremented when it less then 50
View 6 Repliesim using sap crystal report version 13.0.2000.0. i've 27,000 records to be printed but when i run my application the exception error is displayed "Out Of Memory".. i've my appliation in VS2010 and OS is server 64bit and 4GB RAM..
View 1 RepliesI am trying to find a way that would allow me to display the parameters that have been selected when there are no records found
For instance.
Pulling from a database with a employee table that contains name, address, city, state, zip, job titile and shift.
i then have two list boxes set up that collect the paramets for the reports. One for the job title and one for the shift.
i want to be able to say that no records are found for "managers" on "third shift" where managers and third shift are the parameters from the listboxes.
consider the example where there is a report which displays all products or a single product from a table through a drop down list selection. The dropdown list also has a '- ALL -' selection item So the resulting query might be
Select * from products OR
Select * from products where ID={id}
Now I have a single report , I am using sql CASE for differentiating between all products or a single product. Another approach is to pass a different value with where clause in report parameters like
[Code]....
What I like to know is what is the best approach? Is doing this inside query is best or specifying the where clause in the report parameters is right? I personally feel much safe with the SQL query CASE.
How to change float number such as 0.12 to 12% in CR? I knew how to % but only display 0.12%
View 2 Repliesi have a problem in formating a number that shows inside a legend i want to show in a custmized format but it is shows like that
here's my chart,, i want to format number from 2,010.00 to 2010 only and same for 2,009.00 because this numbers are representing years
how to count total no of record in different group section in seagate crystal report
View 2 RepliesI want to print number in the (national) form (arabic localization sys)
I tried some solutions as here: [URL] ....
But still face problems with the stringthat contain digits ....
I have requirement that have to add header and footer into 50 over reports. So I dont want to change one by one.
Is there a way to create master page header and footer and used it in multiple reports?
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.
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 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 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#.
View 3 RepliesIn 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.
View 1 Replies