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 > april 2005 > threads for friday april 15

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

move reports service system
Posted by alf at 4/15/2005 10:25:14 PM
hi all how can move all reports system (web and database) from one box to other = box. thx. from spain. _______________________________ * Alberto Garc=EDa S=E1nchez * Subdirector Inform=E1tica * Autobar Spain, S.A. * Email: agarcia@autobar-spain.com * Web: www.autobar-spain.com...more >>

print directly
Posted by alf at 4/15/2005 10:20:17 PM
I would like print directly from my vb.net application to default printer = in the client pc.=20 how can i do it. thnkas many thanks _______________________________ * Alberto Garc=EDa S=E1nchez * Subdirector Inform=E1tica * Autobar Spain, S.A. * Email: agarcia@autobar-spain.com * We...more >>

Conditional visibility in a table group.
Posted by Nick Addison at 4/15/2005 10:05:03 PM
I have a report that presents the detail lines in two groupings. So I have the detail lines as a subset of group1 which is a subset of group2. Nothing clever there. I want now to add a line to the report that is only visible if a parameter "DisplaySignOff" (which will just show a box which ...more >>

How do we pass parameters when using URL JUMP
Posted by James Woo via SQLMonster.com at 4/15/2005 6:10:15 PM
Hi all, HAve a Horizontal bar Chart I want to drill through, it looks somehtign like this: Manager1 ||||||| 70% Manager2 |||||| 60% Manager3 |||| 40% What I want to do is under Data >> Action >> Jump URL instead of Jump to Report, is pass the manager name to a details-report th...more >>

Using RS to develop reports on Sharepoint lists?
Posted by ScottWMcCarter NO[at]SPAM gmail.com at 4/15/2005 2:52:34 PM
My question is very basic, but i cannot seem to find an answer. Is there any way to use RS to develop reports about Sharepoint libraries and lists. The data is not stored in SQL, but in XML. Any thoughts? ...more >>

How can I make a Landscape PDF file
Posted by Aki Nomura at 4/15/2005 2:39:34 PM
rs:Format=PDF creates a PDF file which is always portrait orientation. How can I make a "Landscape" PDF file? Thanks. ...more >>

Service Pack 2
Posted by muris at 4/15/2005 2:18:57 PM
When is service pack 2 coming out? I heard from a local microsoft guy that it might be out as early as next week. Does anyone know for sure!? :) Thanks. ...more >>

Subscription - Select Schedule Button
Posted by Jaye at 4/15/2005 1:59:02 PM
I had to re install Reporting Services recently and since doing so I can no longer create a schedule to run my reports. I can go to the Subscription page for the report but when I click on the Select Schedule button nothing happens. No options or error messages are displayed. Any ideas on why ...more >>



Exchange Reporting Pack
Posted by Tony G at 4/15/2005 1:58:01 PM
Has anyone been able to successfully install the Exchange reporting pack without also having Visual Studio .Net installed? I've tried but receive the following error: "Object Reference not set to an instance of object" and the install fails....more >>

Output Parameters in Stored Procedures
Posted by PR at 4/15/2005 1:30:02 PM
Hi I have a stored proc that has 1 input parameter and soem output parameters. When I call that stored proc from my report, it prompts for all the parameters, both output and input. What am I doing wrong ? Thanks PR...more >>

rendering issue exporting to Excel
Posted by Hadyn Pkok at 4/15/2005 12:41:03 PM
OS = XP Pro latest sp, MS Office 2003 Pro latest sp I am using SQL Reporting Services (sp1) to export data to Excel. My stored proc requires a case statement with carriage returns to format Address data. I have also deleted the carriage returns from the stored proc and written an expression...more >>

permission grant set is incompatible between appdomains
Posted by george tharakan at 4/15/2005 11:16:03 AM
HI , I have a custom dll that I use to do some of the code expressions across reports. I have set the required permissions in the rsrvpolicy.config file to allow it to run under full trust. I have also set the following attributes on the method in that dll <System.Security.Permissions.En...more >>

Reporting Services: Using Calendar Control for Report Paramters
Posted by Aaron Williams at 4/15/2005 11:03:08 AM
I'm looking for a way to use a calender control to enter date parameters on my reports. Is there a calendar control available or is there a way to use custom controls for entering report parameters? Thanks, Aaron...more >>

New Project - Should I use MS technology?
Posted by David Young at 4/15/2005 10:30:55 AM
Wow, this is exciting. I've just got a new project request. It's for building a statement processing system. Customer send us data, we merge the data with an existing report layout, then we print and send back to the customer for distibution. Sounds simple enough right? Use Crystal or SQL ...more >>

New Role Assignment Question
Posted by Charles Collins at 4/15/2005 10:15:04 AM
I have just set up SQL Reporting Services in our Development environment and want to set all users with browser or read-only access to our reports but do not see how. I am going in through the web interface and it tells me that I must have a valid domain group or interface. Any idea on how to ...more >>

Apply formatting to data in the Datafield?
Posted by boilersrock NO[at]SPAM gmail.com at 4/15/2005 10:01:27 AM
I have a chart that shows Price totals in the Datafields section. the price amounts tyipcally run into the 10s or 100s of thousands of dollars, but it shows up as "125650" (less quotes) I've tried the following expressions in the Value field of the Value tab: =format(Sum(Fields!PRICETTL.Va...more >>

Acrobat Reader print error
Posted by BobK at 4/15/2005 10:01:06 AM
I have a couple of Reporting Services reports that I render to PDF and open them in Adobe Acrobat Reader 5.0.1 for viewing/printing. When I try to print either report, I get the following popup error message: The instruction at "0x77f580db" referenced memory at "0x013997c4". The memory cou...more >>

Rendering Reports on aspx (SOAP)
Posted by DJONES at 4/15/2005 9:37:02 AM
I've never worked with a Web Service before and am confused. I have established a prox class for the web service RS, and authenticated with the Report Server (I think). Now, how do I go about getting a particular report to display on my page (on Page Load or other)? Also, once I get past this...more >>

SQL Reporting Services Install
Posted by Yosh at 4/15/2005 9:33:38 AM
When I go to install reporting services it's telling ASP.NET is not installed. I go to the Add/Remove Windows Components but I don't see it in there. How do I install ASP.NET? I have the .NET Framework 1.1 installed BUT I did not install the SDK. Thanks, David ...more >>

Input parameter
Posted by AlwaysLearning at 4/15/2005 8:41:03 AM
Our IT department created an Access database to run reports against data in our accounting system. Access soon was unable to handle the amount of data, so I moved the data to SQL and just use Access as the front end. I want to get away from Access altogether, and run reports using Reportin...more >>

Stored Proc. runs in QA, but not in Reporting services
Posted by ADrew at 4/15/2005 8:31:03 AM
I have a stored procedure that returns a neatly formatted dataset for a report. The proc receives 2 input params @Entry_Date and @STName. This allows a user to input a date and a sales trader's name and get the proper financials. Works like a charm in Querey Analyzer, 3 second run time. I ...more >>

Text Box with Normal and Bold Font
Posted by sparky at 4/15/2005 8:17:05 AM
I have created a report that simulates a letter. The body of the letter is rendered by a text box with text and carriage returns (VbCrlf). Some, but not all of the text needs to be bold. I checked the properties on the text box and you can set the font for the text box but it is an all or noth...more >>

Subscription delay of 1 day
Posted by Koen at 4/15/2005 4:55:02 AM
Hi, does sql server uses an internal clock or something ? because everytime i make a new subscription (using web service OR the standard .../reports interface), i get the message that the subscription was succesfully made, but, when i expect the subscription, i have to wait an entiry day....more >>

WebServices and SQL server 2005 reports
Posted by Shafia at 4/15/2005 12:00:00 AM
Hi, Can you plz send in a link that can help me understand how to use my WebService methods to populate an SQLServer Report ? Thanks, Shafia ...more >>

In repeated group header
Posted by Matt at 4/15/2005 12:00:00 AM
Hi, has anyone discovered how to determine if your group has split onto a new page. The Crystal Equivalent was InRepeatedGroupHeader which I now consider a sorely missed luxury :) It would be nice if we could inform the viewer that the group they are viewing is continued from the previous ...more >>

Possible to reference the value of a textbox in page header or footer?
Posted by Kaisa M. Lindahl at 4/15/2005 12:00:00 AM
Is it possible to reference the value of a textbox in a report page header or footer? I've tried to create a textbox in my report page footer, and make it show the PageNumber. My textbox is called txtPageNum. In my report body, I've created another textbox. I've tried to set this textbox's val...more >>

How to get Visual Studio .NET 2003 for SQL Reporting Services?
Posted by Curtis Fray at 4/15/2005 12:00:00 AM
Please forgive this basic question. I'm a complete novice when it comes to SQL. I'm installing SQL and SQL Reporting Services to be used with MOM. As part of the Reporting Services install according to the instructions here (http://www.microsoft.com/sql/reporting/howtobuy/default.asp), at s...more >>

Microsoft Reporting Services
Posted by arvind sharma via SQLMonster.com at 4/15/2005 12:00:00 AM
Default value or value provided for the report parameter 'ParamaterName' is not a valid value. (rsInvalidReportParameter) I am getting this error when I am trying to run a deployed report. However, this is driving me mad because in the report preview within VS.Net the report works fine an...more >>

Reporting Services only for Enterprise Ed?
Posted by Heiko Schmidtke at 4/15/2005 12:00:00 AM
Hello, general question: We have SQL-Server2000 - Standard Edition with installed AnalysisServics (Standard Ed.). Is Reporting Services operable on this configuration or only with SQL-Server-Enterprise Ed.? Who knows? Heiko ...more >>


DevelopmentNow Blog