Search results for query: *

Thanks lbass, but it doesn't.

Thanks for your help Madawc. My problem is I don't know how to build the formula to identify when the SP returns no rows.

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

many thanks satinshouette

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 ?

Thanks Ian Option 2 is best for me. Can you tell me also how to produce a right pointing arrow, within a blue circlar background ? This again should be displayed or not, depending on a parameter. Windings doesn't give such a representation.

Thanks Telemachus This works great. However, I now need to display spaces instead of an empty box if @variable isn't a tick, and I can't apply a formula as above for a drawn box. Is there another approach ?

Thanks Telemachus : this works great : I had to use lower case "a", & I learned a bit more about Crystal.

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

Thanks Jason I use Crystal XI. I don't get export > excel > data only > custom, "column width based on objects in the details". XI gives the path I sent in the last email.

Hi Jason Yes: all items are in the Details section. I have zoomed to 200%, and there is nothing obvious either side of where the subreport is defined. I select File > Export > Export Report then Format - Microsoft Excel 97-2000 - Data Only (XLS) Destination - Application then defaults...

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

It' OK : I have resolved this !

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

I have implemented the above suggestion, and it works fine. Many thanks

Thanks LB. Rather than reposting to the other forums you are suggesting, can you advise what you mean by {table.fieldA} ? FieldA in my example is from an SP. I have coded if {?Group on fieldA} = "Yes" then {SP.fieldA} End If but get a syntax error. Many thanks

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 ?