Search results for query: *

bborissov Thanks for your previous reply to the above, I assumed (wrongly I think ) that I could use the variables in your reply to update the Dupe field with the value in the variable. It runs fine for a select query. My question is how can I use these correct results from the select query...

bborissov Thanks for your help and the code to sort my problem. I used your solution with some tiny tweaking and the results are below. Regards Pator [code=Used] DECLARE @Test table (Ldg CHAR(3) , Bnk numeric(6,2), Combine varchar(50)...

I suppose For the same reason I still use Office 97 , Unfortunately I have no control over what version I use, I'm piggy backing on another guy's server for SQL test purposes , So I just have to live with at the moment. Thanks for your reply will check it out this morning. Regards Pator

Folks I have an access database to convert to convert into SQL 2000, Most of the queries are fine to convert as they are select type queries and easy to follow. There are some which are more difficult such as the following problem. I have this table called TblCombine Sample data Ldg ...

Thanks lbass for your Help and Time, that worked a treat. PATOR

Using CrXi reporting off SAP. Folks I have this string of data which includes this ^ character , this data is in a formula called {@sv4_level_40} (DATA SAMPLE) ^007-08_1_2008 TO test comments at this level for testing ^009-08_1_2008Good progress made in P4. 4 new DSLTM hope to be commissioned...

Using CRXI reporting from SAP. I sumittted a post previoulsy which I got some answers for, unfortunatley I had to leave it and work on other things. Now I have time to look at the issue again. To this end can you look at the following problem please and advise if possible. The following code...

I tried inserting a .gif photo into CRXi and the image did not show. However when I changed the type to .bmp it inserted fine. Maybe this could help you. Pator

Using CRXI SAP datasource I have a subreport placed in a report footer Q in my main report.The subreport is linked by a Formula called @CreateKpi. When the report runs I can only see the last value in the subreport. I placed it in the details section to verify the link is working and I get...

I'm using CRXI I have found the following array code on this site and tried modifying it for my own use. My problem is the last part of it only returns the last record in the array, My problem is this, I have comments in a shared array variable which is derived using this code in a...

If your problem is that you can only fit so many fields into your report design view which can be based on the page set-up for the printer selected. You can try the following , which works fine for me. Download PdfSuite995 from http://www.pdf995.com/ this is free software. After installation...

I'm using Crystal XI reporting of SAP. I use Remote Function Call (RFC)to retrieve comments from SAP for Particular records.I use a shared variable to return these comments into the details section of my report.(This works OK) I then want to loop through the shared variable and line up the...

Thank you Madawc for you reply , it was very helpful

Hello All I have 2 fields. In F1 an asterisk in F2 text on different lines. Example F1 F2 * text which is on different lines and I need to get this text into 1 long string.There could be numerous lines of text here. * New line of text here Can anyone please advise on how for each * in...

That problem seems to be a bug with CRXI , I have raised it with Bus Objects as all my exports which where fine in previous versions of CR are not exporting as they should be. Regards Pator

I'm using Crystal Reports 10 I have a tricky problem which I'm looking for some ideas on. I retrive data from a SAP ABAP function using a Remote Function Call (RFC). To do this I have to pass the following parameters, {Z_FS_READ_TEXT.I_ZCLIENT} ="020" and {Z_FS_READ_TEXT.I_ZID} ="ST" and...

Folks Has anyone got any examples on how to retrieve data from a SAP function. I'm using Crystal Reports 10. I can see the SAP function OK in report design and have passed the parameters in the record selection formula. My record selection formula {RFC_READ_TEXT.T_TEXT_LINES.MANDT} = "020" and...