Crystal Reports :: How To View Datasource In It
Jun 22, 2010
I am new to a company and to administering some crystal reports. Looking at a report in design view how can I view the datasource of the report? I have the field explorer open and I can see the name of the datasource and I know which sql server it is from. It isnt a table in the database and if it is a view it is under and alias. I think it might be a query in the dataset in the datasource but im not sure how to view it or find out the details.
View 1 Replies
Similar Messages:
Nov 22, 2010
I have a Registration form with two Buttons "Save" & "Report". When I click on "Save" the data will store in the Database. Now I want when click on the "Report" button the report of that particular will be produce in the Crystal report. How can I do that??
View 2 Replies
Aug 5, 2010
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 Replies
Jun 13, 2010
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.
View 1 Replies
Jul 16, 2010
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.
View 9 Replies
Sep 27, 2010
Crystal report view tool bar is not showing correctly. Instead of toolbar there is text "Submit Query"
View 2 Replies
Apr 6, 2010
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#.
View 3 Replies
Jan 4, 2011
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 Replies
Feb 15, 2010
I 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 Replies
Sep 1, 2010
I 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 Replies
Feb 1, 2011
There 5 crystal reports which have the same fields. Each of them is using different store procedure as datasource as sp1, sp2...sp5 I have done first report rp1. I copied rp1 as rp2. How to change rp2 datasource from sp1 to sp2?
View 1 Replies
Feb 7, 2011
I have no problems viewing data on local machine but for some reason I cannot view that same report on the web. When i view source of the web page I can see data inside the javascript but the page is blank. What could I be doing wrong?
View 2 Replies
Jan 19, 2011
I am trying to create a report using crystal report 11 and asp.net 2.0(C#) and Oracle10g. My requirement is to create a report which contains 6 pages with each pages different and is connected to different datasource. I pass three parameter (1)USER_ID, (II)YEAR and (III)TYPE. Based on these parament i'd like to construct a report with different layout on different pages with different datasource. Can i do it in single .rpt file or do i need to nested with sub reports. I am trying to create 6 subreports with their own datasource and put it in one parent report to display data, but not able to do it.
View 2 Replies
Apr 11, 2010
I want to know that is it possible to create crystal report without database as datasource?
because i am having database but the data that i want to show in report is not a direct values from database...
Actually i am having one attendance table now i want to show the total no of rows(attendance table has 50 rows then report should display just "50" instead of displaying each rows) in the report...how can i show that?
attendance table(sub_code,status,roll_no,date)
subjects(sub_code_sub_name)
my report format is like :(sub_name,total lectures,present lectures)
for example:-report should look like....
(sub_name,total lectures,present lectures)-This total lectures can be counted using attendance table but how can i diplay in report thats what i want to know?
Sub-1 | 20 | 15
Sub-2 | 45 | 4
Sub-2 | 33 | 3
View 1 Replies
Feb 9, 2010
I have developed few crystal reports using VS.2005 and now i want to deploy the same on my web server which is running Windows 2003 server and got installed only .net frame work 2.0.... so now i want to know how can i run those reports successfully and i have downloaded CRRedist2005_X86.msi and even crXIsp3 and 4 _net_server from business objects page and i do have Crystal Reports XI original CD.... while by using them can i run crystal reports on my web pages.
View 1 Replies
Jun 15, 2010
I want report generted based on value from querystring.
View 3 Replies
Feb 4, 2011
Crystal
Reports Error when publishing a Website on to the Web Server---- The type initializer for 'CrystalDecisions.Shared.CrystalReportClientScriptManager' threw an exception
View 3 Replies
May 27, 2010
I'm working on a site that ws developed using VS 2005 and the server where the site is running has Crystal Reports for .net 2.0 (ver 10.2.36)I will be making changes. I just ported the website to my local computer, and build the site using VS 2008, that comes with Crystal R. Basic.I haven't tested all the functionality of the site, so I'm not sure since all the pages that use C. Reports work ok.My main concern is about publishing the site I compiled to the server. Will things work, if I have Crystal R. Basic and the server has Crystal R. for .net 2.0.
View 2 Replies
Mar 25, 2010
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?
View 2 Replies
Jul 25, 2010
I'm getting the "Load Report Failed" Error.
I have a web application designed using VS2008 & Crystal Reports for VS2008 (Ver. 10.5.3700). I'm using Framework 2.0 for deployment.
My development system is WinXp and my deployment system is Win2003 Server.
Here is what i have done -
1) Added a Crystal Report to my project "rptReport.rpt"
2) Added a Crystal Report Source (crSource) to my .aspx page.
3) Added Crystal Report Viewer to my page, with crSource as its Report Source.
This works fine when i run it on my development machine. But Gives a "Load Report Failed" error on my deployment machine.
This is what i have already tried doing on deployment server:
1) Giving IIS_WPG full control to temp folder.
2) Publishing with "Allow this precompiled site to be updatable." checked/unchecked.
View 1 Replies
Dec 17, 2010
Crystal reports are properly working on my local pc but not on server. I am using vs 2008 and install crystal report for Visual basic 2008 on server.but parameter count for CrystalReport is zero on server.
CrystalReportViewer.ReportSource = Session("Rpt" & Request.QueryString("ReportGroup") & Request.QueryString("ReportCode"))[code]....
View 6 Replies
Mar 28, 2011
I have a requirement to generate Dynamic Crystal Reports.I am a new bea of Microsoft .net.
View 2 Replies
Mar 11, 2010
We have an old server (Win Server 2003/ IIS) that makes use of an old version of Crystal Reports for asp.net pages. I'm making a new server (Win Sever 2008 SP2/ IIS 7) that will be the replacement for the old server. I have asp.net apps working, but since I can't use the old Crystal reports install, the new one isn't doing anything for me.After installing CRRedist2008_x86, it shows some files in:
C:inetpubwwwrootaspnet_clientsystem_web2_0_50727CrystalReportWebFormViewer4
andC:Program FilesBusiness ObjectsCommon2.8inAre there any special configurations I have to do in IIS to get asp.net to recognize this stuff? Right now, I'm getting nothing.
View 1 Replies
Jan 4, 2011
why does my crystal reports not loading on the server
View 4 Replies
Feb 19, 2011
I'm new to Crystal Reports and am just trying to add some simple reports to my web application. In the non-report pages I've been using SqlDataSources to retrieve data from the database and would like to do the same for the report pages. I saw a tutorial that indicated I could do this by explicitly setting the data source for the report in the Page_Load callback of the ASPX page as shown below:
[code]...
Is there a way to create "bound" fields w/o a database, since I'll be specify the database at runtime? Or is there a way to create the ".rpt" file w/ unbound fields, that get "bound" at runtime?Or is there a better way to do this altogether?
View 5 Replies
