Telerik Forums
Reporting Forum
4 answers
385 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
121 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
85 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
125 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
97 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
115 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
102 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
873 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
1 answer
87 views
Hi,

Is it possible to render Crosstab or Table as image?. So that I can avoid table layout in Exported RTF file. Borders are showing in the exported report, that looks ugly. Otherwise any other way to avoid table borders?

Please help me.


Regards,

B.Sridhar


Steve
Telerik team
 answered on 20 Oct 2009
1 answer
126 views
It looks like when I call "RefreshReport()" on the WinForms report viewer it gives the focus to the report viewer. Is there a way I can prevent this functionality? I want the focus to stay where it is.
Steve
Telerik team
 answered on 20 Oct 2009
Top users last month
Edmond
Top achievements
Rank 1
Iron
fabrizio
Top achievements
Rank 2
Iron
Veteran
RobMarz
Top achievements
Rank 2
Iron
Fakhrul
Top achievements
Rank 1
Iron
Tejas
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?