I had implemented telerik reports more than 50 in Telerik Report Designer by using Sql Datasource and now i wanna change the connection string of all the telerik reports...now how can i change the connection string in Sql Datasource of Telerik Report Designer.

 

Please help me...

Hello everyone,

I am looking for the exact syntax for checking a boolean, is it :

=IIF(Fields.BOffreAnnulee==true, "ANNULÉE", null)

=IIF(Fields.BOffreAnnulee=true, "ANNULÉE", null)

=IIF(Fields.BOffreAnnulee = 1, "ANNULÉE", null)

=IIF(Fields.BOffreAnnulee="true", "ANNULÉE", null)

=IIF(Fields.BOffreAnnulee, "ANNULÉE", null)

...

Can't seems to find the right formula, (server is a MS SQL, and the field is a bit in the database)

 

Thanks a lot !

 

Louis

 

 

see my question also on stack overflow http://stackoverflow.com/questions/42758013/store-procedure-return-multiple-data-sets-how-to-access-all-data-sets-in-telerik

when i add SQL data source and add store procedure in it, Actually store procedure return multiple tables but in telerik report designer just got single table or single table parameters if anyone can't understand my question than visit above link

 

SQL store procedure result https://i.stack.imgur.com/ZL1hz.png

in telerik report designer https://i.stack.imgur.com/uoonR.png

 

 

I want a report like this, How much sales, for each city (vertical) in each season (horizontal) :

Cirty1                     City2                   City3
      Spring                  Spring                 Spring
      day1   1000          day1    2000        day1   3000
      day2   1100          day2    2100        day2   3100
                  ...                        ...                         ...

      Summer               Summer              Spring
      day1    1200          day1     2200      day1     3200
      day2    1300          day2     2300      day2    3300
                  ...                           ...                        ...

How can it can be built in telerik reporting?

 

           

Hello

I have a working HTML5 report viewer on my local pc running with VS 2013 dev. webserver.
From this project I copied the necessary files to our web application development server running windows server 2008 and IIS 7.
I copied the necessary DLLs as listed in the How-To, made the web.config entries (binding redirects / handlers) and the global.asax entry, added the report controller to the website's App_Code directory (not precompiled web application), copied the html, css and js files and so on.
The Newtonsoft.JSON.dll seems to be not in the GAC. I copied it too from my working local project.

When I now open the viewer, I see the frame and as soon as it "loads data" It shows 404 - not found where the report should appear:

Module: IIS Web Core
Notification: MapRequestHandler
Handler: StaticFile (is this correct?)
Error code. 0x80070002
Requested URL: http://.....ch:80/api/reports/clients

When I open .../api/reports/formats it shows the same error message. Seems that the handler is not catching the request?
I've also restarted the website and the app. pool several times and tried changing targetFramework to 4.5 but it didn't change anything.
Of course I have some third party handlers but I put the report viewer in a subdirectory with an own web.config where I remove those handlers again without success.

I don't know what to try further but I think I didn't make a mistake by myself. All necessary content from my local project should be on the server as well.

thanks for any help getting this nasty report viewer finally to work - hopefully on the production server too some time!

regards

Does anyone know if its possible to use Json.NET's JObject as a source for graphs? I need to bind a dynamically typed objects in runtime.

In C#, I'm doing this as a POC:

 

var d = new { Missing = 60D, Flagged = 10D, Valid = 30D };        

var s = JsonConvert.SerializeObject(d);        

var j = JsonConvert.DeserializeObject(s);

var ds = new ObjectDataSource();             

ds.DataSource = data;             

var report = new Report1();             

report.MyPieGraph.DataSource = ds;

 

The report renders the graph, but only the legend, not the actual pie graph.

Hi,

I have a text box in a group section and the value is Avg(fields.fieldsName), it works fine if at least one record in detail section in the group has not null value on this column, however, I have a group, none of its records has value on this field, and the textbox in the grouping section through the exception:

#ERROR# Exception has been thrown by the target of an invocation.

is there any alternative I could fix the problem? 

Thanks

I've been beating my head against the wall over this all day and I'm completely puzzled.

 

I'm feeding a pie chart a very simple data source which consists of two columns:  "Category" (string) and "Amount" (double)

If I sort by Fields.Category, it properly sorts the results alphabetically by category.  If I sort by Fields.Amount, my pie chart entirely disappears.. no pie chart whatsoever.

 

[img]http://i.imgur.com/M0W8Ce3.png[/img]

[img]http://i.imgur.com/wvwgQTO.png[/img]

The data I'm passing in is in the form of a DataTable bound to an ObjectDataSource

Any clue what might be happening here?  Is there something else I need to change as well?

 

I am new to Telerik Reporting.....

In my App_code-folder I have created a new report called Product.cs, I have choosen Telerik Reporting/ReportWizard to create a new report with some data in. But no matter what I do, I get the above mentioned error.

Hope someone can help me.

Hi,

I am trying to use Telerik ReportViewer with ASP.NET UpdatePanel but getting below error when I trigger update request.
I also tried using Telerik RadAjaxManager but the result is the same.

Below is my Page and its Code Behind. I a using Internet Explorer 11 (11.0.9600)
I have added both UpdatePanel and RadAjaxManager with different ReportViewer and trigger buttons.

.aspx 

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
        <div>
            <table>
                <tr>
                    <td>Report</td>
                </tr>
                <tr>
                    <td>

                        <asp:ScriptManager ID="ScriptManager1" runat="server" />
                        <asp:Button ID="Button1" runat="server" Text="Button" OnClick="Button1_Click" />
                        <asp:UpdatePanel ID="UpdatePanel1" runat="server">
                            <Triggers>
                                <asp:AsyncPostBackTrigger ControlID="Button1" />
                            </Triggers>
                            <ContentTemplate>
                                <telerik:ReportViewer runat="server" ID="rptViewerTest"></telerik:ReportViewer>

                            </ContentTemplate>
                        </asp:UpdatePanel>

                    </td>
                    <td>
                        <hr />
                    </td>
                    <td>
                        <asp:Button ID="Button2" runat="server" Text="Button" OnClick="Button2_Click" />
                      
                         <telerik:ReportViewer ID="ReportViewer1" runat="server"></telerik:ReportViewer>
                         <telerik2:RadAjaxManager ID="RadAjaxManager1" runat="server">
                          <AjaxSettings>
                            <telerik2:AjaxSetting AjaxControlID="Button2">
                              <UpdatedControls>
                                <telerik2:AjaxUpdatedControl ControlID="ReportViewer1"/>
                              </UpdatedControls>
                            </telerik2:AjaxSetting>
                          </AjaxSettings>
                    </telerik2:RadAjaxManager>
                    </td>
                </tr>
            </table>
        </div>
    </form>
</body>
</html>

Code behind :

 protected void Button1_Click(object sender, EventArgs e)
        {
            Telerik.Reporting.Report report = new EmployeeReport();
            rptViewerTest.Report = report;
            rptViewerTest.Visible = true;
        }

        protected void Button2_Click(object sender, EventArgs e)
        {
            Telerik.Reporting.Report report = new EmployeeReport();
            ReportViewer1.Report = report;
            ReportViewer1.Visible = true;
        }

 

Error message:

Error: Sys.WebForms.PageRequestManagerServerErrorException: Value cannot be null.
Parameter name: key

(PFA screenshot)

Can you please help.

Thanks,

Snehal