Crystal Reports :: Integrate Into Web Application - Images On Parameters Screen?
Aug 27, 2010
I have been trying from the past two weeks to integrate crystal reports into my web application. The problem is "We created some reports using Crystal Reports 2008(Sp2) and we are trying to integrate those reports into webpage. Everything works fine on my local machine but when it is deployed to the production server i ran into a lot of problems..
Problem-1 : First time I load the report it comes to the screen where it prompts for DB credentials and stucks up there..I mean those are non editable and doesn't go to next screen. On my local machine the report even didn't prompt for DB credentials. Why it prompts when moved to prod'n Box? How to avoid that?
Problem-2: How about the images on parameters screen?
I have question regarding printer option page which pop up when i click on print button on crystalreportviewer and when i click okay on that pop up page it displays print preview of the report.
Is there any way to skip that pop up window(Printer Option) and just display (PDF)print preview screen instead?
(I am not exporting report to pdf, just want to display printview screen and when the user click on print button it will print out the page)
I have tried following code but i am getting error:
"Object reference not set to an instance of an object."
I have already generated crystal reports but i've made them static. but now i want to make the user to select the criteria for generating the reports. for eg., in one of them i want to show monthwise data so user should be able to select the month and year and that would be passed as parameter and compared to the existing data. provide me with proper exact code that can be used for giving parameters in such a report using C#.
I'm new to Visual Studio.NET . I need to integrate the crystal reports into an ASP.NET application. I generated Crystal report with the help of crystal report XI developer edition(Stand alone version and NOT from the one which comes from visual studio).
How to integrate this report with the web application.
After some internet sifting i found how to create a crystal report using the disconnected model and learnt how to pass parameters to it.
In my report am suplying a range of dates to select data inside the range; when the report only has one page (or the first of a multi paged) everything works like a charm. The problem is when i naviagate the report using the default toolbar buttons on the crystalreportviewer, the report asks for the very same parameters ive set in code behind.
I was using queystring parameters to pass the parameters (i have a page where you pick the report types and another which has the reportviewer and displays the reports previously selected)
and i thought that they got lost because when you click next/previous there is a postback...switched to session variables and it is still the same.
1: How can i solve this?
2: Is there a way to cache all the report so that navigation doesnt require database access?
3: How can i open the reports without any browser controls /toolbars?
When i run the application locally it works fine but when i publish it n access from it it gives the error asEither the Crystal Reports registry key permissions are insufficient or the Crystal Reports runtime is not installed correctly.
to print a crystal report from the server's printer with a button on the web application.Assume that I have a ASP .NET Web Application, When i press the "print" button on the web application, the server which holds the web application prints the specific crystal report with specific data set. Is this possible? How I am going to make this happened?I am sorry to say that I'm very new to all these web programming,
My report is displayed without any problem. However, when I click on the button from my crystal report viewer toolbars I get the error. Note : the toolbars is working fine on my local machine.
Error message : Logon failed. Details: mscorlib : Could not find a part of the path 'C:Documents and SettingschiaMy DocumentsVisual Studio 2008WebSitesSafety Permit System ptLoad_ConfineSpace_Summary.xml'. Error in File C:WINDOWSTEMP ptPrintSummaryConfineSpace {965CF937-D48C-483A-AC32-198A790880A6}.rpt: Unable to connect: incorrect log on parameters.
I'm passing some parameters to a CR report programatically and it was working fine, but now that I have added a new date parameter to the report, for some reason, it is prompting me to enter that parameter on screen (the user isn't allowed to set that parameter is the system who must set it.), I haven't changed a thing other than adding the new date parameter, and all the other parameters behave normal, just the date parameter is prompted even thought I've already set a value for the parameter.
Just for the sake of things: I have checked that the parameter is indeed a date and that it is well formed. CR prompts me to enter it in the format (mm/dd/yyyy hh:mm:ss) so I pass date in that exact format (In fact I've even tried hard coding a well-formed date and it still prompts me to enter the date).
I am trying to find a way that would allow me to display the parameters that have been selected when there are no records found
For instance.
Pulling from a database with a employee table that contains name, address, city, state, zip, job titile and shift.
i then have two list boxes set up that collect the paramets for the reports. One for the job title and one for the shift.
i want to be able to say that no records are found for "managers" on "third shift" where managers and third shift are the parameters from the listboxes.
consider the example where there is a report which displays all products or a single product from a table through a drop down list selection. The dropdown list also has a '- ALL -' selection item So the resulting query might be
Select * from products OR Select * from products where ID={id}
Now I have a single report , I am using sql CASE for differentiating between all products or a single product. Another approach is to pass a different value with where clause in report parameters like
[Code]....
What I like to know is what is the best approach? Is doing this inside query is best or specifying the where clause in the report parameters is right? I personally feel much safe with the SQL query CASE.
i want to show a crystel report on page load of page. where i want to show report of those student who logged in the system and their session is created.
I'm using Crystal Reports in a Webform inside of an MVC application. Images in the reports are not being displayed, however, on both the ASP.NET Development Server and IIS 7 (on Win7x64).
I know from a number of other questions similar to this that the CrystalImageHandler HTTP Handler is responsible for rendering the image, but I've tried all of the usual solutions to no avail.
So far, I have
Added the following to my appSettings (via http://www.mail-archive.com/bdotnet@groups.msn.com/msg26882.html) <add key="CrystalImageCleaner-AutoStart" value="true" /> <add key="CrystalImageCleaner-Sleep" value="60000" /> <add key="CrystalImageCleaner-Age" value="120000" /> Added the following httpHandler to system.web/httpHandlers (via http://stackoverflow.com/questions/2253682/crystal-report-viewer-control-isnt-loading-the-images-inside-the-report) <add verb="GET" path="CrystalImageHandler.aspx" type="CrystalDecisions.Web.CrystalImageHandler, CrystalDecisions.Web, Version=12.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/> Added the following to my Global.asax.cs (via http://stackoverflow.com/questions/2006011/crystal-reports-images-and-asp-net-mvc) routes.IgnoreRoute("{resource}.aspx/{*pathInfo}"); and routes.IgnoreRoute("CrystalImageHandler.aspx");
i created a crystal report in my project . that is report worked fine if i run in debug mode(F5).then i created a virtual directry "myweb". if i run it from the browser like "localhost/myweb".. Data is displaying properly.but crystal report header images are not displaying. and i am not able to export & print.i have "aspnet_client" in www root folder. crystal report images and hava script files are exists in below path
I have a crystal report designed in cystal report 9. The report also has a sub report. Now what I want is to show dynamic image in the sub report. My images are saved in sql server 2005 as image. Anyone has any idea how to show the images from sql server 2005 to crysatal report.
We have just migrated our Application's reports from Crystal Report 10 To 12. But on conversion everything goes fine.Except the reports which are built on Typed data sets started genrating the Message "The report you requested requires further information". with the login parameters dispalying on the page.{Note: we are using Visual Studio 2005 (framework2.0)}