Telerik Forums
Reporting Forum
3 answers
477 views
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 :(



Stef
Telerik team
 answered on 10 Mar 2015
1 answer
264 views
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.
Stef
Telerik team
 answered on 10 Mar 2015
1 answer
132 views
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.

Stef
Telerik team
 answered on 10 Mar 2015
1 answer
63 views
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.
Stef
Telerik team
 answered on 10 Mar 2015
1 answer
189 views
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
Sirwan
Top achievements
Rank 1
 answered on 10 Mar 2015
1 answer
163 views
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

Stef
Telerik team
 answered on 10 Mar 2015
8 answers
1.6K+ views
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
Srinivas
Top achievements
Rank 1
 answered on 10 Mar 2015
1 answer
122 views
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):
13/02/2015 17:57:00; 13/02/2015 17:59:00; 13/02/2015 18:12:00; 13/02/2015 18:12:00
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
Stef
Telerik team
 answered on 09 Mar 2015
3 answers
317 views
I have a report that displays a calculated value in a textbox in a group footer section.  I need to highlight this textbox if its' value is the maximum for the values displayed in this column.

The section of the report is shown in the attached file.

How would I highlight the 16.09% in the Membership in PAL column.

Any help would be appreciated.
Stef
Telerik team
 answered on 09 Mar 2015
3 answers
132 views
Hi,

I have gone through many posts regarding this issue. By reading most of the posts I assumed that this issue has been resolved. 
I am currently using Telerik Reporting Q3 2014 and I am still having this issue when the text is justified. It may be because of the our local language.
When text is justified, it kind of gets reversed.

Language/Font and style details:
Font Name: Faruma (can be downloaded from http://fonts.webtoolhub.com/font-n24647-faruma.aspx)
Culture: dv-MV / dv
Style->TextAlight: Justify


I have attached the screenshots of what is happening for your reference. Is there any fix for this issue? Or am I missing some setting? We have many report developments pending because of this.

Sample text in case you need it: 
ވީމާ،
މިއޮތޯރިޓީއަށް ޗެކުން ފައިސާދައްކަވާ ހުރިހާ ފަރާތްތަކުންވެސް އެފަރާތްތަކުން
ހުށަހަޅުއްވާ ޗެކް ބައުންސް ނުވާނެ ގޮތެއްގެމަތިން އިންތިޒާމުތައް
ހަމަޖެއްސެވުމަށް ދަންނަވަމެވެ. އަދި މިއަދުގެ ނިޔަލަށް މިއޮތޯރިޓީއަށް ބައުންސް
ޗެކަކާ ގުޅިގެން އެއްވެސް ފައިސާއެއްދައްކަވަންޖެހި ނުދައްކައިހުރިނަމަ، އެފައިސާ
ލަސްނުކުރައްވާ ދައްކަވައި ޚަލާޞްކުރެއްވުމަށް އިލްތިމާސްކުރަމެވެ.



Stef
Telerik team
 answered on 06 Mar 2015
Top users last month
Jay
Top achievements
Rank 3
Bronze
Iron
Iron
yw
Top achievements
Rank 2
Iron
Iron
Stefan
Top achievements
Rank 2
Iron
Iron
Iron
Kao Hung
Top achievements
Rank 1
Iron
Bohdan
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?