dcsimg
Results 1 to 9 of 9

Thread: Open Source RDL: My-FyiReporting

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Apr 2011
    Posts
    75

    Thumbs up Open Source RDL: My-FyiReporting

    It appears that My-FyiReporting is the sole active fork of the old (now defunct) FyiReporting, so I've started a new thread to share my findings.

    It seems to me that it has great promise if the potential users could be assured of continued development and support.
    For those of us wishing to avoid the cost and complexity of full blown reporting options, this simple option may suit us perfectly. It just needs to gain a critical mass of followers to snowball onwards.

    I have emailed the project maintainer Peter, and he says, promisingly :
    "I am hosting my code https://github.com/majorsilence/My-FyiReporting and hopefully that will encourage some more active development from others.
    I will generally only be fixing bugs that affect me or adding features that I need. However patches from others is very much encouraged."


    Now, the good news is that it costs nothing to play with it. There are both .MSI and .ZIP downloads at
    https://github.com/majorsilence/My-F...ting/downloads
    and I unzipped 4.5.0-my-fyi-build-dot-net-4-x86.zip into a test folder and found that it works without installing or registering anything, so it won't work its tentacles into your setup if you're nervous about such things!

    The zip file contains 18 files, a collection of .EXE and .DLL along with some config XML files. I'm ignoring the server and map stuff, as I just want to design a report and then make it appear from my vb.net app.

    Designer : RdlDesigner.exe

    The standalone designer loads the previously loaded report, or has a new report wizard. It looks like this:
    Name:  Designer.gif
Views: 6229
Size:  44.7 KB

    In the wizard, I kept the default SQL option and dialled in a connection string like :
    server=MYSERVER; database=MyTest; Integrated Security=SSPI
    - and it connected straight away, and listed the tables and fields. It was easy to write a SELECT query, using a button to copy field names, and as if my magic my report was there, looking like it would suit my requirements perfectly. The report was saved to a .RDL file containing XML as follows-

    Code:
    <?xml version="1.0" encoding="UTF-8"?>
    <Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
      <Description>
      </Description>
      <Author>
      </Author>
      <PageHeight>11in</PageHeight>
      <PageWidth>8.5in</PageWidth>
      <DataSources>
        <DataSource Name="DS1">
          <ConnectionProperties>
            <DataProvider>SQL</DataProvider>
            <ConnectString>server=MYSERVER; database=MyTest; Integrated Security=SSPI</ConnectString>
          </ConnectionProperties>
        </DataSource>
      </DataSources>
      <Width>7.5in</Width>
      <TopMargin>.25in</TopMargin>
      <LeftMargin>.25in</LeftMargin>
      <RightMargin>.25in</RightMargin>
      <BottomMargin>.25in</BottomMargin>
      <DataSets>
        <DataSet Name="Data">
          <Query>
            <DataSourceName>DS1</DataSourceName>
            <CommandText>SELECT field1, field2 FROM table1</CommandText>
          </Query>
          <Fields> .... etc...
    RdlReader.exe

    A report viewer control may be added your VB forms, but there is also a standalone reader. So I have been able to load an RDL file into that and there is my report.
    This is looking good, IMHO, I will keep you updated as I go...

    Reminder
    This is Open Source under the Apache License, Version 2.0 ( http://www.apache.org/licenses/LICENSE-2.0 ) so you can use it in your project and supply it to customers.
    Helpful documentation from the original project can be found at http://fyireporting.com/helpv4/
    along with Peter's newer wiki at https://github.com/majorsilence/My-FyiReporting/wiki
    Last edited by geek648; Aug 10th, 2012 at 06:59 AM.

  2. #2

    Thread Starter
    Lively Member
    Join Date
    Apr 2011
    Posts
    75

    Re: Open Source RDL: My-FyiReporting

    If you're happier with Open Source if you can build the project yourself from the source code, that's an easy download from the Zip button at
    https://github.com/majorsilence/My-FyiReporting/
    I created a 'MyFyiR' folder under MonoDev, that one being one I added in the same folder as the VB projects folder, and I unzipped the source code there.

    If you can't already work with C#, it works well with MonoDevelop, v3 can be downloaded from
    http://monodevelop.com/Download (Win/Linux/Mac)
    - you may need to install .NET Framework 4.0 and GTK# for .NET 2.12.10 (both easy to do from the links given)
    I'm pleased to find I can drag and drop an .sln onto the MonoDevelop desktop shortcut icon and it loads - it didn't in a previous version from a year or two ago.

    If you're only used to Visual Studio, MonoDevelop may seem slightly confusing at first. Project references are listed amongst the forms and modules, for instance. But you should find it possible to rebuild the RDLEngine using the relevant .sln solution in its folder, then set the references in other solutions so that they (referencing RDLEngine for 'fyireports.RDL' etc) build correctly.

    It gives me peace of mind knowing I can play with the project myself, and if I come up with anything useful I might actually find I'm contributing to Open Source at last

  3. #3
    New Member
    Join Date
    Aug 2012
    Posts
    1

    Re: Open Source RDL: My-FyiReporting

    While I usually use crystal reports in my day job I am fully committed to making sure that the fyiReporting project continues as https://github.com/majorsilence/My-FyiReporting. I find it a useful place to try out new ideas. If anyone is interested in the project I am available to answer questions.

    As geek648 mentioned it can be built in monodevelop. It can also be built using visual studio or sharp develop. The current build script produces .NET 3.5 and .NET 4.0 packages targeting x86 and x64. It includes a WPF (https://github.com/majorsilence/My-F...005-WPF-Viewer), Winform, and GTK# https://github.com/majorsilence/My-F...k-Viewer-Linux viewers. The designer is winforms and can be embedded in your applications.

    For basic information on using My-FyiReporting see its wiki https://github.com/majorsilence/My-FyiReporting/wiki.

    If a feature is missing or you want to fix a bug it is as simple as creating a fork on github and sending a pull request or opening an issue and attaching a patch. If you are interested in making changes to the code it is best to read https://github.com/majorsilence/My-F...iki/Contribute first.https://github.com/majorsilence/My-F...k-Viewer-Linux

  4. #4

    Thread Starter
    Lively Member
    Join Date
    Apr 2011
    Posts
    75

    Re: Open Source RDL: My-FyiReporting

    Thank You majorsilence for all your hard work and for joining in here.

    I'm delighted to share the news that with the latest version 4.5.2, we can now call RdlReader.exe from just about anywhere, passing it the report .rdl file as a parameter...

    DOS Batch
    Code:
    C:\data\FyiTests\test452>RdlReader.exe test.rdl
    VB
    Code:
            Dim ID As Integer
            ID = Shell("""C:\data\FyiTests\test452\RdlReader.exe"" C:\data\FyiTests\test452\test.rdl", , True, 100000)
    etc etc..... it should be possible to call it from any language that supports shelling out DOS commands... Powershell, Python, you name it

    Much easier than building the control into your own project's own forms - to start with at least. Gets you started on the shallow part of the learning curve!

  5. #5

    Thread Starter
    Lively Member
    Join Date
    Apr 2011
    Posts
    75

    Re: Open Source RDL: My-FyiReporting

    There have been updates to the Wiki, hopefully that makes it even more simple for newcomers.
    https://github.com/majorsilence/My-FyiReporting/wiki

    Guide to the New Report wizard
    https://github.com/majorsilence/My-F...ate-New-Report

    Introduction to the Report Designer
    https://github.com/majorsilence/My-F...esigner-Basics

    MS SQL connection strings
    https://github.com/majorsilence/My-F...008-Connection

    HTH

  6. #6

    Thread Starter
    Lively Member
    Join Date
    Apr 2011
    Posts
    75

    Re: Open Source RDL: My-FyiReporting

    Quick Update
    The project is still going strong, and has been renamed Majorsilence Reporting although My-FyiReporting lives on in the URLs involved!
    https://github.com/majorsilence/My-FyiReporting/#readme

  7. #7
    Hyperactive Member stingrae's Avatar
    Join Date
    Apr 2002
    Location
    Sydney
    Posts
    401

    Re: Open Source RDL: My-FyiReporting

    I had my hopes up as I've got my main application written in VB2010 with a lot of Crystal Reports, but I'm always getting errors with deploying it around the reports. So I'm trying to find a new lightweight reporting tool I can use with VS2015.
    Everytime I try and run a report with FYI / MajorSilence, I get this error.
    Name:  Capture.PNG
Views: 2114
Size:  7.7 KB
    "The passion lives to keep your faith, though all are different, all are great" ... Michael Hutchence 1960-1997.

    Windows & Web Developer
    Specialising in Visual Basic .Net & Client Server Programming & Client/Customer Relations Databases
    Sutherland Shire, Sydney Australia
    www.stingrae.com.au
    Developer of Arnold - Gym & Martial Arts Database Management System
    www.gymdatabase.com.au

  8. #8
    Hyperactive Member stingrae's Avatar
    Join Date
    Apr 2002
    Location
    Sydney
    Posts
    401

    Re: Open Source RDL: My-FyiReporting

    Ok, I finally got it working ...!
    A lot of useful information in this group: https://groups.google.com/forum/#!to...ng/S0kiuMcNAsE
    One thing I'll add to it with - when changing the DataSet, the DataSetName is case sensitive and is different to the Data Source name (seems obvious now, but took me a while to figure out).
    "The passion lives to keep your faith, though all are different, all are great" ... Michael Hutchence 1960-1997.

    Windows & Web Developer
    Specialising in Visual Basic .Net & Client Server Programming & Client/Customer Relations Databases
    Sutherland Shire, Sydney Australia
    www.stingrae.com.au
    Developer of Arnold - Gym & Martial Arts Database Management System
    www.gymdatabase.com.au

  9. #9
    New Member
    Join Date
    Jan 2018
    Posts
    1

    Re: Open Source RDL: My-FyiReporting

    As an intro, I program primarily in C# for the application that has used the old FyiReporting tool set (ver: 4.1.0.0). The problem I ran into when upgrading a customer's server from XP to Windows 10 Pro (new machine), my application gives me an error when attempting to print a report of data from a PostgreSQL table. I kept the same database version (8.4.5), but the C# interface tools (npgsql.dll and mono.security.dll) are newer versions (old ver: 1.0.5; new ver: 3.0.8). When running RDLDesigner Preview, it returns the message: no rows of data. The yellow triangle next to the Run Report button says:
    Severity: 4 - DataSource 'DS1'.
    Could not load file or assembly 'Npgsql.dll' or one of its dependencies.
    The system cannot find the file specified.
    Severity: 4 - Unable to connect to datasource 'DS1'.

    I'm hoping someone can shed some light on this. It seems I must be overlooking something. Possible that Npgsql.dll needs some other version(s) of .NET items?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Featured


Click Here to Expand Forum to Full Width