CREATE FUNCTION [dbo].[GLAS_AGING] ( @tnum int, @flag VARCHAR(1)) RETURNs int as BEGIN declare @result int begin IF @flag = 'Y' AND @tnum > 999 set @result= 8 IF @tnum<=30 set @result= 0 IF @tnum <= 90 set @result=1 IF @tnum > 90 AND @tnum <= 180 set @result=2 IF @tnum > 180 AND @tnum <= 365 ...
hi did you know that using Crystal Reports 8.5 + VB 6.0 for a project, what .Dlls we need to include while preparing a setup file for the project? The project executes on my own computer properly but it does not execute on user's computer. The user says: " I get this error when I wanna to execute a report:: 'physical database not ...
In one of the enterprise-level projects, we are using ASP.Net MVC for the web application portion. The reporting system is a huge system with hundreds of reports plus adhoc reporting, printing and notifications, the whole nine yards. Although we are using MVC for the web portion, the reporting doesn't need to be in the same technology, ...
Running any of the Crystal Reports 10.5 redistributables (CRRedist2008_x86.msi, CRRedist2008_x64.msi or CRRedist2008_ia64.ms) is supposed to, according to the Crystal_Runtime2008.txt file, deploy the following files: CRVsPackageLib.dll CrystalDecisions.CrystalReports.Design.dll CrystalDecisions.CrystalReports.Engine.dll CrystalDecision...
I need to create a report that references multiple tables, including one table that is a line-by-line detail of an order. On orders, we have packages and the only way to determine if the package is of a certain status is to analyze the statuses of it's component members. The invoice detail is stored in sequential order with the line nu...
Hi I want to rotate the text (table data) by 90 in the crystal report as I need to show the data vertically. The table has many columns and they should be arranged Vertically. This can be done by rotating the text by 90 but the problem here is table data is not growing vertically as I get the records one below one. But my requrement i...
Hi How i can Decrease the report file Loading Time? I Use this Code to Load a Report File reportDocumnet.Load(reortFilePath); but the first time loading is very long. just in first time running this code i want use a way to run this line of my code speedly ...
How disable this message when I click on print button :The report you requested requires further information . In ConfigureCrystalReports function I write this: string reportPath = Server.MapPath("NastavaPrikaz.rpt"); ObjektniNastavaIzvjestaj = new ReportDocument(); ObjektniNastavaIzvjestaj.Load(rep...
My Crystal Report .rpt file has a datasource of 'dev'. The deployment environment datasource name will vary. In my app code, I have: SqlConnectionStringBuilder SConn = new SqlConnectionStringBuilder(connectionString); Label myLabel = new Label(); myLabel.DataSourceConnections[0].SetConnection(SConn.DataSource, SConn.InitialCatalog...
Hi fellow experts, here is my situation. I have created a DataSet, in my projet, that is linked to my Crystal report. Howhever, when I run the application and that I look at my report, there is decimal on all of my numeric fields. How can I remove them? For your information, when I right-click on one of these numeric field, I don't have...
How can I change the data source (database server, username, password) that a Crystal report uses at runtime, running within a crystal server? I have a crystal server and have uploaded reports that have a set datasource (SQL Server 2005 hosted on SERVER A, userA, passwordA). I would like to schedule reports to run using a different dat...
Im my crystal report i ve parameter field like 1.From account 2.To account If user select from account alone (without choose To account) then in To account field the same from account details shoud be shoen that is if user select From account="1" and didnt chose (To Account="") then the value should be assing like(To account="1") i ...
I have an SQL query like SELECT GNTD_SCHEDULE_CODE SCHEDULE, GNTD_PARENT_ACCT PARENT_ACCOUNT, GNTD_ACCOUNT_CODE ACCOUNT, GNTD_COMP_CODE, SUM(CONVERT(FLOAT, ISNULL(GNTD_CUR_MNTH_ACT, 0))) CURR_MONTH_END, SUM(CONVERT(FLOAT, ISNULL(GNTD_PRV_PRD_ACT, 0))) PREV_MON...
Hai Friends this is my query SELECT COUNT(CASE ISNULL(GAM_STATUS, ' ') WHEN '1' THEN '1' END) + COUNT(CASE ISNULL(GAM_STATUS, ' ') WHEN '2' THEN '2' END) + COUNT(CASE ISNULL(GAM_STATUS, ' ') WHEN '3' THEN '3' END) ACTIVE_REC, COUNT(CASE ISNULL(GAM_STATUS, ' ') WHEN '5' THEN '5' END) DELETED,...
How to Get Value from Crystal Report Formula Field programmatically in C#?? ...
I need to load images to crytal reports. I just have ImagePath field in database which stores the path of the image file. How do i load images from file system to crystal reports at runtime. I would like to load using dataset. Thanks in advance ...
I have a method that loads a Crystal Reports file, sets the appropriate login information, and then generates a PDF. ReportDocument rep = new ReportDocument(); rep.Load(...); // Set table LogOnInfo rep.ExportToStream(ExportFormatType.PortableDocFormat); // Save the PDF to disk or return it as web request This exact code works in bo...
I have the custom forumla in my record seletion formula editor in Crystal reports 8.5 {_v_hardware.groupName} = {?companyname} and ({_v_hardware.DriveLetter} = "C" or isNull({_v_hardware.Driveletter}) I'm trying to list all records with a drive letter C or has a Null value and it currently lists all records with the drive le...
Hello Guys, I have a problem with Crystal report, I wanted to show a dynamic image on my report. The images is generated via HTTP Handlers. Something like this: "Services/Print?ID=1143". The image doesn't show at all on my report view. But when I copy and paste the whole part and past it on my browser the handler just works fine. The im...
Hi All, How can we pass a parameter from main report to subreport in crystal reports XI. I am having a parameter in the main report. Now i want to pass the same parameter to subreports. Kind help needed please.. By, Sivakumar.P ...