Thursday, March 22, 2012

bugs in subreport

I have a table contain a sub report . when I run on preview (visual studio), no problem . but when I run from my application , the report viewer just show "Report been generated" , never show the report .

after try and error I discover that when the query from main report return no records , plus the table contain a sub report , the problem occur only if you run it from your application using report viewer . not from visual studio . is this a bugs? anyway to resolve this or work around?

thks

a couple of things..

on your main report, you should probobaly set up a static dataset that always returns data... some like select from table where 1=1 or something like that. You can hide that information.

Secondly, besure to set up a description in the no rows property of the main and sub reports.

Bugs & Issues

Is there a web page where I can monitor the new/old bugs
and issues related to SQL Server & Analysis Services, SP's
e.t.c ?
Thanks.
You can see a list of hotfixes and the bugs that they fix at
http://www.aspfaq.com/2160 (anything past 8.00.760 is most likely a bug fix
that deals with at least one symptom).
As for a general list of all bugs, no, Microsoft does not publish this
information.
http://www.aspfaq.com/
(Reverse address to reply.)
"Nick" <anonymous@.discussions.microsoft.com> wrote in message
news:b78c01c48938$7353c460$a501280a@.phx.gbl...
> Is there a web page where I can monitor the new/old bugs
> and issues related to SQL Server & Analysis Services, SP's
> e.t.c ?
> Thanks.
|||Thanks............

>--Original Message--
>You can see a list of hotfixes and the bugs that they fix
at
>http://www.aspfaq.com/2160 (anything past 8.00.760 is
most likely a bug fix
>that deals with at least one symptom).
>As for a general list of all bugs, no, Microsoft does not
publish this
>information.
>--
>http://www.aspfaq.com/
>(Reverse address to reply.)
>
>
>"Nick" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:b78c01c48938$7353c460$a501280a@.phx.gbl...
SP's
>
>.
>
sql

Bugs & Issues

Is there a web page where I can monitor the new/old bugs
and issues related to SQL Server & Analysis Services, SP's
e.t.c '
Thanks.You can see a list of hotfixes and the bugs that they fix at
http://www.aspfaq.com/2160 (anything past 8.00.760 is most likely a bug fix
that deals with at least one symptom).
As for a general list of all bugs, no, Microsoft does not publish this
information.
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Nick" <anonymous@.discussions.microsoft.com> wrote in message
news:b78c01c48938$7353c460$a501280a@.phx.gbl...
> Is there a web page where I can monitor the new/old bugs
> and issues related to SQL Server & Analysis Services, SP's
> e.t.c '
> Thanks.|||Thanks............
>--Original Message--
>You can see a list of hotfixes and the bugs that they fix
at
>http://www.aspfaq.com/2160 (anything past 8.00.760 is
most likely a bug fix
>that deals with at least one symptom).
>As for a general list of all bugs, no, Microsoft does not
publish this
>information.
>--
>http://www.aspfaq.com/
>(Reverse address to reply.)
>
>
>"Nick" <anonymous@.discussions.microsoft.com> wrote in
message
>news:b78c01c48938$7353c460$a501280a@.phx.gbl...
>> Is there a web page where I can monitor the new/old bugs
>> and issues related to SQL Server & Analysis Services,
SP's
>> e.t.c '
>> Thanks.
>
>.
>

Bugs & Issues

Is there a web page where I can monitor the new/old bugs
and issues related to SQL Server & Analysis Services, SP's
e.t.c '
Thanks.You can see a list of hotfixes and the bugs that they fix at
http://www.aspfaq.com/2160 (anything past 8.00.760 is most likely a bug fix
that deals with at least one symptom).
As for a general list of all bugs, no, Microsoft does not publish this
information.
http://www.aspfaq.com/
(Reverse address to reply.)
"Nick" <anonymous@.discussions.microsoft.com> wrote in message
news:b78c01c48938$7353c460$a501280a@.phx.gbl...
> Is there a web page where I can monitor the new/old bugs
> and issues related to SQL Server & Analysis Services, SP's
> e.t.c '
> Thanks.|||Thanks............

>--Original Message--
>You can see a list of hotfixes and the bugs that they fix
at
>http://www.aspfaq.com/2160 (anything past 8.00.760 is
most likely a bug fix
>that deals with at least one symptom).
>As for a general list of all bugs, no, Microsoft does not
publish this
>information.
>--
>http://www.aspfaq.com/
>(Reverse address to reply.)
>
>
>"Nick" <anonymous@.discussions.microsoft.com> wrote in
message
>news:b78c01c48938$7353c460$a501280a@.phx.gbl...
SP's[vbcol=seagreen]
>
>.
>

Bugs

What do you do when you think that you've got a bug? Do
you have to call MS Support? Or do they have a free way
to report a bug?First, check the documentation and search the MS Knowledge Base to see if
it's a known issue:
http://support.microsoft.com/defaul...h;en-gb;kbhowto
Use Google to search the archives of the sqlserver newsgroups to see if your
problem has been discussed before.
If you're still not having any luck then post your problem here. If possible
post some some code that will actually reproduce the problem so that others
can test it out and suggest solutions.
You can also go via MS Product Support. If they acknowledge it as an
undocumented bug then you shouldn't be charged for the call.
David Portas
SQL Server MVP
--

Bugs

What do you do when you think that you've got a bug? Do
you have to call MS Support? Or do they have a free way
to report a bug?First, check the documentation and search the MS Knowledge Base to see if
it's a known issue:
http://support.microsoft.com/default.aspx?scid=fh;en-gb;kbhowto
Use Google to search the archives of the sqlserver newsgroups to see if your
problem has been discussed before.
If you're still not having any luck then post your problem here. If possible
post some some code that will actually reproduce the problem so that others
can test it out and suggest solutions.
You can also go via MS Product Support. If they acknowledge it as an
undocumented bug then you shouldn't be charged for the call.
--
David Portas
SQL Server MVP
--

Bugs

What do you do when you think that you've got a bug? Do
you have to call MS Support? Or do they have a free way
to report a bug?
First, check the documentation and search the MS Knowledge Base to see if
it's a known issue:
http://support.microsoft.com/default...;en-gb;kbhowto
Use Google to search the archives of the sqlserver newsgroups to see if your
problem has been discussed before.
If you're still not having any luck then post your problem here. If possible
post some some code that will actually reproduce the problem so that others
can test it out and suggest solutions.
You can also go via MS Product Support. If they acknowledge it as an
undocumented bug then you shouldn't be charged for the call.
David Portas
SQL Server MVP
sql