Tagged Questions
3
votes
2answers
119 views
why would command text not execute at all?
in my report i have::
<CommandText>SELECT
column1,
column2,
'poop'
from mytable
</CommandText>
i am using sql server profiler to see exactly what statement is ...
3
votes
1answer
344 views
Store SSRS Report export directly to database
As a requirement, I have to check for a certain condition on some data in the database, if the condition is true, then I have to create a pdf report and store it on a table.
I have everything set up ...
1
vote
0answers
47 views
Drill down report links fall outside cell
Apologies for the vague title, not sure how to summarise the problem...
I'm creating a dashboard report showing server state for a group of SQL servers, the problem is that the links for the drill ...
4
votes
1answer
328 views
How to query EndDate value from ReportServer..Subscriptions.MatchData
In SQL 2008 R2, I'm putting together some administrative queries on SSRS metadata to check proper configuration, and other sorts of proactive things.
While querying the ReportServer db, I've been ...
4
votes
2answers
227 views
Splitting a column in two and returning a summary of results
Lets take a very simple table
Department | Staff Name
---------------------|---------------
Web - Electronics | Matthew
Store - Electronics | Mark
Web - Home | Luke
Store - ...
2
votes
1answer
160 views
Execute Queries Against CMS within SSRS Reports?
Is it possible to execute queries against a Central Management Server (CMS) using SSRS?
For example, I know of no way to tell a stored procedure that it is inherently supposed to call the CMS, so it ...
