Telerik Forums
Reporting Forum
4 answers
265 views
I'm using a couple of SQL data sources to populate parameters for a Telerik report. Some of these queries are loaded on very large databases and take upwards of of a minute to execute. I don't have a problem with that, but once values are selected by a user and the Preview button is clicked (in the Web Viewer) it takes even longer to generate the report. I couldn't understand why this was happening, as the resulting queries execute in a couple of seconds, so I started SQL profiler and discovered that the initial queries to populate the SQL data sources assigned to the parameters execute unnecessarily when you click that Preview button. 

Is this expected behavior? Is there a way to prevent this from happening? I'd appreciate any help you could offer on the subject.

Thanks.
Andrew
Top achievements
Rank 1
 answered on 14 Mar 2012
2 answers
138 views
I have a single report viewer that I use to show multiple reports. In each of the reports I have a text box called FooterTextBox which places text with the footer of the report at run time. I get errors in the Error List: 'FooterTextBox' is not  a member of 'Telerik.Reporting.Report' of the VS 2010 IDE.

If I ignore the errors during build time the program runs fine and can change the footer text with no issues. However when I am building additional reports the build fails (in the preview) unless I comment out these lines ?        

If Me.FooterTextbox.Text <> "" Then

            myReport.FooterTextBox.Value = Me.FooterTextbox.Text
        Else
            myReport.FooterTextBox.Value = "Printed copies are uncontrolled documents."
        End If 


Report code:

        Dim myReport As Telerik.Reporting.Report = Nothing
        Select Case ReportDDL.SelectedItem.Value
            Case "OSHAItembyPersonnelReport"
                myReport = New OSHAItembyEmployeeReport
                Exit Select
            Case "OSHAItems"
                myReport = New OSHAItems
                Exit Select
            Case "OSHAItemDue"
                myReport = New OSHAItemDue
                Exit Select
        End Select
        Me.ReportViewer1.Report = myReport

        If Me.FooterTextbox.Text <> "" Then
            myReport.FooterTextBox.Value = Me.FooterTextbox.Text
        Else
            myReport.FooterTextBox.Value = "Printed copies are uncontrolled documents."
        End If

        Me.ReportViewer1.RefreshReport()
        Me.ReportViewer1.Report = myReport

Andy
Top achievements
Rank 1
 answered on 13 Mar 2012
1 answer
795 views
I have a report that show due dates. When a due date is within a certain amount of days, I need the report to format the date in a red font. Example:

Item X due date is 2012-04-01 is with in 90 days of today (2012-03-12) so the report will need to show it in a red font
Item Y due date is 2012-08-01 is not within 90 days so the font should be black.

I tried to compare dates using   = Fields.due >=DateAdd("d", 90, now()) but I get an error has occurred while processing textbox The expression contains undefined function call DateAdd()
Elian
Telerik team
 answered on 13 Mar 2012
1 answer
76 views
 
I am using q2 2011 telerik reporting for silverlight apps.
in access to data by object data source I can only access to properties of my main class(that defined by set and get) and I can not access to other public methos, why?I have a created class with some public method(c#) and no any property(set get ...) , when I connect to the "list" type class of this class I can not see the public methods but if I create a property(by set and get) I can see that properties! .Is any way for accessing to public methods? Thanks.
Elian
Telerik team
 answered on 13 Mar 2012
6 answers
581 views
I am currently using telerik reporting, and I need to have a barcode printed.  I need to replace an existing barcode using what was told to me to be encoded with Code 128B.  An example text I need to encode is “D00100235373”
When I go to this site and select barcode type 128 and put D00100235373 in the Enter Code Text it generates the barcode exactly the way I want.  Meaning it looks exactly the same as the bar on a document I am replacing.  
http://www.dbautotrack.com/demo/WebDemoBW/Default.aspx

Though, I would love to use Telerik’s barcode control, because it is simpler to use, and I have already paid for Telerik.  
I have tried several things such as below, but I cannot seem to get the same barcode as the one from the above website.  
Symbology = Code128 and Checksum = False
Symbology = Code128 and Checksum = true
Symbology = Code128B and Checksum = False
Symbology = Code128B and Checksum = true

Any help on this would be much appreciated.
Thanks, Tommy
Wang
Top achievements
Rank 1
 answered on 13 Mar 2012
1 answer
264 views
Hi,

Great job with the Report Designer but can you clarify licencing for it? Product documentation still lists "Products that expose the design-time functionality of the Telerik reports." as "Examples of Uses that Require Discussion", can I provide "the business" (for internal projects) with Report Designer or do they need licence for Reporting too? Same with clients (for external projects) can they use Report Designer without purchasing Telerik Reporting licence?

Regards,

Tomashiba
Peter
Telerik team
 answered on 12 Mar 2012
6 answers
266 views
I am setting image URL as follows.
pictureBox1.Value = System.Configuration.ConfigurationSettings.AppSettings["ImageFolderURL"] + "apple_ex.png";
It is working fine when I am running application. I am able to see image in browser. If I am trying to preview report through designer Tab, It is saying "The given key was not present in the dictionary."
My Appsetting section:
<appSettings>
    <add key="ImageFolderURL" value="http://www.queness.com/resources/images/png/" />
  </appSettings>
Please suggest how I can make working in preview mode too.
Manoj
Top achievements
Rank 1
 answered on 12 Mar 2012
24 answers
686 views
Hi all
I want post a parameter to the reportViewer,
who can help me?
thank you~~
Brett
Top achievements
Rank 1
 answered on 12 Mar 2012
1 answer
597 views
We have a need to add an action to a report with a link to the specific object. We produce pdf reports, and we've been asked to provide some way of a user clicking a link to get to an account or a record from within the pdf.

I know it's possible to add actions into a report, but I can't find anyway to give the link access to another value from the data so we can build URLS.  
Steve
Telerik team
 answered on 12 Mar 2012
2 answers
197 views
I am using q2 2011 telerik reporting for silverlight apps.
in access to data by object data source I can only access to properties of my main class(that defined by set and get) and I can not access to other public methos, why?I have a created class with some public method(c#) and no any property(set get ...) , when I connect to the "list" type class of this class I can not see the public methods but if I create a property(by set and get) I can see that properties! .Is any way for accessing to public methods? Thanks.maniaqrzep@yahoo.com
M
Top achievements
Rank 1
 answered on 11 Mar 2012
Top users last month
Tien
Top achievements
Rank 1
Iron
Krasimir
Top achievements
Rank 3
Bronze
Iron
Iron
Cedar
Top achievements
Rank 1
Iron
Emil
Top achievements
Rank 1
Iron
Kyle Watson
Top achievements
Rank 1
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?