Telerik Forums
Reporting Forum
6 answers
278 views

Hi,

I've created a report whose filter label may change.  I'm passing the filter label in as a parameter but when I go to set the label text, the filter label is not appearing when the page first opens and the report includes all data.  When I change the filter or dates and the report refreshes, the filter label is then displayed.  I'm setting the label to the parameter.FilterLabel.Value but again, it doesn't display until the report is refreshed after the initial report is displayed after opening the page.  Any ideas on how to get this filter label to display when the page opens?

 

I've include a pic of what the filter looks like when the page first opens and after a filter is selected.  I'm passing the string 'Department' in as a parameter.

 

Thanks,

Jim

 

Jim
Top achievements
Rank 1
 answered on 25 Jun 2018
16 answers
2.6K+ views

I was successfully running Telerik Reporting R2 2016 (Telerik_Reporting_R2_2016_SP1_10_1_16_615_DEV.)   in my VS 2015. Recently I upgraded from VS 2015 to 2017 . Now I am unable to edit/create new reports in VS 2017 Report Designer as the Telerik Reporting Toolbox and Menu items are missing in VS 2017.

I can open the report file in Report Designer though.

headPropellerHead
Top achievements
Rank 1
 answered on 25 Jun 2018
8 answers
334 views
Here is a snippet of a TRDX

    <PageHeaderSection Height="0.899999936421712in" Name="pageHeader">
      <Items>
        <TextBox Width="4.07916673024496in" Height="0.400000015894572in" Left="0.0208333333333333in" Top="0.0208333333333333in" Value="Workspaces" Name="reportNameTextBox" StyleName="PageInfo" />
        <PictureBox Url="~/images/logo.png" Width="1.79999987284342in" Height="0.700000047683716in" Left="4.63750012715658in" Top="0.0208333333333333in" Sizing="ScaleProportional" MimeType="" Name="pictureBox1" />
      </Items>
    </PageHeaderSection>

I am trying to specify the image relative the virtual directory (this is not a web site) of the place where the report controller resides (REST API)

What is the correct syntax?
Silviya
Telerik team
 answered on 25 Jun 2018
1 answer
466 views

Hi,
I am creating the report with standalone designer. 
My sample datasource will be like this below,

Data Source
-----------
Name,QtyValue,DateTime
S001,100,2018-05-01
S001,200,2018-05-02
S001,300,2018-05-03
S001,50,2018-05-04
S001,250,2018-05-05
S001,100,2018-05-06
S002,200,2018-05-02
S002,30,2018-05-04
S002,100,2018-05-05

In my report group footer, I would like to display the 
Maximum/Minimum Qtyvalue and the DateTime value for that maximum value. 
I tried to use the expression 
IIF(Fields.QtyValue =  Max(Fields.QtyValue), Fields.DateTime, "")

It didn't work. Can you guys please advise me how to achieve.

Expected
---------
Name: S001

Max                                        Min
Value         Date                     Value            Date
300            2018-05-03          50                 2018-05-04


Actual
-------
Name: S001
Max                                Min
Value  Date                    Value          Date
300                                 50              

Thanks in advance. 

Todor
Telerik team
 answered on 22 Jun 2018
3 answers
1.3K+ views

I'm using the standalone Report Designer, and I'm trying to export my report to Excel with each order line item on a separate sheet. My report has orders, and each order has one or more line items. Basically, our customer wants to see separate reports on each tab showing the order header data and the line item data.

I've seen suggestions to use the Report Book feature, but we're using the standalone designer, and the report book feature seems to be a programmatic solution. I need a solution I can implement in the designer.

Thanks!

Nasko
Telerik team
 answered on 22 Jun 2018
1 answer
113 views

Hi everybody,

   we need to print a report with following format:     

Silviya
Telerik team
 answered on 22 Jun 2018
1 answer
212 views

Hi everybody (second try):

    we need to print a report with format attached in file. 

Header of Report
 
Group with Name A                                            Subtotal of Group
 
  First Subgroup of Group A                                 Subtotal of Subgroup
 
    First Subgroup of subgroup of Group A                  Subtotal of Subsubgroup
 
    Second Subgroup of subgroup of Group A                 Subtotal of Subsubgroup
 
  Second Subgroup of Group A                                Subtotal of Subgroup
 
Group with Name B                                            Subtotal of Group
 
  First Subgroup of Group B                                 Subtotal of Subgroup
...
 
Total                                                        Total

 

    In other words, we need beginning of a subgroup can be bellow parent group. Is it possible?

Very thanks

Silviya
Telerik team
 answered on 22 Jun 2018
1 answer
214 views

I have group its header print on every page if the detail will be extended to more pages.

But, I need to do conditional formatting or binding to check if group header is repeated in this page (this group data displayed in previous page or not) or not.

 

Example : 

Product Category 1 Group Header
        Product 1 Detail
        Product 2 Detail

Product Category 1 Group Header
        Product 7 Detail

Product Category 2 Group Header
       Product 3 Detail
       Product 4 Detail

Product Category 3 Group Header
      Product 5 Detail
      Product 6 Detail


Silviya
Telerik team
 answered on 22 Jun 2018
11 answers
424 views
I am trying to embed a telerik report into my asp.net web application and am having difficulties.  The report was built in a class library, "blah.Reports" and then the project was added to my application.  I added the reference to the class library as well.  When I try to set the "Report" property of the ReportViewer in my page I get a Visual Studio Error:

Value cannot be null.
Parameter name: key

Because I could not get around this I tried another route:
I looked at some examples and manually set the report property in the xaml with this:
blah.Reports.Statement, blah.Reports, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null

Now the report shows up in the page with text boxes to enter the parameters, but as soon as I enter them I receive a new error:

An error has occurred while processing Report 'Statement':
Unable to establish a connection to the database. Please, verify that your connection string is valid. In case you use a named connection string from the application configuration file, make sure the name is correct and the connection string settings are present in the configuration file of your application.
------------- InnerException -------------
Format of the initialization string does not conform to specification starting at index 0.

I copied the connection string from the app.config of the class library to my asp.net app's web.config, still no dice.  Same error.  Any help would be greatly appreciated.
headPropellerHead
Top achievements
Rank 1
 answered on 21 Jun 2018
6 answers
3.0K+ views

I have created one report in standalone report designer (Report.trdp), using object data source (my custom CLR type). It´s possible to programmatically load the report file and set the data source like a report created in Visual Studio (Report.cs)?

 

Idea of code:

Report reportFromFile = new Report(@"c:\temp\Report.trdp");
reportFromFile.DataSource = _repository.Query().ToList();

 

Regards,

André

ivan
Top achievements
Rank 1
 answered on 21 Jun 2018
Top users last month
Chester
Top achievements
Rank 1
Iron
Simon
Top achievements
Rank 1
Iron
Douglas
Top achievements
Rank 2
Iron
Iron
SUNIL
Top achievements
Rank 3
Iron
Iron
Iron
Marco
Top achievements
Rank 3
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?