|
|
|
June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 |
Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Temp Table Alernative in SRS 2005 Posted by Pete Zerger at 10/31/2006 11:25:01 PM
All,
WHile I am able to query the dataset I want, and able do query it. However,
I did so using #temp tables to achieve my desired result, and encounter errors
when attempting to add this dataset in Report Designer in VS2005 (Microsoft
Report Designer: Could not generate a list of field...more >>
9GB log file generated Posted by Patsy at 10/31/2006 7:08:01 PM Hi
The reporting services is generating large log files of 9GB daily and using
all the virtual memory that all applications on my win2003 server stop
running. Application is running on sql server 2000 and Microsoft Report
Server SP1.
How do I go about trouble-shooting this?
--
Regar...more >>
Can report content be generated dynamically? Posted by Chris G. at 10/31/2006 2:55:02 PM SSRS 2005
I have figured out how to use a custom code assembly to dynamically control
the content of the textboxes in the footer of my report.
For example, I have an expression like this in one of the textboxes:
=Code.OakRptLib.BuildPageFooterLeft()
This approach assumes that the textbox...more >>
Error: 7105, Severity: 22, State: 6 Posted by ME at 10/31/2006 2:22:07 PM My SQL server logs this in Application log:
Error: 7105, Severity: 22, State: 6
Page (1:952446), slot 39 for text, ntext, or image node does not exist.
MS KB890755 http://support.microsoft.com/kb/890755 asked to contact MPSS for
a hot fix for this problem.
I believe this call is free bec...more >>
Calling functions in an expression Posted by Matt M at 10/31/2006 1:55:02 PM I have a function in the Report Code of one of my reports and an expression
that references it. Here is the expression that is in the details row:
=Iif(Code.Check(Fields!fullname.Value), 0,
Code.AddClient(Fields!fullname.Value))
The Check function basically looks in an array to see if the ...more >>
"Custom" Report Model Data Source? Posted by brianpmccullough at 10/31/2006 1:23:02 PM Hello,
Is this a true statement: "The only Data Sources available to a Report Model
are SQL Server 2000, SQL Server 2005, and SQL Server Analysis Services 2005"?
I had read somewhere that there was going to be an ability to specify a
"custom" query processors so that you could use data so...more >>
Sub-reports not in the same order as designed when the Main Report is generated Posted by pcipriani NO[at]SPAM chubb.com at 10/31/2006 1:01:00 PM Hi,
I have a main report with multiple subreports. I need to insert a new
subreport between two existing subreports. When I run the main
report, a pre-existing subreport is now jumping and printing out of
sequence.
Any idea how I can fix this problem? Does anybody know why the
sequence...more >>
Report subscription to sharepoint Posted by David at 10/31/2006 12:45:01 PM I want to setup a subscription for a report to be copied out to a sharepoint
site. Is this possible? If so, then how do I do it?...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Name multiple sheets in excel export? Posted by pichula at 10/31/2006 11:11:14 AM I have a report that when exported to Excel creates multiple sheets. Im
doing this on purpose. I wanted know if anyone new a way to
automatically name the Sheets in the Excel export? I wanted to name
them from a field on the report.
...more >>
rsExecutionNotFound Posted by glennl at 10/31/2006 10:02:01 AM Hi!
Has anyone figured out what causes a "Execution '2ye0gq45qszd0m55wlgy0n55'
cannot be found (rsExecutionNotFound) " error? Our scenario is this:
A relatively new/unused sql server 2005 (so load is not a factor).
A new report (the first one on this server) conisting of a main report and ...more >>
Using variables in text dataset does not work Posted by Jason Rodman at 10/31/2006 9:42:02 AM I have a query that I am using in my report as a text dataset (i dont want it
in a stored proc yet) but my issues is that I have a variable defined that I
want to become a parameter for the report. What happens is if I refer to the
variable at all before the select statement its used in, it do...more >>
Example for IN Operator? Posted by Mike Livenspargar at 10/31/2006 9:14:02 AM I think I'd like to use the IN operator in a filter expression in a SQL
Reporting Services report and I cannot find documentation for the syntax or
an example showing its use. The variations of delimiters I've tried have not
worked. Is there documentation or an example out there showing use of...more >>
Using LIKE in a Filters for a Table Posted by Craig at 10/31/2006 9:13:02 AM I am trying to filter a dataset that is displayed in a table. However when I
use LIKE as the Operator I cant get it to work. What is the correct syntax
for the VALUE column?
I have tried (where Text is my sample string I am searching for):
Text
%Text%
=Text
="Text"
=%Text%
="%Text%"...more >>
Specify cell background color for cell that contains subreport Posted by bjkaledas at 10/31/2006 8:51:02 AM Hello. I have a subreport in a cell and I can't specify the background color
of the cell. I have a "dummy" dataset in the subreport to always return data
so that it appears grey, but the problem lies in when there is a carriage
return/line feed. The next row will be white with color only wh...more >>
Duplex printing SRS 2000 Posted by bhughes at 10/31/2006 8:28:45 AM Is it possible to set a printer to duplex within SQL Reporting Service 2000?
I have several reports to print and need to switch back and forth between
duplex (Front and Back) and one sided printing.
TIA
...more >>
Confined by table cells .. Col span option? Posted by jobs at 10/31/2006 8:00:45 AM
Under a table with headers, groups, details and footers .. say I want
two sets of details that should not align with the headers. Or for
example, say I have a subreport in a group that I would lke to span the
entire width of the the table.. How do I do this?
Thansk.
...more >>
Parameter multi-value problem when using a stored procedure Posted by Peter at 10/31/2006 7:51:02 AM Hi folks,
I am describing the issue as below:
1. create a stored procedure as below
.....where age in (@p_age)
note: age is the table coumn of table table1 with datatype tinyint
2. ..... and create a second dataset for parameter @p_age
select distinct age from table1
3. asso...more >>
Querying XML containing <
| home · blog · groups | Questions? Comments? Contact the dn |