i have sql server 2008. i would like to learn the reporting services. where can i start? can you show me a tutorial that helps me make a simple report.
Hi,
Can anyone explain how to create a custom build to deploy reporting services reports with TFS? Is it possible? If so then how... Samples or articles will be greatly appreciated.
Thanks
I have a report that groups months by quarters, so each quarter has three months and the display of the months under the quarter is toggled by the quarter header.
It looks just fine in the ReportViewer, but when exporting to Excel the first month in the quarter with data is duplicated and appended to the end of the quarter group.
Here is what it looks like in the ReportViewer (with Quarters 2 and 4 expanded, note May and June do not have any data and show blank columns by design):
http://i.imgur.com/MykZE.png
This is how it looks when exported to Excel:
http://i.imgur.com/zfLuk.png
The collapsed Quarter should only show the LAST month in the quarter.
You can see that in the Excel export July is inserted in Q1 even though it should be hidden entirely since that quarter is collapsed, December is appended to Q2, January is inserted into Q3, and April is duplicated and appended to Q4.
Exporting the any format OTHER than Excel works correctly and does not insert these columns.
A similar bug for rows was filed and marked as "by design": http://connect.microsoft.com/SQLServer/feedback/details/508823/reporting-services-2008-group-by-export-to-excel-duplicate-rows-csv-ok-pdf-ok
How do I stop the export to Excel feature from inserting these duplicate columns?
I have two local data sources that I can push into the report. Works no problem. But how do I set up the report? One data source contains a list of employees, and info about them. The other contains a bunch of working hours for each employee.
I would like to use a table for the list of employees, and then have another table for the working hours beneath each employee (with their working hours).
Is this even possible? Do I have to use a Sub-Report? Would I have to merge them into one datasource? =/
I have a SQL Server Reporting Services local (i.e. RDLC) report displayed in a ReportViewer, with two subreports. I am using business objects to populate the datasets. What is the best way to populate single-instance data on my report, e.g. a dynamic title, or a text box that lists a calculated value, not based on the report data?
I am currently displaying data using the following style:
public class MyRecordList
{
string Name { get; set; }
List<MyRecord> Records { get; set;}
}
public MyRecord
{
string Description { get; set;}
string Value { get; set;}
}
I set the datasource to the Records in an instance of MyRecordsList, and they print out find in a table. But adding a textbox and and referring to Name displays nothing. I also tried turning Name into a List, and referring to the first in the list, using:
=First(Fields!Name.Value, "Report1_MyRecordList")
but still nothing is printed on the report.
Hi, I am getting "ASP.NET Session Expired" error when viewing SQL Server 2008 reports using the Microsoft ReportViewer web control. I found this article http://balanagaraj.wordpress.com/2009/09/25/session-has-expired-in-asp-net/ which suggests to use one worker process in IIS application pool, but that may affect performance, is there any other solution for this? I tried setting "AsyncRendering" to false already and that didn't work.
I'm trying to pull a report down using the following:
https://user:[email protected]/ReportServer?%2fFolder+1%2fReportName&rs:Format=CSV&rs:Command=Render
And it just pulls an html page and not the csv file. Any ideas?
I have a SQL Server Reporting Services report with an embedded image in the header. It works fine in preview mode and if I inspect the RDL file, it has the encoded image stream in there.
However, when I deploy the report to the server and view the report in the Report Manager, the image shows with a broken X icon.
Has anyone experienced this?
Thanks in advance for any and all assistance.
My code is:
Public Function StripHTML(value As String) As String
Return System.Text.RegularExpressions.Regex.Replace(value, "<(.|\n)*?", "")
End Function
Then I call the function from a textbox. This works great unless there are nulls in the dataset. I tried to compensate for the nulls, but the RDLC file generates an error message that it can't display the subreport.
Public Function StripHTML(value As String) As String
if isnothing(value) then return value
else
Return System.Text.RegularExpressions.Regex.Replace(value, "<(.|\n)*?", "")
end if
End Function
I also tried to tell it to return " " if null.
I had no luck...
Any ideas? and thanks again.
I'm calling CreateReport method on ReportingService web service to create a report on the server. I was wondering if there is a way to give this newly created report a Guid I want for the ItemID in the Catalog table?
I have a report which displays customer address in multiple labels.
My customers use windowed envelopes for mailing. I need the address labels position to be configurable.
Something like, I'll have a database table which stores the Top/Left position of each label per customer. Based on this table, I need to position the address labels on my report.
I thought, it is doable by expressions, but Location property doesn't provides ability to set an expression and make the label's top and left dynamic.
Anybody, any ideas, on how to achieve this?
I've got several reports and they have been built with various formatting. Nothing huge just the header row is different between them. I'd like to pick a standard and just update the reports so they all look the same. This can be done on a textbox by textbox basis - setting the font, font color, font size and background color.
It seems like I should be able to select more than one textbox and set the formatting on them all at once but the "textbox properties" item is disabled when I've selected more than one.
Any thoughts?
I'm trying to create a CI process for SQL Server Reporting Services.
I am fairly new to TFS but quite experienced with MSBuild. In the past I've used a combination of MSBuild with Team City so the whole build process is more or less custom.
Here lies the start of my problems, as the solution I am deploying only contains Report Server projects (rds), no compilation is required. I thought that I would override the the first default task that TFS runs (EndToEndIteration) to override the default TFS build sequence and inject my own.
The first snag that I have come across is that the build always fails, how can I set the status of the build to success? Currently the EndToEndIteration task is very light and only has a message.
Is this the best method to create a custom build process in TFS where compilation is not required? Or should I use the default sequence and override one of the hook tasks mentioned in
http://msdn.microsoft.com/en-us/library/aa337604%28VS.80%29.aspx
(ie: AfterCompile)
The core steps that I'd like to achieve are:
Bundle the RDL and datasource files
Connect to the host server to
register/deploy the reports
Re-apply any subscriptions that
previously existed
Run tests to verify the deployment
succeeded and is returning results
as expected
I have found another article on Report services deployment:
http://stackoverflow.com/questions/88710/reporting-services-deployment
But it doesn't mention the best practice for customizing the standard build process.
Any help would be appreciated.
I would like to set the visiblity of columns based upon the value selected in a paramater.
The problem is I do not want a specific paramater to do this (i.e Hide column X True/False)
My report has several diffrent "departments" who are only intrested in certain columns.
What would be the syntax for example to hide the "Sales" column when the "Customer Care" paramater is set?
I have chart that plots values of Y-axis less than 1 (0.1, 0.24, etc).
When the chart is built, Y-axis label just shows 0 at the origin and no other values along the axis.
Hi,
I have a table called Resource, and i am making a line chart (the chart is complicated, so just assume its a simple xy line chart).
I want to execute the report with different resources. I have added a new parameter and bound it to a dataset to return a dropdownlist of resource names.
Can i do a mulitiple selection of resource. for example if i want to make chart with ResourceA and ResourceB, only, can i select these two resources from the dropdownlist of parameters.
cheers,
Oz
I have two reports that are setup with the same page dimensions- A4 portrait, with page margins of 1cm.
When I run the reports seperately and print them they both come out as expected: fitting into the width constraint of the page.
However, when I include one report as a subreport in the other and then run and print the "master" report I start to experience problems. Even though both reports appear I get extra blank pages appearing every other page in the output.
I'm sure I'm missing a simple trick - probably with the page sizes of the two reports but I can't figure it out - any pointers?
I don't mind changing the setup of the subreport as it will never be run as a seperate eport in the wild, I only included that step to prove that it did indeed fit within the page!
Hello....I have a report with 12 Tablixes on it. The user can pcik and choose which one of these Tables and their associated data shows when the Report is generated. However, when chosing a subset of the 12 tables, the report shows blank space where I hide the non-selected tablse. Is there any way to make the report resize/fit the size of the selected tables...truncating the white space where the invisible tables are?
Thanks
Hi is it possible to change the direction of column header values ?
By default header valules displayed in horizontal direction only. But I want to show the values in vertical direction. Is it possible?
I tried from the last 3 days. But no where I got any good results.
Thanks in advance
Hi everyone,
Right now I have an application which uses Reporting Services to render reports.
This is working nicely, I call each report with a given value (e.g. a ClientId), and the report gets rendered correctly.
However, what I'd like to do now is being able to send multiple ClientIDs to the report, and would like to get 1 pdf file with count(ClientsIDs) pages, each containing the report, according to the ClienID.
How is that possible? I don't really know how to name what I want to do, so I don't really find answers on the net right now. Maybe someone has a tutorial for me?
Thanks in advance !
When I click File - Open on Report Builder, I can see a list of folders under Report Server Home root folder. But I don't want end-user to see any of the folders under root unless I grant them access.
I tried hiding and removing permission on the folders but they are still visible in the root folder.
Currently, our system will do a "foreach" over all Subscriptions which are returned from the ListSubscriptions method of ReportingService and fire a Timed Subscription event so that they receive the report as an email.
In our dev environment, I don't want every subscription of these reports to be sent out when we are testing.
Is there a way I can create a new subscription with my own email address being used so that I receive the report? The temp subscription could then be deleted after sending.
Any ideas on how to do this?
I have a table with the following columns and data
Category Item Price Tax
A I1 1.00 .01
A I2 2.22 .02
B I3 3.33 0.3
I want to group on Category and have the details below such as:
Category/Item Price Tax
A
I1 1.00 .01
I2 2.22 .02
B
I3 3.33 .03
I want the category to have its own row then the detail rows below with the item in the same column as the Category.
The output that is desired is:
Category - Item | Price | Tax
A | |
I1 | 1.00 | .01
I2 | 2.22 | .02
B | |
I3 | 3.33 | .03
Dear All,
I have problem with Full-Text Search service in production environment.
Each time I rebuild full-text catalog, there is no error in User Interface, but there is no data in Full-Text Catalog
Item Count : 0
Catalog size : 0 MB
OS : Windows Server 2003 R2 Standard Edition Service Pack2
SQL Server Version : Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
It work on dev server (windows xp professional version 2002 service pack 3) but error on prod server (Windows Server 2003 R2 Standard Edition Service Pack2)
This is error log.
Scrawl Log:
2010-06-02 03:51:31.06 spid24s Informational: Full-text Full population initialized for table or indexed view '[test1].[dbo].[test]' (table or indexed view ID '37575172', database ID '9'). Population sub-tasks: 1.
2010-06-02 03:51:31.06 spid24s Error '0x80092003' occurred during full-text index population for table or indexed view '[test1].[dbo].[test]' (table or indexed view ID '37575172', database ID '9'), full-text key value 0x00000006. Attempt will be made to reindex it.
2010-06-02 03:51:31.06 spid24s The component 'MSFTE.DLL' reported error while indexing. Component path 'D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\MSFTE.DLL'.
2010-06-02 03:51:31.06 spid24s Error '0x80092003' occurred during full-text index population for table or indexed view '[test1].[dbo].[test]' (table or indexed view ID '37575172', database ID '9'), full-text key value 0x00000005. Attempt will be made to reindex it.