Search results for query: *

Hello, I need guidance on selecting good book on ASP. I Have good knowledge on database and Crystal Reports but now I need to work on ASP. Thanks for your time. --Raj.

Hi, I am having problem to write parameter in following procedure. CREATE PROCEDURE Emp_proc @EmpNoMin varchar(6) ,@EmpNoMax varchar(6) AS BEGIN SET NOCOUNT ON SELECT E.EMPNAME E.DEPARTMENT FROM EMP_TBL WHERE EMPNO between @EmpNoMin and @EmpNoMax END The above procedure...

Using ROUND function I can get round after decimal but I want to display only 2 decimals after the point. Ex: ROUND(2275.4559, 2) Results: 2275.4600 But I want to display only 2275.46 Thanks in advance.

Hello, I have amount column with two 4 decimal places. EX: 2275.4559 , I want get out put only 2275.46, how to do in SQL server, I am using Sql 2000. Thanks.

I have RAS 9 , Crystal Report 9 and I am developing application in ASP and I am using CrystalReportsInteractiveViewer.asp as viewer. But problem with this viewer is if my users want to print report they can't print directly. When we choose to print first it will exports to PDF and then we have...

Hi, I have installed RAS 9 on Development server. We have application, through that application I want to run the reports for that I am trying to write ASP pages. I got samples from Businessobjects but those are good if I am using CrystalReportsInteractiveViewer as viewer i am able to enter...

I am converting CR 8 to CR 9 versition as database is SQL server 7. In pts_change_log table there is column called change_closed, data type of this column is "bit" and data stored in the column as 1 or 0. When i am trying to access this column in Crystal Report 9.0 (in CR 8 this...

I installed RAS-9 on XP pro on standalone machine. First I installed ISS web server and I did make sure that it is running properly. Then I installed RAS 9 successful, but when I am trying to access RAS Configuration Manager I am getting following error message "Class not registered-Agent...

I am installing Full stand-alone installation for CE 9. Setup program can install its own Microsoft Data Engine (MSDE) database by default. I should go with default? I should first install SQL Server and make SQL server as default. Should I choose Windows NT or SQL Server Authentication when...

Hello, I am very good at Crystal Reports. But I do not have knowledge on Enterprise 9 and I was asked by manager that how much time will takes to install CE and ready for work on that. Initially we got CD to install in stand alone machine, later we are going to install in server. But either...

Hello, I am very good at Crystal Reports. But I do not have knowledge on Enterprise and I was asked by manager that how much time will takes to install CE and ready for work on that. Initially we got CD to install in stand alone machine, later we are going to install in server. But either...

Hello, I ran in to difficult situation. I am developing report out of views. And we have more than 30000 records in the particular view (I mean corresponding table). My problem is , in craystal when we do brows data we get distinct records in "first 500 records" (not...

I have extensive experience in Crystal Report development and Database (SQL server, Oracle and Sybase.). Problem is I don't know any languages. In my company we are using CR designer and using PB as interface. So there is no way to learn in the company. I am eager to learn CR Enterprise...

I have a situation where I need to convert number into hours and minuts. I am select dApplicatioStat.MaxCallsAbandonedDelay from view. MaxCallsAbandonedDelay is the number field , which I need to display in 'Hours and Minutes' Is there any formula to convert. Thanks in advance for helping. Raj.

Please can some body suggest me any books or link on Crystal Enterprise. I would like to know about Crystal Enterprise . Thanks, Raj.

Need help to create formula, I want display space after 4 records. So When I preview I should see 4 records and space and 4 records and space. Example: David John Alla Oxford Steev Tom Tim Mary Thanks, Raj.

Recently upgrade System to XP, after that installed crystal reports 9 Developer. Created new report , and I want to save it, not able to save new report. If I want to do File-> Open , the popup window is not coming to access the file. And also I am not able user function File-> SaveAS . Can some...

How can I remove Line on the chart, which is connected by "Markers" I want to show only Markers but not line(connected by Markers).

Hi hth, I want to use vertical chart but I want to show string field on the Y-axes?. -rpal

I am not able to show Industries on Y axes. I want to do some thing like this. I want to show diffrent industries on Y axes. On Y Axes: Long Distance Lodging Restaurants Business Services Class Plastics & Fiber On X Axes: 5.0 5.5 6.0 6.5 7.0 7.5