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.

But It displaying results 2275.4600 I want to take out 00 and want to display only 2 decimal places.

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

Thanks for your post. But it is giving info on viewing on web. I got error message when I am trying to open "RAS Configuration Manager " from Programs-> Crystal 9 Tools.

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

So Guyute do I need to worry about NT/SQL server authentication at any point. And in the documentation they are saying I have to create some account for ASP (Automated Process Scheduler)? Can you please explain what they mean. Thanks, Raj.

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 Synapsevampire, I am going to install CE 9 version. In your post you said CE will install automatically "MS SQL Server engine" is this same as "ASP" (Automated Process Scheduler)? If not please let me know what is the difference between two. Thanks, Rajani.

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

Hi cisscott, I am very great full if can share with me that pdf. Please advise me what I am supposed to do to get that help file. Thankss, Raj.

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 am able to solve this problem guys. Thanks all whoever working on this problem.

Sample Data: MaxCallsAbandonedDelay: (In the database) 102 22 38 Above records I want to display in the report like : 01:42 00:22 00:38 Hope this is clear. Thanks.