Archived Months
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
all groups > sql server reporting services > july 2004 > threads for tuesday july 20

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

XML Data Input
Posted by May Liu at 7/20/2004 11:45:02 PM
I want to use my own application to retrieve SQL and process the data base on business logic. Then the result set is save in XML file. Does Reporting Service can import this XML file which already contain the data ??? ...more >>


Problem with multi parameters
Posted by Angi at 7/20/2004 11:04:40 PM
Hi, I use this syntax to enter multi value in a parameter textbox. ="SELECT OrderID FROM Orders" & IIF(Parameters!ID.Value="","","WHERE OrderID IN (" + Parameters!ID.Value + ")") When value is empty "", I can get all of the OrderID. But when I enter OrderID like 001 (the datatype of the O...more >>

Report Generator in VS.NET
Posted by adrian m at 7/20/2004 8:17:23 PM
We have a SQL server 2000 w/ Reporting services installed. I have a laptop I use for development running Windows XP, w/ VS.Net enterprise installed. [I know if you intall Reporting services on a Sql server with VS.net installed you get the Business Intelligent Project types and, therefore, ha...more >>

Exporting only a portion of a Report
Posted by Samuel at 7/20/2004 6:03:36 PM
Hi, How I can export only a portion of report? For example can I export only first 15 pages of a report? TIA Samuel ...more >>

how to export current viewing HTML report to a PDF file programmatically - to simulate the Export button in the HTML viewer
Posted by Guo, Lianghong at 7/20/2004 4:39:18 PM
I created a Windows report viewer and use the RS HTML viewer to view a report. In order to print the report, I added two buttons in to the viewer, one button is for Print-Preview and the other is for Print. For various reasons I decide to use Acrobat Reader as the print/preview tool. I know how ...more >>

parameters not showing up in report manager
Posted by Dan at 7/20/2004 3:26:51 PM
Hi, My MAIN report jumps to REPORT1 using the "jump to report:" hyperlink action of a textbox. REPORT1 has one parameter. Every thing works fine except I would like to be able to change REPORT1 parameter after I execute it, but it does not display when in Report Manager. ie. I jump from M...more >>

Security Problem
Posted by Alex at 7/20/2004 2:57:12 PM
Hi, As report designer, when I deploy and view report, there is no problem but for other people they get error: Login failed for user (null). Not associated with a trusted SQL Server connections. What permission should be assigned to viewers? Thanks ...more >>

How do i refer to previous row in a report?
Posted by shankar at 7/20/2004 2:56:36 PM
How do i refer to previous row in a report? ...more >>



localization and RS
Posted by Patrick Ruhnow at 7/20/2004 2:23:53 PM
Hi, i want to make a report which could be called in several countries. My question is, what kind of regional settings do RS use ??? I tried the VB.NET Functions FormatCurrency etc and i set the regional settings on (server + client) from german to english, but the currency value is still in ...more >>

Using temp tables in RS
Posted by Ha Vo at 7/20/2004 2:15:46 PM
Hello, I am using a stored procedure that's using table variables and a temp table for querying purposes. I want to create a report in Reporting Services using this stored procedure as a datasource but it will not allow temp tables. I am currently using SQL2000. Please help. Thanks, Alliso...more >>

chart and image problem
Posted by jimmy stewart at 7/20/2004 12:08:56 PM
I'm having a problem with charts and images showing up as "broken images". It seems to work just fine when I preview a report but after I deploy them the chart and images show up as broken. ...more >>

Dynamically Writing & Rendering Report
Posted by Simon Dingley at 7/20/2004 11:45:55 AM
I have a report which will change almost everytime it is requested. I am building the query and writing the RDL on the fly. I don't want to save the RDL to the report server as it will be of no future use. Is there a way to pass the RDL as perhaps a string or something similar and ask the Report...more >>

How can I install Report Server without VS.NET?
Posted by Stan at 7/20/2004 11:06:10 AM
VS.NET 2003 is required for the installation of the reporting services. Question is how can I install the Reporting Server on a staging or production box? Thanks, -Stan ...more >>

Microsoft .NET Framework: Unhandled Exception
Posted by Adam Bliss at 7/20/2004 8:55:32 AM
Hi, I built a very simple report that uses a shared data source to access an SQL server. I wanted to select all columns from a table on a linked server. My query is simply "select * from SERVER.DATABASE.USER.table" and it works fine in Query Analyzer. However, when I enter this query into t...more >>

Determine what server i'm running on
Posted by G at 7/20/2004 8:29:55 AM
I've generated a report that will need to display different information based upon where it is being run. For instance, if the report is executing on our DVLP server, i need a title to say "Developement". Is there is simple way to determine what environment the report is being run in? Check the U...more >>

Customize SRS Home Page
Posted by CurtisK at 7/20/2004 7:36:01 AM
I need to customize the SQL Reporting services home page with my company logo and some text. Is there a way of doing this. Thanks!...more >>

pull-down menu based on user id
Posted by JIM.H. at 7/20/2004 7:25:08 AM
Hello, When I lunch my report I want to display a pull-down menu based on the user id. I know how to get userid but I do not know how I can use it to display pull-down menu, for some user id I should not display anything. Also if I display the pull-down, after selection I should write val...more >>

Paging & Visibility?
Posted by fzuma NO[at]SPAM yahoo.com at 7/20/2004 7:12:45 AM
I have been trying to figure out why paging was not working on my reports. I checked the report layout and could find nothing wrong. Then I started turning off "features" and found that if I use this statement in the Table Visibility box "=IsNothing(Fields!CampaignMasterName.Value)" (w/o quote...more >>

Reporting Oracle Long datatypes
Posted by RW at 7/20/2004 7:00:03 AM
I am including a Oracle Long datatype dataset field in a table report item textbox cell and only getting 100 characters of the field displayed. Is this the maximum length possible or is it possible to display more characters? I am connecting to the Oracle database with the Oracle provider for OLE...more >>

Navigating to another report with date parameter
Posted by Paddy at 7/20/2004 4:25:01 AM
When I navigate to another report which requires a date parameter I get the following error : ....\AppsAndAwds.rdl An unexpected error occurred while compiling expressions. Native compiler return value: ‘[BC30260] 'EH_School' is already declared as 'Class EH_School' in this class.’. Any id...more >>

How to ... Create Custom Assembly
Posted by Chris McGuigan at 7/20/2004 3:00:38 AM
I was struggling to get started with custom assemblies until I found this post, it was a great help. http://blogs.sqlxml.org/bryantlikes/articles/824.aspx?Pending=true Regards Chris McGuigan...more >>

Page Breaks
Posted by SqlJunkies User at 7/20/2004 2:00:02 AM
How can i design my data region so that i shown only 10 records per page. I mean 10 records in page1 and next 10 records in page2 and so on. Thankx for ur help. --- Posted using Wimdows.net NntpNews Component - Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine suppor...more >>

Running Total
Posted by May Liu at 7/20/2004 1:29:01 AM
I try to sum the weight by putting the expression =Sum(IIf(Fields!EQP_LEN.Value = 20 And Fields!EQP_TYPE.Value = "L", Fields!CONTAINER_WEIGHT.Value, 0)) in group footer section but #Error is returned. On the contrast if the expression: =Sum(IIf(Fields!EQP_LEN.Value = 20 And Fields!EQP_TYPE.Valu...more >>

Allow null value option in Report Parameters
Posted by thepacket at 7/20/2004 12:09:03 AM
Hi, I have very simple parameter driven report that accepts a null value. When I enable "Allow null value" option under VisualStudio's Report Parameter, the null checkbox is checked by default when I run the report. Is there anyway that I can uncheck the null check box by default via Visual S...more >>


DevelopmentNow Blog