Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

reporting services and share point

0 views
Skip to first unread message

שושי פוקס‎

unread,
Nov 10, 2009, 1:52:48 AM11/10/09
to
hi,

i am using reporting sevices 2005
the dataset source is from sharepoint,
i get the error:

an error occured while reading data from the query results set,
'?' , hexadecimal value 0*0B , is an invalid character, line 22
position 763

i don't care about this line, i want the report ignores the error and
doesn't show the problem line.
i have no access to the sharepoint, so everything i can do , have to
be in reporting.

looking forward your answer ,thank you very much
shoshi

Uri Dimant

unread,
Nov 10, 2009, 4:10:46 AM11/10/09
to
???? ???? ????
I do not think that is possible. If you could write a sp and check the error
with BEGIN TRY... BEGIN CATCH then I think I would be possible


"???? ????" <shosh...@gmail.com> wrote in message
news:c5047465-219e-464b...@j19g2000yqk.googlegroups.com...

שושי פוקס‎

unread,
Nov 10, 2009, 5:21:29 AM11/10/09
to
On Nov 10, 11:10 am, "Uri Dimant" <u...@iscar.co.il> wrote:
>  ???? ???? ????
> I do not think that is possible. If you could write a sp and check the error
> with BEGIN TRY... BEGIN CATCH   then I think I would be possible
>
> "???? ????" <shoshif...@gmail.com> wrote in message

>
> news:c5047465-219e-464b...@j19g2000yqk.googlegroups.com...
>
>
>
> > hi,
>
> > i am using reporting sevices 2005
> > the dataset source is from sharepoint,
> > i get the error:
>
> > an error occured while reading data from the query results set,
> > '?' , hexadecimal value 0*0B , is an invalid character, line 22
> > position 763
>
> > i don't care about this line, i want the report ignores the error and
> > doesn't show the problem line.
> > i have no access to the sharepoint, so everything i can do , have to
> > be in reporting.
>
> > looking forward your answer ,thank you very much
> > shoshi- Hide quoted text -
>
> - Show quoted text -

hi, thank you,
but as i searched it is imposible to write try and catch in the
dataset text

Uri Dimant

unread,
Nov 10, 2009, 5:40:50 AM11/10/09
to
Yes, but you can wrap the query within a SP and there to check for errors

"???? ????" <shosh...@gmail.com> wrote in message

news:77ac0949-fbcc-4f9e...@c3g2000yqd.googlegroups.com...

שושי פוקס‎

unread,
Nov 10, 2009, 5:45:56 AM11/10/09
to
On Nov 10, 12:40 pm, "Uri Dimant" <u...@iscar.co.il> wrote:
> Yes, but you can wrap the query within a SP and there to check for errors
>
> dataset text- Hide quoted text -

>
> - Show quoted text -

how can i wrap it?

Uri Dimant

unread,
Nov 10, 2009, 7:05:21 AM11/10/09
to
CREATE PROCEDURE sp
AS

BEGIN TRY
<
SELECT <columns> FROM SharePoint Table
>
END TRY
BEGIN CATCH
......
END CATCH

"???? ????" <shosh...@gmail.com> wrote in message

news:321a3d89-9fd0-40e2...@d10g2000yqh.googlegroups.com...

0 new messages