I'm currently using VS 2008 and I am trying to make my web application to print only 1 specific data set from my SQL database.
For example, i got 3 rows of data sets, how can I choose only 1 data set to be printed?
string reportPath = Server.MapPath("CrystalReport2.rpt");
using vs.net 2005, sql server 2005, creating windows form appI have a dataset that I bound to a crystal report as follows:
[Code]....
and in the Crystal Report in design view I added a Text Object called "myTxtObj".I am assuming that I can do something like this
[Code]....
However I'm not seeing the "myTextObj" with intellisense in the code behind in the form.so my question is: after binding a dataset to a report how to you bind column values to text objects on your crystal report?and actually one mor thing:I just ran the project and found out when I try to do the databind that i'm getting an error:"The report has no tables"how to solve this too?
I want to bind dynamic dataset to my crystal report. Dataset come from store procedure with pivot.
following is my sp and code.
[Code]....
[Code]....
I am new to crystal reports and I would like to know to create reports using untyped datasets instead of typed datasets.
View 1 Repliesi am using untyped dataset to bind the data to crystal reports.
View 1 RepliesI want to export dataset to Excel. I did the following ways:
1) bind a dataset to a crystal report,
2) export crystal report to Excel Can it be done without displaying crystal report and only Excel file? Or, I have to find out a way export to Excel directly from dataset?
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 Repliesi have done a crystal report in asp.net. i have a table called c_order it contains cust_id field, so while generating report itself i specified cust_id value but i have put a textbox and a button in the form which contains crystalreportviewer. so i need to enter a value in textbox and press the button then it should get value which match with the value in textbox with database and generate report.
View 1 RepliesI 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 RepliesI have a crystalreportviewer bound to a dinamically generated DataSet. The Datatable within that dataset has 2 rows of data, however only the first one is showing on my report.
Here's the code that binds my dataset to the report viewer:
[Code]....
using vs.net crystal reports 2005
I am attaching a dataset to a crystal report and want to know when I have several rows of items to display on the report how would I display several rows of data in the crystal report.
I am normally using textObjects on the report but it looks like I need some kind of repeating control, something like crystal reports version of a datagrid. I realize that in the part of the report where I need to display rows of product names that I might need to create a sub-crystal report that I attach a sub query to.
I'm having a lot of trouble with this, and all the examples that I've found online tell me different things, so II added a DataSet to my project and added my database table to it. (DataSet should be ready)I added a CrystalReport to my project and in the Details section, I right clicked and chose "Database Expert" under "Database". I expanded "Project Data" and found my DataSet...I selected my table and added it to the "Selected Tables" list.In the CrystalReport designer, I used the "Field Explorer" to add 5 of my database fields (just for testing purposes). The report added their names to the "Page Header" and the fields to the "Details" section.On some button click, I use the following code to show the report:
[Code]....
where "conn" is my global SqlConnection.where "CrystalReportViewer1" is obviously the viewer I have put in my aspx page.where "DataSet1" is the DataSet I created and holds my table.where "CrystalReport.rpt" is obviously the report I created.and I used the following code to make sure that myDS actually was loaded with the data:
[Code]....
So the DataSet is definitely loaded with data, the CrystalReport is found (because before I was having trouble with loading into oRpt), and no exception is being thrown because the "Catch" section is never reached.I'm sure it's something dumb I'm doing, but does anyone have any suggestions? I know if I can figure this little problem out, I can expand it to the more complex things I want it to do. But currently, I can't get anything to show,
I am trying hard to analyse but cant figured it out.I am using a Dataset which has 23 stored procedures (Table Adapters).Depending on the user requirement,I call each Tableadapter and pass the dataset to Crystal reports to display.
Namespace DAL
{
Dataset1 ds = new Dataset1();//Dataset instance is create/////
public dataset getdata()
{----
dataadapter.fill(ds1.sp1);
return ds;
}
public dataset getrecdata(params)
{---------
dataadapter.fill(ds1.sp2);
return ds;} and so on
}
Does the dataset instance gets loaded once or multiple times( as the table adapter calls each timme)Can anyone tell me if this is the right procedure I am following? and also does it work fast?or slows down my project.I am using dataset as input to Crystal reports bcaz thats working good in Design of crystal report as well as it takes dataset as input.
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 RepliesIs it possible to configuring a Report.rdlc without using of DataSet?
View 2 RepliesI have designed a DataSet which contains two TableAdapters. I want to Bind That dataSet with two table adapters how to do this?
Code:
[Code]....
My Code runs without error but it shows a blank report.
i am havin one join condition in back end and storing the result into dataset and from dataset i am unable to load data into crystal reports nothing is coming only empty report is getting displayed.
View 1 RepliesI have a report displaying the data for an employee. If I wish to generate report for 2 employee, how I can do to make a single report contains both the data? (e.g.: 1st page display data for 1st employee; 2nd page display data for 2nd employee and so on) I need them to be in the same report/pdf file.
View 3 RepliesI tried to bind a dataset to a cyrstal report viewer in asp.net as follow,
[Code]....
But nothing happens. What can be the problem? Is there any other way?
I have Data Entry Webform. Entries are saved in database with submission date.I am able to display report of specific date entries with their SUM in report footer.Now i want to display only Specific Date/Dates SUM only in report, not entries.I think it may be done by grouping. But i dont know how to do this.I am using vs2010 and crystal reports.
View 1 Repliesusing vb.net 2005 and crystal reports. in the vb.net code I am querying the database, processing the results and then binding to the crystal report.
What I need to do now in the code is this: I need to create a new page to display the results so that there is one page for each row in the dataset that I'm binding to the report.
VS2010/sqlserver/crystalreport13
I have a report which is runnin fine as it is using singe table Dataset(.xsd) . I want to expand the report and use more tables in it to show more information .
How can I do so. I am attaching my present code with this.
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim stdate, enddate As Date
Dim sql As String
start_date.Text = Session("startdate")
end_date.Text = Session("endate")
Dim dt As DateTime = DateTime.Parse(start_date.Text, System.Globalization.CultureInfo.GetCultureInfo("en-gb"))
[CODE]...
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]....
why does my crystal reports not loading on the server
View 4 RepliesI need to print Crystal Report using JavaScript and a Button on client side without any server side ASP.Net code.
View 1 Replies
