I have create crystal report with select * from table name command and designd it but when it is shoiwing i want to show as filterd record that i am using follwing code
OleDbConnection gn = new OleDbConnection(ConfigurationManager.ConnectionStrings["conStr"].ConnectionString.ToString());
protected void Page_Load(object sender, EventArgs e)
{
PrintReport();
}
private void PrintReport()
[Code]....
I 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]....
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.
View 1 Replies am using crystal reports and directly exporting it to pdf. I want to filter records based on record selection formula but below mentioned code is not filtering data for particular employee. All records are coming to pdf. I want only selected records based on selection formula.
ReportDocument report = new ReportDocument();
string ReportPath = Server.MapPath("Reports/PayRollReport.rpt").ToString();
report.Load(ReportPath);
[code]...
I have a crystalreportviewer bound to a dinamically generated DataSet. The Datatable within that dataset has 2 rows of data, however only the first one is showing on my report.
Here's the code that binds my dataset to the report viewer:
[Code]....
I 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.
Main menubar is not showing when I add a crystal report viewer to asp.net page (only for the added page). So I'm unable to nevigate to other pagesI'm using asp.net 4.0 / crystal report for VS 2010
View 1 Repliesone record in each page
View 2 RepliesI display only one record per page in crystal reports??. Im new in using crystal reports, someone show me what to do?.
View 1 RepliesIm new to Crystal reports. I need to make a statement in which three columns are displayed.Debit, Credit and Balance.
something like:
Debit Credit Balance
3605241
51613 3656854
7599 3664453
3398 3661055
I just have top Balance amout in DB which is 3605241. now I have to display the updated balance After debit or credit. I want to get the Previous Balance amount for addition/subtraction.How can I do it using Formula field?
How to print the particular record to the crystal report. I have a gridview control in webform1, in that gridview I have a link button like salary check, the link button passes the particular empid to the next form and display all the records in the webform2, in the webform2 I am having print button, if I click the print button,all the fields in the webform2 wants to print in the crystal report...
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 RepliesCrystal report view tool bar is not showing correctly. Instead of toolbar there is text "Submit Query"
View 2 Repliesere is a record selection where clause in a crystal report.
[Code]....
I'm not sure if the report is selecting the enddate or is selecting everything upto the end date.
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 have data in 2 rows with 1 booking no each rows have different data. But when trying to view crystal reports shows only top row data.. i want 1st row data should come on 1st page and second row data on 2nd page.
View 1 RepliesI 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..
View 4 Repliesshow only 10 Invoice.. after 10th record next 10
View 3 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 trying to generate crystal report based on the two dates selected by the user ... the selection formula editor gives me
the error "a string is required" when I want to save and close my formula , can any1 help me whts wrong with my formula shown below ,
{records.entrance_date} >= {?entrance_date} and {records.entrance_date} <= {?entrance_date2}
both ?entrance_date and ?entrance_date2 are of date data type
how to count total no of record in different group section in seagate crystal report
View 2 Repliesi have maked a form which is saving used detail . how we can print the same record after saving. i have maked a report viewer which is print the data when we give the date and name. but i want print report currenty which saved.
i need i have a print button in form so i need when i click them it should print the current record which is i saved currently.
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'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?