I have the following tables:ACTNUM in ACT1 and ACT2 is linked to ACTNUM in ACT0. I am using ACT0.ACTNUM for grouping (I want to display all MEMOTEXT and all Desc for each ACTNUM). the poblem is that I am getting duplicate values in the details section although the dataset is being filled without those duplicate values.
View 1 RepliesI have an issue while working with a Crystal Report 10.0 I am printing a Students records in a pre-define format. now the detail section is dymaically change beacuse of No. of records for the studentsfor some students there are 8 record ,& for some other students only 2 records are theirbecause i am printing on pre defined format when 2 records comes in the details section it is placing the reords at wrong places
View 1 RepliesI 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.
http://www.dotnethell.it/users/files/1303_crys.zip
this is an image of structure of my crystal report and the result of it as you can see, there are no space between the label "auditor" and the beginning of section2, but then i run it, crystal insert some blank rows in it how can i do to delete this space?
Actually i am creating 1 sofware in which i need to print bill. On that bill my page header (company's name) is constant & on Report footer (companys rule & some more data) is also constant. & my Detail section is varying. On bill if data is short, my footer goes upside.
I need to fixed my detail section so that position of detail section will be maintained.
or
I need to fixed my footer section so that position of footer section will be maintained.
now which is the solution form above 2? . and how to implement?
I want to pass a string to textbox at report header section. how to do this? Devlopment plateform is C# ASP .net. (VS2005)...
View 3 RepliesI just started playing around with crystal reports. I created a report crystareport1.rpt and from the data base fields section I dragged and dropped empid, empname into details section. I want the report to show
empid empname
1 a
2 b
3 c
Like this . But now it is displaying
empid empname
1 a
empid empname
2 b
empid empname
3 c
Like this how can i get the desired out? One more thing on the button click I wrote
Response.Redirect("~/CrystalReport1.rpt");
But I am unable to open the report what should I do to see the report?
how to count total no of record in different group section in seagate crystal report
View 2 RepliesI have a weird problem that I am struggling with. We have a legacy project (VS 2003), and all I have to do is change a Crystal Reports label, when I change it and save it creates an additional code behind file. So after saving I have the file rptInvoice.rpt with two dependant files rptInvoice.vb and rptInvoice1.vb. I have no idea why it is creating an additional file but it is causing a compiler error.
View 1 RepliesI 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 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 making a crystal report which displays values from database. Now the values from db contains duplicate values. I need that duplicate values should be suppressed and should display 0.00
Value
250.00
250.00
250.00
Should display
250.00
0.00
0.00
I have applied "Suppress Duplicate" to the column but don't know how to display 0.00 there.
i can develop crystal report with password itself.But, i want to pass values in to crystal report programatically..
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 wanted to post my problem and solution since I've gotten some good information on this board. When deploying my Visual Studio 2008 C# .NET 2.0 web application Production, I encountered some problems, which is not unusual. What was unusual is that my Crystal Reports .NET reports that use the Report Viewer control would not work; they errored out with:
note: Crystal Report works fine in dev environment....
Logon failed. Details: ADO Error Code: 0x Source: ADODB.Connection Description: Provider cannot be found. It may not be properly installed. Unable to connect: incorrect log on parameters.We are using Oracle 11g 64 bit as database. We establish crystal report database connection by two ways,
1. Microsoft OLE DB Provider for Oracle
2. Microsoft OLE DB Provider for ODBC
but we got the same error in report module when we using two methods.
Our Coding : //CrystalDecisions.CrystalReports.Engine.ReportDocument crpt = new ReportDocument();
private ReportDocument crpt = null;
private void Page_Init(object sender, EventArgs e) [code]....
am generating crystal report and in this am using product name and its price, i want to display the total price of the product in footer section ,
View 1 RepliesI have a query that returns a field called Type. Possible values for Type are A, B, C, or Unknown. I want to create a table that will show the number of rows of each Type but not the not the Unknown type. Also I like the table to show the percentage of known types versus total types. So the table show look like this:
Type Count
A number of rows with A Type
B number of rows with B Type
C number of rows with C Type
Total: (number of rows with A, B, or C Types / number of all rows with A, B, C, or Unknown Types)Please someone tell me how to do this in Visual Studio 2005 reports.
I have distinct value combinations of two values.i cannot achive in sql why beacause ,here crystal report having grouping options and output will going to print in a foote..
Sample format crystale report
SNo Name TranID
1 Guru 18
2 Inbaa 19
3 Guru 20
4 Inbaa 19
------------------------------------
Total Name : 3 Tran ID :3
------------------------------------
Name inbaa with Tran ID 19 is duplicate ..
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 tried using this and am concatenating the fields together. It does not appear to be working. Here's what I have.
View 7 Repliesi want to show a crystel report on page load of page. where i want to show report of those student who logged in the system and their session is created.
View 1 Repliesparameter field {?country}: string
allow diffrent values: true
selection record: table.country in {?country}
when i pass one parametrs it's works fine.
rd.SetParameterValue("country", DropDownListSalle.SelectedItem.Text);
my question is how can i passing multiples values (tokyo,usa,india,...) ?
I have database with 5 tables as follows in my crystal report I am trying to display the patient details of only one patient (whose pid is requested by the user) and display the tests information of that patient.I have created a dataset and have the following code in codebehind of crystalreportviewer
[Code]....
I also have a stored procedure to check the whether the pid entered is same as the pid in the test reports tablessomewhat like follows
[Code]....
but still It is not displaying anything in the crystalreport.
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 Replies