Cacher is the code snippet organizer for pro developers

<cms:CMSRepeater ID="RepeaterCourses" runat="server" ClassNames="Northtec.CoursePages"
TransformationName="northtec.coursepages.northtec-courseslistinginprogrammes"
Path="./%" SelectOnlyPublished="true" StopProcessing="false" WhereCondition="" DelayedLoading="false" OrderBy="NodeOrder ASC"  HideControlForZeroRows="false" ZeroRowsText="No Data Found" SelectTopN="100" MaxRelativeLevel="-1" /> 
WhereCondition=<%# "<columnName>='"  +  CMS.CMSHelper.CMSContext.CurrentResolver.ResolveMacros("<macro>")  +  "'" %>

If this doesn’t work with the repeater then try Universal Document Viewer webpart.
You can use the ASCII character to ignore the single quotes----- &#39;
To add a where condition to the nested repeater add this code:
DelayedLoading="true" 
WHERE Condtion within Transformation
<script runat="server">
    protected override void OnInit(EventArgs e)
    {
        base.OnInit(e);
        repSubCategories.WhereCondition= "Rohe LIKE '%" +  Eval("LocationID") + "%'";
        repSubCategories.ReloadData(true);        
    }
</script>

Nice Link for nested repeater:
http://devnet.kentico.com/Knowledge-Base/Web-parts-Controls/How-to-use-query-repeater-as-nested-repeater.aspx

Another Example:
<cms:CMSRepeater ID="rptListerAll" runat="server"
ClassNames="custom.BanhamProduct"
TransformationName="custom.BanhamProduct.ListerAll" SelectedItemTransformationName="custom.BanhamProduct.Detail" 
OrderBy="Price DESC"
ShowEditDeleteButtons="false"
Path="/{0}/{1}/{2}/{3}/%"
MaxRelativeLevel="1"
PagerControl-Enabled="true" 
PagerControl-PageSize="12" 
PagerControl-HideOnSinglePage="false" 
PagerControl-BackText="Prev" 
PagerControl-NextText="Next" 
PagerControl-ShowPageNumbers="true"
PagerControl-ShowFirstLast="false"
PagerControl-PagerPosition="Top" >
<HeaderTemplate><ul class="Sub-SubCategory striped-list"></HeaderTemplate><FooterTemplate></ul></FooterTemplate>  
</cms:CMSRepeater>


Help Links:
http://devnet.kentico.com/Forums/f55/t29353/nested-repeater-contentBefore,-container.aspx


Nested Nested Repeater
This can be done by adding the same line cms:cmsrepeater inside the transformation again but to do that add the below code to the primary transformation
NestedControlsID="repSubCategoriesSubSub"


NodeAlias path
Path='<%# Eval("NodeAliasPath")+ "%" %>'
<cc1:CMSRepeater DelayedLoading="true" StopProcessing="true" … 
<script runat="server">
protected void Page_PreRender(object sender, EventArgs e)
{
repeaterId.StopProcessing = false;
repeaterId.ReloadData(true);
}
</script>