-
as seen on Stack Overflow
- Search for 'Stack Overflow'
I've got a Reporting Services report that has two row groups: Category and SubCategory. For columns it has LastYearDataA, ThisYearDataA, LastYearDataB, ThisYearDataB.
I added two columns (one for A and one for B) to handle an expression calculation (to show a percentage different from LastYear to…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
My report is as follows:
One table provides financial information with sums at the group footer (Grouping is called "StockTable_Shipped"). The group is controlled by a boolean value (1=shows shipped data, 0 = shows received data)
The second table is a variance report for data that has been shipped…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
after a number of failed attempts i seem to have successfully installed the Reporting services add-in to my WSS farm. However, I seem to be missing most of the enhanced functionality eg no report library template, no report center site template. the only additional functionality available is the report…
>>> More
-
as seen on Server Fault
- Search for 'Server Fault'
When I open Reporting Services Configuration Manager on my server, an error message appears that says:
Reporting Services Configuration Manager
An unknown error has occurred in the WMI Provider. Error Code 800706B3
This error appears before I can even attempt to connect to an SSRS instance.
In…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hello!
So... here's my story:
I'm trying to create a SQL server data extension (to be precise, I'm trying to get some sample code to run) (SSRS2005).
I've done the following:
Placed the extension assembly into the ReportServer/bin folder.
Placed the assembly into the Private Assemblies folder…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
I have a custom SQL call that is returning different results to the template than I get when I run the same query against the database directly, 1 row vs 2
Query - copied from Django Debug Toolbar:
SELECT ((Sum(new_recruit_interviews) / Sum(opportunities_offered)) * 100) as avg_recruit, ((Sum(inspections)…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hi all,
I have have an array as follows:
$row[6]
This section of the array has 4 numbers within it that I can display and use without any problems, what I'd like to be able to do is sum the first two numbers and the last two numbers separately.
Is there any way to do this?
Thanks in advance…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
My data in table_1 and table_2.
table_1
id_1 num ids_2
3 33 666,777,888
4 44 111,222,333
table_2
id_2 num
111 1
222 2
333 3
666 6
777 7
888 8
I only know how to do what I want with two steps:
First LEFT JOIN to get:
SELECT 1.id_1, sum(2.num) FROM table_1 AS…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
My report is as follows:
One table provides financial information with sums at the group footer (Grouping is called "StockTable_Shipped"). The group is controlled by a boolean value (1=shows shipped data, 0 = shows received data)
The second table is a variance report for data that has been shipped…
>>> More
-
as seen on Geeks with Blogs
- Search for 'Geeks with Blogs'
Note: The code below applies to version 0.3 of Microsoft Axum. If you are not using this version of Axum, then your code may differ from that shown here. I have just solved Problem 1 of Project Euler using Microsoft Axum. The problem statement is as follows: If we list all the natural numbers…
>>> More