Search results for query: *

Hi! I have CR11 and SQL Server 2005. I created Stored Procedure to Delete all records from table and than base on Select Statement Insert back to this table new records base on parameter sent from Crystal Report. Later, I use this table as a Data Source for other report. I created report base on...

Hi! I have a requirement from the State to import file is in ASCI, fixed length with a CR-LF at the end of each row. Each row represents one service record. I use Crystal Reports 11 with SQL Server 2005 to get those services. Should I export result of Crystal into Excel in than save is .prn...

Hi! I am using Crystal XI with SQL server. I need the report witch will show Client ID and Client info from the Client.db table and the registration date witch aren’t store anywhere. Therefore, the parameter needs to be a combination of Client ID and the Date user will just type: “Enter Client...

Hi! I founded a lot of treads about exporting Crystal reports in to CSV files, but didn’t find any help with my problem. I’m working w/CR10 and MS Office 2003 Professional Edition. Created a simple report ready to export in CSV file by adding couple of fields in empty text box with “,”...

Hi! I have a problem to build Pivot table in Excel 2003. I’m creating this table base on the “External Data” which is a MS Access 2003 table. The table has 50 fields and about 500.000 records. (This is the reason, I can’t just export table to Excel and then do pivoting). One of the fields of...

Hi, I'm new in using SP as a data source. I'm running CR10 against SQL Server 2000. The SP I created very simple and I think is working fine: CREATE PROCEDURE mfs_Clients_with_Medication_Monitoring_LofC @StartTime as datetime, @EndTime as datetime AS SELECT TOP 100 PERCENT Client.OID as...

Hi! I'm using MS Access 2003. I create the Macro to run bunch of queries. All of them have the same field [svs.date], and for all of them I want to set this field to the same value. Let's say [svs.date] >= #7/1/2006#. Any way, I can do it in a Macro. Thank you very much for help. Alec. Thanks...

Hi, I need to create a query to get only Max value. I’m using MS Access 2003. The table looks like: ClientID Month Project FTE 1 3 A 0.25 1 3 B 0.75 2 4 B 0.35 2 4...

Hi! I very new in any kind of Access Programming, so my question may look very stupid. Working with MS Access 2003. I need to create three Macros. First, will OpenQuery to create table Second and Third, will OpenQuery to append to “First” table. In every of those queries I need pass “Start Date”...

Hi! I'using CR10 and SQL server 2000. Currently, I'm working on Demographic summary report. I need distinct count of Clients by Gender with some conditions, like age >= 18 and <= 25 I can’t use this condition in record selection because in the same report I’ll count clients with age >= 25 and...

Hi! I'm using CR10, SQL Server2000. I'm trying Reset Running Total by PageNumber to find maximum value of the field on every page. Not working... :-( May I get any help? Thanks. Alik. Thanks. Alec.

Hi! I’m working with cr10 and SQL 2000. We have 2 sets of Data Base. “Live” and “Training” I created reports using “Training”, now I need to test it on “Live” Before, in CR5 – CR8.5 it was very easy. Changing of location of one table sent prompt to change location for all tables. Now in CR10 I...

Hi! Today is my first day of using Crystal 10. In CR 8.5 I was using before, in Crystal Tools was Crystal SQL Designer. I didn’t find anything like that in CR10. What else can I use in CR10 to create an SQL queries. Thanks a lot.

Hi! Do you know where on Internet I can learn about Store Procedure for CR.? Thanks. Alik.

Hi! Please help with grouping by Date Range Parameter. ?Start Date = Date(2003, 2, 01) ?End Date = Date(2004, 1, 25) The group should looks like: Feb, 03 Mar, 03 Apr, 03 May, 03 Jun, 03 Jul, 03 Aug, 03 Sep, 03 Oct, 03 Nov, 03 Dec, 03 Jan, 04 Than I’ll need to send this parameter in the...

Hi! Do you know where on Internet I can learn about Store Procedure for CR.? Thanks. Alik.

Hi! Do you know where on Internet I can learn about Store Procedure for CR.? Thanks. Alik.

Hi! Can somebody help me create a formula in CR 8.5 for Grouping by Month using Selected Date Range. Parameters: ?Start Date = Date(2003, 04, 23) ?End Date = Date(2003, 04, 23) Now, they need see how many clients served during each month for selected period using Date of Service...

Hi! I’m using CR 8.5 with SQL Server. One table in report. I created the text parameter base on one of the field (string). When I did “Set default values” and selected field I want use and than I added those values it shows only first 35 values from 121. Is it any restriction to past just...

Hi! I need to convert Memo field to Text field using Query. The function {fn CONVERT (table1."field1", SQL_CHAR} returnig the Error. Thanks a lot for any help. Al.