Search results for query: *

Unfortunatly, that is the same conclusion that i have come to. Thanks for your efforts !

I have tried this without the line feeds/carriage returns. No Difference, the Excel still puts the narrative on multiple rows. Thanks !

Hey Skip, could you elaborate a little bit ? Not quite sure how that is going to help me, thanks.

Using Crystal Reports 2008, Visual Studio 2008 with C#. Build the report in Crystal with multiple columns, some of which are narrative and can be quite lengthy. Using the “Can Grow” option on all fields. Have a web page that displays the report through the viewer, looks great. Since...

Seem to remember that i had to convert the barcode string, via a formula to include an @ sign at the beginning and at the end. Control characters to designate the start and the stopping points. Changed to code 128 via a free downloaded font. Don't know if this helps, been a while... Pat

We have been trying to find a solution that allows our .Net web application to send Crystal reports directly to our web user's printers. Some reports go to their laser printer while others go to a barcode label printer. We want to print reports in the background with out prompting the user to...

Need to report through crystal reports 9.0 Developer over the web from a SQL 2000 database. Looking for the best way to do this on a budget. Can store the crystal reports on the remote machines. But the machines don't have sql or direct access to the sql database. Can either transfer the...

Sorry for the lack of info, trying to place 14+ individual graphs in the report footer based upon data in the details section, currently grouped on distinct field. Trying to translate the following sql command / concent into crystal 9 formula language ? 'select @number1,@number2 into @a,@aa...

Please can anyone help translate the following sql command / concent into crystal 9 formula language ? 'select @number1,@number2 into @a,@aa where @testname='ABC' @number 1 is the result of a numeric calculation in the report. @a is a number, no decimals, parsed from a memo field and converted...

Some experience with sql,on crystal 8.5. New to MS Access and crystal 9.0. Have tried this with both configurations. Have multiple rows of data, same unique id, different row names, am pulling a string out of a memo field and converting to number. Managed that. Can either update dbase or...

Thanks you for your quick reponse, any chance of getting sql converting the data objects to a graphic ? Thanks again, pat

Thanks in advance, Please, Is there any way to orient text vertically in 7.0? Trying to print address labels from sql stored procedure on a verical label printer with a width of 1 inch, length of 5 inches ? Need guidence Desperately ...THANKS

if you are talking about point & click, hold the shift key, if you are talking about programing, not enough coffee yet.

set nocount on declare @long varchar (75), @short varchar (25), @testid varchar (10), @alt varchar (25), @cpt varchar (25), @hisid varchar (25), @anal varchar (25), @tdtestid varchar (25), @row int, @order varchar (3) declare abc cursor for select longname, shortname, testid...

Couldn't you copy the distinct records to a view, delete the table and copy the records back from the view ? Alter your table by adding a unique counter to distinquish each future row. Although running time might be lengthy...? Just a thought, Pat

Trying to create a view in a stored procedure: CREATE PROCEDURE [DATE2] AS create view pdt (pxid,pdate) as (select distinct patid,postdt from main union select distinct patid,postdt from archives) This pops an invalid syntax near keyword 'view' error. Tried insering a 'go' between create proc...

try setting the max to -1, works with borland database engine... pat

simple but something like this might work... delete from ads where (convert(varchar(25),AdDate,101))> DateAdd(day,-90,(convert(varchar(25),getdate(),101))) good luck, Pat