Hi,

I have encountered a little problem and i would be glad to receive some help.
If I create a stored procedure like this:

result will be quite obvious (it is just a sample to show You my problem).

Now, if I use this stored procedure as a data source command in Telerik Report Designer, it will of course show me the right result in window called "Preview Data Source Results"  but as soon as I click "Finish" button it will not display ANY columns in Data Explorer. Same story happens if I use table variable instead of tmp table. Question is, how can I get columns list in Data Explorer if I'm using tmp table or table variables in stored procedure ? Without it, it is a bit difficult to design anything, as every time I have to create procedure with simple select and proper column names, create data source command based on that procedure, and after that I am changing my procedure to "normal" code (column list in data explorer does not change in this situation). 

How can i avoid this ?

All the best,
Mateusz

I read that Telerik Reporting does not support nesting of aggregates and I don't know if there is a way to achieve the following:

* I have a report with a list of amounts and currencies. Some amounts are positive and others are negative.
* I have grouped the amounts by currency.
* In the group footer I put two textboxes:
1) textBox1.Value:  =Sum(IIF(Fields.Amount>=0;Fields.Amount;0))
2) textBox2.Value: =Sum(IIF(Fields.Amount<0;-Fields.Amount;0)) * At the very bottom I need to create a hashcode of respective group footer values. a) textBox3.Value: =Sum(textBox1.Value) b) textBox4.Value: =Sum(textBox2.Value) I can't seem to calculate values based on the group footer results however. Am I missing something really simple?
Yours,

Mattias Åslund

Hi

We use ReportViewer for report visualization, print and export in a silverlight application.  

Sometime after we save exported file(no matter what format) the control show exception of type "IO.IO_SharingViolationFile" please see the screen attached.

We need to hide this message from end user and show him some styled popup message with user friendly text.

We tried to add try{ }catch{ } block but sometime it helps sometime now.

then we looked at control ViewModel code and discovered here the reason why we can't catch this exception 

Below is the code listing:

    private void Save()
    {
        string documentName;
        bool flag;
        RenderingResult viewerModel = base.ViewerModel.exportResult;
        if (viewerModel != null)
        {
            SaveFileDialog saveFileDialog = new SaveFileDialog();
            saveFileDialog.DefaultExt = viewerModel.Extension;
            SaveFileDialog saveFileDialog1 = saveFileDialog;
            if (Application.Current.HasElevatedPermissions)
            {
                documentName = viewerModel.DocumentName;
            }
            else
            {
                documentName = null;
            }
            saveFileDialog1.DefaultFileName = documentName;
            saveFileDialog.Filter = ReportViewerModel.SaveExportCommandImpl.BuildSaveFileDialogFilter(base.ViewerModel.selectedExtensionInfo, viewerModel.Extension, base.ViewerModel.TextResources.AllFiles);
            saveFileDialog.FilterIndex = 1;
            SaveFileDialog saveFileDialog2 = saveFileDialog;
            bool? nullable = saveFileDialog2.ShowDialog();
            flag = (!nullable.GetValueOrDefault() ? false : nullable.HasValue);
            if (flag)
            {
                try
                {
                    Stream stream = saveFileDialog2.OpenFile();
                    using (stream)
                    {
                        byte[] documentBytes = viewerModel.DocumentBytes;
                        stream.Write(documentBytes, 0, (int)documentBytes.Length);
                    }
                }
                catch (Exception exception1)
                {
                    Exception exception = exception1;
                    MessageBox.Show(exception.Message);
                }
            }
            return;
        }
        else
        {
            throw new InvalidOperationException(base.ViewerModel.TextResources.UnableToExportError);
        }
    }

Please pay attention on this block 
  try
                {
                    Stream stream = saveFileDialog2.OpenFile();
                    using (stream)
                    {
                        byte[] documentBytes = viewerModel.DocumentBytes;
                        stream.Write(documentBytes, 0, (int)documentBytes.Length);
                    }
                }
                catch (Exception exception1)
                {
                    Exception exception = exception1;
                    MessageBox.Show(exception.Message);
                }

There is standard MessageBox shown and no exception is throw. It make impossible to work with such type of exeptions please fix it

I have a report with a table in it.  The table has four columns I know at design time, but there are a unknown number of dynamic columns that I want to display at run time to the right of the four design time/static columns.  Basically I am trying to replicate a Gantt chart and the first four columns are task names and key dates and the dynamic columns are the days I am going to eventually fill in with a background color if the task lands on the dynamic column representing the day.

I have found a couple samples in the forums for creating dynamic columns, but in all of the examples I get the following exception when I try to apply it to my code.



Below is report code that is generating the above error.


If anyone can provide a better example of how to dynamically add columns to a table that already has columns that would be great!

I am attempting to build a report with the Q2 2011 reporting tools but am running into numerous issues that are really confusing me. The report itself is part of an existing web project (not in a separate library) where an existing web.config has connection strings specified. When I try to create a new SQL data source the connection strings box lists all of my connections that show up in Server Explorer, but it won't list anything in my web.config. When I let the wizard create a new connection entry (which is identical to the existing one) the report generates  until I add a table and link it to the data source (which it created). At that point it tells me it can't connect to the DB because the connection name may be incorrect. I've confirmed the connection string it created is in the web.config but it still acts like it can't find it. I know the connection strings themselves aren't an issue as I created a new project, copied from the "old" web.config to the new one and they show up in the wizard and everything functions great. The database definitely isn't going down either as it is running on my local box.

Any ideas on what might cause this? I also tried an ObjectDataSource (using my LinqToSql objects) and in the code-behind of the report set the data source of that to a linq query but it won't run it (it was setup in the constructor).

Hello,

I have download and install the actual Telerik Reporting TRIAL. I will try to make a sample but when i drag the ReportViewer-Control to a WPF-View.

It come a error up: "Telerik.Windows.Controls is missing"

What is missing? Which licenses I must buy if I want to use only "Telerik Reporting"?

I've been trying to resolve this issue for over a week now and there's a huge demo of my customer's new site this week and I just cannot solve this issue.  It seems like such a minor thing yet it's causing a huge headache.  I finally tracked down what was causing it but I cannot seem to get around it.

I have a report that has a table inside of it with a 2nd data source.  It displays the data perfectly except for the fact that the text is right up alongside the table cells. If I try to add padding to the table cells it causes some serious display problems.  I've attached two screen shots.  One is the HTML Preview of my report Without padding and one With padding.

This display issue only occurs in HTML not in Print Preview and it exports just fine.  They preview the report through the Telerik WebForm Report Viewer however so I need it to show up appropriately in HTML.

Hello,

Hi Telerik Team.
I am new on Telerik reporting and I have looked for any information about what I want to do but any success.
I am trying to do a report which the source is an object I create from my model, which model has a navigation property which is a collection.
For example I create an Object ClassRoom(name, grade, code, amount students, etc) and I have a collection of student belong to that ClassRoom (which is a navigation property in my model), I also have a navigation property in my Entity Studen which is subjtects (Math, English, Spanish, etc), when I create my Object ClassRoom (my datasource) I CANT access to the collections when I am doing my report.
Please if someone can tell me what can I do? I would like to show in my report for example:

ClassRoom 1
Grade First
Code CLAS001
Amount Student 30

Details
Peter   12 years old   Math-9   English-8  Spanish-6
Tom     12 years old   Math-9   English-8  Spanish-6
Pep     12 years old   Math-9   English-8  Spanish-6
Rick     12 years old   Math-9   English-8  Spanish-6

In other things my Object is this was: ClassRoom has Students and Students has Subjects (there are navigation properties collections)
Thanks in advance!

Hi,
       I am am trying to export a report programmatically to then attach to an email. The report runs correctly and is save as expected, I just cannot get the parameter values to pass through to the report, I have followed the advice in the following two articles:

• Exporting Report Programatically
• InstanceReportSource class - this shows how to add initial parameter values

The report being used is used elsewhere in the website in a ReportViewer control wheer it's parameters are set prgramatically and it works correctly.

This is the code I am using is below:

Do you have any ideas as to why my reports is not receiving the parameters as passed to it. This code is setting the parameters via code but using a ReportViewer to see the result, this works as expected.


 I am using Q3 2012 (6.2.12.1017) in an ASP.NET 4 website.

Thanks

Chris