on 05-14-2009 3:12 PM
When I run this baby from design mode everything works great. When I run on to 2003 server the report comes up blank. It apprears not to be loading the report when ran from server in release mode.
The code is straight forword so I think this is a permissions issue with the server. Thanks for your help.
rptDocumentYTD.Load(path);
rptDocumentYTD.SetDataSource(ds);
CrystalReportYTD.ReportSource = rptDocumentYTD;
I am missing something on the server end for sure. Thank you
I should have mentioned earlier that this application started out in VS2005, and was upgraded to VS2008. We had no issues at that time with Crystal Reports. Three weeks ago we upgraded a development machine to CR 2008. We had the prompt to convert the solution to the newer version of Crystal as well as the prompt asking if it was fine to save the report in the newer version of Crystal. We said yes to both.
I just started a brand new VS2008 solution and added an ASP.NET Crystal Reports Website to it. I do not recall that being a choice before. One thing I noticed right away was a huge difference in the viewer in design mode. In our existing application, the .aspx page with the CRViewer is just a little box control. In the new one I just started, it has the same apperance as the running report does ... with a toolbar and frame, etc.
I tried dragging the CR Viewer control off the page in my older app and adding it back in but it still looks the same.
Now I am wondering if something didn't actually get updated or converted properly?? Any ideas??
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I had already stated that I tried deleting the viewer and adding it back on in the application that we are trying to deploy and nothing about its apperance has changed in design mode. It still runs fine on the development machine, and brings up the report in a newer viewer. all CR references in the project show 12.0.xxx . When I build this website and move it to our Windows 2003 server, everything about the website works EXCEPT for the CR Viewer. It brings up a blank page, no toolbar, no red x, no errors. Please see my earlier posts if you have any questions regarding the properties of the viewer or how it is loaded in the code behind.
I also stated that I had already created a new little VS2008 and added the CR Viewer to it. Only this time, in design mode, the viewer control looks very similar to what I see only in the browser window when we run our real app on our dev machine. So there is a big difference in between the viewer controls in DESIGN mode of VS2008.
All our existing reports are fed from datasets. Not sure how to set the CR Viewer to an existing path. Do you mean an existing report anywhere in the default app pool?
I really do appreciate your help as this is very frustrating. We expected much greater results when upgrading to full CR 2008. We did not expect to have so much trouble when moving an upgraded application to its server.
Remember, this is only a community forum, not technical support as such. If you're not getting what you need here, you always have the option of creating a phone case:
We've covered all the possible issues I can think of. Searching through these forums, I doubt you will find your issue and there is 1000s of post in here. So, yes your issue appears to be unique and talking to a technician should help.
Ludek
did anyone ever get a solution to this problem?? i have tailed many fora but still can not find a definitive solution. this problem is plaguing me. please help anyone!! (using CR 12, WINSERVER 2008, ASP.NET)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I've encountered this issue twice now. In both cases, it was a permissions issue.
Crystal installation programs create tools Crystal uses to render a report in inetpub\wwwroot\aspnet_client\Crystal....and so on.
My websites are typically in inetpub\webpages\myWebSite....and so on.
By default, site users do not have access (server security permissions-wise) to folders/directories 'above' the site they are using.
I fix it simply by placing a copy of aspnet_client in inside of my site folder. The it renders just fine.
HTH!
Ken, thank you very much for your input.
To all those coming upon this thread, I believe these issues and resolutions are documented in various Kbases (use the search box at the top right of this page). Also, see the following two articles;
Happy new year everyone,
Ludek
Thank you for your response. I had already read through the links and supporting documents from the links you just provided yesterday as they are also given in an ealier reply to the initial problem for the other user.
We are not even getting the red X, however. Can you point me to a specific reason that you think might be causing the issue? The web.configs are the same and it works on our local machine, so I feel it must be something changed in the machine environment, or perhaps a missed permission to one of the Crystal folders or something? I didn't find any assistance from the links you posted.
I verified that our page load on the reports is not within a !IsPostBack area. Here is that code:
protected void Page_Load(object sender, EventArgs e)
{
int id = Convert.ToInt32(Request.QueryString["ID"]);
vwDAPEnrollmentDetail vded = new vwDAPEnrollmentDetail();
if (Request.Url.ToString().Contains("Enrollment"))
{
vded.Where.ID.Value = id;
if (vded.Query.Load())
{
DataSet ds = new DataSet();
ds.Tables.Add(vded.GetMyDataTable);
ReportDocument report = new ReportDocument();
report.Load(HttpContext.Current.Server.MapPath("rptDAPEnrollmentDetailRptt.rpt"));
report.SetDataSource(ds);
DAPMaintenance.Entity.vwDAPNote vdn = new DAPMaintenance.Entity.vwDAPNote();
CrystalReportViewer1.ReportSource = report;
}
}
The reports are being brought up in a new window and you have to be logged into the website to see them (hence they are in seperate "admin" folder within the site).
Here is the code to bring up the new window
string strCmd = "window.open('DAPDetailReport.aspx?Page=Enrollment&ID=" + Session["DAPEnrollmentID"] + "','window','width=1024,toolbar=1, location=1, menu=1, scrollbars=1, resizeable=yes');";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "nothing", strCmd, true);
Would any of these things make a difference?
Is there a way I can post or send you a screen shot of the IIS Default Website tree?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The page is completely blank. We cannot see a toolbar. If we do "View Source", we can see the information we are trying to display in text format within some other html. If we right-click anywhere within the blank webpage and check its properties, all we see for the URL is the address of the page we are on.
We are using the default application pool with predefined NETWORK SERVICE account.
Edited by: alinhardt on Aug 13, 2009 11:47 PM
Edited by: alinhardt on Aug 13, 2009 5:28 PM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I am getting the same thing, works in VS2008 when running it through normal debug, but when it is put on a 2003 web server, it does not. It opens but there is nothing showing (blank). If you right-click on the window and select View Source it does have the data in the source code, but nothing is visible in the window. It does have a small image in the report, but not sure if that is the problem. Have installed CRRuntime_12_1_mlb.exe on the 2003 webserver. In IIS it does show the crystalreportviewer12 web service under the default web site treeview. Not sure what to do but any help would be appreciated.
Here is some of the code to the crystalreportviewer:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="DAPDetailReport.aspx.cs" Inherits="Admin_DAPDetailReport" Title="DAP Detail Report" %>
<%@ Register Assembly="CrystalDecisions.Web, Version=12.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"
Namespace="CrystalDecisions.Web" TagPrefix="CR" %>
<CR:CrystalReportViewer ID="CrystalReportViewer1" runat="server" AutoDataBind="True"
EnableDatabaseLogonPrompt="False" EnableParameterPrompt="False"
ReuseParameterValuesOnRefresh="True" EnableDrillDown="False"
HasCrystalLogo="False" HasDrillUpButton="False" HasExportButton="False" HasGotoPageButton="False"
HasSearchButton="False" HasToggleGroupTreeButton="False"
Height="50px" Width="350px"
ReportSourceID="CrystalReportSource1" DisplayToolbar="False"
HasDrilldownTabs="False" ToolPanelView="None" />
<CR:CrystalReportSource ID="CrystalReportSource1" runat="server">
<Report FileName="Admin\rptDAPDetailRpt.rpt">
</Report>
</CR:CrystalReportSource>
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Look at the two articles below. It is the viewers directory that is not installed correctly.
The install of the CR runtime will install the viewers directory in the correct place - if you are using default website. If you are using custom website, the runtime install has no idea what that is. Follow the suggestions for the viewers directory for your version of Crystal Reports.
Ludek
Hi,
The behavior occurs because the report's dynamic images are not created in the 'CrystalReportWebFormViewer' virtual directory's default location.The following work around changes the path of the dynamic image directory to reflect your actual directory location.
Steps to change the virtual directory
_____________________________
1. Right-click the square on the blank report screen where the image should appear and select 'Properties'.
2. In the 'Properties' window, note the image file name and locate the file on your local drive. The location of this file will reflect the directory where the dynamic images are being created.
3. Start Microsoft Internet Information Services Manager (IIS) 6.
4. In the IIS manager window, from the 'Tree' window, select the 'Default Web Site'.
5. To the right of the 'Tree' window are the 'Default Web Site' virtual directories and files. Right-click the 'CrystalReportWebFormViewer' directory and select 'Properties'.
6. In the 'Properties' window, modify the 'Local Path' text box to reflect the directory path displayed in the search results from step 2.
7. Verify the account you are using has full permissions to this directory.
Hope this helps!
Sincerely,
Nikhil Dharme
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Well, what threw me on this whole thread was one this post:
"It works just fine in compiler, I have tried a simple preview also. I tried just opeing a CR with just a text box that says "Hello""
Now, that report should have displayed the string. The only way it would not have, is if the report had if a background dynamic image of some sort, which you appear to confirm by:
2. In the 'Properties' window, note the image file name and locate the file on your local drive. The location of this file will reflect the directory where the dynamic images are being created.
If the report was created from scratch - no dynamic images, then the string would show up.
Ludek
BTW., as far as issues with images in a CR report, these two articles will be useful:
Edited by: Ludek Uher on May 15, 2009 7:00 AM
Hi,
For Simple Test- Save the Data with report and then try to view it.
If it does not show the report with Saved data then we can conclude that it is problem in rendering the report rather than loading the data.
Create a sample application where you directly assign the report to viewer through crystal report viewers properties at design time only and let the viewer prompt for information it might need.
Thanks,
Prasad Kanchan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
What version of Crystal Reports are you using?
What version of .NET are you using?
See if a sample app from this download will work (depending on the version of CR, you may have to recompile the app):
https://smpdl.sap-ag.de/~sapidp/012002523100006252712008E/csharp_web_smpl.exe
I'd recommend trying the csharp_web_simplepreviewreport from the above download.
Ludek
Yes it works in compiler, and shows up blank on our 2003 server. Yes we have the CR runtime deployed and we are using crystal in other apps to stream a PDF which is working.
I have traced the app and all appears to be working fine. I have the permissions set for Network Services user on the directory.
The viewer does come up, but the report is not loading or rendering correctly. This is the first app we are using the viewer on.
User | Count |
---|---|
71 | |
26 | |
10 | |
9 | |
7 | |
6 | |
4 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.