Formatting in MRS:

I can't seem to get my formatting to work correctly. I have a very simple
report, yet, when I try to print it, it doesn't break properly. It seems to
print all on one page and I do have a break after my group.
It worked at one point, now, something has changed that makes it not work.
I'm using a letter size piece of paper and I thought that should give me 8.5
inches across the top of the page. When I use the full 8.5 inches, the
report appears too "Wide" in the viewer. When I use less inches, say, 7.5",
it appears too narrow and without page breaks.
Is there something I need to read to better understand what's going on with
the formatting?Where are printing from the browser? If so, you should export to PDF or
TIFF and print from there, those are considered print-ready formats while
HTML is not. SP2 is coming soon and it includes a nifty print utility.
--
Douglas McDowell
douglas@.nospam.solidqualitylearning.com
"C. Lynn" <CLynn@.discussions.microsoft.com> wrote in message
news:8497D03E-80C0-4C9A-ACF6-574EE9B89E2D@.microsoft.com...
>I can't seem to get my formatting to work correctly. I have a very simple
> report, yet, when I try to print it, it doesn't break properly. It seems
> to
> print all on one page and I do have a break after my group.
> It worked at one point, now, something has changed that makes it not work.
> I'm using a letter size piece of paper and I thought that should give me
> 8.5
> inches across the top of the page. When I use the full 8.5 inches, the
> report appears too "Wide" in the viewer. When I use less inches, say,
> 7.5",
> it appears too narrow and without page breaks.
> Is there something I need to read to better understand what's going on
> with
> the formatting?

Formatting a field in a database

Hi,
I want to format an address field that is in a database as 123 Happy Street|
|Montgomery|AL|36104
I want to break it out into address1, address2, etc without the pipes.
I found some code that seems to fix my problem below pretty well, but about
half the time it doesn't work. I get an error message when I run it that
says - An error has occurred during report processing. (rsProcessingAborted)
Get Online Help
Cannot read the next data row for the data set DAIS.
(rsErrorReadingNextDataRow) Get Online Help
Invalid length parameter passed to the substring function.
The following is part my code. Can anybody PLEASE help me figure why this
doesn't always work or tell me a better way to do it?
Thanks
Jill
SELECT TOP 1 SUBSTRING(NAMEAttributes1.Attribute, 0, CHARINDEX('|',
NAMEAttributes1.Attribute, 0)) AS Addr1, SUBSTRING(NAMEAttributes1.Attribute,
CHARINDEX('|', NAMEAttributes1.Attribute, 0) + 1,
CHARINDEX('|', NAMEAttributes1.Attribute, CHARINDEX('|',
NAMEAttributes1.Attribute, 0) + 1)
- (CHARINDEX('|', NAMEAttributes1.Attribute, 0) + 1))
AS Addr2, SUBSTRING(NAMEAttributes1.Attribute, CHARINDEX('|',
NAMEAttributes1.Attribute,
CHARINDEX('|', NAMEAttributes1.Attribute, 0) + 1) + 1,
CHARINDEX('|', NAMEAttributes1.Attribute, CHARINDEX('|',
NAMEAttributes1.Attribute,
CHARINDEX('|', NAMEAttributes1.Attribute, 0) + 1) + 1)
- CHARINDEX('|', NAMEAttributes1.Attribute, CHARINDEX('|',
NAMEAttributes1.Attribute, 0) + 1) - 1)
AS City, SUBSTRING(NAMEAttributes1.Attribute,
CHARINDEX('|', NAMEAttributes1.Attribute, CHARINDEX('|',
NAMEAttributes1.Attribute, CHARINDEX('|',
NAMEAttributes1.Attribute, 0) + 1) + 1) + 1,
CHARINDEX('|', NAMEAttributes1.Attribute, CHARINDEX('|',
NAMEAttributes1.Attribute, CHARINDEX('|',
NAMEAttributes1.Attribute, CHARINDEX('|',
NAMEAttributes1.Attribute, 0) + 1) + 1) + 1) - CHARINDEX('|',
NAMEAttributes1.Attribute, CHARINDEX('|',
NAMEAttributes1.Attribute, CHARINDEX('|',
NAMEAttributes1.Attribute, 0) + 1) + 1) - 1) AS State,
SUBSTRING(NAMEAttributes1.Attribute, CHARINDEX('|',
NAMEAttributes1.Attribute, CHARINDEX('|',
NAMEAttributes1.Attribute, CHARINDEX('|', NAMEAttributes1.Attribute,
CHARINDEX('|',
NAMEAttributes1.Attribute, 0) + 1) + 1) + 1) + 1, 5)
AS ZIP,Suppose that you wouldn't want to rethink how you are keeping your
address.....
Anyway, the code you have should work as long as you can absolutely
guarantee that your addresses will be in the desired format. If you are
missing one pipe as an example you will end up with the error message that
you supplied. I think that is probably your problem and that you need to
clean up the data.
Note that you could work around thie problem of missing pipes in a stored
proc except for the fact that if a pipe is missing there's no way to know
exactly what piece of data is missing. With a normal table structure holding
the address in separate fields this would not be an issue.
"Jill" wrote:
> Hi,
> I want to format an address field that is in a database as 123 Happy Street|
> |Montgomery|AL|36104
> I want to break it out into address1, address2, etc without the pipes.
> I found some code that seems to fix my problem below pretty well, but about
> half the time it doesn't work. I get an error message when I run it that
> says - An error has occurred during report processing. (rsProcessingAborted)
> Get Online Help
> Cannot read the next data row for the data set DAIS.
> (rsErrorReadingNextDataRow) Get Online Help
> Invalid length parameter passed to the substring function.
> The following is part my code. Can anybody PLEASE help me figure why this
> doesn't always work or tell me a better way to do it?
> Thanks
> Jill
> SELECT TOP 1 SUBSTRING(NAMEAttributes1.Attribute, 0, CHARINDEX('|',
> NAMEAttributes1.Attribute, 0)) AS Addr1, SUBSTRING(NAMEAttributes1.Attribute,
> CHARINDEX('|', NAMEAttributes1.Attribute, 0) + 1,
> CHARINDEX('|', NAMEAttributes1.Attribute, CHARINDEX('|',
> NAMEAttributes1.Attribute, 0) + 1)
> - (CHARINDEX('|', NAMEAttributes1.Attribute, 0) + 1))
> AS Addr2, SUBSTRING(NAMEAttributes1.Attribute, CHARINDEX('|',
> NAMEAttributes1.Attribute,
> CHARINDEX('|', NAMEAttributes1.Attribute, 0) + 1) + 1,
> CHARINDEX('|', NAMEAttributes1.Attribute, CHARINDEX('|',
> NAMEAttributes1.Attribute,
> CHARINDEX('|', NAMEAttributes1.Attribute, 0) + 1) + 1)
> - CHARINDEX('|', NAMEAttributes1.Attribute, CHARINDEX('|',
> NAMEAttributes1.Attribute, 0) + 1) - 1)
> AS City, SUBSTRING(NAMEAttributes1.Attribute,
> CHARINDEX('|', NAMEAttributes1.Attribute, CHARINDEX('|',
> NAMEAttributes1.Attribute, CHARINDEX('|',
> NAMEAttributes1.Attribute, 0) + 1) + 1) + 1,
> CHARINDEX('|', NAMEAttributes1.Attribute, CHARINDEX('|',
> NAMEAttributes1.Attribute, CHARINDEX('|',
> NAMEAttributes1.Attribute, CHARINDEX('|',
> NAMEAttributes1.Attribute, 0) + 1) + 1) + 1) - CHARINDEX('|',
> NAMEAttributes1.Attribute, CHARINDEX('|',
> NAMEAttributes1.Attribute, CHARINDEX('|',
> NAMEAttributes1.Attribute, 0) + 1) + 1) - 1) AS State,
> SUBSTRING(NAMEAttributes1.Attribute, CHARINDEX('|',
> NAMEAttributes1.Attribute, CHARINDEX('|',
> NAMEAttributes1.Attribute, CHARINDEX('|', NAMEAttributes1.Attribute,
> CHARINDEX('|',
> NAMEAttributes1.Attribute, 0) + 1) + 1) + 1) + 1, 5)
> AS ZIP,
>|||Perhaps you can use this code in Reporting Service.
=Split(Fields!Address.Value, "|")(0)
=Split(Fields!Address.Value, "|")(1)
=Split(Fields!Address.Value, "|")(2)
=Split(Fields!Address.Value, "|")(3)
Hope this helps ..
> "Jill" wrote:
> > Hi,
> > I want to format an address field that is in a database as 123 Happy Street|
> > |Montgomery|AL|36104
> > I want to break it out into address1, address2, etc without the pipes.
> >
> > I found some code that seems to fix my problem below pretty well, but about
> > half the time it doesn't work. I get an error message when I run it that
> > says - An error has occurred during report processing. (rsProcessingAborted)
> > Get Online Help
> > Cannot read the next data row for the data set DAIS.
> > (rsErrorReadingNextDataRow) Get Online Help
> > Invalid length parameter passed to the substring function.
> >
> > The following is part my code. Can anybody PLEASE help me figure why this
> > doesn't always work or tell me a better way to do it?
> >
> > Thanks
> > Jill
> >
> > SELECT TOP 1 SUBSTRING(NAMEAttributes1.Attribute, 0, CHARINDEX('|',
> > NAMEAttributes1.Attribute, 0)) AS Addr1, SUBSTRING(NAMEAttributes1.Attribute,
> > CHARINDEX('|', NAMEAttributes1.Attribute, 0) + 1,
> > CHARINDEX('|', NAMEAttributes1.Attribute, CHARINDEX('|',
> > NAMEAttributes1.Attribute, 0) + 1)
> > - (CHARINDEX('|', NAMEAttributes1.Attribute, 0) + 1))
> > AS Addr2, SUBSTRING(NAMEAttributes1.Attribute, CHARINDEX('|',
> > NAMEAttributes1.Attribute,
> > CHARINDEX('|', NAMEAttributes1.Attribute, 0) + 1) + 1,
> > CHARINDEX('|', NAMEAttributes1.Attribute, CHARINDEX('|',
> > NAMEAttributes1.Attribute,
> > CHARINDEX('|', NAMEAttributes1.Attribute, 0) + 1) + 1)
> > - CHARINDEX('|', NAMEAttributes1.Attribute, CHARINDEX('|',
> > NAMEAttributes1.Attribute, 0) + 1) - 1)
> > AS City, SUBSTRING(NAMEAttributes1.Attribute,
> > CHARINDEX('|', NAMEAttributes1.Attribute, CHARINDEX('|',
> > NAMEAttributes1.Attribute, CHARINDEX('|',
> > NAMEAttributes1.Attribute, 0) + 1) + 1) + 1,
> > CHARINDEX('|', NAMEAttributes1.Attribute, CHARINDEX('|',
> > NAMEAttributes1.Attribute, CHARINDEX('|',
> > NAMEAttributes1.Attribute, CHARINDEX('|',
> > NAMEAttributes1.Attribute, 0) + 1) + 1) + 1) - CHARINDEX('|',
> > NAMEAttributes1.Attribute, CHARINDEX('|',
> > NAMEAttributes1.Attribute, CHARINDEX('|',
> > NAMEAttributes1.Attribute, 0) + 1) + 1) - 1) AS State,
> > SUBSTRING(NAMEAttributes1.Attribute, CHARINDEX('|',
> > NAMEAttributes1.Attribute, CHARINDEX('|',
> > NAMEAttributes1.Attribute, CHARINDEX('|', NAMEAttributes1.Attribute,
> > CHARINDEX('|',
> > NAMEAttributes1.Attribute, 0) + 1) + 1) + 1) + 1, 5)
> > AS ZIP,
> >|||Thank You, Thank You!! This worked!!
"Keenan" wrote:
> Perhaps you can use this code in Reporting Service.
> =Split(Fields!Address.Value, "|")(0)
> =Split(Fields!Address.Value, "|")(1)
> =Split(Fields!Address.Value, "|")(2)
> =Split(Fields!Address.Value, "|")(3)
> Hope this helps ..
> > "Jill" wrote:
> >
> > > Hi,
> > > I want to format an address field that is in a database as 123 Happy Street|
> > > |Montgomery|AL|36104
> > > I want to break it out into address1, address2, etc without the pipes.
> > >
> > > I found some code that seems to fix my problem below pretty well, but about
> > > half the time it doesn't work. I get an error message when I run it that
> > > says - An error has occurred during report processing. (rsProcessingAborted)
> > > Get Online Help
> > > Cannot read the next data row for the data set DAIS.
> > > (rsErrorReadingNextDataRow) Get Online Help
> > > Invalid length parameter passed to the substring function.
> > >
> > > The following is part my code. Can anybody PLEASE help me figure why this
> > > doesn't always work or tell me a better way to do it?
> > >
> > > Thanks
> > > Jill
> > >
> > > SELECT TOP 1 SUBSTRING(NAMEAttributes1.Attribute, 0, CHARINDEX('|',
> > > NAMEAttributes1.Attribute, 0)) AS Addr1, SUBSTRING(NAMEAttributes1.Attribute,
> > > CHARINDEX('|', NAMEAttributes1.Attribute, 0) + 1,
> > > CHARINDEX('|', NAMEAttributes1.Attribute, CHARINDEX('|',
> > > NAMEAttributes1.Attribute, 0) + 1)
> > > - (CHARINDEX('|', NAMEAttributes1.Attribute, 0) + 1))
> > > AS Addr2, SUBSTRING(NAMEAttributes1.Attribute, CHARINDEX('|',
> > > NAMEAttributes1.Attribute,
> > > CHARINDEX('|', NAMEAttributes1.Attribute, 0) + 1) + 1,
> > > CHARINDEX('|', NAMEAttributes1.Attribute, CHARINDEX('|',
> > > NAMEAttributes1.Attribute,
> > > CHARINDEX('|', NAMEAttributes1.Attribute, 0) + 1) + 1)
> > > - CHARINDEX('|', NAMEAttributes1.Attribute, CHARINDEX('|',
> > > NAMEAttributes1.Attribute, 0) + 1) - 1)
> > > AS City, SUBSTRING(NAMEAttributes1.Attribute,
> > > CHARINDEX('|', NAMEAttributes1.Attribute, CHARINDEX('|',
> > > NAMEAttributes1.Attribute, CHARINDEX('|',
> > > NAMEAttributes1.Attribute, 0) + 1) + 1) + 1,
> > > CHARINDEX('|', NAMEAttributes1.Attribute, CHARINDEX('|',
> > > NAMEAttributes1.Attribute, CHARINDEX('|',
> > > NAMEAttributes1.Attribute, CHARINDEX('|',
> > > NAMEAttributes1.Attribute, 0) + 1) + 1) + 1) - CHARINDEX('|',
> > > NAMEAttributes1.Attribute, CHARINDEX('|',
> > > NAMEAttributes1.Attribute, CHARINDEX('|',
> > > NAMEAttributes1.Attribute, 0) + 1) + 1) - 1) AS State,
> > > SUBSTRING(NAMEAttributes1.Attribute, CHARINDEX('|',
> > > NAMEAttributes1.Attribute, CHARINDEX('|',
> > > NAMEAttributes1.Attribute, CHARINDEX('|', NAMEAttributes1.Attribute,
> > > CHARINDEX('|',
> > > NAMEAttributes1.Attribute, 0) + 1) + 1) + 1) + 1, 5)
> > > AS ZIP,
> > >