Thanks
JWWe don't document the tables structure for the RS catalog. If you want to interract with the report server, you should use the SOAP APIs.
Thanks
Tudor
I have a very simple table report. I need to be able to export it as a CSV, but I can not have the first line being the header. I need just the data and no header. Is there a way to do this? I tried working with the Output tab on the tables properties, but I only seem to be able to include or exclude columns not the column headers.
I look forward to you response.
FredZilz
Hello,
To do this you need to set the DeviceInfo parameter "NoHeader" to True:
http://msdn2.microsoft.com/en-us/library/ms155365.aspx
-Chris
|||Excellent, I can now get my results using URL Access.
Can, I set Device information settings as the default for a particular report (not at the server level but at the report)?
Thanks
|||Hello,
DeviceInfo parameters can be set 1) via URL access, 2) when rendering with the SOAP API, or 3) set in the report server config file for the entire server (all reports).
However, they cannot be set as default for particular reports.
-Chris
Hi All,
Issue : While Exporting Report to Excel (Report contains SubReport)
Advance Thanks
In Reporint Services, I am using Table control to display the data.
In that control footer section i added one subreport that accessing the value from the Footer Section of the table(like Total ..) Report is generating.
While exporing that report, it is giving exception like : "Sub Report in Table Cell could not be shown."
Any idea/ suggestion to resolve this issue.
I believe export to excel does not support this.
How to reset the page number for each group in a table on the report?
Thank you in advance.
Please check the following blog article: http://blogs.msdn.com/chrishays/archive/2006/01/05/ResetPageNumberOnGroup.aspx
-- Robert
|||Thank you. This was very helpful.
Is it possible to know how many pages are in the group to print page number and out of these many pages in a group?
Hi, on my local SSRS (RDLC), I have a table which presents several
items, however these are not sequential data from a table on my DB, are
fields of only one row of a table on my DB. More specificly, I have a
table with the fields issue1, description1, issue2,
description2...until 6! I want to present those fields six times (the
same times as they appear on the DB), however, I only want them to
appear is the issuex (which is an integer) is greater than 0. So to
guarantee that each field only appears one time, I do this:
=First(Fields!issue1.Value)
to each table line
And
what I want to do on each line is IIF(Fields!issue1.Value >
0,True,False) to make that line visible or not, however, if I apply
this to a line it automatically applies it to the complete table, and
if only one of this conditions returns false the complete table becomes
invisible.
Is there anyway to make this work dynamically?!?Thanks a lot!
The first mistake in your hidden expression is that your true and false results are exchanged. As per your first sentence, you want to show the row when issue>0 which means hidden should be false. so your hidden expression for table row should like this: IIf(Fields!issue1.Value>0, false, true)
To achieve the result you want, create 6 table detail rows and control the visibility of these rows based on the corresponding issue number. For example, first row will check for issue1 > 0, second row will check for issue 2 >0 etc until 6th row..
Shyam
Hi,
I have a fact table with 2 columns value A and value B
In Analysis server I add a calculated column C as A / B
Now my data looks like this
A B C
0 10 0
5 10 0.5
If you add totals in Analysis server you get
5 20 and 0.25 which is correct
If you add totals in Reporting server you get
5 20 and 0.5 which is not correct.
How can I fix this ?
Thanks in advance
Constantijn
If you are using a table report, in your group footer you could add an expression for C that equates to
=sum(Fields!A.value)/sum(Fields!B.Value)
|||Or, assuming that the report uses the SSAS cube, instead of using SUM use Aggregate as explained here.
|||Teo,
Many thanks for that tip - I had totally missed that little trick.
Will
|||Thanks, I wasn't aware of the that functionHi,
I have a fact table with 2 columns value A and value B
In Analysis server I add a calculated column C as A / B
Now my data looks like this
A B C
0 10 0
5 10 0.5
If you add totals in Analysis server you get
5 20 and 0.25 which is correct
If you add totals in Reporting server you get
5 20 and 0.5 which is not correct.
How can I fix this ?
Thanks in advance
Constantijn
If you are using a table report, in your group footer you could add an expression for C that equates to
=sum(Fields!A.value)/sum(Fields!B.Value)
|||Or, assuming that the report uses the SSAS cube, instead of using SUM use Aggregate as explained here.
|||Teo,
Many thanks for that tip - I had totally missed that little trick.
Will
|||Thanks, I wasn't aware of the that functionI have a table whose structure is follows:
Date
EmpID
Code
Amount
Sample data looks like this:
Date EMPID Code Amount
1-Jul-07 1 A1 100
1-Jul-07 1 B1 100
1-Jul-07 2 A1 150
1-Jul-07 3 B1 50
1-Jul-07 4 C1 120
1-Jul-07 4 D1 80
-
The Codes are not fixed, they can be of any number and varies from employee to employee.
I want to show a report like this:
Month: Jul-07 CODES --
EmpID A1 B1 C1 D1
1 100 100 0 0
2 150 0 0 0
3 0 50 0 0
4 0 0 120 80
--
Since Codes are not fixed, so an SQL query is difficult. What is the alternative approach?
I am thinking to create another table at run-time that reads column values (Code names) from the original table and create a field of that name in the next table.
I also want to know in which edition of SQL Server is reporting included. How SQL Server Reporting compares with Crystal Reports?
Secondly, while generating reports from Windows OS on a Dot-Matrix Printer, printing is slow. How can I print at a speed same as in DOS?
To answer the first part of your question:
It's a simple procedure to create a cross-tab report in Reporting Services. The dataset you'll create is nothing more than SELECT * FROM table. Next, add a List control to the form. Set the grouping to =Year(Fields!Date.Value), =Month(Fields!Date.Value) and add a Textbox control to display the month and year of the date field such as:
=Month(Fields!Date.Value) & "-" & Year(Fields!Date.Value)
Next, add a Matrix control inside the List and under the Textbox. Drag the EMPID field from the Datasets window to the Rows area of the Matrix. Drag the Code field to the Columns area. Drag Amount to the Data cell. Since the Data cell needs an aggregate function, you'll most likely do OK with the SUM function that Reporting Services adds by default. Since you have zeros in your sample above where NULL data exists, replace the equation in the Data cell with the following to display a zero instead of a blank:
=Iif(Sum(Fields!Amount.Value) <> 0, Sum(Fields!Amount.Value), 0)
I have a table whose structure is follows:
Date
EmpID
Code
Amount
Sample data looks like this:
Date EMPID Code Amount
1-Jul-07 1 A1 100
1-Jul-07 1 B1 100
1-Jul-07 2 A1 150
1-Jul-07 3 B1 50
1-Jul-07 4 C1 120
1-Jul-07 4 D1 80
-
The Codes are not fixed, they can be of any number and varies from employee to employee.
I want to show a report like this:
Month: Jul-07 CODES --
EmpID A1 B1 C1 D1
1 100 100 0 0
2 150 0 0 0
3 0 50 0 0
4 0 0 120 80
--
Since Codes are not fixed, so an SQL query is difficult. What is the alternative approach?
I am thinking to create another table at run-time that reads column values (Code names) from the original table and create a field of that name in the next table.
I also want to know in which edition of SQL Server is reporting included. How SQL Server Reporting compares with Crystal Reports?
Secondly, while generating reports from Windows OS on a Dot-Matrix Printer, printing is slow. How can I print at a speed same as in DOS?
To answer the first part of your question:
It's a simple procedure to create a cross-tab report in Reporting Services. The dataset you'll create is nothing more than SELECT * FROM table. Next, add a List control to the form. Set the grouping to =Year(Fields!Date.Value), =Month(Fields!Date.Value) and add a Textbox control to display the month and year of the date field such as:
=Month(Fields!Date.Value) & "-" & Year(Fields!Date.Value)
Next, add a Matrix control inside the List and under the Textbox. Drag the EMPID field from the Datasets window to the Rows area of the Matrix. Drag the Code field to the Columns area. Drag Amount to the Data cell. Since the Data cell needs an aggregate function, you'll most likely do OK with the SUM function that Reporting Services adds by default. Since you have zeros in your sample above where NULL data exists, replace the equation in the Data cell with the following to display a zero instead of a blank:
=Iif(Sum(Fields!Amount.Value) <> 0, Sum(Fields!Amount.Value), 0)
