Actually 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 Replies
i'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 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 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 RepliesI want to display images in crystal reports from database. what i do?
View 1 RepliesHow to display images in crystal report from database am inserting address (image folder) of images into the database, not inserting images into the database...
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 RepliesIn Crystal Report I have some text boxe on the page footer section, I wanted to show all these text boxes only on the last page. In other words I wanted to show the whole page footer section only on the last page. I do not wanted to user Report footer, as report footer starts immediatly after the contenets of the report are finished, but I wanted to display my stuff at the page footer leve in any case.
View 1 RepliesI am trying to populate a report with parameters from session. Problem I am getting is that it is asking for parameter after I click the 2nd page of report. If I remove the Session.Remove it works good. Is there anyway to clear session after the first time the code executes? Here is my report viewer page code
public partial class setups_ftreaty_ft_mstmt : System.Web.UI.Page
{
ReportDocument rptDoc = null;
protected void Page_Init(object sender, EventArgs e)
{
string reportName = Request.QueryString["reportName"].ToString();
rptDoc = new ReportDocument();
rptDoc = ReportFactory.GetReport(rptDoc.GetType());
string path = Server.MapPath("~/reports/ptreaty/" + reportName + ".rpt");
rptDoc.Load(path);
if (Session["ptRepParams"] != null)
{
Hashtable repParams = (Hashtable)Session["ptRepParams"];
foreach (string param in repParams.Keys)
{
rptDoc.SetParameterValue(param, repParams[param].ToString());
}
}..............
In my database having 50 records,i wnt to display the first 10 record on first page of gridview and next 20 record on second page and so on..
View 1 RepliesIm 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 RepliesI have a new issue, i am working with crystal report 2008 in ASP.NET 2.0
I am trying to call Crystal report through ASP.NET page
the issue is, system DSN is not allowed to create on the server.
how i can create DSN and pass database credential through a ASP.NEt 2.0 page to call a crystal report
previousley i am doing like this on a local machine to call a report
crConnectionInfo.ServerName = "dsn_Name"
crConnectionInfo.DatabaseName = "DB_Name"
crConnectionInfo.UserID = "sa"
crConnectionInfo.password="password"
but i am not able to create or system DSN is not allowed to create on the production server.
please help that wt are the other way to call the crystal report 2008 through asp.net 2.0
I have two reports but i want to use the same crystal report viewer to display both reports depending on an option selected. How can I achieve this?
CrystalReportViewer.setCrystalReportSource(CrystalReportSource3) or something like this i am just not sure about the code in c#
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.
View 2 RepliesI want to display a crystal report in my vb.net application. Suppose I have tables named student details, student marks, student address, etc... Nowif I want to display all these details (fields of all tables) in one crystal report (with page breaks if necessary) then how will I achieve it. I will be providing a combo box in my application that contains list of student names.How can I link this combo box with the cystal report to dynamically display report for different student on selected index change of combo box?
View 2 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 display whole records from database in Gridview and also do filteration using textbox ?
View 1 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 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 want to display all records from database in gridview when pageload and also i wanna search for particular record using textbox appear in my webform .
Means by default all records from the table will appear in gridview using sqldatasource and i also wanna search for a particular record by enter ID in text box ...
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.
