Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
BOOK: Professional Crystal Reports for VS.NET
This is the forum to discuss the Wrox book Professional Crystal Reports for Visual Studio .NET by David McAmis; ISBN: 9780764544033
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Professional Crystal Reports for VS.NET section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old August 24th, 2004, 11:19 PM
Registered User
 
Join Date: Aug 2004
Location: , , .
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Crystal reports 10 XML handling

Hi ...

I have to display the records using the crystal report. The following is the xml:


 <?xml version="1.0" ?>
 <FundOutRptRs xmlns:jsp="http://java.sun.com/JSP/Page">
  <status code="0">success</status>
 <Header>
  <version>1.0</version>
  <operatorID>06</operatorID>
  <languageID>EN</languageID>
  <terminalID>C555</terminalID>
  <hash>00-0D-60-78-76-4F</hash>
  <channelID>C</channelID>
  <dateTimeStamp>2004-08-24 19:49:27</dateTimeStamp>
  <userID>cbtest06</userID>
  <password>1234</password>
  <sessionKey>BrrLxm1LTnmTW67pxjtUrRSxEuXD9fnKFnjdTl LZKpR0FyYYrDOA!-1828760951!1093348107854</sessionKey>
  </Header>
<BetCenter>
  <Center id="AUS" name="Aus location" />
  <Date>2004-08-18</Date>
  <TotalFundIn>599.01</TotalFundIn>
  <FundInTran>1</FundInTran>
  <MonTotalFundIn>599.01</MonTotalFundIn>
  <MonFundInTran>1</MonFundInTran>
  </BetCenter>
<Terminals>
 <Terminal>
  <TerminalID>C555</TerminalID>
  <Time>19:29:22</Time>
  <TransCode>CB0/C555/000001</TransCode>
  <AccountID>06000813</AccountID>
  <Name>First</Name>
  <Amount>599.01</Amount>
  <StaffID>cbtest06</StaffID>
  </Terminal>
  </Terminals>
  </FundOutRptRs>


I created DSN and everything...But when i try to run the report iam getting terminal table doesnt exist...
Pls help me if u guys know..


rgds
khan

 
Old February 18th, 2005, 07:24 PM
Registered User
 
Join Date: Feb 2005
Location: Grand Terrace, CA, USA.
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hello Ferozkhan,

Is your XML doc in a file? if not then put into a file and place it ina directory that you will point to with your DSN. The Crystal ODBC driver will then look in the directory and pick up all XML files and you can then choose when you go to the Database source tab.

Cyrstal will parse the XML into a table that you can use in your reports.

Sincerely,

Dr. Wolf

 
Old March 30th, 2005, 01:11 PM
Registered User
 
Join Date: Mar 2005
Location: , , .
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I'm trying to get XML data to display in my Crystal Report without a design time xsd file - i.e., I want to display a database completely on the fly. Is it possible to read and display an XML file without an xsd file?

Thanks.
 
Old May 27th, 2005, 11:25 AM
Registered User
 
Join Date: May 2005
Location: , , .
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

You need to have a schema for your xml.

CD





Similar Threads
Thread Thread Starter Forum Replies Last Post
Crystal Reports 10 With .Net 3.5 subbukbc BOOK: Professional Crystal Reports for VS.NET 2 June 24th, 2011 05:08 AM
Crystal Reports 10 without CrystalActiveXReport !! ahmed_hammam70 Pro VB 6 4 May 21st, 2007 02:31 AM
Vb6 with crystal reports 10 Eleakim Cribe Pro VB 6 0 June 22nd, 2006 09:20 AM
Crystal reports 10 XML handling ferozkhan XML 1 August 25th, 2004 08:33 AM
Crystal reports 10 with parameters HELP! stevecobbett Crystal Reports 0 March 18th, 2004 09:58 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.