473,511 Members | 15,364 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Can the .NET version of Crystal Reports parse a string?

I have a transaction log file where the DataSet table's Description column
is actually delimited into "subcolumns" based upon the transaction id. I
would like to parse these into separate fields for reporting purposes and am
wondering if anyone knows if this is easily accomplished using the .NET
version of Crystal Reports?

For example, the description column may be reporting on a dataentry error as
follows:

TXNCODE: 1010001
DESCRIPTION: "USERID: xxxxxxxxx TAXID: xxxxxxxxxxxxxxxxxx"

I would like to, say, parse the substrng values for USERID and TAXID from
the DESCRIPTION column.

Jul 21 '05 #1
5 2996
CR.NET has extensive language support. You can program formulas using Basic
syntax or Crystal syntax (similar to C). However, if you are using Datasets
to populate the report, you are better off doing the parsing at the .NET
level prior to passing it to CR. Just add two new fields to your datatable
and save the parsed results there. But if that doesn't suit you, just use
the CR built in syntax and you'll be good to go.

I have an entire book about CR.NET coming out on Amazon on April 1st and I'm
offering autographed copies on my website prior to its release. I also have
a free ebook you can download off my website which teaches the basics of
integrating Crystal Reports with .NET.
HTH,
Brian Bischof

A Crystal Reports.NET book for programmers? Its here!
* Covers ASP.NET and Windows Forms
* Teaches all phases of report development
* Alerts you to the bugs and how to get around them
* Maps out the complex ReportDocument object model
* Shows how to perform runtime customization
* Demonstrates all options of connecting with ADO.NET
* Gives complete code listings for every concept presented

http://www.123aspx.com/redir.aspx?res=30160


"BStorm" <nf*@nospam.com> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...
I have a transaction log file where the DataSet table's Description column
is actually delimited into "subcolumns" based upon the transaction id. I
would like to parse these into separate fields for reporting purposes and am wondering if anyone knows if this is easily accomplished using the .NET
version of Crystal Reports?

For example, the description column may be reporting on a dataentry error as follows:

TXNCODE: 1010001
DESCRIPTION: "USERID: xxxxxxxxx TAXID: xxxxxxxxxxxxxxxxxx"

I would like to, say, parse the substrng values for USERID and TAXID from
the DESCRIPTION column.

Jul 21 '05 #2
That is great news. What level will your book be targeted? (Beginner,
Intermediate, Advanced, Professional?)

"Brian Bischof" <br***@nospam.bischofsystems.com> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...
CR.NET has extensive language support. You can program formulas using Basic syntax or Crystal syntax (similar to C). However, if you are using Datasets to populate the report, you are better off doing the parsing at the .NET
level prior to passing it to CR. Just add two new fields to your datatable
and save the parsed results there. But if that doesn't suit you, just use
the CR built in syntax and you'll be good to go.

I have an entire book about CR.NET coming out on Amazon on April 1st and I'm offering autographed copies on my website prior to its release. I also have a free ebook you can download off my website which teaches the basics of
integrating Crystal Reports with .NET.
HTH,
Brian Bischof

A Crystal Reports.NET book for programmers? Its here!
* Covers ASP.NET and Windows Forms
* Teaches all phases of report development
* Alerts you to the bugs and how to get around them
* Maps out the complex ReportDocument object model
* Shows how to perform runtime customization
* Demonstrates all options of connecting with ADO.NET
* Gives complete code listings for every concept presented

http://www.123aspx.com/redir.aspx?res=30160


"BStorm" <nf*@nospam.com> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...
I have a transaction log file where the DataSet table's Description column is actually delimited into "subcolumns" based upon the transaction id. I
would like to parse these into separate fields for reporting purposes and
am
wondering if anyone knows if this is easily accomplished using the .NET
version of Crystal Reports?

For example, the description column may be reporting on a dataentry
error as
follows:

TXNCODE: 1010001
DESCRIPTION: "USERID: xxxxxxxxx TAXID: xxxxxxxxxxxxxxxxxx"

I would like to, say, parse the substrng values for USERID and TAXID

from the DESCRIPTION column.


Jul 21 '05 #3

All the above - from beginners to advanced developers. It's a 2 part book.
Part 1 is for newbies to CR who just want to learn how to create reports and
do things like grouping/subreports/etc. Part 1 also teaches how to do
formulas and is a reference for Basic syntax. Part 2 is for people who want
to do advanced .NET runtime customization of reports. Each chapter is filled
with tons of code samples (VB.NET and C#) that have been written so that you
can drop them directly into your own projects. It also covers programming
Web Services, RDC, and RAS. Most of this code is undocumented except in my
book (I know b/c I spent countless hours researching how to do every
imaginable task with CR and I put all the code in here). In my biased
opinion, its one of a kind (and desperately needed by the .NET community).

Brian Bischof

A Crystal Reports.NET book for programmers? Its here!
* Covers ASP.NET and Windows Forms
* Teaches all phases of report development
* Alerts you to the bugs and how to get around them
* Maps out the complex ReportDocument object model
* Shows how to perform runtime customization
* Demonstrates all options of connecting with ADO.NET
* Gives complete code listings for every concept presented
http://www.crystalreportsbook.com/123aspx.asp

"BStorm" <nf*@nospam.com> wrote in message
news:u6***************@tk2msftngp13.phx.gbl...
That is great news. What level will your book be targeted? (Beginner,
Intermediate, Advanced, Professional?)

"Brian Bischof" <br***@nospam.bischofsystems.com> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...
CR.NET has extensive language support. You can program formulas using

Basic
syntax or Crystal syntax (similar to C). However, if you are using

Datasets
to populate the report, you are better off doing the parsing at the .NET
level prior to passing it to CR. Just add two new fields to your datatable
and save the parsed results there. But if that doesn't suit you, just use the CR built in syntax and you'll be good to go.

I have an entire book about CR.NET coming out on Amazon on April 1st and

I'm
offering autographed copies on my website prior to its release. I also

have
a free ebook you can download off my website which teaches the basics of
integrating Crystal Reports with .NET.
HTH,
Brian Bischof

A Crystal Reports.NET book for programmers? Its here!
* Covers ASP.NET and Windows Forms
* Teaches all phases of report development
* Alerts you to the bugs and how to get around them
* Maps out the complex ReportDocument object model
* Shows how to perform runtime customization
* Demonstrates all options of connecting with ADO.NET
* Gives complete code listings for every concept presented

http://www.123aspx.com/redir.aspx?res=30160


"BStorm" <nf*@nospam.com> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...
I have a transaction log file where the DataSet table's Description

column is actually delimited into "subcolumns" based upon the transaction id. I would like to parse these into separate fields for reporting purposes and
am
wondering if anyone knows if this is easily accomplished using the ..NET version of Crystal Reports?

For example, the description column may be reporting on a dataentry

error
as
follows:

TXNCODE: 1010001
DESCRIPTION: "USERID: xxxxxxxxx TAXID: xxxxxxxxxxxxxxxxxx"

I would like to, say, parse the substrng values for USERID and TAXID

from the DESCRIPTION column.



Jul 21 '05 #4
The only book I have is Professional Crystal Reports for Visual Studio .NET,
which doesn't seem to have enough depth. (have you seen it?)

This is very encouraging and BADLY needed.

"Brian Bischof" <br***@nospam.bischofsystems.com> wrote in message
news:eo*************@TK2MSFTNGP11.phx.gbl...

All the above - from beginners to advanced developers. It's a 2 part book.
Part 1 is for newbies to CR who just want to learn how to create reports and do things like grouping/subreports/etc. Part 1 also teaches how to do
formulas and is a reference for Basic syntax. Part 2 is for people who want to do advanced .NET runtime customization of reports. Each chapter is filled with tons of code samples (VB.NET and C#) that have been written so that you can drop them directly into your own projects. It also covers programming
Web Services, RDC, and RAS. Most of this code is undocumented except in my
book (I know b/c I spent countless hours researching how to do every
imaginable task with CR and I put all the code in here). In my biased
opinion, its one of a kind (and desperately needed by the .NET community).

Brian Bischof

A Crystal Reports.NET book for programmers? Its here!
* Covers ASP.NET and Windows Forms
* Teaches all phases of report development
* Alerts you to the bugs and how to get around them
* Maps out the complex ReportDocument object model
* Shows how to perform runtime customization
* Demonstrates all options of connecting with ADO.NET
* Gives complete code listings for every concept presented
http://www.crystalreportsbook.com/123aspx.asp

"BStorm" <nf*@nospam.com> wrote in message
news:u6***************@tk2msftngp13.phx.gbl...
That is great news. What level will your book be targeted? (Beginner,
Intermediate, Advanced, Professional?)

"Brian Bischof" <br***@nospam.bischofsystems.com> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...
CR.NET has extensive language support. You can program formulas using Basic
syntax or Crystal syntax (similar to C). However, if you are using

Datasets
to populate the report, you are better off doing the parsing at the ..NET level prior to passing it to CR. Just add two new fields to your datatable and save the parsed results there. But if that doesn't suit you, just use the CR built in syntax and you'll be good to go.

I have an entire book about CR.NET coming out on Amazon on April 1st and
I'm
offering autographed copies on my website prior to its release. I also

have
a free ebook you can download off my website which teaches the basics
of integrating Crystal Reports with .NET.
HTH,
Brian Bischof

A Crystal Reports.NET book for programmers? Its here!
* Covers ASP.NET and Windows Forms
* Teaches all phases of report development
* Alerts you to the bugs and how to get around them
* Maps out the complex ReportDocument object model
* Shows how to perform runtime customization
* Demonstrates all options of connecting with ADO.NET
* Gives complete code listings for every concept presented

http://www.123aspx.com/redir.aspx?res=30160


"BStorm" <nf*@nospam.com> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...
> I have a transaction log file where the DataSet table's Description

column
> is actually delimited into "subcolumns" based upon the transaction
id. I > would like to parse these into separate fields for reporting
purposes and
am
> wondering if anyone knows if this is easily accomplished using the

.NET > version of Crystal Reports?
>
> For example, the description column may be reporting on a dataentry

error
as
> follows:
>
> TXNCODE: 1010001
> DESCRIPTION: "USERID: xxxxxxxxx TAXID: xxxxxxxxxxxxxxxxxx"
>
> I would like to, say, parse the substrng values for USERID and TAXID

from
> the DESCRIPTION column.
>
>
>



Jul 21 '05 #5

Yes, I have a copy of that book. In fact, when I saw the press release I was
all upset thinking that Wrox would be the death of my book. Luckily, once I
got a copy I saw that it read more like a brochure than a book. David McAmis
is a great writer and his book is very easy to read and understand. However,
it just touches on all the topics and nothing is covered in any depth. It
will get you through your first week or two of writing reports, but you
quickly have to start looking elsehwhere for answers to your questions. Have
you seen George Peck's CR 9 book? They put ".NET" all over the cover and
after you buy the book you find out that all he did was throw a bunch of
screen shots in the Appendix and it says, "See MSDN for more information".
Unbelievable marketing hype! Theres no telling how many .NET programmers
have thrown away their hard-earned money on this book to find out that it is
trash. And his book "Professional Crystal Reports" is a reprint of the help
files (literally). It makes me sick that they get away with this. I can't
wait for my book to come out and then people will see what a CR programming
book is supposed to look like. My book focuses on giving you answers and not
screen shots.

Personally, I wish my writing style was as good as David's is. He is great
at introducing a topic and showing how to use it. My writing style is more
of what a "computer geek" would write. I just spit out what I want to say
and show the code for it. For example, he introduces Report Web Services
with almost 3 pages explaining what it is and why its beneficial. My chapter
on web services has two paragraphs telling you that you can deliver reports
using HTTP and then the rest of the chapter shows you how to create and
program them. His style appeals to a newbie learning reports for the first
time. My style is for hard-core programmers who have deadlines to meet and
just want to see code. However, in the first part of my book I use a
tutorial style of writing so that new programmers can learn how to create
reports. But if you are reading the chapter on web services, I figure that
you most likely an intermediate programmer so why should I restate the
obvious? It just wastes pages and costs me money. Since I'm paying for the
book out of my own pocket I have to make sure each page is useful or else I
will remove it.

Wow, what a long response that was.
Brian Bischof

A Crystal Reports.NET book for programmers? Its here!
* Covers ASP.NET and Windows Forms
* Teaches all phases of report development
* Alerts you to the bugs and how to get around them
* Maps out the complex ReportDocument object model
* Shows how to perform runtime customization
* Demonstrates all options of connecting with ADO.NET
* Gives complete code listings for every concept presented
http://www.crystalreportsbook.com/123aspx.asp


"SStewart" <nf*@nospam.com> wrote in message
news:OA**************@TK2MSFTNGP11.phx.gbl...
The only book I have is Professional Crystal Reports for Visual Studio ..NET, which doesn't seem to have enough depth. (have you seen it?)

This is very encouraging and BADLY needed.

"Brian Bischof" <br***@nospam.bischofsystems.com> wrote in message
news:eo*************@TK2MSFTNGP11.phx.gbl...

All the above - from beginners to advanced developers. It's a 2 part book.
Part 1 is for newbies to CR who just want to learn how to create reports and
do things like grouping/subreports/etc. Part 1 also teaches how to do
formulas and is a reference for Basic syntax. Part 2 is for people who

want
to do advanced .NET runtime customization of reports. Each chapter is

filled
with tons of code samples (VB.NET and C#) that have been written so that

you
can drop them directly into your own projects. It also covers programming Web Services, RDC, and RAS. Most of this code is undocumented except in my book (I know b/c I spent countless hours researching how to do every
imaginable task with CR and I put all the code in here). In my biased
opinion, its one of a kind (and desperately needed by the .NET community).
Brian Bischof

A Crystal Reports.NET book for programmers? Its here!
* Covers ASP.NET and Windows Forms
* Teaches all phases of report development
* Alerts you to the bugs and how to get around them
* Maps out the complex ReportDocument object model
* Shows how to perform runtime customization
* Demonstrates all options of connecting with ADO.NET
* Gives complete code listings for every concept presented
http://www.crystalreportsbook.com/123aspx.asp

"BStorm" <nf*@nospam.com> wrote in message
news:u6***************@tk2msftngp13.phx.gbl...
That is great news. What level will your book be targeted? (Beginner,
Intermediate, Advanced, Professional?)

"Brian Bischof" <br***@nospam.bischofsystems.com> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...
> CR.NET has extensive language support. You can program formulas using Basic
> syntax or Crystal syntax (similar to C). However, if you are using
Datasets
> to populate the report, you are better off doing the parsing at the .NET > level prior to passing it to CR. Just add two new fields to your

datatable
> and save the parsed results there. But if that doesn't suit you, just use
> the CR built in syntax and you'll be good to go.
>
> I have an entire book about CR.NET coming out on Amazon on April 1st and I'm
> offering autographed copies on my website prior to its release. I
also have
> a free ebook you can download off my website which teaches the basics of > integrating Crystal Reports with .NET.
>
>
> HTH,
> Brian Bischof
>
> A Crystal Reports.NET book for programmers? Its here!
> * Covers ASP.NET and Windows Forms
> * Teaches all phases of report development
> * Alerts you to the bugs and how to get around them
> * Maps out the complex ReportDocument object model
> * Shows how to perform runtime customization
> * Demonstrates all options of connecting with ADO.NET
> * Gives complete code listings for every concept presented
>
> http://www.123aspx.com/redir.aspx?res=30160
>
>
>
>
> "BStorm" <nf*@nospam.com> wrote in message
> news:%2****************@TK2MSFTNGP12.phx.gbl...
> > I have a transaction log file where the DataSet table's
Description column
> > is actually delimited into "subcolumns" based upon the transaction

id.
I
> > would like to parse these into separate fields for reporting

purposes and
> am
> > wondering if anyone knows if this is easily accomplished using the

.NET
> > version of Crystal Reports?
> >
> > For example, the description column may be reporting on a dataentry error
> as
> > follows:
> >
> > TXNCODE: 1010001
> > DESCRIPTION: "USERID: xxxxxxxxx TAXID: xxxxxxxxxxxxxxxxxx"
> >
> > I would like to, say, parse the substrng values for USERID and TAXID from
> > the DESCRIPTION column.
> >
> >
> >
>
>



Jul 21 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
1740
by: JDP | last post by:
How do I tell what version of Crystal is being used in VS .Net? Is there a way to tell what version my report was created in? Details: During the installation of VS 2003 we were prompted and...
2
4906
by: Mythran | last post by:
In .Net, how can I go about and set a Crystal Reports namespace? Right now they use the Root Namespace (VB) from the project. How can I extend the namespace for a single report (which will be set...
17
8413
by: Peter Proost | last post by:
Hi Group, I've got an interesting problem, I don't know if this is the right group but I think so because everything I've read about it so far says it's a .net problem. Here's the problem, we're...
3
472
by: BStorm | last post by:
I have a transaction log file where the DataSet table's Description column is actually delimited into "subcolumns" based upon the transaction id. I would like to parse these into separate fields...
1
2294
by: Tim_Mac | last post by:
hi, i am encountering a sporadic exception using crystal reports that is causing me grief, I can't 'handle' it... my code is loading a typed report, and loading a DataSet to it. unfortunately...
1
2226
by: Kannan | last post by:
Hi, I have noticed that Visual studio 2005 coming along with Crystal report. I have few crystal reports which is developed in 6.0 in my existing VB project and currently we are migrating m y VB...
0
1731
by: Wayne Deleersnyder | last post by:
I've been looking on the web trying to find a solution to converting a PDF Form from v.1.6(Acrobat 7) to PDF v1.4(Acrobat 5). It's one of those weird situations where one of the applications I'm...
4
1586
by: shyam255 | last post by:
1) Crystal Reports XI professional was installed on my machine. 2) After installing i checked in this folder path C:\Program Files\Common Files\Business Objects\3.0. But there was no MANAGED...
6
6573
by: G. Stoynev | last post by:
I can't seem to be able to prevent a Crystal Reports formula to evaluate an expression when the report contains no records to show. Here's the formula (DateTransferred is a DateTime column): ...
0
7242
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
7353
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
7418
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
7075
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
1
5063
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
4737
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
3212
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1572
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
1
781
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.