Search results for query: *

Well, if I couldn't amuse you, who would? I guess I forgot about the ability to increase the viewing the zoom, to about 200-300%. This allowed me to get a better view on the edges.... So that worked.

OK. So this may be the most boring topic going on TT right now but I had to ask.... I'm using CR 8.0. I'm trying to draw Vertical lines to make a grid. My lines are "meeting up" with the exterior box but the top part of the vertical line is extending oh so slightly past the box. I am aware of...

Thanks for all the info. I think I do need a cursor as I need to process the data depending on the returned data. Thanks to all.

I'm using Oracle 9i. I'm creating a Db procedure that will retrieve data and I'm planning on using a cursor to loop through the returned data to insert into a table. The only problem is that I'm a newbie to Cursors...my Db expertise is low. So what I am asking is how to go about defining a...

Thanks to both for the quick response and helpful tip!

Using Excel 2002. I have a simple formula which adds up multiple columns .. =SUM(A1:A84) but is there a way to add a text string to the end result? so my result would read something like "895 minutes" (without the quotes)? Thanks

Thanks for the reply as I'm still stumped.... I'm not too sure we are on the same page. Currently, I have main report that contains a value in the Gross_QTY field, say 100. The subreport is linked on a field that contains recordIDs for sets of members. I can't seem to link to a formula field...

It appears that I cannot group on this value though...I would like to return data based on this running total value. I.E Give me data for set #1 until the set # that equals the gross QTY.

Using CR v8.0. On the main report I have a database field GROSS_QTY that contains a value. This main report also contains a subreport. I would like to link this subreport to a running total variable off this GROSS_QTY value. I also will group off this variable in the subreport i.e if GROSS_QTY...

Definitly follow synapsevampire's advice... Is the information in the Page Header or the Report Header section? It sounds as though it's in the Report Header only...If the info is in the Page Header section it will print at the top of each page.

I have reversed 4 & 5, thanks for seeing that! The result is still the same... My IF statement is as follows: If IsNull(VW_GEO.LOCATIONS) Then x := 'N'; If "Stores" in Places Then x := 'Y' Else x := 'N'; x Same issue, weird...

I originally posted this in the wrong forum...Sorry. using CR 8. When I use the below formula, it appears that the formula returns a null, so I'm using the IsNull() to trap it. If I comment lines 4 & 5, I return "N/A". If I don't it continues to return a null... any ideas...

Let me elaborate on what I want... The array Places may contain a particular location, if it does, I want it to display "Y", else "N" but if the field {VW_GEO.LOCATIONS} is null, I want it to display "N" as well... Here is my formula that handles everything fine except nulls...

using CR 8. When I use the below formula, it appears that the formula returns a null, so I'm using the IsNull() to trap it. If I comment lines 4 & 5, I return "N/A". If I don't it continues to return a null... any ideas?? whilereadingrecords; StringVar x; StringVar Array Places...

Just an update on how this was achieved: Created a subreport in the reports Details section. Formated this Details section with mulitple columns, set column width to 3.5. In the subreport, I suppressed the Details section and placed this formula in the group footer to concatenate the members...

Here is what I am doing right now.... I have a grouping on the formula, and the group options section is not choosen...

That's great...The only thing, and I am very thankful for your assistance but the report is printing the results vertically and then, if the total number of sets is great, prints the second column.. Something like this: set 1 set 4 ...data.. ...data.. ...data...

Thanks for the tip...I'll play around with it. I'll post back shortly my results. The one thing that I am trying to do as well is to create an array containing all members for each set and then group on sets....is that even possilbe?

The number of Sets can vary...no rhyme or reason in the variance either...

I'm using CR v8.0.1. I've been able to get data to display horizontally but not exactly to my liking. When printing vertically, the data looks like this: Set #1 Member(s): Notes: Tim Mark Chris Set #2 Member(s): Notes: 2 Sue Travis The...