Return or print more than one date
Basically i have two dates suppose minDate and maxDate, Just i want to find diff in day..If both dates are same then i want to return mindate and if difference is there then then i want to return all dates from mindate to maxDate..How to do this?Please help me

Answer Question   |  May 8, 2008  3:47 PM
Crystal Reports

Crystal Report Problem in VB6
I am using VB6 with back ground Database DB2 AS400 iSerices and Crystal Report 9.0. When I Show the Report Its prompt me to enter password. I have tried to find the solution and found some thing about LogOnServer but every example is there for Crystal Report 7,8, and 8.5. I have tried to use [...]

Answer Question   |  April 14, 2008  6:49 AM
AS/400 DB2, Crystal Reports, VB

Crystal Reports newbie has a question
I am an intern at my company and I *think* I have to use Crystal Reports to complete one of my projects. I will start by explaining what I need done. I would like to know if it is possible, and if it is, how I would go about doing it. I am building a [...]

Answer Question   |  April 9, 2008  1:01 PM
Crystal Reports, Web development

LogOnServer Problem in Crystal Report
I am using VB6 with back ground Database DB2 AS400 iSerices and Crystal Report 9.0. When I Show the Report Its prompt me to enter password. I have tried to find the solution and found some thing about LogOnServer but every example is there for Crystal Report 7,8, and 8.5. I have tried to use [...]

Answer Question   |  April 8, 2008  11:35 AM
AS/400 DB2, Crystal Reports, VB

Crystal report
I just started a job as a data analyst and wanted to see if any want can help me build a report on crystal report. Claims billed by month Claims outstanding by month Monthly report showing write off ‘bad dept’ Thanks

Answer Question   |  April 4, 2008  12:26 AM
Crystal Reports, Data analysis

Excel Date format () dd-mmm-yyyy error from exported crystal report
I am exporting a crystal report file to excel and date field TRADE_DATE is coming out strange. i.e PARTY_ID TRADE_DATE CX () 16-Jul-2003 CX 29-Jul-2003 CX 09-Dec-2003 Some trade_date fields are in Custom Type “dd-mmm-yyyy” format ( which is the correct format) but some are in Custom Type “() dd-mmm-yyyy” format which is incorrect. I [...]

Answer Question   |  March 24, 2008  7:30 PM
Crystal Reports, date format () dd-mmm-yyyy error, Excel 2003

Crystal report – how to link fields
I have to make a report that links two fields after some string manipulation like mid({field1}, 3) = field2. Is there any way to do this? I have attempted a subreport, but that is a left outer join and doesn’t limit the report results. I’m sure that can be done in the select expert, but [...]

Answer Question   |  February 26, 2008  9:21 PM
Crystal Reports

how to save crystal report in excel format ?
hi i wanna to save crystal reports as excel form so can anyone help me

Answer Question   |  February 22, 2008  7:19 PM
Crystal Reports, Microsoft Excel

How to pass Stored procedure to Crystal reports
I have created a report in Crystal report using stored procedure and i have to call that report in delphi by passing parameters to stored procedure..?

Answer Question   |  January 21, 2009  11:56 AM
Crystal Reports, Delphi

Crystal report
I have to show treeview on Group header of my report.Is there any functionality in crystal report to set tree view on any group header like pivote table in Excel.

Answer Question   |  January 16, 2008  8:57 AM
Crystal Reports, TreeView

Crystal Reports
I am a novice in Crystal and I am trying to create a funtion that will read more than one record to give me the result. The formula I have now is only reading the first record and I am not sure how to get it to read every record. The formula is as follows: [...]

Answer Question   |  December 7, 2007  6:15 PM
Crystal Reports

crystal x1 ms sql ver. 7
is crystal reports x1 compatible with ms sql version 7?

Answer Question   |  November 21, 2007  8:01 PM
Crystal Reports, SQL Server 7.x

opening crystal report using ISeries sql error Temp table already exists
I built an sql stored procedure on the ISeries using ISeries Navigator. The procdure returns a good result set using a couple of global temporary tables from other stored procedures I call. When I try to access the stored procedure using Crystal X1, I get an obdc error telling me the temp table already exists. [...]

Answer Question   |  December 13, 2007  8:20 PM
Crystal Reports, iSeries, ODBC

Crystal Reports – How to force page break
I have a report that I am designing that requires that a new page be generated if a property has more than 6 occupants as the form will allow for 6 listings and if there are more, a second page needs to be generated. Does anyone know how to do this in Crystal? The version [...]

Answer Question   |  April 18, 2013  8:54 PM
Crystal Reports

C#.Net
Does anyone know of a good place to find people with C#.net experience besides the big job boards? We have several positions in the Financial/Trading industry in Chicago but we are having a hard time finding enough people with this skill set. Any Blogs, User Groups or Niche Sites you can recommend? Please forward on [...]

Answer Question   |  March 10, 2008  3:58 PM
Application development, Business Objects, Business/IT alignment, C, Career development, Certifications, Cognos, Computer Associates, Crystal Reports, Data Junction, Data mining/analysis, Data warehousing applications, Database, DB2, Deltek Systems, Desktops, Development, Distribution/logistics applications, Enterprise Desktop, Financial services applications, IBM, Linux, Management, Microsoft Windows, MySQL, Oracle, OS, PeopleSoft, SAP, SAS Institute, Security, Servers, Software Quality Assurance, Software testing, SPSS, SQL, SQL Server, SS&C Technologies, SunGard Data Systems, Systems Union Group, Training, Transaction Systems Architects, VBScript, Vendors, Visual Basic, Web development, Web development tools

Store Procedures, SQL statements
I am a newby to SQL and I am currently creating a store procedures for Crystal Reports. I have ran into a Problem. Here is some of my coding: SELECT @Address = ISNULL(Address,”) from tblAddresses WHERE (ClientNumber = @ClientNumber) AND (AddressType = ‘Current’) IF LTRim(RTrim(@Address)) <> ” SELECT @Address = isnull(Address,”) + char(13) + char(10) [...]

Answer Question   |  September 14, 2006  6:45 PM
Crystal Reports, Microsoft Windows, SQL Server

Crystal Reports
I am working on a report in Crystal Report, I have a stored Procedure like this ALTER PROCEDURE [dbo].[usp_cust_by_activity] @carrier as VARCHAR(10) AS –drop table #custA –drop table #custPA –drop table #cdrall –drop table #cdrPrevMonth –SET @carrier = ‘PR’ –’PR’, ‘RG’ SELECT DISTINCT fld_cust_id INTO #custA FROM tbl_cust_ld WHERE fld_ld_status = ‘active’ and fld_cust_id in [...]

Answer Question   |  June 11, 2011  6:08 PM
Certifications, Crystal Reports, Data warehousing applications, Development, Project management

Passing parameters from .ASP (VBSript) to Activex object in date format
I have inherited the following: <%@ LANGUAGE=”VBSCRIPT” %> <% dim adoconn set adoconn = server.createobject(“adodb.connection”) adoconn.open Application(“DSN”),Application(“UID”),Application(“PWD”) reportname = “traininghrsbyemployee.rpt” If Not IsObject (session(“oApp”)) Then Set session(“oApp”) = Server.CreateObject(“CrystalRuntime.Application”) End If Path = Request.ServerVariables(“PATH_TRANSLATED”) While (Right(Path, 1) <> “” And Len(Path) <> 0) iLen = Len(Path) – 1 Path = Left(Path, iLen) Wend If IsObject(session(“oRpt”)) [...]

Answer Question   |  February 7, 2006  1:29 AM
ActiveX, ASP, Crystal Reports, HTML, Software, SQL, VBScript, Web site design & management

List of Values in a SP Parameter
I need to pass a List of Values parameter from a Crystal Report to a Store Procedure. 1) How do I define the Parm? and 2) How do I code the WHERE clause? Example: Result Sets 1 Language SQL Begin Declare C1 Cursor with Return For Select * From Table1 WHERE Field1 in(‘Value1′, ‘Value2′,’Value3′, etc);

Answer Question   |  February 9, 2006  2:42 PM
Application development, Crystal Reports, DB2 Universal Database

messaging and collaboration
What is messaging and collaboration,how does it works,how to set it up ,where can it be implemented and how

Answer Question   |  January 12, 2008  8:40 AM
AIM, Availability, Bandwidth, Billing and customer care, Billing Support Systems, Brightmail, Budgeting, Business Objects, Business/IT alignment, Career development, Certifications, Cognos, Compliance, CRM, Crystal Reports, Data analysis, Data mining/analysis, Data warehousing applications, DataCenter, DataManagement, Development, Enterprise Desktop, ERP, Exchange, Instant Messaging, Laws, Lifecycle development, Linux, MySQL, Network monitoring, Network protocols, Networking, Outsourcing, Regulations, Spam, standards, Training, Web development