Telerik Forums
Reporting Forum
1 answer
109 views
I'd like to subtotal  items based on a boolean field in the datasource that is not being grouped on.  So my subtotal would look like:

= Sum(Fields.DemandAtMemberPeak) where Fields.Include = 1

if this were indeed the correct syntax.  It doesn't run and the sub-report just shows a a red box.  How would I create a subtotal that filters on another field in the datasource?

Thanks Much

Jonathan
IvanDT
Telerik team
 answered on 15 Sep 2011
3 answers
817 views
Hello,

I am developing dashboard reports using Telerik Q2 2011 tools. My question here is how to format numbers with commas (,) for easy reading in the axis appearance properties.

When I use 'Number' value format it shows the decimal places and that is ok for the actual decimal values (see Y-axis2 below image) but I also need to format with commas without decimal positions. E.G. 1,000.

Please see the Y-axis below and I need to use commas to format it. Please help. Thanks in advance.


Srilal
IvanDT
Telerik team
 answered on 15 Sep 2011
1 answer
198 views
Hello,

I'm just starting to work with Telerik Reporting along with OpenAccess and I'm running into some difficultly that I thought would be relatively straight forward using the two products together.  I'm sure I'm just missing something simple, but I just can't seem to figure it out.

I'm using an OpenAccess DataSource to build a report.  I can pull my object properties and the navigation properties representing my foreign key relationships from the Data Explorer to my report just fine.  However, I can't seem to figure out how to get data from the 1:1 or 1:M navigation properties that are represented as collections.  I've tried using the List control and creating a binding to the child object, but the following error shows up on my report when previewing:

"An error has occurred while processing Table 'list1':
The expression contains object 'MyChildObjects' that is not defined in the current context."

I've noticed in the Data Explorer that when I expand the child object none of the properties show up like when I expand an object representing a foreign key relationship.

I'm trying to pull one instance of the child object collection and include it in the report.  This could either be the first instance or based on some other logic (like a where clause).

Thanks for your assistance,

Al
Ivan
Telerik team
 answered on 15 Sep 2011
2 answers
237 views
Hi,
I'm trying to change the font color of the labels in the bar chart. Please see image here:

http://twitpic.com/6hduhh/full


Thanks in advance :)
awni
awni
Top achievements
Rank 1
 answered on 14 Sep 2011
3 answers
404 views
I am looking for a way to create either a report book or a report with several sub reports each of which have their own parameters. All my current reports are standalone and I don't use a report viewer. I am using the new sqlDataSource and setting the parameters in Public Properties like this:
 Public Property setSiteID() As Integer 
        Get 
            Return CInt(Me.SqlDataSource1.Parameters.Item("@SiteID").Value)  
        End Get 
        Set(ByVal siteID As Integer)  
            Me.SqlDataSource1.Parameters.Add("@SiteID", DbType.Int32, siteID)  
        End Set 
    End Property 
I pass the parameter from codebehind of a button like this:
Dim tF As New TelerikFunctions  
Dim strSite As String = ddlSite.SelectedValue.ToString  
Dim rv = New D007RwpSchedule()  
rv.setSiteID = strSite  
tF.ExportToPDF(rv) 'The class tf exports the report to pdf 
So I have several reports that my users have to print every week but they want to be able to just click one button and have all the reports print at once. My problem is that I doon't know how to pass parameters to the individual reports. Does anyone have a solution to this? Thanks for any help.
AkAlan
Top achievements
Rank 2
 answered on 14 Sep 2011
0 answers
91 views
Is it possible to configure telerik reports to generate public chart items? 

If I create a textbox on the designer I would like to have this variable be generated as public, Is this possible ?
Stefen
Top achievements
Rank 1
 asked on 14 Sep 2011
6 answers
413 views
I haven't been able to get it to work, not sure why.  The SL Report Viewer displays an exception when I change the security mode from default to Windows, I assume I'm doing something wrong with the bindings.  IIS is set for Windows Authentication, Anonymous Login disabled.  Any ideas?

Portion of web.config:

<authentication mode="Windows" />
<
identity impersonate="true" />

...

    <bindings> 
      <basicHttpBinding> 
        <binding name="basicHttpBinding_Windows">  
          <security mode="TransportCredentialOnly">  
            <transport clientCredentialType="Windows" /> 
          </security> 
        </binding> 
      </basicHttpBinding> 
      <webHttpBinding> 
        <binding name="webHttpBinding_Windows">  
          <security mode="TransportCredentialOnly">  
            <transport clientCredentialType="Windows" /> 
          </security> 
        </binding> 
      </webHttpBinding> 
    </bindings> 
 
...  
 
 <service name="Telerik.Reporting.Service.ReportService" behaviorConfiguration="ReportServiceBehavior">  
        <endpoint  
          address="" 
          binding="basicHttpBinding" 
          bindingConfiguration="basicHttpBinding_Windows" 
          contract="Telerik.Reporting.Service.IReportService">  
          <identity> 
            <dns value="localhost" /> 
          </identity> 
        </endpoint> 
        <endpoint  
          address="resources" 
          binding="webHttpBinding" 
          bindingConfiguration="webHttpBinding_Windows" 
          behaviorConfiguration="WebBehavior" 
          contract="Telerik.Reporting.Service.IResourceService" /> 
        <endpoint  
           address="mex" 
           binding="basicHttpBinding" 
           bindingConfiguration="basicHttpBinding_Windows" 
           contract="IMetadataExchange" /> 
      </service>

Thanks,
-Brian
Adam
Top achievements
Rank 1
 answered on 13 Sep 2011
5 answers
1.3K+ views
It seems simple enough, but they either overlap, or they are too far apart.  I have a report with about 50 textboxes, and want to align them vertically and horizontally and I don't think I can use a table, as it's just one record.  You cant move a textbox pixel by pixel, using the keyboard or the mouse.  It moves more than one pixel at a time, so you can never align everything perfectly.  How would I accomplish this?

Thanks.
Steve
Telerik team
 answered on 13 Sep 2011
4 answers
291 views
When i set some values in code - txt25000.Value = amount25.ToString(); I see these values when I am looking at my report in the report viewer (See attachment) - But when I export/save to a pdf on my computer and open the file up. Any value that is set in code is never displayed.(See second attachment)

any help is appreciated.
Steve
Telerik team
 answered on 13 Sep 2011
1 answer
213 views
Is there a way to float multiple text box's inside a panel similar to divs with a fixed width and a css property of float:left;.... It needs to load dynamic content that's why i need it to float to stay with in the design other wise another design concept must be created... Let me know if you know how to do this..

Thanks!
Peter
Telerik team
 answered on 13 Sep 2011
Top users last month
Boardy
Top achievements
Rank 2
Veteran
Iron
Benjamin
Top achievements
Rank 3
Bronze
Iron
Veteran
ivory
Top achievements
Rank 1
Iron
Iron
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
ClausDC
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?