Crystal Reports

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

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...

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 web-based accessible use policy agreement for...

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...

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

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 "()...

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 the table...

how to save crystal report in excel format ?

hi i wanna to save crystal reports as excel form so can anyone help me

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..?

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.

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: if ((({MFGMAT.STU_0} = "EA" and...

crystal x1 ms sql ver. 7

is crystal reports x1 compatible with ms sql version 7?

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...

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 that I am using is 10. ...

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?...

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))...

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'...

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...

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 ...

messaging and collaboration

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