Designing a report for lightswitch desktop applicaiton

Jump to: Board index.NET FrameworkStimulsoft Reports.Silverlight

Stimulsoft Reports.Silverlight discussion

Designing a report for lightswitch desktop applicaiton

Post Tue Aug 29, 2017 5:39 am

Hello dear friends,
Hope to be fine and everything is going well.
I'm using Stimulsoft Report veiwer on my Lightswitch application (Desktop Client). I follow the video you shared on youtube https://www.youtube.com/watch?v=F90vaVA1kMs you shared. Everything is going well. but my problem is about my report.mrt file. how i should design my .mrt file to be able to show my report? currently there is nothing to show. I think i have a problem with business objects on my report.
Database Diagram.jpg
Database Diagram
Database Diagram.jpg (68.24 KiB) Viewed 68 times

Code: Select all
partial void ShowViewer_Execute()
        {
            // Write your code here.
            var findControl = this.FindControl("viewControl");
            findControl.ControlAvailable += delegate(object sender , ControlAvailableEventArgs e)
                {
                    StiReport report = new StiReport();

                    OpenFileDialog openFile = new OpenFileDialog();


                    if(openFile.ShowDialog() == true){
                        using(FileStream stream = openFile.File.OpenRead()){
                            report.Load(stream);
                            report.Dictionary.Clear();
                            report.RegBusinessObject("Demo " , "Demo", this.Patients);
                            report.Dictionary.SynchronizeBusinessObjects();
                            report.Render();
                        }
                    }

                };

if it's possible for you show me how to design a report to view the selected patient details on header and all it's orders. You can return the patientID with the following code.
Code: Select all
int PID = this.Patients.SelectedItem.PatientID;

I'm using Microsoft LightSwitch for Visual Studio 2013 and Microsoft SQL Server 2012.


FYI:
Currently i have a designed report but work with stored procedure from sql server and not related to the LightSwitch application. if you need more details i can send you in this post or by email.


Kind Regards
Homayoon Azimi
Attachments
PatientBillDetails.mrt
My MRT File
(66.71 KiB) Downloaded 3 times
Exp3rt
User avatar
 
Posts: 1
Joined: Mon Aug 28, 2017 7:46 pm

Re: Designing a report for lightswitch desktop applicaiton

Post Sat Sep 02, 2017 2:32 am

Hi Azimi,

Thank you for the explanation of the problem. Please send us a sample project to support[at]stimulsoft.com for analysis. If you could include a small extract from you db, that would be an ideal scenario. The attachment limit is only 7Mb there. Or a link to some online storage such as Dropbox,OneDrive or Google Drive would do yust fine.

Thank you,
Edward
Edward
 
Posts: 2694
Joined: Fri Jun 09, 2006 4:02 am


Return to Stimulsoft Reports.Silverlight

Who is online

Users browsing this forum: No registered users and 1 guest