Hi, In my report Vertical lines are extended to bottom even if there are no records to display in the Detail section. I display Total number of records in the Report Footer. Please let me know how to fix this problem. Thanks.. ...
I have a Sub like this: Public Sub ReportViewer(ByVal ReportName As String, ByVal SQLText As String) Dim strReportPath As String = System.AppDomain.CurrentDomain.BaseDirectory() & "Report\" & ReportName & ".rpt" If Not IO.File.Exists(strReportPath) Then MsgBox("Unable to locate report file", MsgBoxStyle.OkOnly + ...
Hi, we use Crystal Reports 9 and want to improve the automatic pagination for printing. We have the following structure in our report: Group Subgroup Entry in Subgroup Entry in Subgroup Entry in Subgroup The whole group appears on the current page if all entries of the subgroup fit on the current page. That's ok. If the subgrou...
hi there i have written a program in C# . i have a problem in crystal report . i wanna sort data in a report by clicking on a link in header . is it possible in crystal report? please help thanks... ...
Hello all When i try to deploy crystal report application on sharepoint server i get the following error The vs2008 application works fine locally.But when it is deployed on sharepoint server it gives this type of error..Plz help Unknown Query Engine Error Error in File C:\WINDOWS\TEMP\EmpReport {C388758D-9AE2-4E60-A4D1-E18BFB6F3703}.rp...
Ok, So I have to generate very complex reports from my DB. If I am to do it with SQL the query themselves will be complex, and I will have to do some more manipulation on the results later, code level. How do libraries like Jasper Reports/ Crystal Reports and friends save me time when developing such reports? What will they give me? ...
I hav visual studio 2008 project and in client computer in crystal report there occurs error and the message is "CrystalDescision.CrystalReports.Engine, Version=10.5.3700.0,Culture=neutral..." so how can i load cyrstal report without installing visual studio 2008... ...
hi i have crystal-report that show my DataBase. how i can mark line in the crystal-report ? for example: i run any query that return one line - and i want to see all the table - and only this line will be mark thank's in advance ...
Please help me as I am a newbie using VB.NET. I have been asked to transfer rows from a DataReader into a Crystal Report dataset. Here are the coding: Private Sub BtnTransfer() dim strsql as string = "Select OrderID, OrderDate from ORDERS" dim DS as new dataset1 '<---crysal report dataset1.xsd dim DR as SqlDataReader dim ...
how to hide columns in crystal report at run time? thanks for any suggistions. ...
I have an existing report (Crystal Reports 11) that is based on two Oracle views. I have made 'Verify database' already, it's done and up to date. My problem is that I can insert some fields to report but some other I cannot. For example: field Name (string(35)) is ok, but similar field Compamy (string(20)) I cannot insert to Report. ...
I have the following SQL Expression Field in my Crystal Report 11.5 {fn CONCAT({fn CONCAT("SPR_PRODUCT"."PRODUCT_ID","SPR_PRODUCT_SUB_ITEM"."P_SUB_ITEM_ID" )},{fn CONCAT("SPR_PRODUCT_ITEM"."P_ITEM_ID","SPR_PRODUCT_GROUP"."P_GROUP_ID" )} )} It works well in the Preview Mode. But when I use the report in my VB.NET 2008 Project it...
I'm using Visual Studio 2005 with VB.NET. I have a number of Crystal Reports, each with their own associated dialog resource containing a CrystalReportViewer. The class definitions look like this: Imports System.Windows.Forms Imports CrystalDecisions.CrystalReports.Engine Imports CrystalDecisions.Shared Public Class dlgForMyReport ...
Using vs2008, winforms C#. Im using the crystal reports version that comes with vs2008. I can create and load a crystal report ok. But becasue it can take a few minutes to load, i want to bring up a wait cursor, but am having trouble with that. I have tried setting the this.crystalReportViewer1.Cursor = Cursors.WaitCursor; and tried...
How I can create a crystal report in php kindly guide me so that I can make it possible. I have tried a lot of code and tutorials but un-usefull for me. I have tried $COM_Object = "CrystalReports12.ObjectFactory.1"; $my_report = "C:\Report2.rpt"; $ObjectFactory= New COM($COM_Object); $creport = $ObjectFactory->OpenReport("c:\report2.rp...
Using MS SQL Server.I have made a Stored Procedure named SP_Get_CallsLogged. I have a table named TRN_Call, and it has one column named CallTime which is a DateTime. I have a web-page in my application where the User enters:- StartDate (DateTime) EndDate (DateTime) Period (Daily/Weekly/Monthly) (varchar) (from DropDownList) I want ...
I want to call crystal report in php. now after searching i reach at that point that it is possible through COM object but now one error is created which is Fatal error: Call to undefined method com::OpenReport() so how to remove it ...
I have an application which was written in Visual Basic 6.0 and some version of Crystal Reports (I believe with a version that came with it). I need to make a few updates to the report now. We have the .rpt file. Is there a way with which version of Crystal Reports that this was created? ...
I use a report in 2 projects, so I need to migrate report to a WebService by following this : http://aspalliance.com/1883_Building_Reports_using_ASPNET_and_Crystal_Reports__Part_5__Creating_Reports_as_a_Web_Service.1 From the existing report, it was loaded by a ReportDocument protected void Page_Load(object sender, EventArgs e) ...
I have created a new .rpt file. Right click on section 3 and there added a picture. It shows nicely in the editor (Visual Studio 2008) but when I generate the report as a pdf file then I do not get to see the image. What am I doing wrong? ...