J
Jabeen
Hi
I have a dataview web part created in Front page for which the data source is a web service
2 of the columns the web service returns are as follows with sample data shown below
ColA Col
Xyz test/ReqdName/filename
While displaying the values for ColB, I want only the ReqdName obtained from the ColB value and using substring operations, I display the ReqdName.
<td class="ms-vb"><xsl:variable name="Temp" select="@ColB"/><xsl:variable name="Temp1" select="substring-after($TempLib,'/')"/><xsl:variable name="Temp2" select="substring-before($TempLib1,'/')"/><xsl:value-of select="$Temp2"/></td
While doing a Group By on these fields, I included the second option line code as follows
<option value="ColA" fieldtype="" title="ColA"><xsl:if test="$dvt_groupfield='ColA'"><xsl:attribute name="selected">yes</xsl:attribute></xsl:if>ColA</option><option value="$Temp2" fieldtype="" title="$Temp2"><xsl:if test="$dvt_groupfield='$Temp2'"><xsl:attribute name="selected">yes</xsl:attribute></xsl:if>Name</option>
From the page when I choose ColA from the Group By list box, it is grouping by perfectly
But when I choose the ‘Name’ value from the list box, it did not group by on Reqd Name
Am I missing something
How do I group by on fields which are not direct fields from the data source, but are modified/custom values
Please let me know
Thank
Jabee
I have a dataview web part created in Front page for which the data source is a web service
2 of the columns the web service returns are as follows with sample data shown below
ColA Col
Xyz test/ReqdName/filename
While displaying the values for ColB, I want only the ReqdName obtained from the ColB value and using substring operations, I display the ReqdName.
<td class="ms-vb"><xsl:variable name="Temp" select="@ColB"/><xsl:variable name="Temp1" select="substring-after($TempLib,'/')"/><xsl:variable name="Temp2" select="substring-before($TempLib1,'/')"/><xsl:value-of select="$Temp2"/></td
While doing a Group By on these fields, I included the second option line code as follows
<option value="ColA" fieldtype="" title="ColA"><xsl:if test="$dvt_groupfield='ColA'"><xsl:attribute name="selected">yes</xsl:attribute></xsl:if>ColA</option><option value="$Temp2" fieldtype="" title="$Temp2"><xsl:if test="$dvt_groupfield='$Temp2'"><xsl:attribute name="selected">yes</xsl:attribute></xsl:if>Name</option>
From the page when I choose ColA from the Group By list box, it is grouping by perfectly
But when I choose the ‘Name’ value from the list box, it did not group by on Reqd Name
Am I missing something
How do I group by on fields which are not direct fields from the data source, but are modified/custom values
Please let me know
Thank
Jabee