Telerik Forums
Reporting Forum
1 answer
77 views
I have an horizontal alignment issue where the report displayed is not centered in the webviewer once I upgrade it to Q3 2011. Before this , i was using Q2 2011 and it works perfectly fine.

Attached is how it looks like after upgrade.
Steve
Telerik team
 answered on 20 Dec 2011
3 answers
857 views
Hi there,

How I can pass parameters to my sql queries in query builder. Please look at picture.

In my ReportViewer I do that:

 public SGASeguranca()
        {
            InitializeComponent();

            try
            {

                ReportViewer1.Report = "ReportClass.ParticipantesReuniao, ReportClass, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null";
                ReportViewer1.ReportServiceUri = new Uri("../ReportService.svc", UriKind.RelativeOrAbsolute);
                ReportViewer1.RenderBegin += new Telerik.ReportViewer.Silverlight.RenderBeginEventHandler(ReportViewer1_RenderBegin);
                
            }
            catch(Exception e)
            {
            }

        }

        void ReportViewer1_RenderBegin(object sender, Telerik.ReportViewer.Silverlight.RenderBeginEventArgs args)
        {
            args.ParameterValues["REUNIAOID"] = 1010;
            
        }

And in code-behind of my report I do that:

   void ParticipantesReuniao_NeedDataSource(object sender, System.EventArgs e)
        {
            Telerik.Reporting.Processing.Report report = (Telerik.Reporting.Processing.Report)sender;

            this.sqlDataSource1.Parameters[0].Value = report.Parameters["REUNIAOID"].Value;

            // Set the SqlDataSource component as it's DataSource
            report.DataSource = this.sqlDataSource1;
        }

But now, I want use this REUNIAOID in query builder.

How I can do that?

Thanks in advance
Manuel
Top achievements
Rank 1
 answered on 20 Dec 2011
8 answers
710 views
I had done some reports for industrial production in the Q3 2009 release. I had no issues using MultiValue parameters and passing it so that the customer could look at multiple items in a single report if needed. I am updating and doing some new reports and have found that in the Q3 2010 release the multivalue continually throws me a error but not if the MultiValue is set to False ( it runs fine then). This is happening after upgrading the reports from the old version. If I go back to the old version, they run fine.
I am getting the following error:

Cannot perform '=' operation on System.String and System.Object[]

I checked the documentation and see nothing new for setting Multivalue parameters. I might be blind though and just missed it. Any ideas as to what is causing this and how to resolve it? I apologize I usually do reports using a different package. The customer has been happy with the look and feel of the old ones.

Thanks!

Tom
Varun
Top achievements
Rank 1
 answered on 19 Dec 2011
1 answer
102 views
Having a small issue with the report viewer. Currently if a user tries to export the report to a file and attempts to overwrite an existing file that is used by another process (such as, it's currently open), the Report Viewer causes an unhandled exception and crashes the app.

Is there an accepted way to handle this scenario? Looking at the code, it seems like there should be a try/catch block around the block of code in the SaveExportCommand that writes to the file system.
Elian
Telerik team
 answered on 19 Dec 2011
4 answers
185 views
.. or I'm even dumber than generally accepted.

Have a look at the attached image.

This is from the detail section of a report. The detail section contains a crosstab (highlighted in Red.

Now, The crosstab has 2 row groups (and the content of these in show in bold).

I've been trying to find a way of getting the whole row for each top-level row group to be formated with the same background colour.

I thought Id cracked it by doing this in code ...
static int TabCount = 0;
public static int GetTabCount()
{
    return TabCount;
}
private void textBox25_ItemDataBound(object sender, EventArgs e)
{
    TabCount++;
}

textBox25 is the textbox holding the top-level grouping value.

I then, for both row groups and the detail section, set up a Conditional Formating rule with Filter="=GetTabCount() % 2" Condition = "Equal" an Value = "=1".

As you can see from the screen shot, this works for the row group cells but not for the detail cell.

I did a test and got the system to echo the value of GetTabCount() for each of the cells in the crosstab and got:
0 - 0 - 3
1 - 1 - 3
2 - 2 - 3

And I'll be damned if I can figure out why.

It seems that textBox25 is being bound more often that I think it should (so I guess my understanding og that is wrong too) and that the detail cells are being bound after the all of the row grouop cells on all of the rows.

Simply formating a report shouldn't be this hard.

If anyone can off any help, I will very grateful.

--
Stuart

Stuart Hemming
Top achievements
Rank 2
 answered on 19 Dec 2011
5 answers
222 views
Hi there,

I´ve installed the telerik reporting and tried to add to my silverlight application but give me an error?

How I can create a report in Silverlight?

Thanks
Manuel
Top achievements
Rank 1
 answered on 19 Dec 2011
1 answer
293 views
Hi,

I have a Style called "Data" with background color white.
I create a conditional formatting rule and only set the ForeColor to red for example.
Now, I change the style "Data", the background color for example to Ivory.
Now, when the rule applies, I see the background color of white, that should be Ivory. 

So, apparently the rule creates a copy of the style when creating the rule, and applies a background color that I do not think is part of the rule. I know other applications that do this differently.

I see two options I think are logical:
1) in the style rule, allow a base style to be inputed (data in my example) 
2) When a rule applies, let me say what style to use. So, I have style "data", l create style "DataRule1" and say in my rule that when condition is met, style "DataRule1" must be applied.

Regards,

Erik
Steve
Telerik team
 answered on 19 Dec 2011
2 answers
64 views
I need to create reports in MVC3 and I use telerik, I could give a tutorial or guide to start doing reports

Thanks,
chris
Top achievements
Rank 1
 answered on 16 Dec 2011
1 answer
79 views
Hi,
my report is performed by a crossTable.
I would like to start witn all groups collapsed.
At the moment i get an explosed tableCross with toggle butto for each group. So it is need to collaps
the group manully one by one.
Is it possible (and  how) to start with all crosstable's groups already collapsed?
Thanks
Elian
Telerik team
 answered on 16 Dec 2011
3 answers
701 views
Is it possible to set conditional formatting within a StyleRule? I am attempting to set the background of an alternating row and want to avoid setting the conditional formatting repeatedly. If there is a way to loop through the rows in the code behind and set the conditional formatting based on row index, that would work too. (For example, change Style name from GridRow to AltGridRow if Mod2.)

Any help would be greatly appreciated. I am a little new to the control suite so I appreciate the patience!

Thanks,

Jake
jacob
Top achievements
Rank 1
 answered on 16 Dec 2011
Top users last month
Miljana
Top achievements
Rank 2
Iron
Iron
Joel
Top achievements
Rank 3
Bronze
Bronze
Bronze
Cynthia
Top achievements
Rank 1
John
Top achievements
Rank 1
Iron
Mozart
Top achievements
Rank 1
Iron
Veteran
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?