reporting-services

Linq for sql server reporting services, is it possible?

Is it possible to use my existing Linq data model for server side reporting (sql server 2005 reporting services)? ...

TSQL - Case Date Compare

Hi, I am trying to compare a date in SQL and create a new field to allow me to group the results by Todays date and other date(s). I am converting both dates to CHAR. However i am getting an expression error near = and ) - This is for an SSRS report. There is already a fairly complex SQL statement and i am just trying to add this ex...

SQL - WHERE clause Return results with next working day

Hi, I seem to be asking a lot of SQL questions at the moment. (I would normally write a program to sort the data into a report table, however at the moment that is not possible, and needs to be done using SQL) The Question I need a where clause that returns results with the next working day. i.e. Monday 01/01/01 the next working day wou...

c# datatable is populated, need help printing particular data to a report

what can I do on the reporting side, not the sql, or the c# part of the problem? my query returns four rows, grouped by the field payment_type, then puts the results into a datatable that's connected to my report in c#. What can I do on the report side to pull a specific row out of the datatable where payment_type="Cash" without modify...

MS CRM (4.0): Reports - Filtering Imported Reports

Hi, I have created a complex report in Microsoft Business Intelligence. The report has its own (fairly complex) WHERE clause. Is it possible for the user to set the CreatedOn date as part of the criteria? UPDATE I was looking at this again. On a basic report (one table) if i import the report over one created with the report wizard,...

vertical column headers in microsoft reports possible?

I have a report that can have 20+ columns I need to be able to generate column header text vertically such as: x | x | x | x | x | x | x | x | ------ 1 | 4 | 8 | 4 | and so on, is there a way to do this in the .rdlc? Or is the use of images my only option? ...

Getting Value From Another Table with a Foreign Key

I've built a report with the report wizard in C#, and I can see my report in ReportViewer. My problem is that I have 2 tables that are related. The value of a column in the first table is a foreign key on the other table. All I see in that column is just the foreign key. I'd like to see the corresponding value from the other table. How ...

Include SharePoint attachements inline within one report

How can I batch print all items in a list including attached documents (word. pdf)? So functionally I need: one report/document which includes all info from attached documents inline within that report. The user only has to print out that single report. Could it be done with Reporting Services? Or a commercial component? Many thanks...

Reporting Services 2008 Pie Chart from multiple fields

I want a pie chart where each of these values represent a slice of the value Total_nr_of_shipments: Late_delivery_forwarder_fault, Late_delivery_shipper_fault, Late_delivery_consignee_fault, Late_delivery_other and the slice that represents the remaining part of the total number of shipments that makes up the shipments delivered on time...

Reporting Services (SSRS 2005) matrix column group shifting right when exported to xls

I have an SSRS matrix report that has 4 column groups with the last group set to hide some of its columns if they contain no data. The report works perfectly, however when exported to excel an empty column header appears and all the headers shift right. It can happen multiple times on the same sheet. For examples instead of seeing some...

Is it possible to have columns RepeatOnNewPage with SSRS?

I have a report in SSRS 2005 that has a lot of coulmns in it. I'd like to find a way to repeat the first 4 columns on each page - essentially I want RepeatOnNewPage for cols instead of headers. for instance if I have C1 C2 C2 C4 D1 D2 D3 D4 D5 D6 D7 D7 I'd like it to print like so Page1 C1 C2 C2 C4 D1 D2 D3 D4 Page2 C1 C2 C2 C4 ...

How to present the result of a dynamic pivot request in SQL Server 2005 Reporting Services?

I have a dynamic pivot request I would like to present in a report of Reporting Services. As it is dynamic, the number of columns of the result is variable (as is the name of the columns). How could I create a report showing a table handling this variable number of columns ? ...

Does Reporting Services embedded in WinForm need SQL Server?

I am starting to learn Reporting Services and I read that it uses SQL Server to store the meta data. I am planning to use it in a WinForm app. Does SSRS require SQL Server to be used in a WinForm app? Can it be self contained like Crystal? ...

Reporting Services custom code not executing

I'm using this code in my report, to alternate row colours of grouped rows. http://stackoverflow.com/questions/44376/add-alternating-row-color-to-sql-server-reporting-services-report/83832#83832 It works correctly on my development server (SQL Server 2008 Developer Edition), but not on the live server (SQL Server 2008 Express). Is the...

Change Printer Settings in Reportings on RUN TIME

Can we change printer settings on run time in SSRS 2008. If a parameter pass which can change the Page Setup of a Page. Like For ex: if a report is on Legal Size paper but i want to print on A4 Landscape Or Legal on run time. it depends on my choice. ...

SSRS ExecutionLog not updating

We just recently updated our prod instanct to sql sp2. since then the executionlog for ssrs hasn't updated except for NT AUTHORITY\SYSTEM. I need to get this running again because management is using a report based off of the log. ...

Editing RDL files with Visual Studio 2008

Hi, I have installed SQL Server 2008 Express on two workstations. On one workstation, it has updated the VS2008 installation so that I can create reporting projects containing reports as *.rdl files. On the other workstations, VS2008 can only create/edit *.rdlc files. The report edition interface is also different. I do not understand ...

How to keep Report parameters in Exported pdf/excel in SSRS

Hi All, when i export my SSRS report to excel / pdf format, i want to show my parameters. is there a way to get it directly. thanks, NB ...

Is there a way to supply query parameters to a SQL Server Reporting Services Report at deployment time rather than at design time

Hello, SUMMARY: I have created a SSRS Report. I want to be able to supply parameters for the report at DEPLOYMENT time rather than just design time or runtime. DETAILS: I want to create ONE report and deploy it multiple times with the only difference being that I want to change one of the query parameters. I do not want to prompt...

SQL Server Reporting Services, how to best apply filters

I have a bunch of records (orders) that I want to make available to users to make reports from. The users come from different departments, and I would like to make it, so each department can only see their own stuff. I can't figure out how to do this the right way. What I have now is: - A model where I have placed a Filter on the Orde...