Telerik Forums
Reporting Forum
1 answer
128 views

Hello Friends,

In Telerik Windows Report , Can anybody tell us when Telerik Report Support  "Add hyperlink to the any field in windows report" ?

Thanks  in advance
Steve
Telerik team
 answered on 26 Oct 2009
1 answer
110 views
Hello,

Could anyone tell me how to produce table similar to this from below (click the link)?
IMAGE
Data are stored in Database. I need alternate columns.

Thank you,
Michal
Steve
Telerik team
 answered on 26 Oct 2009
4 answers
393 views
Hi there,

I have a strange problem with a report which works fine with the development webserver in VS 2008.
When I publish it on a IIS, the reportviewer can't find the pics for the buttons and the report is not loaded.

Searching in the forums for the problem I've found a handful of similar posts, but no luck, none of the tricks did work.
I ensured that:
- the reportviewer is referenced correctly in the web.config ( <system.webServer> / <handlers> )
- validateIntegratedModeConfiguration is set to false
- trust level is set to full trust

The output from Fiddler shows that the access to the ReportViewer.axd ends up with a 404 error (see below).

Any idea anyone what's wrong?


#   Result  Protocol    Host    URL Body    Caching Content-Type    Process Comments    Custom    
0   200 HTTP    agricura    /   3'123   private     text/html; charset=utf-8    iexplore:848              
1   200 HTTP    agricura    /ClientBin/DataService.axd/AgricuraRiaTelerik-Web-AuthenticationService/GetUser 480 no-cache  Expires: -1   text/json; charset=utf-8    iexplore:848              
2   200 HTTP    agricura    /ClientBin/DataService.axd/AgricuraRiaTelerik-Web-AuthenticationService/Login   597 no-cache  Expires: -1   text/json; charset=utf-8    iexplore:848              
3   200 HTTP    agricura    /ClientBin/DataService.axd/AgricuraRiaTelerik-Web-Services-AgricuraToolsService/GetSessionDuration  94  no-cache  Expires: -1   text/json; charset=utf-8    iexplore:848              
4   200 HTTP    agricura    /ClientBin/DataService.axd/AgricuraRiaTelerik-Web-Services-SdvSddService/GetSdvDatumsListe  115 no-cache  Expires: -1   text/json; charset=utf-8    iexplore:848              
5   200 HTTP    agricura    /ClientBin/DataService.axd/AgricuraRiaTelerik-Web-Services-SdvSddService/GetFrmSdv?Jahr=2008&Branch=56&FrmNr=115&DelStat=9  7'524   no-cache  Expires: -1   text/json; charset=utf-8    iexplore:848              
6   200 HTTP    agricura    /ClientBin/DataService.axd/AgricuraRiaTelerik-Web-Services-SdvSddService/GetFrmSdd?Branch=56&FrmNr=115&Jahr=2008&Monat=1    23'744  no-cache  Expires: -1   text/json; charset=utf-8    iexplore:848              
7   200 HTTP    agricura    /ClientBin/DataService.axd/AgricuraRiaTelerik-Web-Services-SdvSddService/GetPksInf?infBer=2&infKey1=115&infKeyA=FRMSDD&infKey2=2008&infKey3=1   672 no-cache  Expires: -1   text/json; charset=utf-8    iexplore:848              
8   200 HTTP    agricura    /ClientBin/DataService.axd/AgricuraRiaTelerik-Web-Services-AgricuraToolsService/SetPeriod   78  no-cache  Expires: -1   text/json; charset=utf-8    iexplore:848              
9   200 HTTP    agricura    /ClientBin/DataService.axd/AgricuraRiaTelerik-Web-Services-AgricuraToolsService/SetCultureInfo  78  no-cache  Expires: -1   text/json; charset=utf-8    iexplore:848              
10  200 HTTP    agricura    /ClientBin/DataService.axd/AgricuraRiaTelerik-Web-Services-AgricuraToolsService/WriteAddressToSession   78  no-cache  Expires: -1   text/json; charset=utf-8    iexplore:848              
11  200 HTTP    agricura    /ClientBin/DataService.axd/AgricuraRiaTelerik-Web-Services-AgricuraToolsService/GetGarLagReport 94  no-cache  Expires: -1   text/json; charset=utf-8    iexplore:848              
12  200 HTTP    agricura    /ClientBin/DataService.axd/AgricuraRiaTelerik-Web-Services-AgricuraToolsService/WriteFrmSddReportList   78  no-cache  Expires: -1   text/json; charset=utf-8    iexplore:848              
13  200 HTTP    agricura    /ClientBin/DataService.axd/AgricuraRiaTelerik-Web-Services-AgricuraToolsService/WriteFrmSddReportList   78  no-cache  Expires: -1   text/json; charset=utf-8    iexplore:848              
14  200 HTTP    agricura    /ClientBin/DataService.axd/AgricuraRiaTelerik-Web-Services-AgricuraToolsService/WriteFrmSddReportList   78  no-cache  Expires: -1   text/json; charset=utf-8    iexplore:848              
15  200 HTTP    agricura    /ClientBin/DataService.axd/AgricuraRiaTelerik-Web-Services-AgricuraToolsService/WriteFrmSddReportList   78  no-cache  Expires: -1   text/json; charset=utf-8    iexplore:848              
16  200 HTTP    agricura    /ClientBin/DataService.axd/AgricuraRiaTelerik-Web-Services-AgricuraToolsService/WriteFrmSddReportList   78  no-cache  Expires: -1   text/json; charset=utf-8    iexplore:848              
17  200 HTTP    agricura    /ClientBin/DataService.axd/AgricuraRiaTelerik-Web-Services-AgricuraToolsService/WriteFrmSddReportList   78  no-cache  Expires: -1   text/json; charset=utf-8    iexplore:848              
18  200 HTTP    agricura    /ClientBin/DataService.axd/AgricuraRiaTelerik-Web-Services-AgricuraToolsService/WriteFrmSddReportList   78  no-cache  Expires: -1   text/json; charset=utf-8    iexplore:848              
19  200 HTTP    agricura    /ClientBin/DataService.axd/AgricuraRiaTelerik-Web-Services-AgricuraToolsService/WriteFrmSddReportList   78  no-cache  Expires: -1   text/json; charset=utf-8    iexplore:848              
20  200 HTTP    agricura    /ClientBin/DataService.axd/AgricuraRiaTelerik-Web-Services-AgricuraToolsService/WriteFrmSddReportList   78  no-cache  Expires: -1   text/json; charset=utf-8    iexplore:848              
21  200 HTTP    agricura    /ClientBin/DataService.axd/AgricuraRiaTelerik-Web-Services-AgricuraToolsService/WriteFrmSddReportList   78  no-cache  Expires: -1   text/json; charset=utf-8    iexplore:848              
22  200 HTTP    agricura    /ClientBin/DataService.axd/AgricuraRiaTelerik-Web-Services-AgricuraToolsService/WriteFrmSddReportList   78  no-cache  Expires: -1   text/json; charset=utf-8    iexplore:848              
23  200 HTTP    agricura    /ClientBin/DataService.axd/AgricuraRiaTelerik-Web-Services-AgricuraToolsService/WriteFrmSddReportList   78  no-cache  Expires: -1   text/json; charset=utf-8    iexplore:848              
24  200 HTTP    agricura    /ClientBin/DataService.axd/AgricuraRiaTelerik-Web-Services-AgricuraToolsService/WriteFrmSddReportList   78  no-cache  Expires: -1   text/json; charset=utf-8    iexplore:848              
25  200 HTTP    agricura    /ClientBin/DataService.axd/AgricuraRiaTelerik-Web-Services-AgricuraToolsService/WriteFrmSddReportList   78  no-cache  Expires: -1   text/json; charset=utf-8    iexplore:848              
26  200 HTTP    agricura    /ClientBin/DataService.axd/AgricuraRiaTelerik-Web-Services-AgricuraToolsService/WriteFrmSddReportList   78  no-cache  Expires: -1   text/json; charset=utf-8    iexplore:848              
27  200 HTTP    agricura    /ClientBin/DataService.axd/AgricuraRiaTelerik-Web-Services-AgricuraToolsService/WriteFrmSddReportList   78  no-cache  Expires: -1   text/json; charset=utf-8    iexplore:848              
28  200 HTTP    agricura    /ClientBin/DataService.axd/AgricuraRiaTelerik-Web-Services-AgricuraToolsService/WriteFrmSddReportList   78  no-cache  Expires: -1   text/json; charset=utf-8    iexplore:848              
29  200 HTTP    agricura    /ClientBin/DataService.axd/AgricuraRiaTelerik-Web-Services-AgricuraToolsService/WriteFrmSddReportList   78  no-cache  Expires: -1   text/json; charset=utf-8    iexplore:848              
30  200 HTTP    agricura    /ClientBin/DataService.axd/AgricuraRiaTelerik-Web-Services-AgricuraToolsService/WriteFrmSddReportList   78  no-cache  Expires: -1   text/json; charset=utf-8    iexplore:848              
31  200 HTTP    agricura    /ClientBin/DataService.axd/AgricuraRiaTelerik-Web-Services-AgricuraToolsService/WriteFrmSddReportList   78  no-cache  Expires: -1   text/json; charset=utf-8    iexplore:848              
32  200 HTTP    agricura    /ClientBin/DataService.axd/AgricuraRiaTelerik-Web-Services-AgricuraToolsService/WriteFrmSddReportList   78  no-cache  Expires: -1   text/json; charset=utf-8    iexplore:848              
33  200 HTTP    agricura    /ClientBin/DataService.axd/AgricuraRiaTelerik-Web-Services-AgricuraToolsService/WriteFrmSddReportList   78  no-cache  Expires: -1   text/json; charset=utf-8    iexplore:848              
34  200 HTTP    agricura    /ClientBin/DataService.axd/AgricuraRiaTelerik-Web-Services-AgricuraToolsService/WriteFrmSddReportList   78  no-cache  Expires: -1   text/json; charset=utf-8    iexplore:848              
35  200 HTTP    agricura    /ClientBin/DataService.axd/AgricuraRiaTelerik-Web-Services-AgricuraToolsService/WriteFrmSddReportList   78  no-cache  Expires: -1   text/json; charset=utf-8    iexplore:848              
36  200 HTTP    agricura    /ClientBin/DataService.axd/AgricuraRiaTelerik-Web-Services-AgricuraToolsService/WriteFrmSddReportList   78  no-cache  Expires: -1   text/json; charset=utf-8    iexplore:848              
37  200 HTTP    agricura    /ClientBin/DataService.axd/AgricuraRiaTelerik-Web-Services-AgricuraToolsService/WriteFrmSddReportList   78  no-cache  Expires: -1   text/json; charset=utf-8    iexplore:848              
38  200 HTTP    agricura    /ClientBin/DataService.axd/AgricuraRiaTelerik-Web-Services-AgricuraToolsService/WriteFrmSddReportList   78  no-cache  Expires: -1   text/json; charset=utf-8    iexplore:848              
39  200 HTTP    agricura    /ClientBin/DataService.axd/AgricuraRiaTelerik-Web-Services-AgricuraToolsService/WriteFrmSddReportList   78  no-cache  Expires: -1   text/json; charset=utf-8    iexplore:848              
40  200 HTTP    agricura    /ClientBin/DataService.axd/AgricuraRiaTelerik-Web-Services-AgricuraToolsService/WriteFrmSddReportList   78  no-cache  Expires: -1   text/json; charset=utf-8    iexplore:848              
41  200 HTTP    agricura    /ClientBin/DataService.axd/AgricuraRiaTelerik-Web-Services-AgricuraToolsService/WriteFrmSddReportList   78  no-cache  Expires: -1   text/json; charset=utf-8    iexplore:848              
42  200 HTTP    agricura    /ClientBin/DataService.axd/AgricuraRiaTelerik-Web-Services-AgricuraToolsService/WriteFrmSddReportList   78  no-cache  Expires: -1   text/json; charset=utf-8    iexplore:848              
43  200 HTTP    agricura    /ClientBin/DataService.axd/AgricuraRiaTelerik-Web-Services-AgricuraToolsService/WriteFrmSddReportList   78  no-cache  Expires: -1   text/json; charset=utf-8    iexplore:848              
44  200 HTTP    agricura    /ClientBin/DataService.axd/AgricuraRiaTelerik-Web-Services-AgricuraToolsService/WriteFrmSddReportList   78  no-cache  Expires: -1   text/json; charset=utf-8    iexplore:848              
45  200 HTTP    agricura    /ClientBin/DataService.axd/AgricuraRiaTelerik-Web-Services-AgricuraToolsService/WriteFrmSddReportList   78  no-cache  Expires: -1   text/json; charset=utf-8    iexplore:848              
46  200 HTTP    agricura    /ClientBin/DataService.axd/AgricuraRiaTelerik-Web-Services-AgricuraToolsService/WriteFrmSddReportList   78  no-cache  Expires: -1   text/json; charset=utf-8    iexplore:848              
47  200 HTTP    agricura    /ClientBin/DataService.axd/AgricuraRiaTelerik-Web-Services-AgricuraToolsService/WriteFrmSddReportList   78  no-cache  Expires: -1   text/json; charset=utf-8    iexplore:848              
48  200 HTTP    agricura    /ClientBin/DataService.axd/AgricuraRiaTelerik-Web-Services-AgricuraToolsService/WriteFrmSddReportList   78  no-cache  Expires: -1   text/json; charset=utf-8    iexplore:848              
49  200 HTTP    agricura    /ClientBin/DataService.axd/AgricuraRiaTelerik-Web-Services-AgricuraToolsService/WriteFrmSddReportList   78  no-cache  Expires: -1   text/json; charset=utf-8    iexplore:848              
50  200 HTTP    agricura    /ClientBin/DataService.axd/AgricuraRiaTelerik-Web-Services-AgricuraToolsService/WriteFrmSddReportList   78  no-cache  Expires: -1   text/json; charset=utf-8    iexplore:848              
51  200 HTTP    agricura    /ClientBin/DataService.axd/AgricuraRiaTelerik-Web-Services-AgricuraToolsService/WriteFrmSddReportList   78  no-cache  Expires: -1   text/json; charset=utf-8    iexplore:848              
52  200 HTTP    agricura    /ClientBin/DataService.axd/AgricuraRiaTelerik-Web-Services-AgricuraToolsService/WriteFrmSddReportList   78  no-cache  Expires: -1   text/json; charset=utf-8    iexplore:848              
53  200 HTTP    agricura    /ClientBin/DataService.axd/AgricuraRiaTelerik-Web-Services-AgricuraToolsService/WriteFrmSddReportList   78  no-cache  Expires: -1   text/json; charset=utf-8    iexplore:848              
54  200 HTTP    agricura    /ClientBin/DataService.axd/AgricuraRiaTelerik-Web-Services-AgricuraToolsService/WriteFrmSddReportList   78  no-cache  Expires: -1   text/json; charset=utf-8    iexplore:848              
55  200 HTTP    agricura    /ClientBin/DataService.axd/AgricuraRiaTelerik-Web-Services-AgricuraToolsService/WriteFrmSddReportList   78  no-cache  Expires: -1   text/json; charset=utf-8    iexplore:848              
56  200 HTTP    agricura    /ClientBin/DataService.axd/AgricuraRiaTelerik-Web-Services-AgricuraToolsService/WriteDsToSession    78  no-cache  Expires: -1   text/json; charset=utf-8    iexplore:848              
57  200 HTTP    agricura    /Default.aspx?Lang=de-CH&RPT=Report2    16'006  private     text/html; charset=utf-8    iexplore:848              
58  404 HTTP    agricura    /Telerik.ReportViewer.axd?name=Resources.ParametersArea.css&version=3.1.9.807&optype=Resource   1'285       text/html   iexplore:848              
59  404 HTTP    agricura    /Telerik.ReportViewer.axd?name=Resources.ReportViewer.js&version=3.1.9.807&optype=Resource  1'285       text/html   iexplore:848              
60  404 HTTP    agricura    /Telerik.ReportViewer.axd?name=Resources.ReportViewerInternal.css&version=3.1.9.807&optype=Resource 1'285       text/html   iexplore:848              
61  404 HTTP    agricura    /Telerik.ReportViewer.axd?name=Resources.Parameters.js&version=3.1.9.807&optype=Resource    1'285       text/html   iexplore:848              
62  404 HTTP    agricura    /Telerik.ReportViewer.axd?name=Skins.Default.ReportViewer.css&version=3.1.9.807&optype=Resource 1'285       text/html   iexplore:848              
63  404 HTTP    agricura    /Telerik.ReportViewer.axd?name=Skins.Default.FirstPage.gif&version=3.1.9.807&optype=Resource    1'285       text/html   iexplore:848              
64  404 HTTP    agricura    /Telerik.ReportViewer.axd?name=Skins.Default.FirstPageDisabled.gif&version=3.1.9.807&optype=Resource    1'285       text/html   iexplore:848              
65  404 HTTP    agricura    /Telerik.ReportViewer.axd?name=Skins.Default.Background.gif&version=3.1.9.807&optype=Resource   1'285       text/html   iexplore:848              
66  404 HTTP    agricura    /Telerik.ReportViewer.axd?name=Skins.Default.PrevPage.gif&version=3.1.9.807&optype=Resource 1'285       text/html   iexplore:848              
67  404 HTTP    agricura    /Telerik.ReportViewer.axd?name=Skins.Default.PrevPageDisabled.gif&version=3.1.9.807&optype=Resource 1'285       text/html   iexplore:848              
68  404 HTTP    agricura    /Telerik.ReportViewer.axd?name=Skins.Default.NextPageDisabled.gif&version=3.1.9.807&optype=Resource 1'285       text/html   iexplore:848              
69  404 HTTP    agricura    /Telerik.ReportViewer.axd?name=Skins.Default.NextPage.gif&version=3.1.9.807&optype=Resource 1'285       text/html   iexplore:848              
70  404 HTTP    agricura    /Telerik.ReportViewer.axd?name=Skins.Default.LastPage.gif&version=3.1.9.807&optype=Resource 1'285       text/html   iexplore:848              
71  404 HTTP    agricura    /Telerik.ReportViewer.axd?name=Skins.Default.LastPageDisabled.gif&version=3.1.9.807&optype=Resource 1'285       text/html   iexplore:848              
72  404 HTTP    agricura    /Telerik.ReportViewer.axd?name=Skins.Default.Refresh.gif&version=3.1.9.807&optype=Resource  1'285       text/html   iexplore:848              
73  404 HTTP    agricura    /Telerik.ReportViewer.axd?name=Skins.Default.Print.gif&version=3.1.9.807&optype=Resource    1'285       text/html   iexplore:848              
74  404 HTTP    agricura    /Telerik.ReportViewer.axd?name=Skins.Default.RefreshDisabled.gif&version=3.1.9.807&optype=Resource  1'285       text/html   iexplore:848              
75  404 HTTP    agricura    /Telerik.ReportViewer.axd?name=Skins.Default.PrintDisabled.gif&version=3.1.9.807&optype=Resource    1'285       text/html   iexplore:848              
76  404 HTTP    agricura    /Telerik.ReportViewer.axd?name=Skins.Default.Loading.gif&version=3.1.9.807&optype=Resource  1'285       text/html   iexplore:848              
 


 
Steve
Telerik team
 answered on 23 Oct 2009
0 answers
124 views
I design a report, with 5mm PageBorders. In this Page is one DetailSection with a black field 10mm x 10mm in the left, top edge
When I print this Report, the black field is not on the correct position on the Paper.
I tried to reduce the Margins with HardMarginX and HardMarginY from the PrinterSettings Object in the constructor of the report. This is working for the Printout. But I think is not the best way to do this. How can I ensure that the report is printed on all printers in the correct layout.

Is there a posibility to set PageScaling to none for the PrintReport method?

If I export the Report to a PDF and print this report, all is at the correct position (Page Scaling = none).

Any ideas are welcome.

 

Bruno Brodmann
Top achievements
Rank 1
 asked on 23 Oct 2009
1 answer
94 views
I am using the StackedBar chart... when the fill colour of the plot area is the default, the report is generated with guide lines from the y-axis making it easy for the user to marry up bars with their values. I want this fill colour to be white/transparent, however when I select this I lose the guidelines. Is there a way to retain these when the fill colour is changed?

Thanks, Carl
Steve
Telerik team
 answered on 23 Oct 2009
3 answers
130 views
Hi

My reports have an sqlConection, sqlDataAdapter & sqlSelectCommand, and the report datasource is set to use the sqlDataAdapter.

I now want to go back and try passing the query param throiugh the properties, I've set the report datasource to none, but when I try to remove any of the data controls I get the error message - Object reference not set to an instance of an object.

How do I remove the data objectsa from my reports.

Andy
Steve
Telerik team
 answered on 22 Oct 2009
1 answer
105 views
Hi,
Is it possible to create a report dynamically?
I need to create a report sort of looking like an excel sheet with header columns and data columns.
The problem is that a user wants to choose from a list which columns to be added to the report, it can be just 1 column or it can be 15.

Do you have any examples like the one I need?

Regards,
Mattias

Steve
Telerik team
 answered on 22 Oct 2009
2 answers
119 views
Hello,
If I only buy the licence of RadControls for WPF.
Can I use the Telerik Reporting for free?
Donna
Telerik team
 answered on 22 Oct 2009
1 answer
103 views
Hey Guys, I have a simple question that I cannot answer.

I have a library of reports that I call successfully. I have a form with a report viewer which shows the report. The problem is, for this 1 report, a field does not require the entire size of the presized text box. I can easily resize the text box, but I fail to be able to move it to the right. userscore is the report object.

 

 

 
            userscore.detcol3.Value = "=average";  
            userscore.detcol3.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;  
            userscore.detcol3.Width *= .75;  
            userscore.detcol3.Style.BackgroundColor = Color.Teal;   
            userscore.detcol3.Location.X.Add(new Unit(1.0, UnitType.Inch)); 

 

 

Gersh
Top achievements
Rank 2
 answered on 21 Oct 2009
3 answers
883 views

I want to create a report that just shows the top 5 records for use in a dashboard. (I'll link to another page with the full results.) I want the number top number (5 inthis case) to be configurable, so I created a report parameter, RecLimit, which is an Integer with a default value of =5. To limit the records I created a filter on the report and used the Top N operator, so my filter looks like this:
    Expression: =RowNumber()
    Operator:    Top N
    Value:         =Parameters.RecLimit

When I preview the report, one of two things happens. If the report parameter UI.Visible property is set to True then I get the error "Filter cannot be evaluated. Value should evaluate to Integer." If the visibility is set to False then the report displays with all the records. The Top N filter is ignored.

If I run in debug I see this stack trace:

 

System.InvalidOperationException: Filter cannot be evaluated. Value should evaluate to Integer.

at Telerik.Reporting.Processing.Data.TopBottomFilterOperator.Create(IEnumerable`1 filters, Object context)

at Telerik.Reporting.Processing.Data.RuntimeDataSource..ctor(Object dataSource, String dataMember, IEnumerable`1 filters, IEnumerable`1 sorting, Object expressionContext, String name)

at Telerik.Reporting.Processing.Data.RuntimeDataSource..ctor(IDataSource dataSrc, Object expressionContext)

at Telerik.Reporting.Processing.ReportDataSource..ctor(IDataSource1D dataSource, Boolean detailGroup, Object expressionContext)

at Telerik.Reporting.Processing.Report.ProcessItem()

at Telerik.Reporting.Processing.ReportItemBase.Process(DataMember data)

 

Doesn't RowNumber() return an Integer?
What am I doing wrong here?

I created the report with Reporting Q2 2009 (version 3.1.9.807).

Steve
Telerik team
 answered on 20 Oct 2009
Top users last month
Cynthia
Top achievements
Rank 1
Iron
Toby
Top achievements
Rank 3
Iron
Iron
Iron
Danielle
Top achievements
Rank 1
Iron
Iron
Joel
Top achievements
Rank 3
Bronze
Bronze
Iron
yw
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?