I won't know where in the string "5679" will be, but...

If it is in that textbox (in the details row), I have to display a
drill down row underneith that record.
Any help is appreciated.
TrintWhat do you want to display there ? I detailed row exists for that row where
the '5679' exist you add a new group ti the table, for this etailed group
you can then handle the toggle to tell the report that it only has to toggle
or to be visible if the textbox.Value has a specific value.
HTH, Jens Süßmeyer.
--
http://www.sqlserver2005.de
--
"trint" <trinity.smith@.gmail.com> schrieb im Newsbeitrag
news:1113850634.959940.237640@.o13g2000cwo.googlegroups.com...
> If it is in that textbox (in the details row), I have to display a
> drill down row underneith that record.
> Any help is appreciated.
> Trint
>|||Ok,
This is what I don't understand. The hidden rows with downline dealers
only has '5678'. But the visible row that needs a drill down might
have in the dealerlineageid (which is a field not to be displayed)
'5678' and 2754 and 10 other dealer numbers (multiple dealer numbers).
How would I know if 5678 is in there as a value? If it has multiple
dealer numbers separated by commas? Wouldn't the expression for the
"hidden" value need to be a substring query? How would I do that?
Thanks,
Trint

I need to have a drill down...

Ok here it is:
this row is always visible:
dealernumber dealername dealerlineageid
+(show a drilldown under each dealernumber if a number in the table
this additional row comes from contains any matching string in their
number with "dealerlineageid" number on the row above them.
In other easier words, hide all rows below each dealer, unless there is
a matching number in the dealerlineageid number in the details row.
Thanks,
TrintInsert a group under the detail row. The detail row should just contain
a cell with value Fields!dealernumber.Value. Insert a group under that,
and group by dealername (and dealerlineageid if you wish). Then, in the
group header (and footer if necessary) rows, put all necessary values.|||It looks like a hide expression on the field containing the string I
need to compair with would be more efficient. But how would the
expression be if if is needing to query the string since the string
contains more than one dealer number, but also has the one I need to
display what I am originally hiding?
Thanks,
TRint
Bassist695 wrote:
> Insert a group under the detail row. The detail row should just
contain
> a cell with value Fields!dealernumber.Value. Insert a group under
that,
> and group by dealername (and dealerlineageid if you wish). Then, in
the
> group header (and footer if necessary) rows, put all necessary
values.