Not a valid Report Server Database?

I had to reinstall RS. While reinstalling Reporting Services I received an
error. I am at the point of specifying the report server database and I
tried to use the default, "ReportServer", which is the same as I used before.
The error = "A database with the specified name(ReportServer) already exists
and is not a valid Report Server Database. You must either remove the
existing database or specify a new database name.
According to my documentation I should be able to use the existing name and
the reinstall will not lose my existing reports.
Any idea why I would get this message?
--
DonI'm getting the same message. Anybody got any ideas?|||Are you connected to a database that was created by report server setup?
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
<butter-ball@.usa.net> wrote in message
news:1106160275.812278.14380@.z14g2000cwz.googlegroups.com...
> I'm getting the same message. Anybody got any ideas?
>

NoRows SubReport

Greetings,

I have a report which contains three subreports. Each subreport is contained within a rectangle in the main report so I can force a page break after each subreport. In each of the subreports, there is a graphic and a text box on one line, then another text box below those two items, then a table below all that. My problem is that if one of the subreports returns no data, it is resulting in a NoRows sort of situation and not even the graphic and the two text boxes are shown. I understand that you can set a NoRows message, but ideally, I want my NoRows message to be the graphic and the two text boxes, not a plain text message.

I'm not sure if this is even possible or at the very least if I could conditionally force a page break in my rectangles based on whether one of the subreports returns a NoRows situation.

Thanks In Advance

One thing that you can do is create a second dataset that always returns data. You can do this with a query like the following. This causes the SubReport to always report to the processing runtime that it contains data, so that it should always be processed and rendered.

Select 1 as DataValue

However, the problem with this is that the empty table will still contain the Table headers. So, you will have to make the table conditionally visible using an expression such as this.

=IsNothing(Fields!FieldName.Value)

You can pretty much use any field in the dataset to which the table is bound.

Adding the second dataset and adding the conditional visibility to the table should result in the subreport still being displayed, with the table hidden.

Ian|||

This works perfectly. Thank You. In fact, due to the NoRows parameter being set on the subreport, the table headers themselves are not shown, but instead the NoRows message is shown WITH the graphic and two text boxes. This is exactly the result I wanted.

NoRows Property in Matrix does not work

I wanted to set the NoRows property for a matrix on a report to inform
the user when this condition occurs. I run the report by supplying
parameters that I am sure returns no data. Specifically, I am
determining the table to query based on user inputs. I provide inputs
that will look for a non existent table. I do an existence check on
the table to see if it is there to prevent a sql server error. If it
finds no table the query is not run. However, given that nothing is
returned the norows property is ignored and I get the error "Invalid
attempt to read when no data is present."
Could it be because the matrix requires an empty dataset back?That is what it was. I now ensure I return an empty dataset if the
table does not exist.

NoRows Leaves Extra White Space

I have a report with multiple tables and datasets. The problem is if one of
the tables/datasets doesn't have any data I get too much white space between
the sections. I tried to set the visiblity property on the table but that
doesn't work if there is no data being returned via the dataset.
For example:
John Does (1st table)
Background Info (2nd table)
Education (3rd table)
This looks fine because there is data in all 3 tables/datasets
Now if there is no background info I get this:
John Doe (1st table)
Education (3rd table)
When I want this:
John Doe (1st table)
Education (3rd table)
I can't combine the info to one table for reasons I won't go into.
Thanks!Try putting each table inside a rectangle and setting the rectangle property
visiblility to Hidden = True if no rows are returned for the rectangles child
table. Additionally, put all 3 rectangles/tables inside a 'master'
rectangle. This will help control some of your whitespace issues.
--
Andy Potter
blog: http://sqlreportingservices.spaces.live.com/
"Anonymous" wrote:
> I have a report with multiple tables and datasets. The problem is if one of
> the tables/datasets doesn't have any data I get too much white space between
> the sections. I tried to set the visiblity property on the table but that
> doesn't work if there is no data being returned via the dataset.
> For example:
> John Does (1st table)
> Background Info (2nd table)
> Education (3rd table)
> This looks fine because there is data in all 3 tables/datasets
> Now if there is no background info I get this:
> John Doe (1st table)
>
> Education (3rd table)
> When I want this:
> John Doe (1st table)
> Education (3rd table)
> I can't combine the info to one table for reasons I won't go into.
> Thanks!
>

NoRows doesn't work for Subreport

Hi there,
I have one report which has a table with a subreport in it, I put
something in the NoRows property of the Table and subreport. If there
is no data, I always got error " An internal error occurred on the
report server. See the error log for more details". Is NoRows property
for subreport broken?
Thanks.
HenryIf you get an error in the subreport this is more likely a problem with the
linkage between the primary and subreport.
Figure out what the parameter values are in the main report that get passed
to the subreport, then run the subreport with those parameters.
-Tim
<fanh@.tycoelectronics.com> wrote in message
news:1151511538.340685.35430@.b68g2000cwa.googlegroups.com...
> Hi there,
> I have one report which has a table with a subreport in it, I put
> something in the NoRows property of the Table and subreport. If there
> is no data, I always got error " An internal error occurred on the
> report server. See the error log for more details". Is NoRows property
> for subreport broken?
> Thanks.
> Henry
>|||Thanks, Tim.
The main report with the subreport works well if there are some data, I
use NoRows property of the main report and subreport. I did try all
input values including null for the subreport, it works well seperately
- showing the NoRows message. I also tried deleting the subreport, and
the main report works well - showing the NoRows message too.
But the main report with the subreport doesn't work and gave me
"internal error" message.I checked the ErrorLog, it shows
"AdjustTokenPriviledges () failed (00000514),,,, Callback type 11 not
used, callback type 7 not used", I don't understand this error, I
wonder the NoRows property is broken in SQL 2005.
Henry
Tim Dot NoSpam wrote:
> If you get an error in the subreport this is more likely a problem with the
> linkage between the primary and subreport.
> Figure out what the parameter values are in the main report that get passed
> to the subreport, then run the subreport with those parameters.
> -Tim
> <fanh@.tycoelectronics.com> wrote in message
> news:1151511538.340685.35430@.b68g2000cwa.googlegroups.com...
> > Hi there,
> >
> > I have one report which has a table with a subreport in it, I put
> > something in the NoRows property of the Table and subreport. If there
> > is no data, I always got error " An internal error occurred on the
> > report server. See the error log for more details". Is NoRows property
> > for subreport broken?
> > Thanks.
> >
> > Henry
> >

Normalization Tool

Anyone know if a tool exists that can be pointed at a specific database, analyze it, and report and/or perform normalization recommendations?

well you have to do it on your own.

its actually easy

|||Joey, I've done it for years and am comfortable with it. I was just wondering if such a tool existed.|||

I guess no such tool exist as of now.

maybe we should invent one

non-typesafe data reporting

I have vb.net 2005 code that generates data that needs to be reported.
The results need to be reported in generic text fields in the rdlc
report. Sometimes I will report 2 text values while the next time I
may report 3 values in the report text box.
My problem is that I can't pass this program generated data to the text
fields on the report. I used to do this and can still do this in
crystal reports and active reports by generating text objects on the
report followed by creating an instance of the report. Next the
instance property (any of the text boxes) value is set by means of
setting the parameter. Lastly generate the report.
In summary, I need to be able to pass specific program generated text
values to text boxes to a Microsoft report by NOT using a dataset or
datatable.
Thanks all
(crystal example)
Dim i As New CrystalReport1
i.SetParameterValue("Parameter_X", "test value for text box on
report")Use hidden report parameters. Then hide or show the textbox based on whether
the parameter is filled in or not.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Chris" <Chris.Grimm@.ormet.com> wrote in message
news:1134161274.196063.122960@.g47g2000cwa.googlegroups.com...
>I have vb.net 2005 code that generates data that needs to be reported.
> The results need to be reported in generic text fields in the rdlc
> report. Sometimes I will report 2 text values while the next time I
> may report 3 values in the report text box.
> My problem is that I can't pass this program generated data to the text
> fields on the report. I used to do this and can still do this in
> crystal reports and active reports by generating text objects on the
> report followed by creating an instance of the report. Next the
> instance property (any of the text boxes) value is set by means of
> setting the parameter. Lastly generate the report.
> In summary, I need to be able to pass specific program generated text
> values to text boxes to a Microsoft report by NOT using a dataset or
> datatable.
> Thanks all
> (crystal example)
> Dim i As New CrystalReport1
> i.SetParameterValue("Parameter_X", "test value for text box on
> report")
>

Non-static data in head of report

Hi everybody,
I'm quite new to reporting services, respectively I were not able zu work
with them for a while, therefore I forget most of the stuff I knew. Here's
my problem:
We have lots of reports made in Microsoft Access, that we now have to
convert for the use in the reporting services (2000). Basically in all
Access reports we use dynamic data in the page header, like a name from an
employee which comes from the database. This seems to be impossible in the
reporting services. We get an error message when compiling the report.
Does anyone know if this possible or a good workaround? I cannot believe
that this isn't possible, it's essential.
Thx in advance
MichaelWe use something like this:
In the hidden text of the body put this
=Code.GetBaseName( First(Fields!BaseState.Value, "DataSet1"))
In the footer/header text use this.
=Code.GetBaseName(Nothing)
Add this to the code pane
' Functions to provide data fields for report header
' Input:
' a data value
' Output:
' data value for report header
' Purpose:
' Provide data values for the report header
' Save data value in a static local variable
' for the last page header, the input variable will be empty
' so return the saved value
' Note:
' The ReportItems passed in must be at the top of the Body of the report
' so they will be accessible on the first page of the report
' The functions are Shared so theStatic variable will work
' The Static variable will retain its value while the report viewer is open,
' even if the parameter values are modified and the report re-run
' so always save the value except when the current value is not available
' All this is necessary because Reporting Services does not allow data
fields in the page header
' and on a Purchase Order with many details, the second page has no detail
fields
' so the hidden data fields cannot not be put in the detail area
public shared function GetBaseName (byval InputValue as string) as string
static SavedValue as string
if InputValue <> "" then
SavedValue = InputValue
return InputValue
else
return SavedValue
end if
end function
Steve MunLeeuw
"Michael Bender" <technik@.salescom.de> wrote in message
news:ecmd6i$c5b$01$1@.news.t-online.com...
> Hi everybody,
> I'm quite new to reporting services, respectively I were not able zu work
> with them for a while, therefore I forget most of the stuff I knew. Here's
> my problem:
> We have lots of reports made in Microsoft Access, that we now have to
> convert for the use in the reporting services (2000). Basically in all
> Access reports we use dynamic data in the page header, like a name from an
> employee which comes from the database. This seems to be impossible in the
> reporting services. We get an error message when compiling the report.
> Does anyone know if this possible or a good workaround? I cannot believe
> that this isn't possible, it's essential.
> Thx in advance
> Michael
>|||Thanks very much, Steve.
"Steve MunLeeuw" <smunson@.clearwire.net> schrieb im Newsbeitrag
news:eDqZMIHyGHA.1936@.TK2MSFTNGP06.phx.gbl...
> We use something like this:
> In the hidden text of the body put this
> =Code.GetBaseName( First(Fields!BaseState.Value, "DataSet1"))
> In the footer/header text use this.
> =Code.GetBaseName(Nothing)
> Add this to the code pane
> ' Functions to provide data fields for report header
> ' Input:
> ' a data value
> ' Output:
> ' data value for report header
> ' Purpose:
> ' Provide data values for the report header
> ' Save data value in a static local variable
> ' for the last page header, the input variable will be empty
> ' so return the saved value
> ' Note:
> ' The ReportItems passed in must be at the top of the Body of the report
> ' so they will be accessible on the first page of the report
> ' The functions are Shared so theStatic variable will work
> ' The Static variable will retain its value while the report viewer is
> open,
> ' even if the parameter values are modified and the report re-run
> ' so always save the value except when the current value is not available
> ' All this is necessary because Reporting Services does not allow data
> fields in the page header
> ' and on a Purchase Order with many details, the second page has no detail
> fields
> ' so the hidden data fields cannot not be put in the detail area
> public shared function GetBaseName (byval InputValue as string) as string
> static SavedValue as string
> if InputValue <> "" then
> SavedValue = InputValue
> return InputValue
> else
> return SavedValue
> end if
> end function
>
> Steve MunLeeuw
> "Michael Bender" <technik@.salescom.de> wrote in message
> news:ecmd6i$c5b$01$1@.news.t-online.com...
>> Hi everybody,
>> I'm quite new to reporting services, respectively I were not able zu work
>> with them for a while, therefore I forget most of the stuff I knew.
>> Here's my problem:
>> We have lots of reports made in Microsoft Access, that we now have to
>> convert for the use in the reporting services (2000). Basically in all
>> Access reports we use dynamic data in the page header, like a name from
>> an employee which comes from the database. This seems to be impossible in
>> the reporting services. We get an error message when compiling the
>> report.
>> Does anyone know if this possible or a good workaround? I cannot believe
>> that this isn't possible, it's essential.
>> Thx in advance
>> Michael
>

Non-Report Hyperlinks on Report Manager Home Page?

Is it possible to add hyperlinks to the Report Manager Home Page that link to other aspx pages? I have created some associated data entry aspx pages that I want to enable access to from the Report Manager Home Page (if possible).

Thanks!

It isn't...maybe you could run it inside an IFRAME, surrounded by other UI (including "your" hyperlinks)?|||

pittpanther wrote:

Is it possible to add hyperlinks to the Report Manager Home Page that link to other aspx pages? I have created some associated data entry aspx pages that I want to enable access to from the Report Manager Home Page (if possible).

Thanks!

Why not just create an "index" aspx page that would have links to reports similar to report manager? You could have this index page in the same project as the associated data entry aspx pages.

It seems to me that you're thinking about it backwards.

|||

Thanks for the replies...

The end user is already fairly comfortable with the Report Manager front end, so I am kind of stuck with it as my launching point.

The only thing I have come up with is an "empty" report accessible from the main folder that only includes the hyperlinks for the "Data Entry" aspx pages. A little kludgy though.

|||Russell - I am not familiar with an IFRAME... could you elaborate a little more?sql

Non-Report Hyperlinks on Report Manager Home Page?

Is it possible to add hyperlinks to the Report Manager Home Page that link to other aspx pages? I have created some associated data entry aspx pages that I want to enable access to from the Report Manager Home Page (if possible).

Thanks!

It isn't...maybe you could run it inside an IFRAME, surrounded by other UI (including "your" hyperlinks)?|||

pittpanther wrote:

Is it possible to add hyperlinks to the Report Manager Home Page that link to other aspx pages? I have created some associated data entry aspx pages that I want to enable access to from the Report Manager Home Page (if possible).

Thanks!

Why not just create an "index" aspx page that would have links to reports similar to report manager? You could have this index page in the same project as the associated data entry aspx pages.

It seems to me that you're thinking about it backwards.

|||

Thanks for the replies...

The end user is already fairly comfortable with the Report Manager front end, so I am kind of stuck with it as my launching point.

The only thing I have come up with is an "empty" report accessible from the main folder that only includes the hyperlinks for the "Data Entry" aspx pages. A little kludgy though.

|||Russell - I am not familiar with an IFRAME... could you elaborate a little more?

Non-queried default values not working

This is driving me crazy. I can't get non-queried default values to
work with non-queried string report parameters. I'm using Reporting
Services 2000. Here's a test case: I have a simple Report Parameter: a
string, called "Color". It has three non-queried label-value pairs:
Red-red, Green-green, Blue-blue. I then try to define a default
non-queried value of green. Run the report, it always says "Select a
value". If I change the label-values to single-digit values, like
this: Red-1, Green-2, Blue-3, and set the default value to 2, then
Green comes up as the selected value (which is what I want). But I
cannot use a string for the value - it never matches. I've also tried
two-digit numbers: Red-11, Green-22, Blue-33, and used 22 as the
default. Comes up with "Select a value".
Can you not use strings as default values?Found the answer myself. Yes, you can use strings as default values,
as you would expect. Everything worked great in the Preview pane of
Visual Studio (the defaults would show properly) but when I put the
report on the report server, the dropdowns would say "Select a value".
To fix it, I had to completely delete the report from the server, and
upload a brand new copy of the RDL file. It did not work to simply use
the "Update" option in the Report Properties web page on the server.
It would update the report (i.e., I could see other changes I made) but
for some reason, the parameters would not work properly until I
completed deleted the report and uploaded it again. Go figure.

nonoandy

Hello,

My users often view some report for some minutes and after that want to return to parent report.
If they did it after small time (~less than minute), everything is OK. But if this pause is above 1 minute they receive "Runtime Error" message and can only to go to homepage.

I think that this is some session time or something like that.
Am I right? How can fix it?

Thank youAfter setting customError=off we receive "Back call without drillthrough report" error|||Did you find a fix for the problem? Can anyone help? I get the same problem.|||

Back call without drillthrough report

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidOperationException: Back call without drillthrough report

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[InvalidOperationException: Back call without drillthrough report] Microsoft.Reporting.WebForms.ReportViewer.Toolbar_Back(Object sender, EventArgs e) +229 Microsoft.Reporting.WebForms.ToolbarControl.OnBack(Object sender, EventArgs e) +25 Microsoft.Reporting.WebForms.BackGroup.BackButton_Click(Object sender, EventArgs e) +40 Microsoft.Reporting.WebForms.ScriptSwitchImage.EnabledImage_Click(Object sender, ImageClickEventArgs e) +25 System.Web.UI.WebControls.ImageButton.OnClick(ImageClickEventArgs e) +105 System.Web.UI.WebControls.ImageButton.RaisePostBackEvent(String eventArgument) +115 System.Web.UI.WebControls.ImageButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102

|||

I am also receiving this error but there is no delay. As soon as the report is loaded, I click back to goto the previous report and I get this error.

It is interesting because charts are also not loading. I dont receive an error message but in the event log this is entered: "The stream cannot be found."

This only happens when I drill-through.

|||

I'm having this issue also. Did anyone ever find a solution? thanks

|||Hey guys I think that this issue has something to do with some other problems I have been having due to SP1. I notice that the back button wasn't the only thing messing up, and it was only doing it in the ReportViewer (not when I went to the report directly in VS)

check out this article
http://www.eggheadcafe.com/software/aspnet/29672997/back-call-without-drillth.aspx

-nonoandy|||

i am also facing this problem...

any solutions for this?

|||Just checking if anyone has any luck with this? I spend more time on these forums than i do developing SSRS. Come across issues on a seemingly endless basis.|||Did you check out this link
http://www.eggheadcafe.com/software/aspnet/29672997/back-call-without-drillth.aspx
?
I had two things that was giving me the same problem one was a Ajax update panel around it and the other was because of the bad release of VS2005 SP1. The "Microsoft.ReportViewer.* assemblies" where messing it up so I had to un-install them from my GAC and find the older "File version"
(To find out what file version of the assemblies you have right click and hit properties. Don't look at the Version tab in the windows explore.)

But you don't have to do that now Microsoft came out with new assemblies in and you can download them in a redistributable package.

Read this
http://support.microsoft.com/default.aspx/kb/933137
and download

Thanks!
Andy

nonoandy

Hello,

My users often view some report for some minutes and after that want to return to parent report.
If they did it after small time (~less than minute), everything is OK. But if this pause is above 1 minute they receive "Runtime Error" message and can only to go to homepage.

I think that this is some session time or something like that.
Am I right? How can fix it?

Thank youAfter setting customError=off we receive "Back call without drillthrough report" error|||Did you find a fix for the problem? Can anyone help? I get the same problem.|||

Back call without drillthrough report

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidOperationException: Back call without drillthrough report

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[InvalidOperationException: Back call without drillthrough report] Microsoft.Reporting.WebForms.ReportViewer.Toolbar_Back(Object sender, EventArgs e) +229 Microsoft.Reporting.WebForms.ToolbarControl.OnBack(Object sender, EventArgs e) +25 Microsoft.Reporting.WebForms.BackGroup.BackButton_Click(Object sender, EventArgs e) +40 Microsoft.Reporting.WebForms.ScriptSwitchImage.EnabledImage_Click(Object sender, ImageClickEventArgs e) +25 System.Web.UI.WebControls.ImageButton.OnClick(ImageClickEventArgs e) +105 System.Web.UI.WebControls.ImageButton.RaisePostBackEvent(String eventArgument) +115 System.Web.UI.WebControls.ImageButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102

|||

I am also receiving this error but there is no delay. As soon as the report is loaded, I click back to goto the previous report and I get this error.

It is interesting because charts are also not loading. I dont receive an error message but in the event log this is entered: "The stream cannot be found."

This only happens when I drill-through.

|||

I'm having this issue also. Did anyone ever find a solution? thanks

|||Hey guys I think that this issue has something to do with some other problems I have been having due to SP1. I notice that the back button wasn't the only thing messing up, and it was only doing it in the ReportViewer (not when I went to the report directly in VS)

check out this article
http://www.eggheadcafe.com/software/aspnet/29672997/back-call-without-drillth.aspx

-nonoandy|||

i am also facing this problem...

any solutions for this?

|||Just checking if anyone has any luck with this? I spend more time on these forums than i do developing SSRS. Come across issues on a seemingly endless basis.|||Did you check out this link
http://www.eggheadcafe.com/software/aspnet/29672997/back-call-without-drillth.aspx
?
I had two things that was giving me the same problem one was a Ajax update panel around it and the other was because of the bad release of VS2005 SP1. The "Microsoft.ReportViewer.* assemblies" where messing it up so I had to un-install them from my GAC and find the older "File version"
(To find out what file version of the assemblies you have right click and hit properties. Don't look at the Version tab in the windows explore.)

But you don't have to do that now Microsoft came out with new assemblies in and you can download them in a redistributable package.

Read this
http://support.microsoft.com/default.aspx/kb/933137
and download

Thanks!
Andy

nonoandy

Hello,

My users often view some report for some minutes and after that want to return to parent report.
If they did it after small time (~less than minute), everything is OK. But if this pause is above 1 minute they receive "Runtime Error" message and can only to go to homepage.

I think that this is some session time or something like that.
Am I right? How can fix it?

Thank youAfter setting customError=off we receive "Back call without drillthrough report" error|||Did you find a fix for the problem? Can anyone help? I get the same problem.|||

Back call without drillthrough report

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidOperationException: Back call without drillthrough report

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[InvalidOperationException: Back call without drillthrough report] Microsoft.Reporting.WebForms.ReportViewer.Toolbar_Back(Object sender, EventArgs e) +229 Microsoft.Reporting.WebForms.ToolbarControl.OnBack(Object sender, EventArgs e) +25 Microsoft.Reporting.WebForms.BackGroup.BackButton_Click(Object sender, EventArgs e) +40 Microsoft.Reporting.WebForms.ScriptSwitchImage.EnabledImage_Click(Object sender, ImageClickEventArgs e) +25 System.Web.UI.WebControls.ImageButton.OnClick(ImageClickEventArgs e) +105 System.Web.UI.WebControls.ImageButton.RaisePostBackEvent(String eventArgument) +115 System.Web.UI.WebControls.ImageButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102

|||

I am also receiving this error but there is no delay. As soon as the report is loaded, I click back to goto the previous report and I get this error.

It is interesting because charts are also not loading. I dont receive an error message but in the event log this is entered: "The stream cannot be found."

This only happens when I drill-through.

|||

I'm having this issue also. Did anyone ever find a solution? thanks

|||Hey guys I think that this issue has something to do with some other problems I have been having due to SP1. I notice that the back button wasn't the only thing messing up, and it was only doing it in the ReportViewer (not when I went to the report directly in VS)

check out this article
http://www.eggheadcafe.com/software/aspnet/29672997/back-call-without-drillth.aspx

-nonoandy|||

i am also facing this problem...

any solutions for this?

|||Just checking if anyone has any luck with this? I spend more time on these forums than i do developing SSRS. Come across issues on a seemingly endless basis.|||Did you check out this link
http://www.eggheadcafe.com/software/aspnet/29672997/back-call-without-drillth.aspx
?
I had two things that was giving me the same problem one was a Ajax update panel around it and the other was because of the bad release of VS2005 SP1. The "Microsoft.ReportViewer.* assemblies" where messing it up so I had to un-install them from my GAC and find the older "File version"
(To find out what file version of the assemblies you have right click and hit properties. Don't look at the Version tab in the windows explore.)

But you don't have to do that now Microsoft came out with new assemblies in and you can download them in a redistributable package.

Read this
http://support.microsoft.com/default.aspx/kb/933137
and download

Thanks!
Andy

nonoandy

Hello,

My users often view some report for some minutes and after that want to return to parent report.
If they did it after small time (~less than minute), everything is OK. But if this pause is above 1 minute they receive "Runtime Error" message and can only to go to homepage.

I think that this is some session time or something like that.
Am I right? How can fix it?

Thank youAfter setting customError=off we receive "Back call without drillthrough report" error|||Did you find a fix for the problem? Can anyone help? I get the same problem.|||

Back call without drillthrough report

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidOperationException: Back call without drillthrough report

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[InvalidOperationException: Back call without drillthrough report] Microsoft.Reporting.WebForms.ReportViewer.Toolbar_Back(Object sender, EventArgs e) +229 Microsoft.Reporting.WebForms.ToolbarControl.OnBack(Object sender, EventArgs e) +25 Microsoft.Reporting.WebForms.BackGroup.BackButton_Click(Object sender, EventArgs e) +40 Microsoft.Reporting.WebForms.ScriptSwitchImage.EnabledImage_Click(Object sender, ImageClickEventArgs e) +25 System.Web.UI.WebControls.ImageButton.OnClick(ImageClickEventArgs e) +105 System.Web.UI.WebControls.ImageButton.RaisePostBackEvent(String eventArgument) +115 System.Web.UI.WebControls.ImageButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102

|||

I am also receiving this error but there is no delay. As soon as the report is loaded, I click back to goto the previous report and I get this error.

It is interesting because charts are also not loading. I dont receive an error message but in the event log this is entered: "The stream cannot be found."

This only happens when I drill-through.

|||

I'm having this issue also. Did anyone ever find a solution? thanks

|||Hey guys I think that this issue has something to do with some other problems I have been having due to SP1. I notice that the back button wasn't the only thing messing up, and it was only doing it in the ReportViewer (not when I went to the report directly in VS)

check out this article
http://www.eggheadcafe.com/software/aspnet/29672997/back-call-without-drillth.aspx

-nonoandy|||

i am also facing this problem...

any solutions for this?

|||Just checking if anyone has any luck with this? I spend more time on these forums than i do developing SSRS. Come across issues on a seemingly endless basis.|||Did you check out this link
http://www.eggheadcafe.com/software/aspnet/29672997/back-call-without-drillth.aspx
?
I had two things that was giving me the same problem one was a Ajax update panel around it and the other was because of the bad release of VS2005 SP1. The "Microsoft.ReportViewer.* assemblies" where messing it up so I had to un-install them from my GAC and find the older "File version"
(To find out what file version of the assemblies you have right click and hit properties. Don't look at the Version tab in the windows explore.)

But you don't have to do that now Microsoft came out with new assemblies in and you can download them in a redistributable package.

Read this
http://support.microsoft.com/default.aspx/kb/933137
and download

Thanks!
Andy

non-existent images

Hi,
I have a database that contains student-id's, and I created a report
that shows the student ID along with a fotograph of the student. The
picture is fetched from a website, and is not stored in the database.
Problem:
Not all students have a fotograph. If no picture exists, a red cross is
shown on the output. Can this red cross be eliminated, or can the
picture be hidden when there's an invalid URL for the image source?
Tnx,
E.T.You could create a small 1x1 pixel gif and upload to your server.
THen for the image tag, write an expression like
=IIF(IsNothing(Field!PictureURL.Value), "mysmallgif.gif",
field!PictureURL.Value)
That way you will display the gif if the url is invalid. You'll have to
tweak the code to fit your fields etc, but the concept should work.
Kaisa M. Lindahl Lervik
"Erik Thijs" <ErikdotThijs@.removethis.khkdotbe> wrote in message
news:esytuq38GHA.4964@.TK2MSFTNGP02.phx.gbl...
> Hi,
> I have a database that contains student-id's, and I created a report that
> shows the student ID along with a fotograph of the student. The picture is
> fetched from a website, and is not stored in the database.
> Problem:
> Not all students have a fotograph. If no picture exists, a red cross is
> shown on the output. Can this red cross be eliminated, or can the picture
> be hidden when there's an invalid URL for the image source?
> Tnx,
> E.T.|||Kaisa M. Lindahl Lervik schreef:
> You could create a small 1x1 pixel gif and upload to your server.
> THen for the image tag, write an expression like
> =IIF(IsNothing(Field!PictureURL.Value), "mysmallgif.gif",
> field!PictureURL.Value)
forgot to mention:
The url of the picture is generated in RS, not in the database, based on
the studentID.
For instance, a student has studentID stud0001, then the url for the
image in reporting services becomes:
Image1.Value="http://fotoserver/" & Fields!studentId.Value & ".jpg"
So every student has a picture with a URL value. The question is how to
detect invalid URL's...|||How do you store the images on the server? Do you upload images when you
register the data about your student, or do you have to upload the picture
after you know the StudentID?
If you do it when registering, you might be able to change your db to save
wether or not a picture has been uploaded.
If "studentpicturesaved = true", then Image1.Value = http://fotoserver &
Fields!studentID.Value & ".jpg" else Image1.Value =http://fotoserver.dummypic.gif
Or else you have to access the file server to check if a picture with that
ID is there, which is fussy at best. I'm pretty sure there's no way of
checking if a image source url is valid just before the image is being
rendered on the screen. You have to register if there's a picture in the
database.
Kaisa M. Lindahl Lervik
"Erik Thijs" <ErikdotThijs@.removethis.khkdotbe> wrote in message
news:OTt$zE48GHA.4348@.TK2MSFTNGP03.phx.gbl...
> Kaisa M. Lindahl Lervik schreef:
>> You could create a small 1x1 pixel gif and upload to your server.
>> THen for the image tag, write an expression like
>> =IIF(IsNothing(Field!PictureURL.Value), "mysmallgif.gif",
>> field!PictureURL.Value)
> forgot to mention:
> The url of the picture is generated in RS, not in the database, based on
> the studentID.
> For instance, a student has studentID stud0001, then the url for the image
> in reporting services becomes:
> Image1.Value="http://fotoserver/" & Fields!studentId.Value & ".jpg"
> So every student has a picture with a URL value. The question is how to
> detect invalid URL's...

Non-Admin user can't create a linked report in My Reports...

A Non-Admin user can't create a linked report in his My Reports folder.
Reporting Services is set up with My Reports enabled with the default tasks
assigned to the My Reports role (this includes Create linked reports). This
same user can create sub-folders but not linked reports.
----
aspnet_wp!library!164!10/07/2004-17:42:44:: i INFO: Call to
CreateLinkedReport( '20041007 1742 SimpleReport', '/My
Reports/Submitted/Test', '/Standard Reports/Test/SimpleReport',
'Microsoft.ReportingServices.Library.Soap.Property[]' )
aspnet_wp!library!164!10/07/2004-17:42:44:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The
permissions granted to user 'LABTM\RSFinancialAnalyst' are insufficient for
performing this operation., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The
permissions granted to user 'LABTM\RSFinancialAnalyst' are insufficient for
performing this operation.Does the user have Read Properties permission to the report /Standard
Reports/Test/SimpleReport?
-Lukasz|||I discovered the problem... The Browser Role is not associated with the
"Create linked reports" task by default. Once I assigned the Create linked
reports task to the Browser Role the non-admin user could create linked
reports.
Thanks for the hint Lukasz.
Garry Lenz
"Garry Lenz" <glenz@.thoughtmill.com> wrote in message
news:%231hAadLrEHA.2136@.TK2MSFTNGP14.phx.gbl...
> A Non-Admin user can't create a linked report in his My Reports folder.
> Reporting Services is set up with My Reports enabled with the default
tasks
> assigned to the My Reports role (this includes Create linked reports).
This
> same user can create sub-folders but not linked reports.
> ----
> aspnet_wp!library!164!10/07/2004-17:42:44:: i INFO: Call to
> CreateLinkedReport( '20041007 1742 SimpleReport', '/My
> Reports/Submitted/Test', '/Standard Reports/Test/SimpleReport',
> 'Microsoft.ReportingServices.Library.Soap.Property[]' )
> aspnet_wp!library!164!10/07/2004-17:42:44:: e ERROR: Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException:
The
> permissions granted to user 'LABTM\RSFinancialAnalyst' are insufficient
for
> performing this operation., ;
> Info:
> Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException:
The
> permissions granted to user 'LABTM\RSFinancialAnalyst' are insufficient
for
> performing this operation.
>

no working drilldown in reportViewer, ASP.NET

I have Report A and report B.
Report A has under "navigation->Jump To Report", report B selected from the
list. I also used the parameters button to insert both parameters required
by Report B.
Deploy both reports.
On the catalog (server/reports/<folder>/A), I run the report A and can drill
to report B.
PROBLEM:
When I go to my ASP.NET application, it doesn't;t work. NOTICE I use
reportViewer (report viewer) in my asp.net page to show the report. When I
drill down on report A, the frame of the report seems to be reloading (get
the green thing) but then the same reports appears!
Additional info: I tried adding to my asp.net page code a handler for the
ReportViewer1_Drillthrough(object sender, DrillthroughEventArgs e)
function. But when I put a breakpoint there, it seems I don't even get
there. In any case, all the samples I saw use this function for windows
forms, and then they set the datasource which seems like something I
shouldn't be bothered with.
anyone can help?
regards.I am facing the same problem, if you got the solution pls let me know. Thanx
in advance.
Regards
"csmba" wrote:
> I have Report A and report B.
> Report A has under "navigation->Jump To Report", report B selected from the
> list. I also used the parameters button to insert both parameters required
> by Report B.
> Deploy both reports.
> On the catalog (server/reports/<folder>/A), I run the report A and can drill
> to report B.
> PROBLEM:
> When I go to my ASP.NET application, it doesn't;t work. NOTICE I use
> reportViewer (report viewer) in my asp.net page to show the report. When I
> drill down on report A, the frame of the report seems to be reloading (get
> the green thing) but then the same reports appears!
> Additional info: I tried adding to my asp.net page code a handler for the
> ReportViewer1_Drillthrough(object sender, DrillthroughEventArgs e)
> function. But when I put a breakpoint there, it seems I don't even get
> there. In any case, all the samples I saw use this function for windows
> forms, and then they set the datasource which seems like something I
> shouldn't be bothered with.
> anyone can help?
> regards.
>
>|||We finally got the solution.
Pls check whether the report A is called only once, use postback.
"csmba" wrote:
> I have Report A and report B.
> Report A has under "navigation->Jump To Report", report B selected from the
> list. I also used the parameters button to insert both parameters required
> by Report B.
> Deploy both reports.
> On the catalog (server/reports/<folder>/A), I run the report A and can drill
> to report B.
> PROBLEM:
> When I go to my ASP.NET application, it doesn't;t work. NOTICE I use
> reportViewer (report viewer) in my asp.net page to show the report. When I
> drill down on report A, the frame of the report seems to be reloading (get
> the green thing) but then the same reports appears!
> Additional info: I tried adding to my asp.net page code a handler for the
> ReportViewer1_Drillthrough(object sender, DrillthroughEventArgs e)
> function. But when I put a breakpoint there, it seems I don't even get
> there. In any case, all the samples I saw use this function for windows
> forms, and then they set the datasource which seems like something I
> shouldn't be bothered with.
> anyone can help?
> regards.
>
>

No transparency used by report using PNG Image?

Hi,

I used some transparent png images in my reports, but it seems that they are rendered using a white background.

Why is this?

Best Regards.
Luis Simoes

Luis,

There is a known issue with PNG Transparency in Internet Explorer, which may be what your experiencing. This link may help http://support.microsoft.com/?scid=kb;en-us;265221

Regards,

Kevin

No Summary page in Management Studio

I have installed SQL Server 2005 sp2. Initialy I didn't install Report Services and Analysis Services. I next installed them using change in Add Remove Programs and still no Summary page. HELP!

I have looked for a solution to this longer than any other software search I have done to no avail.

Try to click F7 on SSMS and if no avail then try to install client tools again.|||

I uninstalled and reinstalled everything and it didn't make any difference.

Still no summary page.

I would love to have it available as it is a development server and the reports on summary page would be very usefull especially.

It works great on our other production servers. This server has the latest service packs on windows server 2003 and SQL Server 2005. SP2 is the latest also not the original one reissued 3/5.

|||

in sp2 the summary page has been renamed... it now Object Explorer Details (i don't have sp2 in my home machine... i am not remembering it exactly... ) .. You click on "View " in Top Menu bar and see the option available there

Madhu

|||

Deliquesent wrote:

I have installed SQL Server 2005 sp2 ... and no Summary page. HELP!

In SQL Server 2005 Service Pack 2, we've renamed the "Summary Page" to "Object Explorer Details". The reports no longer display in this page. They are now launched from the object in Object Explorer and open in their own report window. This allows you to open multiple reports at the same time. Thus, you can compare reports on different instances or the same report multiple times to see what has changed over time.

I gave a webcast on SP2 improvements in this area a little while ago. You should check it out:

SP2 Improvements Webcast Blog with Links to Resources:

http://blogs.msdn.com/sqlrem/archive/2007/03/20/Webcast-SP2-improvements-Resources.aspx

SP2 Improvements Webcast:

http://msevents.microsoft.com/cui/WebCastEventDetails.aspx?EventID=1032330864&EventCategory=4&culture=en-US&CountryCode=US

Paul A. Mestemaker II

Program Manager

Microsoft SQL Server Manageability

http://blogs.msdn.com/sqlrem/

|||

Thank you very much!

Now I know.