I am using crystal report with ASP.NET 3 web application.
I am facing an issue with the default search functionality of the crystal reports.
When typing a word and hit enter, it searches only in the column headers, title, footer, summary columns, . Not searching in the data field in the details section.
But in the sub reports, everything is fine, searching in all the fileds.
we deliver micro-site content for our client. Our content is injected into a wrapper that is supplied by another developer.
To deliver our content we host the wrapper as well as the content. The user can access this at
[URL]
For the other content that is not ours, the other developer hosts a similar (though slightly different) wrapper and delivers the content. the user accesses this here:
[URL]
The wrapper contains a search box, which does not work for us but it works for the other developer. I took a look at the network traffic with FireBug but it appears that when I do the search from the wrapper that we're hosting, I'm getting a "407 Proxy Access Denied" error. My guess is their proxy has a problem with the fact that the search is being conducted from a page hosted outside the scope of their proxy.
It was also suggested that there were javascript errors on the page that were preventing the search from executing but I can't see any. Also, I don't think I'd get as far as the proxy error if that was the case.
I have master page, menu on master page, i use asp roles and trim menu item based on user roles and rights this process is working fine.
Now i have to create some reports based on user roles, and responsibility in a company like country head will view country wide reports, manager region will only view regional report and rest will view reports related to them.
How can i achieve this efficiently using asp roles.
I am trying to use crystal report for my project. I have made .rpt file as instructions in the tutorials now the problem is with crystal report viewer control... i hav set its its report source to the one that i have made using its properties.. but still its not working..I am using professional edition of visual studio 2008 with .net frameowrk 3.5
View 3 RepliesI have created a crystal report application using VS 2005 on my Dev machine, it worked correctly.On another machine where VS 2005 is also installed, it is not working.
The DLL that is giving error is:
<add
assembly="CrystalDecisions.ReportAppServer.ClientDoc,
Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>
If I search for this DLL on my Dev machine, I can't find it.
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.
View 2 Repliesi am using this code to search record in crystal report when print from print report button in crystal report i am using this code for displaying record .
using CrystalDecisions.Web;
using CrystalDecisions.Shared;
public partial class About : System.Web.UI.Page
{
[Code].....
am newbie to asp.net 3.0 ,req: is like ...whn user enters id in the textbox,the query has to run against the sql server DB and has to generate the result inside a gridview with a chkbox field by default chked,now in the DAL layer ,is it better option to use datareader(think not,since it has to always maintain connection)..or webservice or WCF or are there any other simple optios available??
View 2 RepliesI want to give option to user with two or three search parameters in textbox or dropdownand the result should display in CrystalViewer.
I know how to do this task with gridview but don't know how to do the same with CrystalViewer.
Moreover, can I have a weblink to download Video lecture on CrystalViewer?
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
[Code]....
How can i remove the default space between two pages in Crosstab report
View 1 RepliesI'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.
We have quite a few reports which were developed earlier in Crystal Reports 8.5. We are now planning to use these reports in our web application developed in VS 2008 (C#).
What dlls are needed for calling 8.5 in the application and how should they be added to the application while shipping it to the client?
They are also struggling to get the code running. Would also need the code to call the report with parameters.
I've just upgraded a visual studio.net 2003 project (asp.net 1.1) to visual studio.net 2010 (asp.net 4.0). I'm encountering a problem with viewing Crystal reports. I'm using Visual Studio Development Server as a Web Server.
When I try to create a new report (via code that worked fine previously) the line below causes the webserver40.exe to crash.
Protected WithEvents MyRep As New CrystalDecisions.CrystalReports.Engine.ReportDocument
I've got Crystal Reports 11 installed.
I'm using vs2005 asp .net using c#and i using the crystal report viewer to create my report and preview the report using crystal report viewer. When i run the application, i can preview the report well in the form, but when i click any button of th tool bar then a blank page is getting displayed.
View 5 RepliesI generate report using parameters.I pass parameter on run time & report is generated. For Example: At first i am displaying A list of customers having SEX = MALE. Than I enter SEX = FEMALE. But it still displaying the MALE list Results. If i rebuild my webform and than put parameter FEMALE then it displays. So, If i generate a report once. I dont want to rebuild my webform to pass new parameter. . How it should be Done. I added one line code CrystalreportViewer1.RefreshReport(); but it did not work for me. I am using VS 2010..
View 1 RepliesI 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#.
View 3 RepliesMy 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.
Everythings working fine on my PC but when I deployed my application on server, Print and export are not working. Even the toolbar images were not displaying on the report. So I added them manually to my application.
Is there some folder missing?
I'm running CR XI, and accessing .RPT files through a ReportViewer in my ASP.NET pages. I've already got the following code, which is supposed to set the Report Datasource dynamically.
rptSP = New ReportDocument
Dim rptPath As String = Request.QueryString("report")
rptSP.Load(rptPath.ToString, 0)
Dim SConn As New System.Data.SqlClient.SqlConnectionStringBuilder(ConfigurationManager.ConnectionStrings("MyConnectionString").ConnectionString)
rptSP.DataSourceConnections(SConn.DataSource, SConn.InitialCatalog).SetConnection(SConn.DataSource, SConn.InitialCatalog, SConn.UserID, SConn.Password)
Dim myConnectionInfo As ConnectionInfo = New ConnectionInfo
myConnectionInfo.ServerName = SConn.DataSource
myConnectionInfo.DatabaseName = SConn.InitialCatalog
myConnectionInfo.UserID = SConn.UserID
myConnectionInfo.Password = SConn.Password
'Two new methods to loop through all objects and tables contained in the requested report and set
'login credentials for each object and table.
SetDBLogonForReport(myConnectionInfo, rptSP)
SetDBLogonForSubreports(myConnectionInfo, rptSP)
Me.CrystalReportViewer1.ReportSource = rptSP
But when I go into each .RPT file, and open up the Database Expert section, there is obviously still servernames hardcoded in there, and the code listed above doesn't seem to be able to change the servernames that are hardcoded there.
I say this because I have training and production environments. When the .RPT file is hardcoded with my production server, and I open it on my training server with the code above (and the web.config has the training server in the connection string), I get the ol:
Object reference not set to an instance of an object.
And then if I go into the .RPT file, and change over the datasource to the training server, and try to open it again, it works fine. Why doesn't the code above overwrite the .RPT files datasource?
How can I avoid having to open up each .RPT and change the datasource when migrating reports from server to server? Is there a setting in the .RPT file I'm missing or something?
I wrote a crystal web server using asp.net security. i have multibple reports in a few different directories, and i have a report viewer form in each secured directory. when i load a particlular report on one machine's web browser, if i go to another machine and launch that report, the report instantly shows up with the parameters selected from the other machine. it's like after the report launches, the next request for that report just dishes out the previously built page.
I have not experienced this before, and makes my report site kinda useless. why these reports aren't treated as separate sessions?
*here is the markup for the frmReportViewer.aspx page:*
<form id="form1" runat="server">
<CR:CrystalReportViewer ID="CrystalReportViewer1" runat="server"
AutoDataBind="true" BestFitPage="False" Width="1100" Height="680"
ReportSourceID="CrystalReportSource1" BorderColor="#000099"
BorderStyle="Inset" PrintMode="ActiveX" />
<CR:CrystalReportSource ID="CrystalReportSource1" runat="server">
<Report FileName=""
</Report>
</CR:CrystalReportSource>
</form>
*here is the vb code for the frmReportViewer.aspx page:*
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Me.CrystalReportViewer1.HasCrystalLogo = False
If Not IsPostBack Then
ReportName = Request.QueryString("reportname") & ".rpt"
Me.CrystalReportSource1.Report.FileName = ReportName
DBConnectionForReports(CrystalReportSource1.ReportDocument)
End If
end sub
Public Function DBConnectionForReports(ByRef rpt As ReportDocument) As Boolean
Dim logonInfo As New TableLogOnInfo
'Dim table As System.Web.UI.WebControls.Table
Dim srptServer As String
Dim srptUN As String
Dim srptPass As String
Dim crConnInfo As New ConnectionInfo
Dim subRepDoc As New ReportDocument
Dim table As Table
For Each table In rpt.Database.Tables
srptServer = "calp"
srptUN = "cdiappsro"
srptPass = System.Configuration.ConfigurationManager.AppSettings.Item("OraclePassword").ToString
logonInfo = table.LogOnInfo
logonInfo.ConnectionInfo.ServerName = srptServer
logonInfo.ConnectionInfo.UserID = srptUN
logonInfo.ConnectionInfo.Password = srptPass
logonInfo.TableName = table.Name
table.ApplyLogOnInfo(logonInfo)
Next table
End Function
In my system Visual studio 2008 with sp1 and Crystal Reports XI Release 2.In Visaul studio 2008 ,while adding add reference it showing crystal reports version 10 instead of 11.How to solve the version problem.
View 1 RepliesI am considering using Crystal Report 2008 as my tool of creating reports on my webpage.The only problem which I'm facing is that I have no control of the remote server which hosts my site (besides uploading files). I can't run a MSI to deploy the CR runfiles.I can't find anywhere in the CR user manual of how to deploy the runtime files without running the msi, and I'm not even sure it's possible.Have anyone deployed CR 2008 without running the MSI and without having to register any files?
View 8 RepliesI have a field in my dataset with type nvarchar(1000). when I link it to crystal reports, it converts it to a field of type string with length set to 100. As a result of that, the string in that field is being truncated on the report. How can I increase the string length to 1000? (I already checked the "Can grow" option).
View 3 RepliesI am create crystol report in asp.net in visual studio 2010 but crystol report toolbar Print Button Not working in Google chrome brouser
View 2 Replies