• .NET

    Filtering with string parameter that allows free user input

    September 17, 2009 Share
    As you probably know, Telerik Reporting comes with built-in parameters and filters. Report parameters allow users to specify or control the data used in a report. They are extremely powerful when used in expressions for filtering, sorting, grouping or even directly provide a value. When used with filters you can limit the number of records in a report based on specified filter rules. If the conditions of the rules are met, the record is included in the report.  Let's suppose we have a string parameter that allows free user input, wired up with a filter. This way the user has the freedom to type any word and the report would be filtered based on the parameter...
  • .NET

    Changing the position of the report progress indicator

    September 09, 2009 Share
    By design the progress indicator of the web report viewer is centered in the viewable area. However in some cases you might want to change its position (e.g. ReportViewer longer than a viewable page). To achieve that we would get the progress area through a few lines of javascript and change its position according to our needs: <script type="text/javascript">                  var viewer = <%=ReportViewer1.ClientID%>;                 var waitDiv = document.getElementById("ReportViewer1_ReportArea_WaitControl");                 var tcell = waitDiv.getElementsByTagName("TD")[0];                 tcell.style.verticalAlign = "top";                 tcell.style.textAlign = "left";     </script>     A sample project showing this functionality is available in this code library article. For those of you who would also like to change the viewer's skin and progress indicator itself, please review Applying custom skin to the web report viewer code library. Hope this helps! Steve...
  • .NET

    Reporting: Using connectionStrings from configuration file

    August 28, 2009 Share
    We've been asked several times, what is the right way of using connection strings from the configuration file, so that Telerik Reports would work both in run time and design time. The answer can be found in this new Knowledge Base article: Using connectionStrings from configuration file It is worth mentioning that the Report and Data Source Wizards do this automatically when instructed to save the selected connection string in the config file. A working solution using the approach from the latter article can be found in our Visual Studio examples. Enjoy! ---------------- Steve...
  • .NET

    Medium Trust Support for Telerik Reporting

    August 10, 2009 Share
    A lot of people requested this, so we've put all our efforts into it and even managed to finish it in time for the Q2 service pack that shipped just this Friday - download it if you haven't yet. Please hold on your dismay - deploying an ASP.NET application containing Telerik Reporting on a web host that requires Medium Trust permission level is now a reallity. For those of you, who do not know what that means - you probably do not need it, but if you would like to know, check the following "ASP.NET Trust Levels and Policy Files" and "Use Medium Trust in ASP.NET 2.0" documents in MSDN. There...
  • .NET

    Do not filter on null

    This post might seem like a no brainer, but I've received quite a few inquiries on this matter recently, so decided to post here.  Let's say you have a parameter of Type: DateTime with AllowNull: true and we filter on a field based on the input parameter value i.e.: Expression        Operator      Value ===========   ========  ================================= =Fields.MyField        =            =Parameters.MyParam When we tick the 'null' checkbox, it basically filters the report to find the Fields with Nulls. However one might expect that it just won't filter at all with this setup. And indeed if you do not wish to filter, you should not have to. Then how do you handle "empty/blank" values in such cases and...