Recent content by alectek

This is actually my question. How to call this procedure from report to run it, not just alter. Thanks. Alec.

Dell, here is like it is look like: set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go -- ============================================= -- Author: AY -- Create date: 7/28/2011 -- To create Table for UC417 report -- ========================================= ALTER PROCEDURE...

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

It is working. Thank you. Thanks. Alec.

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

Lbass, BRAVISIMO! It's working! Thank you. Thanks. Alec.

Sorry, it was an error in last Post. Here is the right one, but the result of repor zero any way. local numbervar i = 1; local numbervar ClntCount := {?Number of Clients to register}; local stringvar array myparam := ({?Client ID & Registration date}[1 to ClntCount]); stringvar x; for i := 1 To...

Lbass, thank you very much. Code looks very logical, but report returns zero records. I was thinking that the problem in the formatting and changed it. Still same result. Any suggestions? local numbervar i = 1; local numbervar ClntCount := {?Number of Clients to register}; local stringvar array...

I used following code. There aren't any errors but it prints all the records from Client table. local numbervar i = 1; local numbervar ClntCount := {?Number of Clients to register}; local stringvar array myparam := ({?Client ID & Registration date}[1 to ClntCount]); for i := 1 To ClntCount Do...

Madawc, thank you for your advice, but I have to do it in parameter Thanks. Alec.

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

Synapsevampire, I'm using text box, because I think it is the best way create flat file with the fields with different data type: Date, Number, Text. Please help me out if I'm wrong with this method. I'm sure the file started from the "very left". Thanks. Alec.

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 “,”...

dhookom, thanks again for your help. Here is the solution I got from another forum and it works. <A query-based way to solve it is craete another field in your table with the type you want, and then run this query : update <YOURTABLENAME> set <YOURNEWFIELD> = val(<YOURNUMBERASTEXTFIELD>)...

Dhoomkom, thank you for your suggestion. However, val()or CLng() return the numbers contained in a string as a numeric value. It is not changing the field data type. Than Excel reads it like a text any way. Thanks. Alec.