How would I go about making a collapsible drill down report

Stimulsoft Reports.Silverlight discussion
nitinsobti
Posts: 19
Joined: Wed Sep 19, 2012 3:07 pm

How would I go about making a collapsible drill down report

Post by nitinsobti »

We are prototyping a report similar to the attachment with this topic in Silverlight and using the MVVM framework. How would you go about doing something like this using your Silverlight Reporting solution?
Attachments
Example Report.png
Example Report.png (91.26 KiB) Viewed 5237 times
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: How would I go about making a collapsible drill down rep

Post by HighAley »

Hello.

It's possible to create such report. You should use cross-tab component.
Do you have any difficulties with it?

Thank you.
nitinsobti
Posts: 19
Joined: Wed Sep 19, 2012 3:07 pm

Re: How would I go about making a collapsible drill down rep

Post by nitinsobti »

Can you provide me with some documentation on how to use this control? We are generating these reports dynamically in code.
nitinsobti
Posts: 19
Joined: Wed Sep 19, 2012 3:07 pm

Re: How would I go about making a collapsible drill down rep

Post by nitinsobti »

Is there a MSDN type documentation available somewhere?
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: How would I go about making a collapsible drill down rep

Post by HighAley »

Hello.

At first you could see our Live Demo:
http://sl.stimulsoft.com/

Then you could download our trial version which has no any limitation except Demo watermark.
http://www.stimulsoft.com/en/downloads

Next step is to read Stimulsoft Reports.Silverlight Viewer Developer FAQ and Stimulsoft Reports Designer.Silverlight Developer FAQ:
http://www.stimulsoft.com/en/documentation

Watch the Quick Start for Silverlight video section from
http://www.stimulsoft.com/en/videos

After that you could find answers on our forum:
http://forum.stimulsoft.com/
and knowledge base:
http://stimulsoft.helpserve.com/index.p ... se&_a=view

Write us if you will have any additional questions.

Thank you.
nitinsobti
Posts: 19
Joined: Wed Sep 19, 2012 3:07 pm

Re: How would I go about making a collapsible drill down rep

Post by nitinsobti »

Hi,

I have attached my report with this post. How would I create group drill downs for all the average balance rows as shown in my previous attachment?

Thanks.
Attachments
BalanceSheetReport.mrt
(19.28 KiB) Downloaded 324 times
nitinsobti
Posts: 19
Joined: Wed Sep 19, 2012 3:07 pm

Re: How would I go about making a collapsible drill down rep

Post by nitinsobti »

Also, when I try to create a relation between 2 business objects, the parent and child datasource dropdown is empty. Please advise.
nitinsobti
Posts: 19
Joined: Wed Sep 19, 2012 3:07 pm

Re: How would I go about making a collapsible drill down rep

Post by nitinsobti »

Anybody? No help?
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: How would I go about making a collapsible drill down rep

Post by HighAley »

Hello.

Please, send us a working sample project which reproduces the issue.

Thank you.
nitinsobti
Posts: 19
Joined: Wed Sep 19, 2012 3:07 pm

Re: How would I go about making a collapsible drill down rep

Post by nitinsobti »

Hi,

Below is the code that I am using to populate the Business Objects. Attached are the report and the screenshot of the report.

Code: Select all


 private List<BalancesItem> _balancesItems = new List<BalancesItem>();
        public List<BalancesItem> Balances
        {
            get { return _balancesItems; }
            set { _balancesItems = value; }
        }


private void GenerateReport()
        {
            var stream = System.Reflection.Assembly.GetExecutingAssembly().GetManifestResourceStream("Budgeting.BalanceSheetReport.mrt");
            var report = new StiReport();
            report.Load(stream);
            stream.Close();
            stream.Dispose();
            StiPage page = (StiPage)report.GetComponentByName("Page1");
            page.UnlimitedWidth = true;
            page.SegmentPerWidth = 3;


            foreach (var combinedScenarioTime in InteractiveDataContext.CombinedScenarioTimes)
            {
                var balancesItem = new BalancesItem();
                try
                {
                    balancesItem.HorizonMonth = string.Format("{0}{1}{2}", combinedScenarioTime.Month,Environment.NewLine, combinedScenarioTime.TimeType);
                    balancesItem.AverageBalanceACT = 11111;
                    balancesItem.AverageBalanceCP = 22222;
                    balancesItem.AverageBalanceNB = 33333;
                    balancesItem.BalanceTypeId = 1;
                    balancesItem.EndingBalance = 99999;
              

             
                }
                catch (Exception)
                {
                    
                }
                finally
                {
                    Balances.Add(balancesItem);
                }
               
            }
          
            report.RegBusinessObject("StimulsoftBalanceSheetViewModel", "StimulsoftBalanceSheetViewModel",this);
            report.Render();
            StimulsoftReport = report;
           
        }

 public class BalancesItem
    {
        public double? AverageBalanceACT { get; set; }
        public double? AverageBalanceCP { get; set; }
        public double? AverageBalanceNB { get; set; }
        public double? EndingBalance { get; set; }
        public string HorizonMonth {get;set;}
        public int BalanceTypeId { get; set; }
    }
Attachments
Screenshot
Screenshot
screenshot.jpg (64.31 KiB) Viewed 5191 times
BalanceSheetReport.mrt
Report
(19.85 KiB) Downloaded 455 times
Locked