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...
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...
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...
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.
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...
Synapsevampire,
I need it to do the separated summary clients with (COST_CENTER_LEVEL_OF_CARE.ExpDate IS NULL OR
COST_CENTER_LEVEL_OF_CARE.ExpDate >= @StartTime) AND
(COST_CENTER_LEVEL_OF_CARE.EffDate < @EndTime) AND (LevelofCare.Code = '012')...
Synapsevampire,
Thank you for the fast response. I have only one stored procedure in my report (the one I created), linked to the tables from the same data partition on the same database.
Thanks.
Alec.
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.