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 > september 2004 > threads for tuesday september 21

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

Conditional Count for Row Group together with Column Group
Posted by JiaN at 9/21/2004 9:55:03 PM
Division =Fields!Status.Value Total =Fields!Division.Value =Count(iif("Status"=Fields!Status.Value,1,0),"Division") Total: the above is the matrix that i had done to count some values. The "=Fields!Status.Value" is a c...more >>


Split Month in a week
Posted by TA at 9/21/2004 9:29:07 PM
Hi I am writing a report that reports on Sales and Budget, of course I can filter sales by transaction date, but the budget is a little bit harder. The buidget covers a hole month, so what I have to do is to calculate the budget amount by deviding, but if the month end in the middle of the...more >>

How to determine in a report if the dataset has data
Posted by Stephen Witter at 9/21/2004 8:37:19 PM
Is there anyway to tell if a report has data? I am looking for an expression or something that would allow me to display a message if the dataset is empty. ...more >>

Problem with BorderStyle while Exporting to PDF
Posted by Ponnurangam at 9/21/2004 8:28:13 PM
Hi, I have lines of BoderStyle: Dotted, BorderWidth: 0.5pt in my report When I preview it and print it I get the dotted lines But if I export the same report to PDF and then print I get Dashed lines instead of Dotted Lines It's very important that I get Dotted lines. Can Someone Help...more >>

Webservice ... Save PDF file?
Posted by Rich Miller at 9/21/2004 8:12:36 PM
Can you use the Webservice to simply run a report and save the results to a file? Examples appreciated. Thanks. ...more >>

Matrix region formulas
Posted by BoruRR at 9/21/2004 7:59:04 PM
Hi, I would like a Matrix report with Jan, Feb, Mar, Total on columns where total sums up all the month values in that row. And something like 2003, 2004, Difference2003-2004 on columns AddColumn does't seem to do the trick Thanks!...more >>

Can set anonymous to ReportServer
Posted by ad at 9/21/2004 7:59:01 PM
I want to all user can see my reports in the server just like they can see my web page. I set the virtual directory ReportServer's access to anonymous. If there any dangers to do that? ...more >>

Reformatting Parameters before using them in Sql query
Posted by Urs Eichmann at 9/21/2004 5:22:16 PM
Hello, We use Reporting Services to do reports from a (rather old iSeries / AS400) database. Date values are stored as numeric data in the format YYYYMMDD, rather than with a proper "Date" type. This is quite common in older host-based databases. In one of our reports, the user should be a...more >>



Report Authentication
Posted by Prem at 9/21/2004 4:09:08 PM
This is a newbie question. I have the report viewer component on one of my aspx pages. When the user tries to open this page, he/she is prompted with a user/password on the server. How do I set up the reporting services so that it uses a generic account for all requests from the web. Thanks. ...more >>

Installation issue
Posted by J. Gonzalez at 9/21/2004 3:29:09 PM
Hi everyone, I'm hoping someone can help me out on this one. I'm getting an error when I try to install rs developer edition on my box. The message is "could not start the reportserver service on Local Computer Error 193: 0xc1" I had a previous version of rs (rs evaluation edition) prior...more >>

Custom coding
Posted by Al Santamaria at 9/21/2004 3:25:31 PM
I'm using the Report.References collection to link to some external Assemblies (developed in C#). Also, I use the Report.Classes collection to instantiate some classes defined in that assemblies. This works, as I'm able to show a custom Windows form from the constructors of the instantiated cl...more >>

print as landscape
Posted by Joe Scalise at 9/21/2004 2:43:47 PM
Is there a way to get reports to print as landscape instead of potrait automatically? I changed the Layout from properties to the correct width and page height, the display looks fine but when I print, it tries to print it on potrait setting. I've tried printing from both the report previewe...more >>

Subscriptions - External Email
Posted by lukeguerrant NO[at]SPAM gmail.com at 9/21/2004 2:30:34 PM
I am trying to email an external email address via a subscription. Every time I try to email the report externally to our company I get an error that the email address is not valid. The email address is valid. I tried testing this on one of my own personal email addresses. I understand tha...more >>

License
Posted by Craig van Nieuwkerk at 9/21/2004 1:47:02 PM
Hello. I was at Borcon (Borland Developer Conference) last week and saw a talk by Don Farmer on DTS and Reporting Services. When asking a few questions afterwards some of the MS guys seemed to indicate that I could deploy reporting services without SQL-Server and just using MSDE. They indicate...more >>

Reports without Using VS ?
Posted by Richard Morey at 9/21/2004 11:59:07 AM
Can I create reports for Report Services without having Visual Studio? If so.. how? Thanks, Rich ...more >>

Repeating data regions on every page
Posted by Raul R at 9/21/2004 9:59:30 AM
Hi all, I want to create an invoice that will repeat numbers dates and shipping info on every page that the list of items grows on to. You know, to simulate a standard preprinted invoice page but fully generated by reporting services. Any assistance is appreciated. Raul Rubio ...more >>

Invoice form layout
Posted by Brian Smith at 9/21/2004 9:45:29 AM
Is there some way to simulate a fixed form layout for an invoice? I want to have a fixed set of columns with dividing lines and totals boxes at the bottom, regardless of how many actual rows of data are displayed. I've tried 2 approaches (using PDF rendering only): 1. overlay a table with a set...more >>

Help me install eval, please.
Posted by Steve Mahon at 9/21/2004 9:21:51 AM
I little experience with sql and no experience with rs. Recently, during a ..net class, the instructor demonstrated rs with the bikeworks db and I was blown away. I want to give the same demo to the bosses here, so they will send me to sql and rs classes. Our server is SBS2003 premium with sql...more >>

how do you set a cookie for axshdocvw
Posted by johnlee22 NO[at]SPAM yahoo.com at 9/21/2004 8:38:55 AM
I am using forms authentication in our reporting service. After authenticating, I get a cookie back and want to set that cookie in the axshdocvw browser control to view the report so the user doesn't have to log in again. How can I do this? I tried sending the session id as a parameter in the re...more >>

Design question
Posted by jhcorey NO[at]SPAM yahoo.com at 9/21/2004 8:02:03 AM
We currently have an ASP.NET app that includes some reports. I'm considering making the data available in RS and I'm looking for some opinions about the feasibility and difficulty in doing this. The app uses ODBC to connect to DB2. The users use their DB2 userid and password, and this is w...more >>

Manipulating dates in an expression
Posted by Nick Caramello at 9/21/2004 6:26:41 AM
Does anyone know a way to subtract a date from a date parameter (e.g. = Parameters!Date.Value - 1, which of course does not work) thanks...more >>


DevelopmentNow Blog