ongeremd.com

Crystal Reports error the group section cannot be printed because its condition field is nonexistent or invalid

Tue, 14 Feb 2012 15:28:25 +0000

Check the formula fields in the Field Explorer. You can right click on them and “Browse Data” to see if an error is produced.

Can we assume this report has groupings? Check the field(s) the report is grouped on. Are any of them null?

Check the group selection formulas.

Crystal reports error

Check the record selection formulas.

Have any of the uses of the report’s datasource changed since it last ran correctly? Perhaps the format of a string field is different now. Ask around.

Just because you can verify the DB doesn’t mean the problem isn’t in the datasource. Maybe one of your report’s formulae is expecting a field to be non-null, and there is a single null entry. Or a date somehow got entered as #01/01/9999# and a formula in the report is expecting a realistic date

Bekijk ook

How to create XML file of Database in C# asp.Net

Fri, 18 Feb 2011 00:25:42 +0000

To create XML file of Database we have to call WriteXml() function of Data Set.

Example

string strConnection = “Server=abc\\SQLEXPRESs;Database=Employee;Trusted_Connection=True”;

SqlConnection con = new SqlConnection(strConnection);

//creating new connection to database Employee

con.Open();

//opening connection

SqlDataAdapter da = new SqlDataAdapter(“select * from employee”, con);

//assigning data to DataAdapter according to the query

DataSet ds = new DataSet();

da.Fill(ds, “Employee”);

//filling dataset.

ds.WriteXml(“C:\\dataEmployee.xml”);

//writing XML file of name ‘dataEmployee.xml’ of database

write xml from database c#

Bekijk ook

Wolfman Full movie

Wed, 15 Sep 2010 17:30:26 +0000

Watch Wolfman here.

Bekijk ook

TWILIGHT ECLIPSE FULL MOVIE

Wed, 15 Sep 2010 15:33:12 +0000

Bekijk ook

How to make a booklet with microsoft word

Tue, 07 Sep 2010 12:15:46 +0000

The WordBookletTemplates.zip file contains Microsoft Word templates for 4, 8, 12, 16, 20, 24, 28, and 32 page booklets, with and without page numbers (16 templates in all). I think I developed these with Microsoft Word 97 and I’ve never made any changes to them. They use a series of text boxes that flow from one to the other to get the text where it is supposed to be in the booklet.

To use them, simply start a new document based on the template of choice and start typing (or paste your text) into the text box on the right hand side of the first page. The text will flow to fill all the other pages as needed. To understand this better, you may find it useful to start with one of the templates with page numbers. If you shrink the page size down so that you can view all the pages, it may appear that your text is all over the place. Don’t panic! That’s normal, and there is a reason for it.

Make sure your printer has 8-1/2? X 11? paper in it. If your printer does duplexing, simply print your document. If your printer doesn’t offer duplexing, then it will be a simple 3-step process for you: 1) Print out all the odd numbered pages; 2) When they are done, reverse the sort order of the pages [This may vary by printer model and settings]; 3) Print out all the even numbered pages on the back of the odd numbered pages. Once all your pages have printed, simply fold them in half. The pages will be set up so that they will form a properly numbered series of pages from beginning to end.

Once the pages are printed, I use a long reach stapler to bind them together. (I omit this step on the 4-page booklet because it’s only one piece of paper, of course.)

Oh, they seem to work in OpenOffice.org too! Enjoy!

Source:

http://rickyspears.com/blog/2005/05/booklet-templates/

Bekijk ook

How to shut down a virtual machine

Fri, 03 Sep 2010 14:11:39 +0000

If a virtual machine is not configured to automatically shut down, you can shut it down manually by following these steps.

To shut down a virtual machine

Do one of the following:
- To shut down from an open virtual machine, from the toolbar of the virtual machine window, click Ctrl+Alt+Del. Or, you can press the CTRL+ALT+END key sequence.
- To shut down from a running virtual application, make sure the focus is on the application (click or restore it if necessary), and then press the CTRL+ALT+END key sequence.
In the window that appears, click Shut down.
The operating system will go through the shutdown sequence, and the resources will be released from the virtual machine.