Re: Detail Records in one field
From: rikesh (rikesh_patel_at_website.com)
Date: 08/26/04
- Next message: Jen: "CrossTabs"
- Previous message: Rob Diamant: "Re: missing the basics"
- In reply to: Bob Holmes: "Re: Detail Records in one field"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 26 Aug 2004 14:41:59 +0100
Thanks Bob, let me try this!!!
"Bob Holmes" <rholmes@REMOVEmmwec.org> wrote in message
news:%23ATkWZ2iEHA.3632@TK2MSFTNGP09.phx.gbl...
> Are you sure that you are trying to reset it in the right group header?
> If you can't see why it isn't working, you could insert a section below
the
> one where the variable is being displayed (ex. group footer 2b) and put
your
> reset formula there. Technically, you could put it in the same section
and
> use 'evaluateafter(YourDisplayFormula)' so that you see the result before
> you reset it.
>
> --
> Bob Holmes MCNGP #31
> "rikesh" <rikesh_patel@website.com> wrote in message
> news:OGBVzM2iEHA.712@TK2MSFTNGP09.phx.gbl...
> > Cool, suggestion, however, mine doesn't have that prob, yet, after
closer
> > inspection, it appears that the variable doesn't reset and instead, gets
> > bigger and bigger, appending the result from the last group.....
> >
> > Can't work out why this is so........
> >
> >
> > "Bob Holmes" <rholmes@REMOVEmmwec.org> wrote in message
> > news:%23O2ORI2iEHA.2688@TK2MSFTNGP15.phx.gbl...
> > > Rikesh,
> > >
> > > What I have done in the past is to create multiple variables and use a
> > > formula basically like this:
> > > If length(variable1) < 240 then variable1 := variable1 + MyField else
> > > If length(variable2) < 240 then variable2 := variable2 + MyField
else...
> > >
> > > This should keep building up the first variable until it gets as large
> as
> > > you can get it without exceeding 254 characters. If it gets too close
> to
> > > accommodate another concatenation, then start filling another
variable,
> > etc.
> > >
> > > I think I had to have six variables in one of my reports in order to
> > handle
> > > all of the necessary records. It is definitely a clunky work-around,
> but
> > it
> > > did the job. If you have no reasonable limit to the size of this
> string,
> > > you may have to create some large number of variables, which may
become
> a
> > > huge burden.
> > >
> > > --
> > > Bob Holmes MCNGP #31
> > > "rikesh" <rikesh_patel@website.com> wrote in message
> > > news:#fD4ei0iEHA.3048@TK2MSFTNGP09.phx.gbl...
> > > > Hi Bob
> > > >
> > > > For this report I have to use CR8.5......
> > > >
> > > > Any ideas??
> > > >
> > > > Kind Regards
> > > >
> > > > Rikesh
> > > >
> > > >
> > > >
> > > > "Bob Holmes" <rholmes@REMOVEmmwec.org> wrote in message
> > > > news:O17dgMtiEHA.3172@tk2msftngp13.phx.gbl...
> > > > > Your initial post says CR8.5-CR9.
> > > > > Are you using CR8.5? I don't think you have this limitation in
CR9.
> > I
> > > > seem
> > > > > to remember seeing 65,000+ characters as a limit.
> > > > >
> > > > > --
> > > > > Bob Holmes MCNGP #31
> > > > > "rikesh" <rikesh_patel@website.com> wrote in message
> > > > > news:#7XknWsiEHA.2992@TK2MSFTNGP12.phx.gbl...
> > > > > > Hi Bob, got the formula working, but there's a prob!!!
> > > > > >
> > > > > > It doesn't seem to reset.....It's just builds up and up and
> reaches
> > > the
> > > > > > dreaded 254 formula character limit....
> > > > > >
> > > > > > Any ideas?
> > > > > >
> > > > > > I print the formula in the GF and reset in the GH...
> > > > > >
> > > > > > Kind Regards
> > > > > >
> > > > > > Rikesh
> > > > > >
> > > > > >
> > > > > > "Bob Holmes" <rholmes@REMOVEmmwec.org> wrote in message
> > > > > > news:ehTVASdiEHA.592@TK2MSFTNGP11.phx.gbl...
> > > > > > > Yes. Reset it wherever you feel it is most appropriate.
> > > > > > >
> > > > > > > --
> > > > > > > Bob Holmes MCNGP #31
> > > > > > > "rikesh" <rikesh_patel@website.com> wrote in message
> > > > > > > news:#P1UJMdiEHA.2992@TK2MSFTNGP12.phx.gbl...
> > > > > > > > Would I have to reset the variable then, perhaps in the
group
> > > footer
> > > > > or
> > > > > > > > Header??
> > > > > > > >
> > > > > > > >
> > > > > > > > "Bob Holmes" <rholmes@REMOVEmmwec.org> wrote in message
> > > > > > > > news:OTb4oEdiEHA.1344@TK2MSFTNGP11.phx.gbl...
> > > > > > > > > If each of the items that are concatenated are in
different
> > > > records,
> > > > > > > then
> > > > > > > > > each line of the 'details' section will add a new word.
You
> > > have
> > > > to
> > > > > > > make
> > > > > > > > > sure the formula field is set to 'Can Grow' if you want to
> see
> > > the
> > > > > > > string
> > > > > > > > > being built with each record.
> > > > > > > > > Ex.
> > > > > > > > > YourField: Formula:
> > > > > > > > > Software1 Software1
> > > > > > > > > Software2 Software1,
> > > > > > > > > Software2
> > > > > > > > > Software3 Software1,
> > > > > > > > > Software2,
> > > > > > > > > Software3
> > > > > > > > > Software4 Software1,
> > > > > > > > > Software2,
> > > > > > > > > Software3,
> > > > > > > > > Software4 .......
> > > > > > > > > You would need to insert another formula in your group
> footer
> > > that
> > > > > > > > displays
> > > > > > > > > the value of the variable.
> > > > > > > > >
> > > > > > > > > --
> > > > > > > > > Bob Holmes MCNGP #31
> > > > > > > > > "rikesh" <rikesh_patel@website.com> wrote in message
> > > > > > > > > news:uUlYC6ciEHA.3288@TK2MSFTNGP10.phx.gbl...
> > > > > > > > > > Hi Bob
> > > > > > > > > >
> > > > > > > > > > Thanks for the reply, I understand what you've wrote,
but
> > not
> > > > > quite
> > > > > > > sure
> > > > > > > > > on
> > > > > > > > > > how the string builds up, I assume there has to be a
loop,
> > or
> > > a
> > > > > For
> > > > > > > > > Next???
> > > > > > > > > >
> > > > > > > > > > Kind Regards
> > > > > > > > > >
> > > > > > > > > > Rikesh
> > > > > > > > > >
> > > > > > > > > > "Bob Holmes" <rholmes@REMOVEmmwec.org> wrote in message
> > > > > > > > > > news:OL3G69RiEHA.1972@TK2MSFTNGP09.phx.gbl...
> > > > > > > > > > > Sure,
> > > > > > > > > > > If Software1, Software2, etc. are values of the
same
> > > > field,
> > > > > in
> > > > > > > > > > different
> > > > > > > > > > > records, I would insert a formula in the details
section
> > > that
> > > > > > looks
> > > > > > > > like
> > > > > > > > > > > this:
> > > > > > > > > > > Shared StringVar MySoftware;
> > > > > > > > > > > MySoftware := MySoftware + {Table.MyField} + chr(13)
> > > > > > > > > > >
> > > > > > > > > > > This should provide you with the results you are
looking
> > > for,
> > > > I
> > > > > > > think.
> > > > > > > > > > >
> > > > > > > > > > > --
> > > > > > > > > > > Bob Holmes MCNGP #31
> > > > > > > > > > > "rikesh" <rikesh_patel@website.com> wrote in message
> > > > > > > > > > > news:#z$ZzkRiEHA.4056@TK2MSFTNGP09.phx.gbl...
> > > > > > > > > > > > Hi Bob
> > > > > > > > > > > >
> > > > > > > > > > > > Thanks very much for your reply....I've been pulling
> my
> > > hair
> > > > > out
> > > > > > > on
> > > > > > > > > this
> > > > > > > > > > > > prob for sometime....and revisiting it on many
> occasions
> > > > with
> > > > > no
> > > > > > > > > > > success????
> > > > > > > > > > > >
> > > > > > > > > > > > could you please elaborate on the idea of using
Shared
> > > > > > Variables,
> > > > > > > in
> > > > > > > > > > this
> > > > > > > > > > > > context??
> > > > > > > > > > > >
> > > > > > > > > > > > Kind Regards
> > > > > > > > > > > >
> > > > > > > > > > > > Rikesh
> > > > > > > > > > > >
> > > > > > > > > > > > "Bob Holmes" <rholmes@REMOVEmmwec.org> wrote in
> message
> > > > > > > > > > > > news:uO1BufRiEHA.704@TK2MSFTNGP12.phx.gbl...
> > > > > > > > > > > > > Hi Rikesh,
> > > > > > > > > > > > > If Software1, Software2, etc are all fields in
> the
> > > > same
> > > > > > > > record,
> > > > > > > > > > then
> > > > > > > > > > > > you
> > > > > > > > > > > > > can certainly place a text field on your report
and
> > drag
> > > > > each
> > > > > > of
> > > > > > > > > these
> > > > > > > > > > > > > fields into the text field. If they are values of
> the
> > > > same
> > > > > > > field
> > > > > > > > in
> > > > > > > > > > > > > different records, then, in order to display them
in
> a
> > > > > single
> > > > > > > > field,
> > > > > > > > > > you
> > > > > > > > > > > > > might have to use a formula with a shared variable
> in
> > > > order
> > > > > to
> > > > > > > > > collect
> > > > > > > > > > > all
> > > > > > > > > > > > > of the data and concatenate one value on to the
> next.
> > > > > > > > > > > > >
> > > > > > > > > > > > > --
> > > > > > > > > > > > > Bob Holmes MCNGP #31
> > > > > > > > > > > > > "rikesh" <rikesh_patel@website.com> wrote in
message
> > > > > > > > > > > > > news:#5g011QiEHA.536@TK2MSFTNGP11.phx.gbl...
> > > > > > > > > > > > > > Hi
> > > > > > > > > > > > > >
> > > > > > > > > > > > > > I'm have a report, which I wish to show the
> Details
> > > > Data,
> > > > > in
> > > > > > > one
> > > > > > > > > > > field,
> > > > > > > > > > > > > > going horizontally, rather than many Detail
Rows.
> > > > > > > > > > > > > >
> > > > > > > > > > > > > > For example:
> > > > > > > > > > > > > >
> > > > > > > > > > > > > > Group Header : Company Name
> > > > > > > > > > > > > >
> > > > > > > > > > > > > > Details : Software1
> > > > > > > > > > > > > > Details : Software2
> > > > > > > > > > > > > > Details : Software3
> > > > > > > > > > > > > > Details : Software4
> > > > > > > > > > > > > >
> > > > > > > > > > > > > > I would prefer, the following format, is that
> > > possible;
> > > > > > > > > > > > > >
> > > > > > > > > > > > > > Group Header : Company Name
> > > > > > > > > > > > > >
> > > > > > > > > > > > > > Details : Software1 / Software2 / Software3 /
> > > Software4
> > > > > > > > > > > > > >
> > > > > > > > > > > > > > Is this possible??
> > > > > > > > > > > > > >
> > > > > > > > > > > > > > Any ideas or suggestions, would be most welcome.
> > > > > > > > > > > > > >
> > > > > > > > > > > > > >
> > > > > > > > > > > > > > --
> > > > > > > > > > > > > > Kind Regards
> > > > > > > > > > > > > >
> > > > > > > > > > > > > > Rikesh
> > > > > > > > > > > > > > (CR8.5-CR9.0/W2K/SQL2K)
> > > > > > > > > > > > > >
> > > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
- Next message: Jen: "CrossTabs"
- Previous message: Rob Diamant: "Re: missing the basics"
- In reply to: Bob Holmes: "Re: Detail Records in one field"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
