Telerik Forums
Reporting Forum
1 answer
103 views
Hi,
I want to test the reporting portal for my company.
Is there anyway to create a "reporting portal" for the for the company where user can enter see a menue with their reports?
and also, do you have a mechanism to manage the security of users accessing it (the "reporting portal")?
I want a link to a tutorial if it is possible.

Thanks
Steve
Telerik team
 answered on 09 Apr 2012
1 answer
133 views
I have created charts inside a report using SQLDataSource to bind the data.  I would like my bar graph to show negative entries in red and positive entries in green.

I have tried setting the "ConditionalFormatting" property as in link below but that doesn't do anything. 
http://www.telerik.com/help/reporting/styling-conditional-formatting.html

Also I found this thread, but my data is generated by datasource.  How can I retrieve the ChartSeriesItem from the reportviewer?
http://www.telerik.com/help/reporting/howtoassigncolors.html

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
    If Not IsPostBack Then
        Dim report As New MyReports.NetIncomeByOffice
        ReportViewer1.Report = report
    End If
End Sub
Hadib Ahmabi
Top achievements
Rank 1
 answered on 09 Apr 2012
11 answers
3.6K+ views
Hello all,

Can anyone give me an example of how to use the PageCount and PageNumber Build-In objects please.

Thanks,

JY
Steve
Telerik team
 answered on 09 Apr 2012
1 answer
339 views

I am using a telerik reporting cs file which has designer and resx file...I want to use the same file or report fro my another project..so i copied them over to my new project and changed the default namespaces of the cs file to the current project namespace but still get an error says:

Error    1    Could not load file or assembly 'file:///C:/Windows/assembly/GAC_32/ESRI.ArcGIS.ADF.Connection/10.0.0.0__8fc3cc631e44ad86/ESRI.ArcGIS.ADF.Connection.dll' or one of its dependencies. An attempt was made to load a program with an incorrect format. Line 144, position 5.    C:\Projects\EnbridgeFlanagan\SilverlightApplication1.Web\MissingPhotos .resx    144    5    



I removed  the dll and added it  again but no avail..can some one suggest me if there is an alternate better way of doing it ?  Thank you
Hadib Ahmabi
Top achievements
Rank 1
 answered on 09 Apr 2012
1 answer
48 views
I'm using the GroupHeader_ItemDataBound method in my report to supress repeated grouped data like this:
data:

                    field1        field2        field3        field4
row 1            abc           123            def            456
row 2                                                               789
row 3                                                               222

In this case, the information in field1, field2 and field3 is supressed because it was all the same.  
My requirement is such that if the page changes and the first record on the page would normally be
a record that Ii would be supressing, I need it to display.  Can you tell me how I would determine this?  
I saw that page relative reporting was on the "roadmap" for enhancements back in 2010.  

Thanks,
Doug 
IvanY
Telerik team
 answered on 06 Apr 2012
0 answers
121 views
I am using Q1 2011 version of Telerik Reporting.

Scenario:
I am using User Functions to build an address (and some other key information) for Shipping information (contained in 2 subreports) that are used in an Order Detail report.

Here is the code for the User Function that builds the Ship To information:
Public Shared Function GetShipToInfo(ByVal Name As Object, ByVal Addr1 As Object, ByVal Addr2 As Object, ByVal City As Object, ByVal State As Object, ByVal PostalCode As Object, ByVal Country As Object, ByVal Carrier As Object, ByVal ShipDate As Object) As String
    Dim address As String = ""
    If Not IsDBNull(Name) AndAlso Name IsNot Nothing Then
        address &= Name.ToString.Trim & vbCr
    End If
    If Not IsDBNull(Addr1) AndAlso Addr1 IsNot Nothing Then
        address &= Addr1.ToString.Trim & vbCr
    End If
    If Not IsDBNull(Addr2) AndAlso Addr2 IsNot Nothing AndAlso Addr2.ToString.Trim.Length > 0 Then
        address &= Addr2.ToString.Trim & vbCr
    End If
    If Not IsDBNull(City) AndAlso City IsNot Nothing Then
        address &= City.ToString.Trim
    End If
    If Not IsDBNull(State) AndAlso State IsNot Nothing Then
        address &= ", " & State.ToString.Trim
    End If
    If Not IsDBNull(PostalCode) AndAlso PostalCode IsNot Nothing Then
        address &= "  " & PostalCode.ToString.Trim & vbCr
    End If
    If Not IsDBNull(Country) AndAlso Country IsNot Nothing AndAlso Country.ToString.Trim.Length > 0 Then
        address &= Country.ToString.Trim & vbCr
    End If
    address &= vbCr & "Carrier: "
    If Not IsDBNull(Carrier) AndAlso Carrier IsNot Nothing Then
        address &= Carrier.ToString.Trim
    End If
    address &= vbCr
    address &= "Ship Dt: "
    If Not IsDBNull(ShipDate) AndAlso ShipDate IsNot Nothing Then
        address &= CDate(ShipDate).ToString("d")
    End If
    Return address
End Function

The Issue:
When this information is displayed in the Web Report Viewer, I see all of the information; however, there should be an empty line between the last line of the address and the "Carrier".  In the Web Report Viewer, this does not occur.  In addition, when you print the report (or export to PDF -- the same thing), the empty line occurs between the last line of the address and the "Carrier" (which matches the user function) BUT the Ship Dt goes misssing.

See the attached files UserFunctionAddress_In_Viewer.jpg and UserFunctionAddress_As_PDF.jpg.  Check out the Ship To Address information about 1/2 way across the image to see what I am talking about.

I went back through the main report and subreport and checked height settings for textbox report controls, sections, etc.  In addition, I confirmed that the textbox control has CanGrow=True.  All settings appear to be set correctly.  Certainly, the web report viewer agrees since the user can visually see all the information...but the export to PDF drops some information (in this case the Ship Dt).

Learnings:
  1. If you are using User Functions to build text (especially if you are adding carriage returns) do not rely on the visual look in the Telerik Report Viewer.  You must check the visual representation of the report as a PDF.  [Note:  When Telerik Reporting prints a report, it renders it as a PDF first.]
  2. Again, if you are using User Functions, you should set the size of any Textbox Reporting Control to the maximum size you expect to see from your data set.  You cannot rely on the CanGrow property to handle the data overflow.

Hopefully this may help some of the other Telerik Reporting developers out there.  The key is...ALWAYS ALWAYS ALWAYS check the report as a PDF before deploying reports to your user community.

Dennis
Top achievements
Rank 2
 asked on 06 Apr 2012
3 answers
186 views
I have created a WPF application that uses SQL CE 4.0 database and runs fine, however, when I try to view a report that uses the same database I get the below error

An error has occurred while processing Report 'RacerAverages':
Unable to establish a connection to the database. Please, verify that your connection string is valid. In case you use a named connection string from the application configuration file, make sure the name is correct and the connection string settings are present in the configuration file of your application.
------------- InnerException -------------
Unable to find the requested .Net Framework Data Provider. It may not be installed. 

The report works fine in the VS 2010 environment and all data is shown but not when deployed or run in debug mode. All CE .dlls are copied to the Debug folder? 

Is there something special I am missing? Below is my config settings...
<add name="RacingApp.Properties.Settings.RacerAveragesSQL" connectionString="Data Source=C:\data\RacingAppData.sdf"
      providerName="Microsoft.SqlServerCe.Client.4.0" />

I have the SQL 4.0 CE and VS 2010 Tools installed. I have seen this Thread, which seems to be similar but have done everything
mentioned with no resolution?

Please help, this has been a thorn in my side for weeks now...

thanks,
SD.
Steve
Telerik team
 answered on 06 Apr 2012
6 answers
570 views
So, created the dashboard (report....have to call it a dashboard...don't ask), and have it set the way I want it.  It's a very basic three text inputs and a chart for results.  The trouble is the button that says "Preview".  I wanted to change it to say "Run", however, it doesn't look like there is any line in the code to do so.

Am I missing something?


Thanks gang!
Matt
Top achievements
Rank 1
 answered on 06 Apr 2012
3 answers
652 views
Can we combine multiple rows into single row in telerik??
I have report in which i have 15 sub sections.In which one of  sub section is PatientData.
I have placed table for each section and assigned corresponding datasources to each table.
Eg: tablePatientData -- PatientDataSource
tablePatientDetails-- PatientDetailsDatasource

For eg: I have a requirement like from DB Patient information was returned in  4 rows.
PatientId  PatientData
1                Test1
2                Test2
3                Test3
4                Test4

In UI i need to display it as below

Patient Data Heading
-------------------------------------------------------------
Test1,Test2,Test3,Test4

I need the information on how can we acheive this in Telerik reporting??
Steve
Telerik team
 answered on 06 Apr 2012
5 answers
235 views
Hello, 

I have a number of reports, I do not wish to create a viewer for each report, can I reuse the same ReportViewer and the winform for multiple reports by creating properties that pass in the Report to instantiate to the Winform.  I've created a separate library for my reports and now wish to instantiate my reports in the one viewer.  Is it good practice to instantiate my Report in a calling form and then pass it to the Winform that holds the viewer, cast it to a (Telerik.Reporting.IReportDocument) object and set the ReportViewers REPORT property.

Using Reporting Q3 2011

Thanks,

Kerry
Steve
Telerik team
 answered on 06 Apr 2012
Top users last month
Jay
Top achievements
Rank 3
Iron
Iron
Iron
Benjamin
Top achievements
Rank 3
Bronze
Iron
Veteran
Radek
Top achievements
Rank 2
Iron
Iron
Iron
Bohdan
Top achievements
Rank 2
Iron
Iron
Richard
Top achievements
Rank 4
Bronze
Bronze
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?