ReportBuilder & FQDN

Anyone run into this?

ReportBuilder fails to load when using a FQDN (fully qualified domain name) URL.
ie: http://servername.xyz.company.com/Reports/Pages/Folder.aspx

ReportBuilder loads with no issue when using the shortname URL.
ie: http://servername/Reports/Pages/Folder.aspx

details:

ERROR SUMMARY
Below is a summary of the errors, details of these errors are listed later in the log.
* Activation of http://servername.xyz.company.com/ReportServer/ReportBuilder/ReportBuilder.application resulted in exception. Following failure messages were detected:
+ Downloading http://servername.xyz.company.com/ReportServer/ReportBuilder/ReportBuilder.application did not succeed.
+ The remote server returned an error: (403) Forbidden.

COMPONENT STORE TRANSACTION FAILURE SUMMARY
No transaction error was detected.

WARNINGS
There were no warnings during this operation.

Nevermind Figured it out -

Modify RSWebApplication.config for Hard IP.

<ReportServerUrl>http://<Site IP Address>/ReportServer</ReportServerURL>

<ReportServerVirtualDirectory></ReportServerVirtualDirectory>

Works - just recycle the application pools in IIS. By the way if you are configuring the manager for a non-default IP address be carefull. For some reason the report manager does not like a <ReportServerVirtualDirectory> value if <ReportServerURL> is supplied.

Report/subreport help?

How would you run one report that is made out of two reports at the same time to get them dispayed on seperate pages as well.

Would you create a subreport or something else, and how many subreports can you have within a report, and if you had more then one where is the best places to insert it in the report and would you know where can I find some info about that.

I hope all of this makes sense,because I am just completely stuck.

Regards"How would you run one report that is made out of two reports at the same time to get them dispayed on seperate pages as well... and if you had more then one where is the best places to insert it in the report"

- I would create 2 subreports. The best place to put them (I think) would be the details section. Make a Details a and a Details b and set the NewPageAfter for Details a.

"how many subreports can you have within a report"

- I'm not sure what the limit is. I have a report that has 3 subreports without a problem.

"where can I find some info about that."

- Not sure about any specific websites, but you can try a search in following links:

Crystal Reports Help:
http://support.businessobjects.com/search/advsearch.asp

Crystal Reports Forum:
http://support.businessobjects.com/forums/default.asp|||thanks a lot for your help, I got some good suggestions, I just have to make it work now.

Regards

Report/query parameter default values

I am using a SQL stored procedure for a report. The sproc has a variable in it (@.itemnumber) to be supplied by the user at run time. In the report parameters within Visual Studio Designer, I am trying to set a default value for the parameter of % so that all items will be returned unless the user enters a specific item number. In the Visual Studio preview this works but once the report is deployed to the web server, the default value does NOT show up. Please advise.

thanks!

Martha

Hi Martha,

SQL Server 2005 Books Online contains an example that takes you through

exactly what it sounds like you are trying to accomplish. Please

take a look at it at:

SQL Server 2005 Books Online->SQL Server 2005

Tutorials->Reporting Services Tutorials->Using a Dynamic Query in

a Report

It shows you how to build a dynamic query to return all records when no parameter is passed through.

If you have further problems after looking at that, please continue posting.|||

Only problem is that we are still on SQL RS 2000. Have not gone to 2005 as yet. Would the information you refer to work on 2000?

thanks!

|||Well let's try to tackle it a different way. Is your query

dynamic and includes a union with your default value that you want to

show all? For example:

SELECT 0 AS DepartmentID, 'All' AS Name

UNION

SELECT DepartmentID, Name

FROM HumanResources.Department

ORDER BY Name|||No, it's a non-queried default. I'm simply trying to set it to %. The variable is a string (varchar) in the sproc. In the Visual Studio preview it works, just not on the web once deployed.|||

hi,

iam also not able to use the dynamic query in repoting services,in sql server 2005.

i am trying from the following path

SQL Server 2005 Books Online->SQL Server 2005 Tutorials->Reporting Services Tutorials->Using a Dynamic Query in a Report-->Lesson 6: Updating the Employees Dataset with a Dynamic Query

as given in the boks online the following query

="SELECT c.firstname, c.lastname, e.title, d.departmentID " &

"From HumanResources.EmployeeDepartmentHistory D " &

"INNER JOIN HumanResources.Employee E " &

"ON D.EmployeeID = E.EmployeeID " &

"INNER JOIN Person.Contact C " &

"ON E.ContactID = C.ContactID " &

Iif(Parameters!Department.Value = 0, "", "WHERE D.DepartmentID = " & Parameters!Department.Value) &

"ORDER BY C.LastName" but am getting error from the if clause,so how to use the dynamic query for the above so.please do replysekhar|||

I am not worked on dynamic queries but i suggest you can use stored procedures with a parameter. Create a stored procedue and pass your parameter to stored procedure.

Report/query parameter default values

I am using a SQL stored procedure for a report. The sproc has a variable in it (@.itemnumber) to be supplied by the user at run time. In the report parameters within Visual Studio Designer, I am trying to set a default value for the parameter of % so that all items will be returned unless the user enters a specific item number. In the Visual Studio preview this works but once the report is deployed to the web server, the default value does NOT show up. Please advise.

thanks!

Martha

Hi Martha,
SQL Server 2005 Books Online contains an example that takes you through exactly what it sounds like you are trying to accomplish. Please take a look at it at:
SQL Server 2005 Books Online->SQL Server 2005 Tutorials->Reporting Services Tutorials->Using a Dynamic Query in a Report
It shows you how to build a dynamic query to return all records when no parameter is passed through.
If you have further problems after looking at that, please continue posting.
|||

Only problem is that we are still on SQL RS 2000. Have not gone to 2005 as yet. Would the information you refer to work on 2000?

thanks!

|||Well let's try to tackle it a different way. Is your query dynamic and includes a union with your default value that you want to show all? For example:
SELECT 0 AS DepartmentID, 'All' AS Name
UNION
SELECT DepartmentID, Name
FROM HumanResources.Department
ORDER BY Name
|||No, it's a non-queried default. I'm simply trying to set it to %. The variable is a string (varchar) in the sproc. In the Visual Studio preview it works, just not on the web once deployed.|||

hi,

iam also not able to use the dynamic query in repoting services,in sql server 2005.

i am trying from the following path

SQL Server 2005 Books Online->SQL Server 2005 Tutorials->Reporting Services Tutorials->Using a Dynamic Query in a Report-->Lesson 6: Updating the Employees Dataset with a Dynamic Query

as given in the boks online the following query

="SELECT c.firstname, c.lastname, e.title, d.departmentID " & "From HumanResources.EmployeeDepartmentHistory D " & "INNER JOIN HumanResources.Employee E " & "ON D.EmployeeID = E.EmployeeID " & "INNER JOIN Person.Contact C " & "ON E.ContactID = C.ContactID " & Iif(Parameters!Department.Value = 0, "", "WHERE D.DepartmentID = " & Parameters!Department.Value) & "ORDER BY C.LastName" but am getting error from the if clause,so how to use the dynamic query for the above so.please do replysekhar|||

I am not worked on dynamic queries but i suggest you can use stored procedures with a parameter. Create a stored procedue and pass your parameter to stored procedure.

Report/query parameter default values

I am using a SQL stored procedure for a report. The sproc has a variable in it (@.itemnumber) to be supplied by the user at run time. In the report parameters within Visual Studio Designer, I am trying to set a default value for the parameter of % so that all items will be returned unless the user enters a specific item number. In the Visual Studio preview this works but once the report is deployed to the web server, the default value does NOT show up. Please advise.

thanks!

Martha

Hi Martha,

SQL Server 2005 Books Online contains an example that takes you through

exactly what it sounds like you are trying to accomplish. Please

take a look at it at:

SQL Server 2005 Books Online->SQL Server 2005

Tutorials->Reporting Services Tutorials->Using a Dynamic Query in

a Report

It shows you how to build a dynamic query to return all records when no parameter is passed through.

If you have further problems after looking at that, please continue posting.|||

Only problem is that we are still on SQL RS 2000. Have not gone to 2005 as yet. Would the information you refer to work on 2000?

thanks!

|||Well let's try to tackle it a different way. Is your query

dynamic and includes a union with your default value that you want to

show all? For example:

SELECT 0 AS DepartmentID, 'All' AS Name

UNION

SELECT DepartmentID, Name

FROM HumanResources.Department

ORDER BY Name|||No, it's a non-queried default. I'm simply trying to set it to %. The variable is a string (varchar) in the sproc. In the Visual Studio preview it works, just not on the web once deployed.|||

hi,

iam also not able to use the dynamic query in repoting services,in sql server 2005.

i am trying from the following path

SQL Server 2005 Books Online->SQL Server 2005 Tutorials->Reporting Services Tutorials->Using a Dynamic Query in a Report-->Lesson 6: Updating the Employees Dataset with a Dynamic Query

as given in the boks online the following query

="SELECT c.firstname, c.lastname, e.title, d.departmentID " &

"From HumanResources.EmployeeDepartmentHistory D " &

"INNER JOIN HumanResources.Employee E " &

"ON D.EmployeeID = E.EmployeeID " &

"INNER JOIN Person.Contact C " &

"ON E.ContactID = C.ContactID " &

Iif(Parameters!Department.Value = 0, "", "WHERE D.DepartmentID = " & Parameters!Department.Value) &

"ORDER BY C.LastName" but am getting error from the if clause,so how to use the dynamic query for the above so.please do replysekhar|||

I am not worked on dynamic queries but i suggest you can use stored procedures with a parameter. Create a stored procedue and pass your parameter to stored procedure.

report works in VS2003, but not in IE

I have a dirt-simple report that will render perfectly in the IDE, but when
it is deployed and run in the browser, I get the following error:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. (rrRenderingError) Get Online Help
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown.
Index was out of range. Must be non-negative and less than the size of the
collection. Parameter name: index
The report consists of a single textbox and two Line objects. The textbox
receives its value from a query that returns a single field. I have applied
the SSRS SP1.
Other reports work fine. For some reason this simple one fails. Why? I
can post the RDL upon request.Do you have any expressions in your report?
Andy Potter|||"Potter" wrote:
> Do you have any expressions in your report?
> Andy Potter
No, here's the only report item:
<ReportItems>
<Textbox Name="Notes">
<Style>
<PaddingLeft>0in</PaddingLeft>
<BorderColor>
<Default>#000000</Default>
</BorderColor>
<BorderStyle>
<Default>Dashed</Default>
</BorderStyle>
<FontSize>8pt</FontSize>
<LineHeight>13pt</LineHeight>
<Color>#000000</Color>
<PaddingBottom>0in</PaddingBottom>
<PaddingTop>0in</PaddingTop>
<PaddingRight>0in</PaddingRight>
</Style>
<Height>0.2083in</Height>
<Width>10in</Width>
<CanGrow>true</CanGrow>
<CanShrink>true</CanShrink>
<Value>=Fields!RSNotes.Value</Value>
</Textbox>
</ReportItems>
---
The field does need to wrap to multiple lines to display the "RSNotes" text
from the db. The above XML is nested inside <List></List> tags, which is the
only thing inside the Body tags.|||Any parameters or calculated fields?|||"Potter" wrote:
> Any parameters or calculated fields?
No calculated fields. There is one report parameter, "nRecordID", which is
used in the TSQL query as "...where RecordID = @.nRecordID"|||Unusual. Most of the references to this error revolve around exporting
to Excel. While the SP2 readme doesn't identify this as a resolved
issue, it might be worth bumping up to the move recent service pack.
Andy POtter|||"Potter" wrote:
> Unusual. Most of the references to this error revolve around exporting
> to Excel. While the SP2 readme doesn't identify this as a resolved
> issue, it might be worth bumping up to the move recent service pack.
I should have corrected my first post to state we are using SSRS2K SP2. It
is strange that this simplest report fails where much more complex ones are
OK. The report was imported from an Access2000 .mdb file. I will try
recreating it from scratch to see what happens. If all else fails I'll
install a trial of SSRS 05 on a different server and try it there.|||I've been able to reproduce the error. Starting from an empty report, the
body would deploy and print OK. When I added the pageheader from the
imported report, I got the "index out of range" error. Here is the
pageheader that was generated by the "Import report from Access" function:
<PageHeader>
<ReportItems>
<Line Name="Line8">
<Width>0in</Width>
<Style>
<BorderWidth>
<Default>2pt</Default>
</BorderWidth>
<BorderColor>
<Default>#000000</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Line>
</ReportItems>
<PrintOnLastPage>true</PrintOnLastPage>
<PrintOnFirstPage>true</PrintOnFirstPage>
<Style>
<BackgroundColor>#ffffff</BackgroundColor>
</Style>
<Height>0in</Height>
</PageHeader>
With this pageheader removed, the report works. It would seem the import
code does not always produce valid reports, even though the pageheader does
render without error in the IDE.sql

Report works byitself, but not in a SubReport

Hi All,
I am trying to run a report which has no parameters. it works fine in
design and even on the report server. but as soon as i put it in a
subreport it gives an error
"Error: SubReport could not be shown"
i have tried almost all of the help available on these group, i have
put the report to be of the same size, removed all the parameters(so
there are no parameters).
will highly appreciate any valuable suggestions.
:-)hi,
theboulevardguy1@.gmail.com wrote:
> "Error: SubReport could not be shown"
This is not an Access or VBA error. So take a look at the report events
(On Load, On Open). There must be some piece of code throwing that
exception.
mfG
--> stefan <--|||I presume you are getting the error in the VS designer. Is the calling
report is in the same project as the subreport?
Also you posted this to reporting services group and access. They are
quite different reports. I am assuming this is a reporting services
report.
theboulevardg...@.gmail.com wrote:
> Hi All,
> I am trying to run a report which has no parameters. it works fine in
> design and even on the report server. but as soon as i put it in a
> subreport it gives an error
> "Error: SubReport could not be shown"
> i have tried almost all of the help available on these group, i have
> put the report to be of the same size, removed all the parameters(so
> there are no parameters).
> will highly appreciate any valuable suggestions.
> :-)

Report won;t run with new paramters

I have a report that works just fine and has for some time. I had to make a
change and added a new parameter to the stored procedure. I updated the
report and republished it. It sees the parameter but doesn't seem to be
using it. I even ran SQL Profiler and it definitely is not calling the
stored procedure with the new parameter. I checked the RDL and it does know
about the parameter. I am just confused.
Stacey LevineTry deleting the report from the report server and redeploying it.
Andy Potter|||That did not work.. but..here is what I had to do to fix it. I had to go to
the data tab in visual studio and run the data set (stored procedure) and
enter the new parameters. Then I rebuilt and redeployed and it started
working. Not sure why.. but this did it.
Thanks.
Stacey
"Potter" <drewpotter@.gmail.com> wrote in message
news:1136925208.341658.254200@.g44g2000cwa.googlegroups.com...
> Try deleting the report from the report server and redeploying it.
> Andy Potter
>|||If you add a parameter to a database object, you must either refresh or
execute the dataset in order for the MSRS to know about the new
parameter. This forces RS to execute its GetParameters() method for
the command. This parameter will then be listed on the Parameters tab
of the dataset (and similarly, in the RDL). The GetParameters() is not
called when you Preview the report.
The alternative is to manually enter the new parameter on the Parameter
tab of the dataset.
Andy Potter

Report with parameter and Windows Application

Hi,
I've created a report with parameter, namely user should enter three
parameter and then run the user.
From a window application I would like to launch (call) an existing report,
already depoloyed in the SQL Reporting Server, and pass the three parameter
according to the user's input. Can anybody help me'
ThanksToday you have two choices, URL integration or web services. With URL
integration you embed the IE browser control, assemble the appropriate URL.
With web services your app uses SOAP to get the rendered report (which still
needs to be shown, either html (browser control again) or pdf). Next version
will have a winform control that will make this much easier (late summer
hopefully).
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Siu" <Siu@.discussions.microsoft.com> wrote in message
news:BF7CD367-3353-4AA9-9C56-A5A6E2411638@.microsoft.com...
> Hi,
> I've created a report with parameter, namely user should enter three
> parameter and then run the user.
> From a window application I would like to launch (call) an existing
report,
> already depoloyed in the SQL Reporting Server, and pass the three
parameter
> according to the user's input. Can anybody help me'
> Thanks|||I'm interested in URL integration: how should I write the url in order to
pass the parameter?
Thanks :)
"Bruce L-C [MVP]" wrote:
> Today you have two choices, URL integration or web services. With URL
> integration you embed the IE browser control, assemble the appropriate URL.
> With web services your app uses SOAP to get the rendered report (which still
> needs to be shown, either html (browser control again) or pdf). Next version
> will have a winform control that will make this much easier (late summer
> hopefully).
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Siu" <Siu@.discussions.microsoft.com> wrote in message
> news:BF7CD367-3353-4AA9-9C56-A5A6E2411638@.microsoft.com...
> > Hi,
> > I've created a report with parameter, namely user should enter three
> > parameter and then run the user.
> >
> > From a window application I would like to launch (call) an existing
> report,
> > already depoloyed in the SQL Reporting Server, and pass the three
> parameter
> > according to the user's input. Can anybody help me'
> >
> > Thanks
>
>

Report window opens, remains blank

I am trying to open reports through an existing application. When I click the button to run the report, the new window opens, appears to be trying to load (the windows logo in the top corner is flowing, the hourglass is present), and then stops. I am left with a blank window, no report, and no error message.

I am able to view and run the reports through the Report Server. Other users are able to run the reports through the application.

Any ideas?

Thanks,

Michelle

I found a solution. I had Adobe Reader 6.0 installed (still not sure why it wasn't working with that). I uninstalled this and installed the latest version of Adobe Reader (8.1), and it worked.

Report window opens, remains blank

I am trying to open reports through an existing application. When I click the button to run the report, the new window opens, appears to be trying to load (the windows logo in the top corner is flowing, the hourglass is present), and then stops. I am left with a blank window, no report, and no error message.

I am able to view and run the reports through the Report Server. Other users are able to run the reports through the application.

Any ideas?

Thanks,

Michelle

I found a solution. I had Adobe Reader 6.0 installed (still not sure why it wasn't working with that). I uninstalled this and installed the latest version of Adobe Reader (8.1), and it worked.sql

Report window and 2-up labels

When I run a multi-column report like labels, the preview does not look like
the labels actually print. Is there a method/property or something that can
make the preview look similar to the actual printed output when printing a
multi-column report? Thanks.
DavidOn Nov 16, 9:47 am, "David C" <dlch...@.lifetimeinc.com> wrote:
> When I run a multi-column report like labels, the preview does not look like
> the labels actually print. Is there a method/property or something that can
> make the preview look similar to the actual printed output when printing a
> multi-column report? Thanks.
> David
I'm not sure if this will help; however, you could try placing the
controls that are being used into a single rectangle control or adjust
your column spacing (by right-clicking Column 2 and select
Properties). Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||On Nov 16, 10:47 am, "David C" <dlch...@.lifetimeinc.com> wrote:
> When I run a multi-column report like labels, the preview does not look like
> the labels actually print. Is there a method/property or something that can
> make the preview look similar to the actual printed output when printing a
> multi-column report? Thanks.
> David
David,
I don't think there's a way to get Preview to look like the printed
output straight-a-way as what you're seeing in preview is the HTML
rendering of the xml code. However, once you're in Preview you can
click on the Print Layout button (right next to the Print button) to
give you a rendering of the page as it will print. Once you change to
this view, it'll stay that way as you flip back and forth from Preview
to Layout.
HTH
toolman

Report Viewer Toolbar Style messed up

Hi All,
When I run a report from Report Manager or from a URL using the ReportViewer
the toolbar looses all styling - it runs down over several lines. I am using
RS 2005 and have also got a RS2000 set-up where we don't have this problem. I
have tried to put in the reference to the stylesheet in the URL access but it
hasn't done anything. Anyone know what the problem could be here? Everything
else in RS2005 works fine.
I also have a problem with Dundas Charts. When accessing the reports via a
URL the charts display if I put in &rc:Toolbar=True but if I put
&rc:Toolbar=False then the Charts don't display and I get a box with a red
cross in it. On the report there are also some tables of data and these
display in both cases.
Any answers to the above much appreciated!
Thanks
RichardHi Richard -
Did you ever get this sorted out? I'm having the same problem, too. I do
have a feeling this is a Win2K3 issue, but just want to guidance as to what
it could be.
Microsoft dudes -- any ideas here?
Thanks,
Brent
"Richard" wrote:
> Hi All,
> When I run a report from Report Manager or from a URL using the ReportViewer
> the toolbar looses all styling - it runs down over several lines. I am using
> RS 2005 and have also got a RS2000 set-up where we don't have this problem. I
> have tried to put in the reference to the stylesheet in the URL access but it
> hasn't done anything. Anyone know what the problem could be here? Everything
> else in RS2005 works fine.
> I also have a problem with Dundas Charts. When accessing the reports via a
> URL the charts display if I put in &rc:Toolbar=True but if I put
> &rc:Toolbar=False then the Charts don't display and I get a box with a red
> cross in it. On the report there are also some tables of data and these
> display in both cases.
> Any answers to the above much appreciated!
> Thanks
> Richardsql

Report Viewer is printing a cached report

Hi All

I have a reporting viewer in a windows form that behaves very strange. When I open the form and run the report it shows up nicely in the report viewer. If I print the report it only prints one page. When i print the report a second time the whole report is printed. Next I'll change the report parameters and run the report, then it shows up nicely in the viewer, but when I print the report the first report is printed.

Does anyone know what to do with this problem?

Thanks in advance

I did some additional testing and the problem appears when im using a stored procedure with a parameter. Even if the parameter is changed and the correct result is displayed the old data is used when the report is printed.

Does anyone know why and where the data is cached?

|||Did you manage to solve this problem? I am having the same issue.
|||do you have repors set to cache in the report manager?|||No, all reports have the setting, Do Not cache temporary copies of this report.

Report Viewer is printing a cached report

Hi All

I have a reporting viewer in a windows form that behaves very strange. When I open the form and run the report it shows up nicely in the report viewer. If I print the report it only prints one page. When i print the report a second time the whole report is printed. Next I'll change the report parameters and run the report, then it shows up nicely in the viewer, but when I print the report the first report is printed.

Does anyone know what to do with this problem?

Thanks in advance

I did some additional testing and the problem appears when im using a stored procedure with a parameter. Even if the parameter is changed and the correct result is displayed the old data is used when the report is printed.

Does anyone know why and where the data is cached?

|||Did you manage to solve this problem? I am having the same issue.|||do you have repors set to cache in the report manager?|||No, all reports have the setting, Do Not cache temporary copies of this report.sql

Report Viewer Help

I need help in Reportviewer report. When i Run my report it pulls up all the information in the database but I want to show data by Month on each page. Does anyone know how to do this?

For example.

Jan 2007 , TOOLS, INFO, NUMBER

Feb 2007, TOOLS, INFO, NUMBER

JAN 2006, TOLLS, INFO, NUMBER

so this is from database now wat i want to do is i want to have each page with diffrent Year so page 1 will have JAn 2007 and FEB 2007 and the next page will have Jan 2006 then i want to sort it by Month on thos each page so i can export data for only that month. I need someone's help. I am not familar with report viewer

Anyone who knows how to do can you please respond. Thanks

You need help on the actual creation of the report. Try this link that has tutorials on creating reports. I think it will have what you are looking for:

http://msdn2.microsoft.com/en-us/library/ms170246.aspx

Report Viewer dlls on web server

I need to get the report viewer files onto my production web box. I know I can run the report view install to get the files registered in the GAL. Unfortunately running an install on a 'productionalized' box will be a big to do for the administrators in my company. Can this issue be resolved simply by copying out the files to the bin directory of the site in question? Are there any pro/cons to doing it this way (other than I'd have to do this for every site that needs reporting).

thanks,

MP

Keep the dlls local to your project by putting them in the bin folder. This should not have any negative effects. I have a report app accessing the dlls way. Cheers!

Report Viewer Control in Local Mode ?

I run my reports in local mode and do something like this :

Code Snippet

//Local Processing mode for Reports

reportViewer.ProcessingMode = ProcessingMode.Local;

// Set RDL file based on handout/grid selected

if (gridRadioButton.Checked)

{

reportViewer.LocalReport.ReportPath = "Grid.rdlc";

}

else

{

//Handout

reportViewer.LocalReport.ReportPath = "Handout.rdlc";

}

//Refresh the report in order to show it to the user.

reportViewer.RefreshReport();

The problem is that both handout and grid is diiferent, Say User Selects the grid once it always shows the grid report. Even second time you change to handout still it shows the same Grid format and I debugged it and it picks the new report path but doesn't help? The application needs to be rerun to fix it.

Can anyone explain what is causing this and how to get rid of it.

Thanks,

Harsimrat

There are a couple of things you need to do:

1) I assume that the user can move back and forth between the reports at will? Not just change once? Therefore you should be checking to see if the user has actually *changed* before doing the appropriate reinitialization (IOW, do a comparison between current and new values)...

2) Reinitialization looks something like this:

Use the ReportViewer.Reset() method -- this is probably the bit you are missing Set the appropriate ReportPath, assuming these are not embedded resources, otherwise you want to set that Rebind the datasources -- this may or may not be required|||I tried adding Reset() and then it tells me cannot find the dataset. But without Reset() it runs fine. I think I need to rebind it somehow as my initial binding is done automatically. If you can please give an code example ?|||

Um, I did say you probably needed to re-bind... I think...

I would forget about the "automatically" bound altogether if you are switching between reports. But this is one of the reasons I told you to check to see whether they had actually *switched* reports -- because you don't want to do the reset and rebind if they have chosen the same report twice in a row. Does that make sense?

I will show you a code example in two parts. The first part shows you where I am actually refreshing the data, previous to changing the report. In my case the procedures for doing so are different depending on whether the source is a local XML file or from a data server --

I will pseudo code some parts of it that are not relevant to you... but this happens to be the reason why I need to switch reports in this particular form.... it doesn't matter that your reason is different, as it will still give you the idea of what you need to do, even in cases (like mine) that the datasets might be entirely different.

Code Snippet

If tsSourceIsServerInfo Then
Me.GetDataSetFromServer()
If [...] the last time they used a different report Then

Me.ReinitializeViewer(tThisReportName)
Else
Me.ReportViewer1.Visible = True ' it might not have been previously
End If
Else
Me.DataSet1.Reset()
Me.DataSet1.ReadXml(tsSource)
If [...] the last time they used a different report as above Then

Me.ReinitializeViewer(tThisReportName)
Else
Me.ReportViewer1.Visible = True
End If
End If

' carry on with initializing params here, then

Me.ReportViewer1.RefreshReport()

OK so far?

You see that the re-initialization is only done where necessary. Now for what happens inside the initialization:

Code Snippet

Private Sub ReinitializeViewer(ByVal tsReport As String)
Dim ReportDataSourceX = _

New Microsoft.Reporting.WinForms.ReportDataSource()
Me.ReportViewer1.Reset()
Me.ReportViewer1.LocalReport.ReportEmbeddedResource = tsReport

' change above line to

' Me.ReportViewer1.LocalReport.ReportPath = tsReport

' if not embedded

If tsReport is a certain report Then

ReportDataSourceX.Name = "Appropriate name for the data set for it"
ReportDataSourceX.Value = Me.BindingSourceDatabase
Else
ReportDataSourceX.Name = "Appropriate name here"
ReportDataSourceX.Value = Me.BindingSourceXML
End If

Me.ReportViewer1.LocalReport.DataSources.Add(ReportDataSourceX)
Me.ReportViewer1.Visible = True

End Sub

HTH,

>L<

Report Viewer and FireFox 1.0

I have a report and added the RS report viewer as a control. when I run the
Asp.net pasge I created in IE 6.0 I have no problem seeing the report,
However When using Firefox, the RS report viewer control looks way
distorted!! Is anyone aware of this problem or am I doing anything wrong.
Most of ower clients use IE, few are using Firefox. i want the .net p[asge
to be cross browser especially when using the Report Viewr control.
Thanks
--
Message posted via http://www.sqlmonster.comAm also running V1.0 and the rendered report that usually shows as a
complete page in IE6 is in a small area about a half-inch high and very
"squashed" - definitely useless...
Firefox also asked me to login to RS twice before it would show the report -
no such login needed with IE.
Stick with IE6 for now...
"James Woo via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:a4b7b466d7fe4ecb9ece2d90a786f5d4@.SQLMonster.com...
> I have a report and added the RS report viewer as a control. when I run
the
> Asp.net pasge I created in IE 6.0 I have no problem seeing the report,
> However When using Firefox, the RS report viewer control looks way
> distorted!! Is anyone aware of this problem or am I doing anything wrong.
> Most of ower clients use IE, few are using Firefox. i want the .net p[asge
> to be cross browser especially when using the Report Viewr control.
> Thanks
> --
> Message posted via http://www.sqlmonster.com|||Fully agree, except when you diploy at client site, you have no control
over the browser they use. And I know for a fact, some will use Firefox
1.0. I have read about a lot of flaws and attacks already in the Fire fox
space. Programming for IE is much more permissive, Fire Fox is so "Anal" so-
to-speak ( could not find a better word to discribe it :) ).
--
Message posted via http://www.sqlmonster.com|||We're in the same situation and are looking at fixes. I don't think any
of us will get the Report Manager app working outside of IE - MS coded
it and that is the way it is!
One semi workaround we've found that I've not seen any postings on is an
export type for more compatible html that by default is not visible. In
the file:
\..\Reporting Services\ReportServer\RSReportServer.config
Find the section on <Render> and:
Extension Name="HTML3.2"
Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.Html32RenderingExtension,Microsoft.ReportingServices.HtmlRendering"
Visible="false"/>
Change Viable="false" to "true"
Since Firefox doesn't open the new browser window from the Export in RS
run the report in IE and then go to the Export drop down and select "web
page for most browsers" which should now be visable. You'll get a new
browser window with a html3.2 rendered report. Copy/paste the very long
url into Firefox and the report looks nearly as good. From that url you
can see how to built other static links to your reports that Firefox can
display. You do loose pagination provided by the IE renderer and if you
want more than static links to your reports you'll have to roll your own
interface to build the url with parameters, report names, etc.....but
it is possible.
David
James Woo via SQLMonster.com wrote:
> I have a report and added the RS report viewer as a control. when I run the
> Asp.net pasge I created in IE 6.0 I have no problem seeing the report,
> However When using Firefox, the RS report viewer control looks way
> distorted!! Is anyone aware of this problem or am I doing anything wrong.
> Most of ower clients use IE, few are using Firefox. i want the .net p[asge
> to be cross browser especially when using the Report Viewr control.
> Thanks
>|||I've posted on this topic already if you want feel inclined to search
for it, if not, the gist of it is that it doesn't even work on IE for
Macs. I've tested a few browsers and it's just a complete no go at the
moment.
Chris
DT Grayston wrote:
> We're in the same situation and are looking at fixes. I don't think
> any of us will get the Report Manager app working outside of IE - MS
> coded it and that is the way it is!
> One semi workaround we've found that I've not seen any postings on is
> an export type for more compatible html that by default is not
> visible. In the file:
> \..\Reporting Services\ReportServer\RSReportServer.config
> Find the section on <Render> and:
> Extension Name="HTML3.2"
> Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.Html32Renderi
> ngExtension,Microsoft.ReportingServices.HtmlRendering"
> Visible="false"/>
> Change Viable="false" to "true"
> Since Firefox doesn't open the new browser window from the Export in
> RS run the report in IE and then go to the Export drop down and
> select "web page for most browsers" which should now be visable.
> You'll get a new browser window with a html3.2 rendered report.
> Copy/paste the very long url into Firefox and the report looks nearly
> as good. From that url you can see how to built other static links
> to your reports that Firefox can display. You do loose pagination
> provided by the IE renderer and if you want more than static links to
> your reports you'll have to roll your own interface to build the url
> with parameters, report names, etc.....but it is possible.
> David
> James Woo via SQLMonster.com wrote:
> > I have a report and added the RS report viewer as a control. when I
> > run the Asp.net pasge I created in IE 6.0 I have no problem seeing
> > the report, However When using Firefox, the RS report viewer
> > control looks way distorted!! Is anyone aware of this problem or am
> > I doing anything wrong. Most of ower clients use IE, few are using
> > Firefox. i want the .net p[asge to be cross browser especially when
> > using the Report Viewr control. Thanks
> >

Report Viewer - tell it not to run until parameters are entered

I have this reportviewer control in an asp.net page -
I've added a parameter of startdate
How do I change the properties of the ReportViewer control so that it waits
for the date input, and doesn't try to run when the page is loaded?
I keep getting this error when running the page:
a.. The property 'DefaultValue' of report parameter 'StartDate' doesn't
have the expected type.On Jan 18, 12:05 pm, "Elmo Watson" <s...@.here.com> wrote:
> I have this reportviewer control in an asp.net page -
> I've added a parameter of startdate
> How do I change the properties of the ReportViewer control so that it waits
> for the date input, and doesn't try to run when the page is loaded?
> I keep getting this error when running the page:
> a.. The property 'DefaultValue' of report parameter 'StartDate' doesn't
> have the expected type.
The easiest way to control the automatic running of the report is to
modify the SSRS report itself to not have a default value (set Default
Values to Null) for the startdate parameter. This should follow
through to the report viewer control. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultantsql