Telerik Forums
Reporting Forum
1 answer
142 views
I want to build a report in which, based on some conditions, I don't want a column to be visible. I've configured conditional formatting on the report items that are part of that column, and it works. However, I want to shorten the width of the GroupSection where the header of the column is placed, in case it is not visible. Then I implemented the ItemDataBinding event tied to the GroupSection, but I figured out that the Width property doesn't exist to be set programatically for a GroupSection! Am I missing something? It's funny I can set the width from the designer in VS for a GroupHeader, but I can't do it programatically.
Peter
Telerik team
 answered on 17 Mar 2010
1 answer
119 views
I cannot seem to get a Date filter to work that uses conversion routines.  The schema which I'm reporting against stores all dates as OLE automation dates (double precision floating point).  I have a static utility function, DateTime MyLib.Utilities.FromOADate(Nullable<Decimal> dt) which wraps the System.DateTime.FromOADate() routine and exposes it to the report.   This way, in the report I can use an expression, e.g.={MyLib.Utilities.FromOADate(Fields.[StartDate])}.  This seems to work correctly for report output.

When I try to setup a filter for start date using a similar method, I get an error 'Cannot apply >= to types System.DateTime and string'.  When I use the expression editor, the expression created is:
=MyLib.Utilities.FromOADate(Fields.[StartDate])   (without the {}'s, adding them seems to be a syntax error )

My filter definition looks like:

Expression                                                                            Operator                      Value
=MyLib.Utilities.FromOADate(Fields.[StartDate])                       >=                            =Parameters.Parameter1   (DateTime)
=MyLib.Utilities.FromOADate(Fields.[StartDate])                       <=                            =Parameters.Parameter2   (DateTime)



  I've barely started to look into Telerik Reporting so I may be missing something obvious.  Any help would be appreciated.

Thanks,
Josh
Josh Turpen
Top achievements
Rank 1
 answered on 16 Mar 2010
2 answers
172 views
I'm trying to use a crosstab in the detail section of my report. I am binding the data at runtime using NeedDataSource (for the crosstab). I have defined a row group and a column group for my data. I have also defined the same fileds as value expressions in the textboxes for the associated row and column. When I preview the report, I get an error as shown in the attached. Is there a step I am missing that would case this?

TIA
Dave Hayward
Top achievements
Rank 1
 answered on 16 Mar 2010
0 answers
153 views
I'm creating an invoice report.  I have a text box that I want to display the address in.  I have the normal fields in my database for address:

Address1
Address2 (optional)
City
State
Zip

I want the the formated text to look like this

{Address 1}
{Address 2} if there is data in the field else move 3rd line to this line
City, State Zip.

How can I format the text box to display my address in this fashion?

Thanks!
Brad Williams
Top achievements
Rank 1
 asked on 16 Mar 2010
1 answer
115 views
I try to export a report in pdf like this (this function ran number one with the 2009 Q3 version): Dim result As RenderingResult = reportProcessor.RenderReport("PDF", reportToExport, Nothing)

The error is "The string initialisation is not conform as expexted starting at index 0"

thanks to help,

Benoit
Benoit Massy
Top achievements
Rank 1
 answered on 16 Mar 2010
1 answer
66 views
Is there a way to force the Legend to stop covering the Chart?


Steve
Telerik team
 answered on 16 Mar 2010
2 answers
277 views

Hi there.

I just upgraded to Q1 2010 and I am getting an error associated with any of my multivalue parameters.

Here is an example of the error: System.Exception: Invalid value of parameter 'Person'.

I am creating all of my parameters programmatically and if I change the parameter to multivalue = false, the report works fine. It seems like the changes associated with changing the UI object in the parameter structure while leaving it there temporarily for legacy purposes has caused an issue. Am I not initializing something (old or new) correctly?

See attached screenshot for Quick watch of created parameter.

Going to production soon! Any help is greatly appreciated.

Mike

Here is how I create/populate the parameter:

Telerik.Reporting.ReportParameter rp = new Telerik.Reporting.ReportParameter();   
 
if (drp.TelerikName != null && drp.TelerikName != "")   
{  
    rp.Name = drp.TelerikName;  
}  
else   
{  
    rp.Name = drp.Name;  
}  
 
rp.Type = drp.ParameterType;  
rp.UI.MultiValue = drp.MultiValue;  
 
// dont show any parameters on the viewer page   
rp.UI.Visible = false;   
 
if (rp.UI.MultiValue == true)   
{  
    if (rp.Value == null)   
    {  
        // Create new list   
        rp.Value = new ArrayList();   
    }  
        foreach (Pair valuePair in drp.ParameterValues)   
        {  
            if ((string)valuePair.First == drp.Name)  
            {  
                switch (rp.Type)   
                {  
                    case ReportParameterType.Integer:   
                    {  
                        ((ArrayList)rp.Value).Add(int.Parse(valuePair.Second.ToString()));  
 
                .....  
 

 

 

 

 

 

As I mentioned before, this worked fine in the previous release. It is still an array list which should be correct.

 

Milen | Product Manager @DX
Telerik team
 answered on 16 Mar 2010
0 answers
205 views
With the Q1 2010 release, RadComboBox.SelectionBoxItemTemplate property is read-only which breaks the Silverlight report viewer control template. To fix this issue, please download the latest internal builds for Telerik Reporting and RadControls for Silverlight (available in your Client.net accounts), build against the latest assemblies and clear your browser cache.

We apologize for the temporary inconvenience.
Telerik Admin
Top achievements
Rank 1
Iron
 asked on 16 Mar 2010
1 answer
167 views
Hello ,
How to view ssrs report in telerik reportviewer ?
Steve
Telerik team
 answered on 16 Mar 2010
1 answer
81 views
Hi telerik,


We recentlty start using telerik products. 

I have one table TABLE_JAPVALUES  :

DATE      RDVAL  PDVAL DPVAL  CTVAL ATVAL
1-1-09       100       50        45         85        90
1-2-09       50         20        15         50        55
1-3-09       120       40        40         70        95
1-4-09       100       30        30         95        80

I want a report where I can select what columns I want to see in report with Avg. of that columns

So I want a  ckeckboxlist  or something like this that should show all the columns:
RDVAL
PDVAL
DPVAL
CTVAL
ATVAL

If I Only select
RDVAL
DPVAL
ATVAL

It should show REPORT like this:

DATE      RDVAL   DPVAL   ATVAL
1-1-09       100          45        90
1-2-09        50           15        55
1-3-09       120          40        95
1-4-09       100          30        80
AVG           92.5       32.5      80


Do you have any tutorial or sample code.

I will really appreciate your help.
Peter
Telerik team
 answered on 16 Mar 2010
Top users last month
Simon
Top achievements
Rank 2
Iron
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Marco
Top achievements
Rank 4
Iron
Iron
Iron
Grant
Top achievements
Rank 3
Iron
Iron
Iron
Kao Hung
Top achievements
Rank 1
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?