Hi there,

We're using the SQL Server provider to store Telerik Reports session state in a database.  We have this Section set in the Web.Config file for our C#/ASP.Net web project:

  <Telerik.Reporting>
    <SessionState provider="Database">
      <Providers>
        <Provider name="Database" type="Telerik.Reporting.DatabaseSession.DatabaseSessionProvider, Telerik.Reporting.DatabaseSession, Version=5.3.12.119, Culture=neutral, PublicKeyToken=a9d7983dfcc261be">
          <Parameters>
            <Parameter name="BackendName" value="mssql" />
              <Parameter name="ConnectionString" value="MyConnectionString" />
          </Parameters>
        </Provider>
      </Providers>
    </SessionState>
  </Telerik.Reporting> 


Everything is working fine, except we want to take the " <Parameter name="ConnectionString" value="MyConnectionString" />" out of the Web.Config file and add it, or at least update it, programmatically, in Global.asax, getting the ConnectionString from the AppSettings which is stored in a separate envsettings.config file.  I've found code online showing how to update programmatically the AppSettings section of the web.config file, but not a custom section like "Telerik.Reporting".  Does anyone have anyone sample code that would demonstrate how to do this?

Many thanks,

Hi:

I have many reports working with "UseNativePrinting=true" but I have one that is REALLY SLOW (around 2 minutes for each page).

I tried it with "UseNativePrinting=false" and it goes really fast but... it doesn't work in OutOfBrowser (and this is essential).

Is there any plan to make it possible in OOB applications?

Do I have any other option to make it work faster without setting the native printing to false??

Thanks in advance.

I'm using a table with a rotated layout, so the items are listed horizontally.  If the page has room for 5 items, the 6th item is displayed on a new page (for pdf output).  Is there a way to force the table to restart on the same page if possible? 

So instead of having item 6 on the next page, I'd like it to "start over" under the first 5 items.

Instead of this:
Page 1 Boundary                                  Page 1 Contents                              Page 2 Boundary        Page 2 Contents  
           |                       Item 1         Item 2       Item 3       Item 4        Item 5            |                        Item 6          Item X...

I want this:
Page 1 Boundary                                  Page 1 Contents                              Page 2 Boundary
           |                       Item 1         Item 2       Item 3       Item 4        Item 5            |            
           |                       Item 6         Item X...


Is there any way to accomplish this?

Dear,
I have been evaluting Telerik Reporting for one of my clients who is already using crystal reports. For this I have produced some their reports in Telerik. I am facing  some very serious problems during the reports development. One of these problems is listed below for your consideration.

I have developed a cross tab report with drill down. In which i have two row groups One is Category (parent) group and other is Description (child) group. I initially set Description visibility False and set its visibility to toggle on Category Action. It is working fine for following Layout of Crosstab offered by Telerrik.

1. No Subtotals and grand totals
2. Blocked Layout, Subtotals below
3. Blocked Layout, Subtotals above

But my required Layout for the report is "Stepped Layout, Subtotals above". When I select this Layout for my report and try to drill down the report by clicking plus sign I get the following error.

An error has occured while processing table 'crosstab1'.
Index was outside the bounds of the array.

I am also attaching few iamges to show the fact.
Please also not that this particular error is only with Stepped Layout while with other Layouts it works fine. I wonder why, Please help me soon

Hello Everybody

Previously i had been working with Crystal reports, there for use the cross tab you must to put it in the page header, an advantage of this feature is that, besides use cross tab you can use the detail area to put the detail of the cross tab report. Currenly i migrate all reports to Telerik Reports, and is  a huge difference, but my customers are asking for the detail of the cross tab, but as in Telerik Reporting the cross tab must be in the detail area, i didnt find the way to do it, I try to make it creating a group and putting the Cross tab in the header of the group, and the textboxes in detail area, but now for each group appears the cross tab and after a few minutes say that the memory is out.


Can anybody show me any way to fix this requirement pls, in the attachment you can find how i made in Crystal, the defintion and the result and in Telerik the defintion and the result


Regards

CM

Hi,

A client has problems with his reportviewer, when clicking the print button in the wpf report viewer nothing gets printed. It worked until recently.

I have not changed anything in the project and it prints from my pc.
I would like to know if Telerik depends on other components than .net 4 framework ?. Because something has been changed in the clients computer, for it to stop working.

Best regards

Ole.

Hello,
I have a problem with reporting in Lightswitch. I have created an empty report, a new control in client and WCF service with reporting service. So now I am able to view empty report in Lightswitch application.
The report is in ServerGenerated project.
The problem is that I am not able to view some data in report. I cannot use the direct SQL access. I need to use existing RIA domain service with existing queries.
The solution should be deployed in Azure and in 3 tier scenario.
How to achieve that?
Thank you

Hi All,

I have try to create a bar chart from database,but I have no clue to make dynamic chart legend data from database.

Can anyone give example for me..?


=========  This is my Code ======================
 private void chart1_NeedDataSource(object sender, System.EventArgs e)
        {
            this.chart1.Series.Clear();
            String pPeriodeStart = Convert.ToString(this.ReportParameters["PeriodeStart"].Value);
            String pPeriodeUntil = Convert.ToString(this.ReportParameters["PeriodeUntil"].Value);




            if (pPeriodeStart == "") pPeriodeStart = "null"; else pPeriodeStart = "'" + pPeriodeStart + "'";
            if (pPeriodeUntil == "") pPeriodeUntil = "null"; else pPeriodeUntil = "'" + pPeriodeUntil + "'";


            string sql = @"exec dbo.procedureName @PeriodeStart = " + pPeriodeStart+ ", @PeriodeUntil = " + pPeriodeUntil;
           
            string connectionString =
             "Data Source=xxx-pc\\SQLEXPRESS;Initial Catalog=dbname;Persist Security Info=True;User ID=sa;Password=password";


            SqlDataAdapter adapter = new SqlDataAdapter(sql, connectionString);
            DataSet dataSet = new DataSet();
            adapter.Fill(dataSet);


            ChartSeries series = new Telerik.Reporting.Charting.ChartSeries();
            series.DataYColumn = "AuctionDealValue";


            series.Appearance.LabelAppearance.Visible = true;
            //series.Appearance.ShowLabelConnectors = true;
            series.Appearance.ShowLabels = true;


            series.Appearance.LegendDisplayMode = Telerik.Reporting.Charting.ChartSeriesLegendDisplayMode.ItemLabels;
            
            //this.chart1.DataGroupColumn = "StakeholderId";


            this.chart1.ChartTitle.TextBlock.Text = "Test";


            this.chart1.PlotArea.XAxis.AutoScale = false;
            this.chart1.PlotArea.XAxis.AddRange(1, 10, 1);
            this.chart1.PlotArea.XAxis.DataLabelsColumn = "CommodityName";


            this.chart1.Series.Add(series);
            (sender as Telerik.Reporting.Processing.Chart).DataSource = dataSet.Tables[0].DefaultView;
        }

============= end of code ===============

+++++++++ this is my data from store procedure ++++++++++++++++
AuctionDealValue StakeholderName CommodityName CommodityId  StakeHolderId
36.475000000 fedde1                       Jagung 1 bures1
271.723100000 fedde2 Kayu Jati 2 bures1
47.050000000 fedde3 Kakao 3 bures2
+++++++++ this is my data from store procedure ++++++++++++++++


Regards,


Diki

I am hosting a Silverlight ReportViewer in a XAML file that programmatically sends parameters to the ReportViewer like this:

void TheReportViewer_RenderBegin(object sender, Telerik.ReportViewer.Silverlight.RenderBeginEventArgs args)
{
    args.ParameterValues["SubjectId"] = subjectId;
    runOnce = true;
}

I also have a DrillThrough action setup on the DetailsSecion of my initial report, which I created through the Design view, so that each details ReportItem has an action that operates like this (taken from the Designer.cs):

The DrillThrough is intended to load a DetailReport, passing the SubjectId of the particular item clicked in as a parameter. The navigateToReportAction behaves as expected, but my DetailReport loads with the following error.

I believe the RenderBegin event might be blowing out my parameters, but even if I try some trickery like this:

my DetailReport still reaches the ItemDataBound event of the DetailSection with ReportParameters["SubjectId"].Value equaling null.

What am I to do? Has anyone run across a scenario where parameters passed from a DrillThrough don't load in the report navigated to?

Many thanks for your time,
-Jonathan

Hi:

I'm trying to make a really simple report to print in a 4-different-parts per page document.

So my report has only a Detail, you can see it in "reportdetail.png".

This detail HAS TO BE 7,6cm because every page will be cutted in 4 different parts and all of them must be written the same way (I mean, every field should be in the same place (the first one at 2cm X 2cm Y etc...).

The result is really confusing because it doesn't leaves those 7,6cm for each detail and you can see the result in reportprint.png

As you can see, every detail is different from each other, this is especially seen in the last part of the report (see at that LARGE margin when it should be almost at the bottom of the report.

Am I doing anything wrong? How should I do this?? Thanks in advance!!