DBR Grouping

MaureenKLM · Jun 4, 2007

FP 2002 with an Access 2002 DB

I have a DBR that lists names of players on teams. There are several
diferent teams with numerous players per team. I'd like to have the team
name (a separate field) and team logo (separate field linked to graphic)
appear ONCE and then the list of team members listed out in a horizontal line
towards the right -

Any ideas on how to do this?

Kathleen Anderson [MVP - FrontPage] · Jun 4, 2007

http://www.spiderwebwoman.com/thingumajig/one_to_many.htm

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others

MaureenKLM · Jun 5, 2007

Thanks for the link -

I tried to implement it but am getting a "type mismatch" error on fp_rs.
The field I am using to determine when the detail row should change it's
header is a TEXT field, not a number field. Would this make a difference?

MaureenKLM · Jun 5, 2007

I think I may be inserting the code in the wrong place. It's unclear to me
exactly where the suggested code should be inserted. What starts the "master
table results" area and what ends it? Is it the header row? Is it the
detail row? Somewhere in between?

My page - WITHOUT the code to adjust the line breaks - is at
www.chestersummerbasketball/csb/teamsdivision.asp I want the Team Name and
Team Logo to appear only once for each team - the player names shoudl be
listed horizontally under each team name/logo. Only the girls 7-8th division
has team names entered so far.

THANK YOU!

Kathleen Anderson [MVP - FrontPage] · Jun 5, 2007

Find this in your page:




there should be a <tr> immediately following it - that's the one you're
looking for.

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others.

MaureenKLM · Jun 5, 2007

Fantastic - location is everything...well almost everything.

I now have ONE LINE per team - each team has 9 players that should display
but only the first is displaying. I have the relationship of ONE-TO-MANY
established for the 1st field in the results (TEAM) and the qry used as the
source is sorted by team initially. Any clue what I'm missing now?

Kathleen Anderson [MVP - FrontPage] · Jun 5, 2007

Can you post the code beginning with:

through the end of the page?

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others.

MaureenKLM · Jun 5, 2007

THANKS SO MUCH!!



<%
If fp_rs("Team") <> savedID Then
savedID = fp_rs("Team")
%>
<tr>
<td>
<%=FP_FieldVal(fp_rs,"Team")%></td>
<td>
<%=FP_FieldVal(fp_rs,"Logo")%></td>
<td>
<%=FP_FieldVal(fp_rs,"PlayerName")%></td>
</tr>
<%
End If
%>

</tbody>
</table>

</body>

</html>

Kathleen Anderson [MVP - FrontPage] · Jun 5, 2007

I think the
<%
End If
%>

should be after the </td></tr>

just before the

startspan -->


--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others.

MaureenKLM · Jun 5, 2007

Didn't work - now the page completely errors out - here's the code showing
where I put the end if stmt



<%
If fp_rs("Team") <> savedID Then
savedID = fp_rs("Team")
%>
<tr>
<td>
<%=FP_FieldVal(fp_rs,"Team")%></td>
<td>
<%=FP_FieldVal(fp_rs,"Logo")%></td>
<td>
<%=FP_FieldVal(fp_rs,"PlayerName")%></td>
</tr>


</tbody>
</table>

</body>

</html>

MaureenKLM · Jun 5, 2007

Silly of me - the end if clause didn't save as part of the file becasue I
can't edit FP BOT codes - it just reverts back to what it was before.
Therefore, I'm unable to edit the code as you suggest. I've played with some
other placement attempts but am unsuccessful in getting the detail to print
out - any more suggestions? The "TIP" seemed so simple....I've no idea why
this is not working...

Kathleen Anderson [MVP - FrontPage] · Jun 5, 2007

Hi:
I don't see the End If in what you posted.

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others.

Kathleen Anderson [MVP - FrontPage] · Jun 5, 2007

If it wouldn't let you save it, then you put it in the wrong place.

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others.

MaureenKLM · Jun 5, 2007

I really appreciate your continued assistance - I know we'll get this working.

Forgive me - but I think you suggested I put the <% End If %> code INSIDE of
the FP Webbot code which is why the clause was not included in what I sent
you - I should have noticed myself before sendintg it to you.

I've now got the End If clause immediately after where I beleive the </td>
and </tr> are - I see ONE line of detail only. I'm looking at my query now -
I used a quesry that joined the two tables as the sourse instead of creating
a custom query within the DBRW -

Kathleen Anderson [MVP - FrontPage] · Jun 5, 2007

Can you post your query?

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others

MaureenKLM · Jun 6, 2007

Hello THere - I got it working - I needed to add a 2nd row to the table and
it all worked. PHEW!

Now here's the glitch - I started playing with the format and placement of
info in an attempt to improve the overall look/layout - didn't like that and
although I put everything back in the original table cell/location, it was no
longer displaying correctly. I was forced to regenerate the DBR and...lost
the coding to get the grouping.

I think I'm back to needing just some help on the PLACEMENT of the asp
statements - Below is the code - could you please take a look and let me know
WHERE to put the appropriate code?



<%
If fp_rs("Team") <> savedID Then
savedID = fp_rs("Team")
%>
<tr>
<td width="185"><font size="4" face="Arial Black">

<%=FP_FieldVal(fp_rs,"Team")%></font></td>
<td width="96"><img border="0"
src="<%=FP_FieldLink(fp_rs,"Logo")%>"></td>
<td width="597"> </td>
</tr>
<tr>
<td width="185"> </td>
<td width="96"> </td>
<td width="597"><font face="Arial" size="2">
<%=FP_FieldVal(fp_rs,"PlayerName")%></font></td>
</tr>
<%
End If
%>

</tbody>
<tbody>


</tbody>
</table>

</form>

</body>
</html>
THANKS!

Kathleen Anderson [MVP - FrontPage] · Jun 7, 2007

I think the
<%
End If
%>

should be after the </td></tr>

just before the

startspan -->


--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others

Parameter in DBR	6	Aug 29, 2007
editing a table thru a form	0	Jul 22, 2010
editing a table thru a form	15	Jul 22, 2010
automatically insert autoshapes when cells are updated?	0	Jan 29, 2010
Table relationships and lookups	1	Jan 19, 2010
DBR Dropw Down Search Retains selection after submit	2	Apr 23, 2007
Form field value passed	1	Mar 31, 2007
Synchronizing lists or views between worksheets	2	Jul 2, 2008

DBR Grouping

MaureenKLM

Kathleen Anderson [MVP - FrontPage]

MaureenKLM

MaureenKLM

Kathleen Anderson [MVP - FrontPage]

MaureenKLM

Kathleen Anderson [MVP - FrontPage]

MaureenKLM

Kathleen Anderson [MVP - FrontPage]

MaureenKLM

MaureenKLM

Kathleen Anderson [MVP - FrontPage]

Kathleen Anderson [MVP - FrontPage]

MaureenKLM

Kathleen Anderson [MVP - FrontPage]

MaureenKLM

Kathleen Anderson [MVP - FrontPage]

Ask a Question

Similar Threads