I have an "Edit" page that uses a FormView bound to an EntityDataSource. The page is called with the ID field of the record to edit in the query string: "EditEmployee.aspx?ID=10". The EDS the FormView is bound to is using: AutoGenerateWhereClause=true and a QueryStringParameter. Below the FormView I have a ListView that contains some child records of the FormView. The ListView is bound to a seperate EDS and also uses the (same) QueryStringParameter.
The problem I am having is when this ListView attempts to Insert or Edt a column I receive an error because I don't have the ID field (EmployeeID) of the parent bound anywhere in the ListView (and obviously, it is setup as a ForeignKey so it fails, like it should). Any advice on the best way to get this ID (EmployeeID) column bound in the ListView? There are many things I can do in code behind, but I would like to solve this in the markup if possible. I can move the ListView so that it is inside of the FormView if necessary.
Actually i am creating 1 sofware in which i need to print bill. On that bill my page header (company's name) is constant & on Report footer (companys rule & some more data) is also constant. & my Detail section is varying. On bill if data is short, my footer goes upside.
I need to fixed my detail section so that position of detail section will be maintained.
I need to fixed my footer section so that position of footer section will be maintained.
now which is the solution form above 2? . and how to implement?
This is my image: - Plz checkout http://tinypic.com/r/dzxpa0/7
From the above image, i have one group header, Detail A and Detail B in my report.The detail Item and Header is merged and showing one detail A and Detail B item.But, I need the report to look like this ....
I need to produce a report that will calculate values based on previous record field value and current record field value Can I store a field value say in a variable and then on the next detail line record have it accessed so I can say subtract current field value - previous field value from previous detail line? Where can I define this globial variable ?
I just started playing around with crystal reports. I created a report crystareport1.rpt and from the data base fields section I dragged and dropped empid, empname into details section. I want the report to show
empid empname 1 a 2 b 3 c
Like this . But now it is displaying
empid empname 1 a empid empname 2 b empid empname 3 c
Like this how can i get the desired out? One more thing on the button click I wrote
But I am unable to open the report what should I do to see the report?
I want to display a crystal report in my vb.net application. Suppose I have tables named student details, student marks, student address, etc... Nowif I want to display all these details (fields of all tables) in one crystal report (with page breaks if necessary) then how will I achieve it. I will be providing a combo box in my application that contains list of student names.How can I link this combo box with the cystal report to dynamically display report for different student on selected index change of combo box?
Order No Date Product Qty Customer A101 10-Oct-2010 Mac Book 10 John A102 10-Oct-2010 I-Phone 25 Smith A103 10-Oct-2010 I-Pad 40 Kallis
Here Order No is primary key
Order Detail Table
Order No Date Product Qty Customer Batch No A101 10-Oct-2010 Mac Book 03 John B01 A102 10-Oct-2010 I-Phone 05 Smith B02 A103 10-Oct-2010 I-Pad 10 Kallis B03 A101 10-Oct-2010 Mac Book 02 John B04 A102 10-Oct-2010 I-Phone 07 Smith B05 A103 10-Oct-2010 I-Pad 15 Kallis B06
Here Batch No is primary key
The above table is just a sample table.
I have more than 1000 Order in my table. And for each Order there are at least 12 Order Detail is available in my Order Detail Table. It uses to take long time on loading the report for the first time. So, I thought to select Top 20 records from Order table. I have used the below query in crystal report command
Select Top 20 O.OrderNo, O.Product, O.Date, O.Qty,OD.Unit,OD.Rate from Order O inner join Order Detail OD on O.OrderNo = OD.OrderNo
1. After execution of above query, I would like to know whether all the records from Order Detail Table will be checked during execution (OR) only matching Top 20 records of Order Table will be checked in Order Detail Table and executed?
2. How to use stored procedure in Crystal Report command?
3. What are the steps I need to take, to load Crystal report fast during first time page load?
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"))
I'm trying to setup is a News module with article listing paging and article detail paging. I have a GridView with paging that lists my articles just fine. In that list, some article titles have links that direct to an article detail page by passing in the articleID to the details page. I was able to setup my details page, which uses a DetailsView control, to use paging by using an ObjectDataSource with pageIndex and pageSize parameters from the querystring. Once on my detail page, I can use my navigation arrows to move through Next and Previous articles just fine.
No matter which article I click in my article list, my detail page always starts with pageIndex 0 and thus not the article I clicked on. I understand why that is because it's going by pageIndex value instead of articleID. What I need it to do is, set the detail to whatever articleID i pass in, then allow me to navigate Next and Previous to THAT particular article instead of starting me off from pageIndex 0.
I have problem when i create a crystal report. follow the requirement from customer, i need to show a report that list all data of 3 tables that it does not have any relationship between them in only one Report. It will show:
Table A: -- column A.1 | col A.2 | col A.3 Table B: -- col B.1 | col B.2 | col B.3 | col B.4 Table C: -- col C.1 | col C.2
So, how do i need to do to show the report same as above?
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.
article on binding to a list and I've got that working fine on one view. But what I'm stuck when doing it off a master record. Everything seems to work except that when I look in the database the detail records previous associated with the current master have their Foriegn key to master set to Null and a new set of detail records have been inserted. I've got a really simple form for this object
The form collection comes back with the expected prefixes:
And the Controller.UpdateModel(master) binds all the properties correctly. But when I call dbContext.SaveChanges it issues the follow sql from sql profiler (psuedo code)
I've got a work around that works but it's pretty hackish and I'm currently not matching up the keys so it's dependent on everything coming back in the right order. Plus I've got to include all the fields that I want updated.
I thought that entity framework's code first was the culprite but I've unit test that and it works fine. I've got a feeling that UpdateModel is somehow removing and re-adding the children. Has anyone else got this to work? Of course, I could throw in the towel and parse the indexed field names myself, but I'm so close!
I've been experimenting with using EF (asp.net 3.5 sp1) with a master detail page. Using northwind as the database, I'm simply trying to have categories as master and products as detail. I have read everything I could find on the net about the where condition and it still fails with this error as soon as I click the select link in the master grid:
Microsoft JScript runtime error: Sys.WebForms.PageRequestManagerServerErrorException: A property with name 'CategoryID' does not exist in metadata for entity type 'WebAppEF01.Products'.
What strikes me is that the CategoryID column is not exposed by the EF model. That's been rolled up into the navigation element 'Categories' I suppose...but on the surface this seems to create the problem I've running in to. I've tried turning off the autogeneratewhere clause but didn't have success. The code for this page follows below.
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.
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:
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?
Iam working on a banking web application developed in asp.net 3.5 and MS SQL Server 2008.My problem is to create reports including some pre-formatted reports,summary reports and some detail reports.I want to know what is the best technique to create these reports.I don't want to use third party reporting tools as they have to be configured on the web server and some times they takes lot of time in generating reports due to their complex structure.Since its a web application having large recordsets so i need a consistent solution keeping in mind the performance and complex nature of the reports which might be demanded by the banks.Can anyone help me please in this regard?
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#.