How to use Object Data Source in Report Designer

10 posts, 1 answers
  1. Don
    Don avatar
    18 posts
    Member since:
    Feb 2013

    Posted 13 Mar 2013 Link to this post

    I've used the designer with SQL and that works fine but I need to use a business object as a data source. I see under the Data tab the Object Data Source but Available data source types is empty (not surprisingly). How can I tell the designer where to find my objects?

    Thanks,
    Don Rule
    http://tranlslationalsoftware.com

    OK, I think that I have found a section of the config file but still not able to see 

    <Telerik.Reporting>
    <AssemblyReferences>
    <add name="C:\PortalApp\ReportLibrary\bin\Debug\ReportLibrary.dll" version="1.0.0.0" />
          <add name="C:\PortalApp\ReportLibrary\bin\Debug\CdssModels.dll" version="1.0.0.0" />
          <add name="C:\PortalApp\ReportLibrary\bin\Debug\Utilities.dll" version="1.0.0.0" />
    </AssemblyReferences>
    </Telerik.Reporting>
  2. Answer
    Obi-Wan Kenobi
    Obi-Wan Kenobi  avatar
    460 posts
    Member since:
    Aug 2007

    Posted 14 Mar 2013 Link to this post

    In the assembly references only the name should be specified(without .dll and pathToDll). E.g.
    <Telerik.Reporting>
    <AssemblyReferences>
    <add name="MyCustomDllName" version="1.0.0.0" />
    </AssemblyReferences>
    </Telerik.Reporting>

    The path should be defined in the probing element:
    http://msdn.microsoft.com/en-us/library/823z9h8w.aspx
    You can't use absolute paths. The path should be relative to the current one.E.g.
    <runtime>
        <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
          <probing privatePath="bin;bin2\subbin;bin"/>
    .....
    <runtime>
  3. DevCraft banner
  4. Don
    Don avatar
    18 posts
    Member since:
    Feb 2013

    Posted 15 Mar 2013 Link to this post

    Thank you, in the end I found it was easier to format the assemblyrefrences correctly and then create a build event in my project that pushes my custom dlls to the executable directory.

    Proper format:
    <Telerik.Reporting>
        <AssemblyReferences>
            <add name="ReportLibrary" version="1.0.0.0" />
            <add name="CdssModels" version="1.0.0.0" />
            <add name="Utilities" version="1.0.0.0" />
        </AssemblyReferences>
    </Telerik.Reporting>


    Directory to place the dlls:
     C:\Program Files (x86)\Telerik\Reporting Q1 2013\Report Designer

      
  5. Jason
    Jason avatar
    11 posts
    Member since:
    Oct 2012

    Posted 11 Dec 2015 Link to this post

    Stumped by the same thing here a couple years later - want to get my business objects to be available as data source in the stand-alone report viewer. I'm able to get it to work in the Visual Studio-integrated designer. I tried moving my main DLL's into "C:\Program Files (x86)\Telerik\Reporting Q3 2015\Report Designer" and changed "Telerik.ReportDesigner.exe.config" (and the x86 counter-part, just to be sure) to add the following:

    <!-- Add assembly references -->
    <Telerik.Reporting>
        <AssemblyReferences>
            <add name="Airborne.Infrastructure.dll" version="1.0.0.0" />
            <add name="Airborne.Invoicing.dll" version="1.0.0.0" />
        </AssemblyReferences>
    </Telerik.Reporting>

    and the stand-alone report designer still shows no choices available in "Choose a Business Object" > "Available data source types". Seems like I should have to option to browse the file system to select a DLL from this window. What am I missing?

  6. Stef
    Admin
    Stef avatar
    3036 posts

    Posted 12 Dec 2015 Link to this post

    Hello Jason,

    Please test to remove the ".dll" part from the assemblies registration and restart the Standalone Report Designer. Note that the assemblies must be loaded in the corresponding by platform version of the Standalone Designer tool.

    More details are available in the tutorials linked at the bottom of the Extending Report Designer help article.

    Regards,
    Stef
    Telerik
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
  7. Jason
    Jason avatar
    11 posts
    Member since:
    Oct 2012

    Posted 15 Dec 2015 in reply to Stef Link to this post

    Thanks, Stef. I did find the error a couple hours after posting the question. Are there any plans to improve the user experience with this? Having to edit a .config file by hand to get business objects working in the stand-alone report designer, and then having to manually turn on error logging in that file, and then parse through these errors to diagnose the issue, made for a very terrible first-experience with Telerik Reporting for me.
  8. Jason
    Jason avatar
    11 posts
    Member since:
    Oct 2012

    Posted 15 Dec 2015 in reply to Jason Link to this post

    Quick follow-up: added this feature request.

    http://feedback.telerik.com/Project/162/Feedback/Details/178115-better-experience-using-business-objects-in-the-stand-alone-report-view

     

  9. Stef
    Admin
    Stef avatar
    3036 posts

    Posted 18 Dec 2015 Link to this post

    Hi Jason,

    Thank you for this feedback.

    In general, any modifications in the Standalone Designer tool's configuration file should be handled manually. If an external assembly is not declared as expected by the tool, there is a first chance exception which is written in the log file after enabling the system.diagnostics section.


    We will discuss the possible improvements, where note that features are considered for implementation based on the demand for them.

    Regards,
    Stef
    Telerik
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
  10. Jason
    Jason avatar
    11 posts
    Member since:
    Oct 2012

    Posted 18 Dec 2015 in reply to Stef Link to this post

    Stef - some feedback on your response: I am aware of how it works. I've worked on several .NET projects that had to scan assemblies and/or load assemblies dynamically. I'm confused about why you would have thought it was helpful to explain it to me. It actually has made me feel more frustrated and unheard.

    Your response felt defensive, and like a brush-off. Just a little empathy would have turned this into a positive experience rather than one where I feel resentful about having to use your product, even given the fact that I well understand: improving the experience of using business objects with the stand-alone report designer is a pretty niche thing, and the team probably has hundreds of other cool stuff on their plate that will help a lot more people out, so that's cool -- I get it.

    Just letting you know how your response made me feel. Hey -- weekend is almost here, the new Star Wars movie is upon us, fun holidays are almost here -- I truly hope you have a good rest of the day and a good weekend, Stef. I feel better now, too. :)

  11. Stef
    Admin
    Stef avatar
    3036 posts

    Posted 21 Dec 2015 Link to this post

    Hi Jason,

    You are right. My response is a statement that settings must be applied manually (something you already know, but I thought it will be reasonable to confirm for anyone concerned).

    After a discussion with our development team, the main concern regarding  the Standalone Designer is that external assemblies should be distributed along with the designer. Also external assemblies may depend on other assemblies, and all of them must be copied relatively to the tool's exe. If these additional assemblies depend on Telerik Reporting or other product used by the Standalone Designer, there will be required binding redirects.
    Having into account the the required settings, it is recommended the settings to be applied by a power user having a knowledge of the content of the external assembly.


    The above lines only describe our concerns for not having such feature. We understand the need for having easier access to configuration settings of Report Designers, and we will appreciate it if you log a feature request describing the use case and the expected result (to what extend the UI should cover the customization of the Standalone Report Designer e.g. write only settings or handle assemblies as well).

    Thank you for your cooperation :)

    Regards,
    Stef
    Telerik
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Back to Top
DevCraft banner