Report Builder - Table Triangles

When building a table in report builder from related entities, there appear two small upside-down moveable triangle flags above the column headers. Moving these flags seem to affect the automatic grouping and automatic joins of the table.

Does anyone know what this feature is called? I mean, it cannot really be referred to as "those triangle things." I've searched and cannot find any reference to it. Also, does anyone know how to really use this feature?

Thanks

These sliders control the equivalent of the "Freeze Panes" feature in Microsoft Excel. They should not affect the grouping structure of the table or the underlying query.

report as side by side records display

I want to generate a report for information related to different libraries. It is required to print two library information (two records) side by side in a page. I do not know how to do so.like

libraray name: abc libraray name: abc
address: abc address:abc
phone:30 phone:abc

best regards
kashifIf there is a link between these table, then u can use linking concept and retrieve data from any of the tables.

If not, try to look at the sub reports concept. May be helpful to you.

Report and other controls not rendered

After resolving all the installation and configuration related issues, I was able to deploy a couple of projects on my report server. I can see alll folders and reports listed inside the folders from http://<servername>/reports . All works fine except when I run a report, the http://<servername>/Reports/Pages/Report.aspx page does not render report.

This page displays View, Properties, History Subscriptions etc, menu items on the top section of the page. It also displays Home, My Subscriptions, Site Settings, Help etc. links on top right corner of the page. I can also see the bar that has "New subscription" button. But the problem starts from the section below that. It does NOT display the Report navigation bottons (like First page button, Next Page button, previous page button, Last page button, print button etc.) Appears that the icons images for these bottons are missing. And above all, the page does not render report.

IE browser status indicate the following error:

error:'HoevrImagectl161_ctl01_ctl01_ctl06_ctl01' is null or not an object.

The report renders fine via http://<servername>/ReportServer/Pages/ReportViewer.aspx

I may not have explained the problem well here however, if you are interested, I can email you the screenshot of Report.aspx to help you understand the problem.

Any help is appreciated!!!

It seems you are using MOSS. Are you you have installed Sharepoint addon for Reporting Services found at http://www.microsoft.com/downloads/details.aspx?familyid=1E53F882-0C16-4847-B331-132274AE8C84&displaylang=en

If you have. Have tou configured the reporting services in central admin - Application Settings?

If you have make sure in VS2005 you have deployed to the correct MOSS site collection and correct MOSS library and that is where you view your reports.

In MOSS the reports should render using RSViewerPage.aspx

Thanks
|||

Thanks for reply.

No. I am not running MOSS on this machine. Any other thought?

|||

I just uploaded the screenprint at :

http://i205.photobucket.com/albums/bb8/spnet/ReportSerrverProblem.jpg

P.s. : I have deliberately masked out the server name and parameter value.

|||

Pls help!! Any ideas?

|||

Woohhaaa!!!!!!!!! Figured that out.

It was a javascript error - "RSController.

Make sure your Reports website has the following seeting:

Right click "Reports" website on IIS manager

Go to Properties

Click on Virtual Directory tab

Click on Configuration button

In "wildcard Application Maps.." section, you should have the latest version of aspnet_isapi.dll file listed. If not listed, insert the file. Usually, the file is located at C:\Windows\Microsft.NET\Framework\<your version folder>\aspnet_isapi.dll

Now, click on "Edit" button. Make sure "Verify that File exixts" checkbox is UNCHECKED.

Click "ok" and exit out of Report properties dialogue box. Your reports should work now without IIS throwing any RSController or PramasCtl, imagehower etc. related errors.

Also visit:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=327473&SiteID=1

thank you all!!

Report and other controls not rendered

After resolving all the installation and configuration related issues, I was able to deploy a couple of projects on my report server. I can see alll folders and reports listed inside the folders from http://<servername>/reports . All works fine except when I run a report, the http://<servername>/Reports/Pages/Report.aspx page does not render report.

This page displays View, Properties, History Subscriptions etc, menu items on the top section of the page. It also displays Home, My Subscriptions, Site Settings, Help etc. links on top right corner of the page. I can also see the bar that has "New subscription" button. But the problem starts from the section below that. It does NOT display the Report navigation bottons (like First page button, Next Page button, previous page button, Last page button, print button etc.) Appears that the icons images for these bottons are missing. And above all, the page does not render report.

IE browser status indicate the following error:

error:'HoevrImagectl161_ctl01_ctl01_ctl06_ctl01' is null or not an object.

The report renders fine via http://<servername>/ReportServer/Pages/ReportViewer.aspx

I may not have explained the problem well here however, if you are interested, I can email you the screenshot of Report.aspx to help you understand the problem.

Any help is appreciated!!!

It seems you are using MOSS. Are you you have installed Sharepoint addon for Reporting Services found at http://www.microsoft.com/downloads/details.aspx?familyid=1E53F882-0C16-4847-B331-132274AE8C84&displaylang=en

If you have. Have tou configured the reporting services in central admin - Application Settings?

If you have make sure in VS2005 you have deployed to the correct MOSS site collection and correct MOSS library and that is where you view your reports.

In MOSS the reports should render using RSViewerPage.aspx

Thanks
|||

Thanks for reply.

No. I am not running MOSS on this machine. Any other thought?

|||

I just uploaded the screenprint at :

http://i205.photobucket.com/albums/bb8/spnet/ReportSerrverProblem.jpg

P.s. : I have deliberately masked out the server name and parameter value.

|||

Pls help!! Any ideas?

|||

Woohhaaa!!!!!!!!! Figured that out.

It was a javascript error - "RSController.

Make sure your Reports website has the following seeting:

Right click "Reports" website on IIS manager

Go to Properties

Click on Virtual Directory tab

Click on Configuration button

In "wildcard Application Maps.." section, you should have the latest version of aspnet_isapi.dll file listed. If not listed, insert the file. Usually, the file is located at C:\Windows\Microsft.NET\Framework\<your version folder>\aspnet_isapi.dll

Now, click on "Edit" button. Make sure "Verify that File exixts" checkbox is UNCHECKED.

Click "ok" and exit out of Report properties dialogue box. Your reports should work now without IIS throwing any RSController or PramasCtl, imagehower etc. related errors.

Also visit:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=327473&SiteID=1

thank you all!!