I have a report which I would like to print a summary of the current report parameters on the last page.  I am using the Report Designer and the report currently has multiple sections to control summary totals with the tables and charts.  That part works fine.  I created a new section with an empty header and a footer that contains a textbox with the report parameters I want to print.  Set the property of the footer section to Visible=True and PageBreak=Before.  The textbox prints, however there is no page break.  It seems that the textbox is merged into the last footer section.  Is there a limit to the number of sections Report Designer can use?  I am currently trying to use four sections.

I wish to change the database the connection string is pointed to based upon a Reporting parameter. Is that possible? Or do I have to use the ChangeConnectionString class I found on another thread.

Ideally, I'd like to be able to have a parameter called @dbid and have the connectionstring be:

<ConnectionString Name="DynamicConnection" ConnectionString="Data Source=servername;Initial Catalog=@dbid;Integrated Security=True"
                            ProviderName="System.Data.SqlClient" />

All within the designer. Is this possible?

Hi,

I have created trdx file from telerik Report designer and I have added a table layout with columns from sql datasource now I want to access it my ASP.NEt application there I have used this code 

 var settings = new System.Xml.XmlReaderSettings();
        settings.IgnoreWhitespace = true;

        using (System.Xml.XmlReader xmlReader = System.Xml.XmlReader.Create("C:\\Lisensining\\Report1.trdx", settings))
        {
            var xmlSerializer = new Telerik.Reporting.XmlSerialization.ReportXmlSerializer();
            var reportDocument = (Telerik.Reporting.Report)xmlSerializer.Deserialize(xmlReader);
            var reportSource = new InstanceReportSource();
      
            reportSource.ReportDocument = reportDocument;

            
            SqlConnectionStringBuilder scsb = new SqlConnectionStringBuilder();
            scsb.UserID = "sa";
            scsb.Password = "root";
            scsb.InitialCatalog = DataBaseName;
            scsb.DataSource = SErverName;
            Telerik.Reporting.SqlDataSource sds = (Telerik.Reporting.SqlDataSource)reportDocument.DataSource;
            if (sds != null)
                sds.ConnectionString = scsb.ConnectionString;

            this.SetConnectionString(reportDocument.Items, connectionString);
 
         
            this.ReportViewer1.ReportSource = reportSource;
            this.ReportViewer1.RefreshReport();
            
         
        }

It is working great and showing all the records from database table  but as I add filters to code report does not show any record
 Telerik.Reporting.Filter filter1 = new Filter("Fields.[ProductName]", FilterOperator.Equal, "Vista");
            reportDocument.Filters.Add(filter1);  

Now report viewer does not show any thing :(

Hi all

We have a .NET web site that uses the Telerik bootstrap theme.

When we add a web form report viewer to our site the toolbar in the report viewer displays incorrectly - please see attached image.

Everything works fine but some of the elements in the toolbar look as though they are being skinned by the skin and others aren't.

What is the solution to this to either...

1. Skin the whole report viewer using the Telerik theme so it looks consistent or
2. Stop the report viewer from trying to pick up the skin/theme.

Thanks in advance.

I'm creating a report where user will select the application type as soon as the user selects application type a country list (multi selection drop down list) is pouplated once the user selects the countries from the multi list I want the report to display the selected countries as columns to the report.
I tried to create a stored procedure but unable to Please help me its really aurgent.

I can not use the latest Reporting as I have to keep the version in synch with the version of reporting used by Sitefinity. The current documentation on Reporting says to "Select the Report Library" project in Visual Studio. The version of Reporting I am using (7.1.13.612 ) did not come with a Report Library project template. If my memory is correct, creating a report project use to involve creating a normal class library in visual studio and making some changes to it. Can you provide me with instructions on creating a report project or preferably give me a link to the documentation relevant to the version I am using.

Hi 
i want to hide a column based on a parameter value.
First: i can't figure out the expression i should write in group filter.
Second : i should adjust the other columns width, will this code do the job
Private Sub Table1_ItemDataBinding(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Table1.ItemDataBinding
        Table1.Body.Columns(index).Width = NewSize
End Sub

I'm implemented a feature in which I need to change the data source of a report at run time. I've found the report object has a datasource property which I could change but what happens in the case of a report with multiple data sources?

Also I've found a workaround by modifying the report definition XML on the fly but since I'm not sure if this is the correct way of doing it. I would rather have an object model that allows me to do this. Perhaps with your report definition schema.(xsd) I could deserialize it back into an object and then manipulate it but I haven't found any place where you expose the xsd.

I'm using Q2 2014.

Thank you

Hi,

I have a multi-value report parameter whose value is coming from database. I want set all values selected by default when report runs first.

How can I set the multiple default values for multi-valued parameter in the report?

I went through the report guide http://www.telerik.com/help/reporting/designing-reports-parameters-using-multivalue-parameter.html

but could not understand the implementation.

I did not find AllValues function in the report designer. I have also tried Array function but did not work. Array function selects multiple values when we pass hardcoded values in it.

I am using standalone report designer. Please advise.

Thanks,
Hardik

I created SqlDataSource in Telerik reporting project which returns only one column with some rows and I need to place them horizontally with
transfer to the next new line (if needed):
I have tried to create a CrossTab element - it transfers rows not to the next new line but to the next new page.
What element I must use? How can I solve this problem?

Thank you and best regards