|
More site info...
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.
|
|
|
|
|
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:
|
Top authors during last week:
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
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...
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.
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.
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...
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.
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.
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.
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
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::
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.
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 ...
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.
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.
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....
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? ...
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 ...
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.
|
|
Hot threads for last week on 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 ...
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?
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.
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!
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
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.
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 ...
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.
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
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
|
|