Posts Topics Forums Images
Search videos from message boards Videos Search messages from microblogs Microblogs Search messages from imdb.com Imdb Search messages from yuku.com Yuku Search messages from lefora.com (free forums) Lefora
My account: Login | Sign Up
Loading... 

SQL Server Reporting Services | Forum profile

Forum profile page for SQL Server Reporting Services on http://social.technet.microsoft.com. This report page is the aggregated overview from a single forum: SQL Server Reporting Services, located on the Message Board at http://social.technet.microsoft.com. This forum profile page summarizes the general forum statistics such as: Users Activity, Forum Activity, and Top Authors, which are reported in either a table or graph below for a given reporting time period. Additional forum profile information for "SQL Server Reporting Services" on the Message Board at http://social.technet.microsoft.com is also shown in the following ways:

1) Latest Active Threads
2) Hot Threads for Last Week

Warning: These statistics are generated using 'best efforts' and can experience delays and reporting errors at times. Please note that such statistics do not constitute a forum's popularity and/or exact posting volumes at any given reporting period.

Site: Microsoft TechNet Forums - SQL Server Reporting Services (site profile, domain info microsoft.com)
Title: SQL Server Reporting Services
Url: http://social.technet.microsoft.com/Forums/en-U...
Users activity: 2 posts per thread
Forum activity: 677 active threads during last week
 

Posting activity on SQL Server Reporting Services:

  Week Month 3 Months
Threads: 677 2,223 3,847
Post: 1,054 3,654 7,639
 

SQL Server Reporting Services Posting activity graph:

Posts by:  day  week  month 

Top authors during last week:

Name
Posts
Jerry Nee
72
user's latest post:
Cannot access report server web...
Published (2009-12-03 23:08:00)
Hi, What's the URL you are using?  Here is the article http://technet.microsoft.com/en-us/library/ms155398.aspx  about report server web service endpoints. Hope this help, thanks, Jerry
Jin Chen
64
user's latest post:
Repeat the images in body on...
Published (2009-12-03 08:09:00)
Hi Darshan, Every image control has a property "RepeatWith", we can use this property to show image on each page. In this case, since we have many tables, we can put some images control on the report. Each image control repeat with each table, and overlap image control. Now, the left and right image will repeat on each page. Please follow these steps: 1.If we have 5 tables on the report, we need to put 5 image controls on...
Yao-Jie Tang - MSFT
46
user's latest post:
Reporting Services + Javascript...
Published (2009-12-03 10:25:00)
Hi, I'm sure we can use window.open in the report. If you failed, maybe this problem is caused by the limitaion of SharePoint. Since I'm not familiar with the SharePoint, please try to post questions there. Here is the link: http://social.technet.microsoft.com/Forums/en-US/category/sharepoint2010,sharepoint Thanks.
Isham H
28
user's latest post:
How to print a report with...
Published (2009-12-03 16:12:00)
Ohh, sorry. I thought I had it. Try to isolate bit by bit, like remove the Stuff part. Then if thats ok, start add one stuff, and so on. In the meantime, I'll try to think any other thing that needs changes. Btw, are you using SQL Server 2005 and above for your database? Because that XML path thing will not work in SQL 2000. FYI.
Boyan Penev
27
user's latest post:
Applying Interactive Sort on...
Published (2009-12-03 18:14:00)
There are two very nice articles on MSDN about implementing Interactive Sort: http://msdn.microsoft.com/en-us/library/cc627509.aspx and http://msdn.microsoft.com/en-us/library/cc627536.aspx Please read those. An excerpt, relevant to your question:     Sorting Child Groups or Detail Rows for a Group Add an interactive sort button to a group header row to enable the user to sort the values of a child group from a parent group or to sort the...
theLilacGroup
25
user's latest post:
Making Column to Rows in TSQL
Published (2009-12-03 14:49:00)
if you simply want a report that is formatted like your example, you can use a 'List' report item (instead of a table) and put textboxes in your list. 
Andrew Goodnight
24
user's latest post:
programming interface needed in...
Published (2009-12-03 23:33:00)
Just a thought. You can always have a few varities of charts in one report. You can control the visibility of those charts by some parameter, i guess the same idea of using programming to control your chart output. Just a thought, if not suit your need, then sorry.
Adam Tappis
21
user's latest post:
programming interface needed in...
Published (2009-12-03 10:19:00)
You can just use grouping to achieve what you want. Place your chart inside a rectangle and set the grouping for the rectangle to be the value that drives the differnt charts. That's assuming that the only difference between the many instances of the charts is a filter value.
Praxy1
20
user's latest post:
Sharing reports across multiple...
Published (2009-12-03 09:45:00)
http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/5e2c0245-d457-43a3-b585-9459463c7e5d check this out
Jagapathi Raju
17
user's latest post:
Can i control the visibility of...
Published (2009-12-03 10:36:00)
I beleive you can acheive this bhy using visibilty expression on the column. Give a try, I havent tested it my self.
 

Latest active threads on SQL Server Reporting Services::

Microsoft TechNet Forums
Started 3 days, 16 hours ago (2009-12-02 07:16:00)  by Dorababu
   What kind of report you are using (Table or Matrix) ?  Generally you can set page breaks in the respective row group (in your case 5th group). In tabular report it will work fine but in the case of matrix report you will face some problems with this.
Thread:  Show this thread (3 posts)   Thread info: Page Break in the Nested Grouping Size: 275 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Page Break in the Nested Grouping :: SQL Server Reporting Services :: Microsoft TechNet Forums"
Microsoft TechNet Forums
Started 1 day, 18 hours ago (2009-12-04 05:02:00)  by Yao-Jie Tang - MSFT
Hi, If you suspect SQL doens't run properly at night, please find the logs or add a trace on Reporting Servcies, then we can analyse what happened. What is the execution type of the report? Reporting Servcies won't execute the reports over and over. By default, it only execute it when accessed. So please check the exection type of the report you viewed, try to change it and let report server ...
Thread:  Show this thread (2 posts)   Thread info: Reporting services idle state Size: 483 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Reporting services idle state :: SQL Server Reporting Services :: Microsoft TechNet Forums"
Microsoft TechNet Forums
Started 1 day, 18 hours ago (2009-12-04 04:56:00)  by Yao-Jie Tang - MSFT
Hi, Please apply the Servcies Pack 3 for SQL firstly. Here is the link: http://www.microsoft.com/downloads/details.aspx?Fa milyID=ae7387c3-348c-4faa-8ae5-949fdfbe59c4&displa ylang=en Thanks.
Thread:  Show this thread (2 posts)   Thread info: Last report printed Size: 371 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Last report printed :: SQL Server Reporting Services :: Microsoft TechNet Forums"
Microsoft TechNet Forums
Started 1 day, 18 hours ago (2009-12-04 04:53:00)  by Yao-Jie Tang - MSFT
Hi, If there is no relationship between these three views, I don't think you can put them into one table. One data region only can refer to one data entity. So you may create relationship between the views, or you may put three tables one by one. Thanks.
Thread:  Show this thread (2 posts)   Thread info: How can I add fields from two different tables i Report Builder Size: 295 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: How can I add fields from two different tables i Report Builder :: SQL Server Reporting Services :: Microsoft TechNet Forums"
Microsoft TechNet Forums
Started 1 day, 18 hours ago (2009-12-04 04:52:00)  by Jin Chen
Hi Feodor, I suppose the issue is caused by the maxRequestLength of the request size. For HttpRuntimSection, the default size is 4096 KB (4 MB). Please follow these steps to increase the size, and the try to move reports again: 1.Open the web.config of Report Manager with TextEditor(such as Notepad) By default, the file is located at: C:\Program Files\Microsoft SQL Server\MSRS10....
Thread:  Show this thread (6 posts)   Thread info: Move reports from one folder to another in SSRS 2008 results in error. Size: 1,034 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Move reports from one folder to another in SSRS 2008 results in error. :: SQL Server Reporting Services :: Microsoft TechNet Forums"
Microsoft TechNet Forums
Started 1 day, 18 hours ago (2009-12-04 04:46:00)  by Yao-Jie Tang - MSFT
Hi, Please understand that when report is rendered in BIDS, it is a real-time application. When depolyed, it is HTML, so it would post the request to the server, and server will give the result when executed. Server will deal the request one by one, so we can't give server second statement to let it stop the first one. How about change the execution property of the report in Report Manager? ...
Thread:  Show this thread (2 posts)   Thread info: Cannot stop report generation on Report Server (Report Manager)?? Size: 456 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Cannot stop report generation on Report Server (Report Manager)?? :: SQL Server Reporting Services :: Microsoft TechNet Forums"
Microsoft TechNet Forums
Started 2 days, 9 hours ago (2009-12-03 14:06:00)  by Aaron Jarboe
I've had this problem before, and go around it by basically creating a Table and putting these text boxes into table cells.  The key is to not use the Details line... just use the table header, and create more headers to accomodate more textboxes as needed.  That way, when one textbox changes height, it will automatically push other boxes down.  I don't know if this will help you at all, but I ...
Thread:  Show this thread (3 posts)   Thread info: Textboxes overlap when size increases to accomodate contents Size: 1,028 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Textboxes overlap when size increases to accomodate contents :: SQL Server Reporting Services :: Microsoft TechNet Forums"
Microsoft TechNet Forums
Started 1 day, 18 hours ago (2009-12-04 04:40:00)  by Yao-Jie Tang - MSFT
Hi, This issue may caused by the KeepTogether property. Reporting Servcies is intend to keep all data in one page instead of separate them. Try to uncheck this property firstly. Thanks.
Thread:  Show this thread (2 posts)   Thread info: Problem when printing a report Size: 226 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Problem when printing a report :: SQL Server Reporting Services :: Microsoft TechNet Forums"
 

Hot threads for last week on SQL Server Reporting Services::

SQL Server Reporting Services
Started 5 days, 20 hours ago (2009-11-30 03:26:00)  by Cavall
Im not sure what forum this should go into, so if this is wrong, sorry. Hi... I am trying to take data from a inspection/timeclock software and create useable reports for our payroll department. My problem is that the data is in a difficult form to sum and I am not entirely sure how I can do this. The employees perform inspections on their vehicle with a handheld unit.  For each row of data ...
Thread:  Show this thread (27 posts)   Thread info: trying to make time clock report... data in strange form. Not sure where
this goes... please help... Size: 26 kb
Related Threads: Same Site | All Sites
Customize:  Customize "trying to make time clock report... data in strange form. Not sure where
this goes... please help... :: SQL Server Reporting Services :: Microsoft TechNet Forums"
SQL Server Reporting Services
Started 1 week, 4 days ago (2009-11-24 10:33:00)  by Isham H
How do we know, based on your input, that the first line of data is odd day or even day?
Thread:  Show this thread (17 posts)   Thread info: How to print a report with values for ODD and EVEN Days Size: 107 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: How to print a report with values for ODD and EVEN Days :: SQL Server Reporting Services :: Microsoft TechNet Forums"
SQL Server Reporting Services
Started 4 days, 6 hours ago (2009-12-01 16:47:00)  by Isham H
To the best of my knowledge, there is NO function for you to look at future rows. This is best handle in your query itself. If you need help with query, feel free to show some sample input data and expected result.
Thread:  Show this thread (9 posts)   Thread info: Referencing "Future" Rows, possible? Size: 233 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Referencing "Future" Rows, possible? :: SQL Server Reporting Services :: Microsoft TechNet Forums"
SQL Server Reporting Services
Started 3 days, 17 hours ago (2009-12-02 06:23:00)  by Ismailc
Any ideas, executing the url from vbscript or automatically saving the ouput. Please any help!
Thread:  Show this thread (9 posts)   Thread info: SSRS automatically run report & save pdf output to c: Size: 131 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: SSRS automatically run report & save pdf output to c: :: SQL Server Reporting Services :: Microsoft TechNet Forums"
SQL Server Reporting Services
Started 2 days, 19 hours ago (2009-12-03 04:11:00)  by Dorababu
Hi Andrew,     The following link will help you : http://www.c-sharpcorner.com/UploadFile/robo60/Sta ndaloneRDLCReports11142007183516PM/StandaloneRDLCR eports.aspx
Thread:  Show this thread (9 posts)   Thread info: programming interface needed in SSRS2008? Size: 334 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: programming interface needed in SSRS2008? :: SQL Server Reporting Services :: Microsoft TechNet Forums"
SQL Server Reporting Services
Started 4 days, 6 hours ago (2009-12-01 17:24:00)  by Adam Tappis
Dynamic sizing is not possible horizontally and is very limited vertically. It's also not very well supported for the various output formats e.g. you'll often end up with hidden data inside a cell when exporting to excel. The Size doesn't even support expressions whereas most other properties do.
Thread:  Show this thread (7 posts)   Thread info: In SSRS How to Change the Textbox width Dynamically? Size: 318 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: In SSRS How to Change the Textbox width Dynamically? :: SQL Server Reporting Services :: Microsoft TechNet Forums"
SQL Server Reporting Services
Started 3 days, 4 hours ago (2009-12-02 18:45:00)  by Aaron Jarboe
I'm a little unclear exactly what you're asking, but it sounds like you want a parameter that is used in a textbox, for example.  Set up your Parameter (let's call it "Dummy") - and to reference it in a textbox, you would refer it in one of two ways: =Parameters!Dummy.Value         (This will return the value of the parameter) =Parameters!Dummy.Label          (This will return the label you ...
Thread:  Show this thread (7 posts)   Thread info: Parameter as a simple label text for a report Size: 611 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Parameter as a simple label text for a report :: SQL Server Reporting Services :: Microsoft TechNet Forums"
SQL Server Reporting Services
Started 5 days, 11 hours ago (2009-11-30 11:59:00)  by Kvasire
Hi Fred, Looks like as you are grouping the data with Description. If you click matrix properties, there will be a option which gives you to create "Add Total" based on the group.
Thread:  Show this thread (7 posts)   Thread info: Totals in a matrix report Size: 221 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Totals in a matrix report :: SQL Server Reporting Services :: Microsoft TechNet Forums"
SQL Server Reporting Services
Started 3 days, 16 hours ago (2009-12-02 07:08:00)  by Andrew Goodnight
can i divide the background of a chart area into many blocks, and then assign different background colors to different blocks. such that, the background is red where the Y-value is less that a target value, Otherwise background color is blue. Thanks. Andrew Edited by Andrew Goodnight Wednesday, December 02, 2009 9:03 AM
Thread:  Show this thread (7 posts)   Thread info: background color of chart area? Size: 914 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "background color of chart area? :: SQL Server Reporting Services :: Microsoft TechNet Forums"
SQL Server Reporting Services
Started 3 days, 16 hours ago (2009-12-02 07:21:00)  by Darshan Altekar
HI All, In my report I have two vertical images in the body one at the left and the other at the right side of body. In between these two images there are multiple tables which shows the data. Is there any way I can repeat the images on every page? I know using background image is one of the solutions but i don’t want you it. Thanks in advance. Regards, Darshan
Thread:  Show this thread (7 posts)   Thread info: Repeat the images in body on every page Size: 513 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Repeat the images in body on every page :: SQL Server Reporting Services :: Microsoft TechNet Forums"

This page was found by:   System.InvalidOperationException: Cannot start service ReportServer on computer ---> System.ComponentModel.Win32Exception: The service did not respond to the start or control request in a timely fashion