Thursday, August 30, 2012

How to get Vs2010 RDLC tablix to repeat group headers on each page

Go here do this:

http://www.codeease.com/how-to-repeat-table-header-on-every-page-in-rdlc-report.html

Incase it disappears here is the text of the workaround:
  1. Go to your Visual Studio RDLC design screen, please look at the right bottom corner in design part. There is a small black rectangle there. Click it and check what you can see:
  2. Yes, you can see “Advanced Mode”, please check on it.
  3. After you check on Advanced Mode, you will see Row Groups and Column Groups like below:
  4. Click “Static” in Row Groups list, and check the properties on the right side:
  5. Set “RepeatOnNewPage” to “True”.

Cascading Dropdowns in JcdcHelper

(Post by Lloyd Bates)
In this example, the parent Drop list is named "SepTypeCd" and the child is "SepReason".
When an item is selected in the parent the change event looks to see if a child list is required to be available, if a child menu is needed, it populates it, if not it disables the child dropdown control.
With this pattern, we get to use the Ajax Wrapper function to allow getting all the error handling built in as a bonus.
This example has the "if" statement in it, but it doesn’t have to have it.
 
        $(document).ready(function () {
           … …
            $(
"#SepTypeCd").change(SepTypeCdChange);
           … …
        });
 
       
function SepTypeCdChange() {
           
//Get selected item from parent drop list
           
var sepTypeCd = $('select[name=SepTypeCd] option:selected').val();
           
            
//Check if selected item should fire load of child drop.                                         
            
if ((sepTypeCd == "538") || (sepTypeCd == "540)
            {
               
//Set action url
               
var actionMethodUrl = '@Url.Action("GetSepReasonDD","StudentLookup")';
               
                
//make Ajax call to Get JSON, note: the param "Id" matches the param in the MethodAction.
                JcdcAjaxDoGetRetrieveJson(actionMethodUrl, GetDDLDataSuccess, {
"Id" : sepTypeCd } );
            }
           
else {
               
//If child is not to be used, clear options and disable it.
                $(
"#SepReasonCd").empty().end();
                $(
"#SepReasonCd").attr("disabled", "disabled");
            }
        }
       
//Success function can hold all your business logic for before and after drop list is loaded.
       
function GetDDLDataSuccess(jsonDDLDispValueCV) {
           
//Load all the options to the dropdown.
            LoadOptions(jsonDDLDispValueCV,
"SepReasonCd");
        }
       
//This function could be moved to JCDCAjax.js
       
function LoadOptions(jsonDDLDispValueCV, passedInSelectId) {
            
//clear old options from drop list
           
var reasons = $("#" + passedInSelectId).empty();
                       
            
//Load new items in drop list from Ajax data
            $.each(jsonDDLDispValueCV,
function(index, option) {
                reasons.append($(
'<option/>', { value: option.Value, text: option.Disp } ));
            });
           
//enable drop down
            reasons.removeAttr(
"disabled").end();
        }

Wednesday, August 8, 2012

How to get VS2010 Group Headers to repeat on each page.


How to get VS2010 Group Headers to repeat on each page.

Do this:

http://www.jasinskionline.com/technicalwiki/(S(hludmc45qohv1i45zwzg4445))/Repeating-Row-Headers-SSRS-2010.ashx?AspxAutoDetectCookieSupport=1

Note that all statis fir a give group have to ahve all 3 settings set or it errors
(it still give warnings after but it works).


How to find advanced mode (this fix does not work but it has pics to help you find it.)
http://www.codeease.com/how-to-repeat-table-header-on-every-page-in-rdlc-report.html