Search results for query: *

I have XI. My rpt accesses an SP to retrieve the data set. I need to suppress a detail line if there are no rows returned from the SP. This detail line contains a text field from the SP, and a drawn box. When there is no return from the SP, I still get the detail line with the box, even though I...

My XI report has a detail line which consists of 2 fields from an SP, and a box, which was drawn using the Insert function. I need to suppress this detail line if it is repeated. I can suppress each of the 2 fields OK, but not the box. If I right click on it, I can Format Box, but I can only...

I use Crystal XI and my report calls an SP with 2 parameters. There are also 2 extra subreports each of which also use the 2 same parameters. How do I set Sub Report links so that I am not prompted for 6 parameters each time I run the report ?

I need to display either a blank box, or a blank box with a tick inside it, on the detail line, depending on the value of a variable. I thought I could build a function like : if {?@variable} = 'tick' then '(box with tick)' else '(empty box)' I can get an empty box from the Insert...

I have written a report (V11 0.0.895) which has 2 subreports in the main detail line. When I export it locally, it looks OK : everything lines up. However, the rpt is being called from a .Net application, and when run thus, 2 extra columns appear after column A. If I amend the rpt, and...

I have an existing report which displays cols A to G from an SP, and uses a SubReport to retrieve col H. Cols I & J are then retrieved from the SP. The output displays OK, but I now need to export to Excel. When I select File > Export > Export Report > etc etc, for each row on the report, I now...

Hi I must have mistakenly clicked something, because when I go into Crystal XI now, I only get the Design & Preview Displays, but no "Field Explorer" on the Right Hand Side. I can click "View" and then "Field Explorer", but the display overwites the normal screen : I need to see the Field...

I have a Crystal XI report, with headings, which runs OK. A runtime parameter has been now introduced so that if passed a value of “Y”, then I use Section Expert to suppress the headings. This is because when the report is to be run from the calling .NET environment, with this new option, the...

Is it possible to interrogate a parameter (Crystal XI) so that if it is set, then a Group is used, but it if it is not set, then there is no Group ?

I have written an SP, with a variable described as (@Ident nvarchar(100)) In Crystal Reports XI, I have @Ident defined in Parameter Fields Type string Static Allow custom values True Allow multiple values False Allow discrete values True When I run the report on my PC, it...

When I Go into Formula Fields & select an existing formula, and then Edit, instead of getting the usual default screen with Headings of Report Fields, Functions, and Operators, I only get the Formula Editor, with a Workshop Tree PopUp. How can I restore the original default settings ? I have...

I need an SP to pick up today’s date, and then return the last 6 months values. E g if today is March 1st, then return 09, 10, 11, 12, 01 & 02 I can declare @mon1 numeric @mon2 numeric …… @mon6 numeric But then I have tried DATEDIFF...

I need to access 4 SPs, which will return the same 3 fields : code, text1, & text2. The SPs are not linked in any way : Data might not be returned by any of them. I have written the report (Crystal XI) using 4 sub-reports, and the data comes back OK. But when I try to select the Sort...

My Report accesses an SP rather than a table. The field I need is defined {FieldName}: Boolean When I move it directly to Detail, the values returned are either "True" or "False". I need to change this into "Yes" or "No". I have tried creating a Formula with If {{SPName};1.{FieldName}} =...

Is there a Special Field which will pick up a date from a database row, and compute the number of days between it and today ? (Version XI ) Thanks I'm new to this

I have a series of folders /temp/a /temp/b /temp/c In folders a, b, and c, I have files a1.txt……….a20.txt b1.txt……….b40.txt & c1.txt……….c60.txt Each file has the same data format :- Line 1 AAAAA aaaa Line 2 BBB bbbbbb Line 3 CCCC cccccc Etc etc I need to write a sed script which will go...

I need to run a process a large number of times. In /home/runX, I have process X, which accesses a file X.ini. X.ini contains 3 variables, as follows : X_date=ccccmm X_location=aaa X_type= t where date will be 200501 thru 200611 location will be aaa, bbb, ccc, or ddd type will be...

I have a load of files in a directory eg /home/test a b c ..... Z Each file has 2 header records & 2 trailer records which I wish to remove, leaving only the data in between. I then wish to copy all the output files to a different directory ie /home/test2 It will probably be...

I need to replace telnet and ftp with ssh & sftp when accessing VMS Servers (from AIX environment) I know that telnet <hostname> is replaced by ssh <userid>@<hostname> from the AIX prompt. But I have my ftp commands within scripts. ie vaxhost = x.y.z for file in $X do print...

How do I do the above ? I have a file A, which looks like a,b,c c,dddd e,f,g g,hhhh etc etc I need to do something like :- while read f1 f2 f3 f4 do ........ done < file A But f1 comes over with the whole line, and f2 f3 f4 are not set. How do I tell it to recognise the commas as...