|
|
|
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 updating a table using a sqltransaction, commit rollback routing Posted by norman via SQLMonster.com at 4/4/2006 7:31:29 PM This is my first shot at updating a table using commit rollback and I just
can't seem to get it. What am I doing wrong?
In this version, it chokes on the: saveCom.CommandText = "UPDATE TrialRun";
This is the error message:
System.Data.SqlClient.SqlException: Line 1: Incorrect syntax near '...more >>
Making groups available Posted by randy1200 at 4/4/2006 4:26:01 PM I'd like to get the sum of a row in a reporting services table. Unlike
summing columns which are easy, I'm told I need to create a group.
I create the group with the fields I want to sum. Then I right click on the
table cell I want to hold the sum value, and select expression. My table
colu...more >>
Report Organization Posted by Brian Shannon at 4/4/2006 3:52:43 PM I am taking over a RS solution from an ex employee and looking for some
report organization help.
I see you can have a shared datasource with RS.
In the solution there are about 20 projects. Each project contains reports
that are displayed in a folder seen off Report Manager. Is this the...more >>
ReportViewer HyperlinkTarget Property Problem Posted by Chuck P at 4/4/2006 3:14:15 PM I am running a locally processed report in Asp.net The report has a
textbox with a hyperlink property. In the report viewer control I
have set the HyperLink target to "_Blank".
When I look at the resultant page everything works fine for the first
page. If the user clicks on the hyperlink an...more >>
Hide data of collapsed matrix group Posted by daveg.01 NO[at]SPAM gmail.com at 4/4/2006 3:12:39 PM I have a matrix with date month on the rows axis. I want to hide all
but the most recent month. The data measures I am using are not
additive so I would like to hide the data for all collapsed groups.
Is this possible? I can't figure out how to reference a report item
to see if it is hidden...more >>
Closing IE Window used for exporting... Posted by Russ Heath at 4/4/2006 1:31:02 PM Taken from Reporting Services 2000 Help - 'When you click Export, the report
opens in a new browser window, in a viewer that is associated with the export
format. If in Step 2 you clicked TIFF, the report is displayed in a viewer
that supports TIFF file types.'
Is there any way to close thi...more >>
Filtering a Matrix Posted by ghoff12 at 4/4/2006 1:14:01 PM I have an aging report as in the columns below.
Current <=30 <=90 <=120 Total
825 756 - - 1581
800 800 1700
etc
etc
I would like to filter the table on the records that have Total - Current > 0
Any ideas on how to do this?
...more >>
Writebacks from reporting services to ssas Posted by Marc at 4/4/2006 1:03:41 PM Dear all
Does anyone knows if it is possible to make writebacks to SSAS with SSRS?
Thanks a lot in advance for your help,
Best regards,
Marc...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Summing Rows Posted by randy1200 at 4/4/2006 11:46:03 AM I'm defining a report in visual studio. In the data tab, I've pulled my table
columns from DataSet1 to a table.
In the layout tab, in the footer of my table, I was able to place fields to
sum the columns. This works great.
Now I'm trying to sum the rows. I right-clicked my row, and create...more >>
Problem with &rc:toolbar=false parameter Posted by Tom Bean at 4/4/2006 11:03:18 AM I am having a problem turning the toolbar off in reports. When I add the
&rc:toolbar=false parameter to the URL, the report is displayed with two
vertical scroll bars. The inner scroll bar scrolls the report and the
external scroll bar scrolls down to what appears to be another report
cont...more >>
Can't open http:\\192.168.1.x\test\test.asp after ASP.NET2.0 insta Posted by Meggie at 4/4/2006 11:00:03 AM Please help me here as I am total lost in the situation. I've just upgraded
the application server to SQL 2005 with SQL reporting service, therefore, I
have to install ASP.NET 2.0.
After I have successfully installed SQL 2005 / reporting services, I have
found out that I cannot open a ASP p...more >>
Unable to intall RS 2000 Server Components on a Windows 2000 Server Posted by Roberto Kohler at 4/4/2006 9:51:35 AM I am trying to install RS 2000 on a Windows 2000 Server.
I run setup.exe from the CD
I only get the option to install the Client Components.
I do not get the option to Install the Server Components.
The server is also a Domain Controller.
Is there anything I need to do in order to get setup t...more >>
Dynamic Default with MDX Cube Report Posted by Scott at 4/4/2006 9:42:01 AM I'm writing reports to an SSAS SQL Server 2005 Analysis Services Cube. When I
toggle the design mode to the MDX script view, I see a button with an @ on it
that says "Parameters". It gives the option of specifying a "default". I
would like to make this default dynamic, either the MAX value i...more >>
Problems upgrading to RS 2005 Posted by dachrist at 4/4/2006 9:40:03 AM I am trying to upgrade our RS 2000 instance to RS 2005. Our Report database
is called "PowTstReportServer". Our virtual directories are called
"SqlReports" and "SqlReportServer". When I run the upgrade, I keep getting
an error that says "SQL Server Setup has encountered the following proble...more >>
RS 2005 Installation problems Posted by Ash at 4/4/2006 8:37:03 AM -OS: Windows 2000
-RS 2005
-SQL Server 2000
The installation completes successfuly in c:\Program Files\Microsoft SQL
Server\MSSQL.1\Reporting Services\
LogFiles in c:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting
Services\LogFiles do not have any errors..
But when i visit http://l...more >>
Problems installing RS 2005 Posted by Ash at 4/4/2006 8:22:02 AM -OS: Windows 2000
-RS 2005
-SQL Server 2000
The installation completes successfuly in c:\Program Files\Microsoft SQL
Server\MSSQL.1\Reporting Services\
LogFiles in c:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting
Services\LogFiles do not have any errors..
But when i visit http://l...more >>
Parameters...HELP! Posted by gte401e at 4/4/2006 8:12:19 AM I am using 6 parameters in a report. If I set the Where clauses to OR,
the report will return everything (understood) but it doesnt work when
I set it to AND (how it should be). By themselves, each parameter
works. But when you combine all of them or even 2, nothing returns. Am
I missing a simpl...more >>
BC30469 Reference to a non-shared member Posted by Jeff Metcalf at 4/4/2006 8:00:04 AM This is the function:
Function funProdName(pFields) as string
IF (IsNothing(Fields!Name.Value))
Then
Fields!ProductDescription.Value
Else
Fields!Name.Value
end Function
Basically it just replaces a column with the value in another column if
column A is null.
The exact error is:
...more >>
Can RS 2005 point to SQL 2000 DB? Posted by Lulk at 4/4/2006 6:46:05 AM I would like to install Reporting Services 2005 on one IIS box and point to a
separate SQL Server 2000 box which would be used to host its two databases
(ReportingServer and ReportingServerTempDB).
Will this work?
--
Lulk...more >>
Queries in mulitiple places Posted by David at 4/4/2006 5:22:01 AM I have many reports in one project and I am using the same query in a few of
the reports. How can I set the query in one place and have my report call
that query? Is that possible? If so, does anyone have an example?
...more >>
Properties in many reports Posted by David at 4/4/2006 5:18:02 AM I have many reports in a project and I want to set some of the properties in
one place and have all of the reports read from it. Properties like page
size, margins, font size, etc.
Is that possible?
...more >>
Yet another rsclientprint problem Posted by SYSteam at 4/4/2006 4:01:02 AM Hi all
I'm trying to get reporting services 2005 to print directly through the
browser but am not having much luck. I've setup the web page as described at
http://msdn2.microsoft.com/en-us/library/ms159195(sql.90).aspx (Using the
RSClientPrint Control in Custom Applications) but am having s...more >>
Server Error in '/Reports' Application. Posted by Mahesh.Bachina NO[at]SPAM gmail.com at 4/4/2006 2:12:18 AM Hi,
I have server (windows 2003) with framework 1.1 and sql server
reporting services 2000. After upgrading framework 2.0, reporting
services is giving an security error when i try to open "reports" web
page.
Herewith the detailed error message:
Server Error in '/Reports' Application...more >>
custom security extension Posted by FleschGordon at 4/4/2006 12:11:01 AM Hello,
i tried the sample for the custom security extension for sql server 2005.
the c# Version worked, the vb.net version does not!
Is there another example with the use of application roles? We need this for
reporting issues.
thx in advange
michael...more >>
Deploy single report with keyboard shortcut? Posted by Kaisa M. Lindahl Lervik at 4/4/2006 12:00:00 AM Is it possible to deploy a single report from Visual Studio 2003 with a
keyboard shortcut? I can do it by right clicking in the Solution Explorer,
but it would be nice to just press "some combination of buttons" to make my
current report get deployed to the server.
Kaisa M. Lindahl Lervik
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |