473,382 Members | 1,377 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,382 software developers and data experts.

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 2981
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
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
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
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
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
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
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
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
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
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): ...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

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.