Telerik Forums
Reporting Forum
0 answers
134 views

Hi Guys

 

I want the user to be able to select which columns we display in their reports. I've got a multiselect parameter that has a list of the reports' columns as the display member (and a number as the value member).

 

In the Column Groups I've added in a filter on one of the columns like so:

However when I try to run the report I get this error:

 

I've troubleshooted the Parameters.availableColumns.Value and it has the expected values.

 

I've troubleshooted this expression "1 In Parameters.availableColumns.Value" in the report body itself and it works as expected (shows true/false correctly)

 

I've changed the expression in the Column Grouping box to both "1 = 1" and "1 =2" and it shows/hides the column as expected.

 

The only thing I can think of is Parameters.availableColumns.Value isn't populated when it hits that expression in the Column Grouping. Is that right? And if so how can I go about giving the user the option to select the columns they want to show?

Richard
Top achievements
Rank 1
 asked on 10 Sep 2021
1 answer
271 views

I have a bar chart embedded into a column of a report. The report has these columns:

Name

Responses

Estimated

Percent Total (Responses / Estimated) * 100

Progress (bar chart)

For the bar chart, the x-axis is numerical and  the y-axis is category. The X value is set to =Fields.PercentTotal and the Y value is blank.

The problem is that the chart is always blank.

For the 3rd row above I'm expecting a bar that's around 1/3 of the length from 0 to 1. What setting do I need to change to make the bar appear?

Thanks

Tim
Top achievements
Rank 3
Iron
Iron
Iron
 updated answer on 09 Sep 2021
0 answers
306 views

Back in the glory days of WebForms, the Telerik report designer lived in Visual Studio. This was fabulous.

Haven't had to write a report for a few years, but now a new batch is needed. Can't find my trusty report class in the Add New Item... dialogue.

I see there's an old-style report designer app which looks like Crystal Reports from 1998: has the trusty VS designer gone?

PH
Top achievements
Rank 2
 asked on 09 Sep 2021
4 answers
374 views
Is there a way to generate a Trend Line on a bar chart?

My graph at the moment shows All Events as a stacked bar chart, and I want a trend line to appear also, but can't see how to create one :o
Tommy
Top achievements
Rank 1
Iron
Iron
Iron
 answered on 09 Sep 2021
0 answers
337 views

I would like to hide the "Column3" column and the "Column3" row based on the value of a report parameter.  I can't seem to figure out how to do this with conditional formatting as you can't apply that to a whole column or row in a crosstab.  Can this be done?


1 answer
111 views

Hi guys, i'm trying to use report server but there is something wrong.

Follow the images:

 

 

This occours when i try to render my report.

The header and the other text are okay, they are rendering.

The other images will show the configuration based on a webServerDataSource.

 

my report.

 

my data

 

my data configuration and i get the my json with the value.

 

the value of the property that i want

 

the data source from my webServiceData.

Neli
Telerik team
 answered on 06 Sep 2021
1 answer
159 views

Hye,

 

I got problem with export report book to pdf.

here is my code

class TestPart : Report1
    {
        public TestPart()
        {
            this.DocumentMapText = "Sales By Region";
        }
    }


Telerik.Reporting.ReportBook ourBook = new Telerik.Reporting.ReportBook();

            var tocReportSource = new TypeReportSource();
            tocReportSource.TypeName = typeof(ReportBookToc).AssemblyQualifiedName;
            ourBook.TocReportSource = tocReportSource;

            ourBook.ReportSources.Add(new TypeReportSource
            {
                TypeName = typeof(TestPart).AssemblyQualifiedName
            });

            Telerik.Reporting.Processing.ReportProcessor rProc = new Telerik.Reporting.Processing.ReportProcessor();
            Telerik.Reporting.InstanceReportSource irs = new Telerik.Reporting.InstanceReportSource();
            System.Collections.Hashtable dinfo = new System.Collections.Hashtable();
            irs.ReportDocument = ourBook;

            Telerik.Reporting.Processing.RenderingResult result = rProc.RenderReport("PDF", irs, dinfo);

            string fileName = result.DocumentName + "." + result.Extension;
            string path = System.IO.Path.GetTempPath();
            string filePath = System.IO.Path.Combine(path, fileName);
            
            using (System.IO.FileStream fs = new System.IO.FileStream(filePath, System.IO.FileMode.Create))
            {
                fs.Write(result.DocumentBytes, 0, result.DocumentBytes.Length);
                fs.Close();
            }

the problem is TOC is empty.

here is result

Neli
Telerik team
 answered on 06 Sep 2021
1 answer
191 views

Hi everyone, I'd appreciate any input on the following problem:

I have a crosstab with "sales period" as column group, and the detail value is sum of sales.

my report structure is pretty much identical to this demo: https://demos.telerik.com/reporting/product-sales

the only difference is that I will only compare 2 periods, and never more. that should make things hopefully easier. (in other words: a 'SELECT DISTINCT period' on the datasource will always return 2 values.)

Now I would like to show a sales index by comparing period1 to period2 in an additional column.

how can I do that?

 

Faye
Top achievements
Rank 1
Iron
 answered on 04 Sep 2021
0 answers
101 views

I am facing a problem with report viewer, the pagination on report does not seem to work correctly although it shows all pages in Pagination section of report viewer but by click on next page does not seem to work and it shows all pages on every page. Please see the attach screenshot.

What the correct result for me is to show each page when I click on next page button not all pages.

abdul
Top achievements
Rank 1
 updated question on 31 Aug 2021
1 answer
124 views

I have created the following report it is not clear to see what id is which part of  the donut chart. 

I am not able to find how to make it clearer either by label or being able to created series label at the bottom of the report something like the following.

 

Dimitar
Telerik team
 answered on 31 Aug 2021
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?