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 > december 2004 > threads for tuesday december 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 31

GetScheduleProperties()
Posted by FNDS at 12/21/2004 4:35:14 PM
I create a report subscription in code. Everything works fine: string id = service.CreateSubscription(reportName, extensionSettings, description, eventType,matchDataParam, parameters ); I get the id back and store it in the database. When I try to pass the id to GetScheduleProperties() I...more >>


different dataset inside table header
Posted by plandry NO[at]SPAM newsgroups.nospam at 12/21/2004 4:31:04 PM
Hi, I need to access a secondary dataset inside a table header. I have a List item defined, and a TextBox inside it. When I try to access a field in the secondary dataset, it says that field is outside of scope. How can I accomplish this? If it's any help, here is the RDL: <TableCell> ...more >>

Integrate Reports in ASP.Net Web Form
Posted by Kiran at 12/21/2004 4:01:17 PM
Hi, I have my reports at http:\\localhost\ReportServer and need to use them in ASP.NET Web Form.I have a few questions reg. this ------> I want to generate a PDF when a button labeled "Generate Report" is clicked" (1) I tried this using the below code: Dim myResponse As Byte() Dim u...more >>

Dynamic SQL in a RDL file?
Posted by Scott Meddows at 12/21/2004 3:55:14 PM
Can I put parameters and change the SQL in a dataset using expressions? Thanks Scott ...more >>

How to avoid Jump/out of fram w/ ReportViewer
Posted by Walter at 12/21/2004 3:47:07 PM
Hi there, I've got a nice drill-down, drill-up parent child MDX report, that works fine when viewed within the reporting services window. However, when I am viewing it through the ReportViewer the navigation action click jumps the result out to a new window. I cannot seam to find a way to k...more >>

Top 10 MDX
Posted by Carlos Krauss at 12/21/2004 3:33:01 PM
I am trying to get the Top N sales for the customers for a datawarehouse using the following MDX: ="SELECT {[Measures].[Net Sales],[Measures].[Qty Lb]} ON COLUMNS, TopCount(ORDER({[CustomerSalesPerson].[Name].Members},[2004], DESC),"& Parameters!TopCustomer.Value &") ON ROWS, {[TimeBy...more >>

Q: dlookup
Posted by JIM.H. at 12/21/2004 3:17:07 PM
Hello, Is there any function like dlookup in reporting services. I need to bring some data from another table.. Thanks, Jim. ...more >>

Matrix Row Headers After Data
Posted by Sean Carpenter at 12/21/2004 2:38:42 PM
I have a report that uses Analysis Services data in a matrix. The column groups in the matrix are based on date, and the number of column groups is variable based on the start time and end time entered as report parameters. I'd like to display the row headers after the column groups, regardle...more >>



Subscriptions Eating up Processor and Memory
Posted by Cooper at 12/21/2004 1:57:03 PM
Is anyone using alot of subscriptions? Currently I just 10 subscriptions made, all of which generate .pdf's and either email the pdf or stick it out on a file share. I scheduled some of these subscriptions to run every hour(as a test). It seems that the subscriptions dramatically effect the pe...more >>

Same Line, Different Lengths
Posted by box2003 at 12/21/2004 12:24:55 PM
Two identical length lines and properties, one in the Page Header and the other in the Body Area. When previewing in the report preview window, the line lengths look good and the same length in the preview window. When the report is deployed to the server and viewed, the line lengths are dif...more >>

Request failed with HTTP status 404
Posted by Priya at 12/21/2004 12:21:03 PM
Hi I have a .net application that lists all the reports within a specific folder using RS.children methodand then calls a specific selected report in Report viewer. My application code and reporting services are in two different servers however in the same domain. The problem is that when I...more >>

Status of SP2?
Posted by Shane Castle at 12/21/2004 11:29:02 AM
So where are we with SP2? This super double top secret stuff is great and all, but it would be nice to understand what changes we will be getting and when. Rumor has February/March, and so it would be nice to truly understand what the future holds. Cognos and BO don't even keep their expect...more >>

GRAPH exported to EXCEL ARE NOT EXCEL GRAPH
Posted by Jean-Marc Pugin at 12/21/2004 10:35:08 AM
Hi, Graph exported to Excel by RS are static images (?!;$%). Is there a way to use RS to generate Excel files that contain REAL Excel graphs interactive on a local subset of data stored in the Excel file. Many Thanks....more >>

Repost:External Assemblies in Reports
Posted by ALI-R at 12/21/2004 9:33:25 AM
Hi ALL, Is it true that any custom assembly that I create ,by defualt has "Execution" permission and if it dosn't attempt to have access to protected resources like files ,that secuity policy will do and I don't need to change any security policy??? I've cretaed a simple Assemly which only ...more >>

LogonUser method from a windows app with RS using forms authentica
Posted by Nathan at 12/21/2004 9:03:06 AM
I have successfully implemented forms authentication and have written a custom security module to suit my needs. During my initial testing of reporting services, I used windows authentication. I had written a vb .net windows application that provided similar functionality to the "RS" appli...more >>

What is the code to generate a PDF in my custom delivery extension
Posted by Adam at 12/21/2004 8:33:02 AM
Hi, I need to know the code that is used to generate a PDF file out of a report that is created in a custom delivery extension I am writing. I'm using the Sample Printer Delivery Extension as the base to extend upon. I need to change this to generate a PDF instead of an IMAGE, afterwards I wi...more >>

Data Processing Extension (Login failed for user '(null))
Posted by Ajay Kumar at 12/21/2004 8:29:02 AM
Hi all , I have created custom Dataprocessing extention for reporting service , the custom dpe code requires calling to other dll for datamanuplation ( which is another layer and i have to use this layer for manuplation on to the dpe) it works fine during design time in vs.net but on depl...more >>

Reporting Services
Posted by mvp at 12/21/2004 8:11:06 AM
Hello I am a SQL SERVER Programmer and new to Reporting Services. Where can i find MS Reporting Services in SQL SERVER 2000 and also what else i need to have to begin with Reporting services (just to create simple report initially). thx ...more >>

HTML5 - rendering extension that is not registered?
Posted by Brian at 12/21/2004 8:06:14 AM
Hello, I'm new to reporting services and trying to evaluate the best use for our needs. One of the first things I've come across is that extensions listed in the documentation (I'm running RS SP1 on SQL DEV) are not all valid. The HTML5 rendering extension in particular does not seem to exist...more >>

Cannot Access Report Server
Posted by Jake Taylor via SQLMonster.com at 12/21/2004 7:08:50 AM
Hi! I installed RS on a Server with the following: Windows Server 2003 IIS 6.0 Sharepoint Server/Services 2003 w/ SP1 SQL Server 2000 w/ SP3 I followed the instructions to the letter on the topic "Side by side installation of RS with Sharepoint" and did not receive any setup errors. How...more >>

WindowsXP problem
Posted by Soan at 12/21/2004 6:43:03 AM
Does someone knows if there is a problem with WindowsXP?? We have an application an from it we call an display the common GUI from Reporting Services. A user installed WindowsXP and now he must have IE always open and he can not export anymore. Do I have to change something in the configura...more >>

Parameter Valid Values
Posted by Ale Dori at 12/21/2004 6:41:08 AM
How can I obtain the valid values from a query based parameter using the Reporting Services web services ??? The ValidValues property don't return them. Thenks...more >>

Juggling Parameters
Posted by Bassist695 at 12/21/2004 6:27:06 AM
I am reporting off a star-schema data warehouse. I have three datasets that I use to populate parameters, and one master dataset that uses the values from all three to populate the report. The way I have set up the master dataset is: SELECT * FROM t_policy_info WHERE month_key = @month...more >>

PageNumber in the body
Posted by Ola A. at 12/21/2004 4:15:02 AM
There is Globals.PageNumber variable that can be used only in page header and footer. How can I get page number in page body? Ola A. ...more >>

Installation sequence
Posted by Keith Macdonald at 12/21/2004 3:55:01 AM
Just want to check whether I have the correct installation sequence... (1) Windows Server 2003 then updates/service packs (2) IIS6 then updates/service packs (3) SQL Server 2000 then updates/service packs (4) Reporting Services Is that correct? Thanks...more >>

Variables in the Mail Subject
Posted by Steve Morris at 12/21/2004 2:03:03 AM
I would like to use other variables in the subject line of the email apart from the two defaults (@ReportName,@ExecutionTime). For example, I would like the subject line to be "Report x - Week y : Year z" where y and z are two of the parameters for the report. Is this supported in RS and, if s...more >>

Error when generating in Excel
Posted by Mukund at 12/21/2004 1:09:02 AM
I am currently having a problem in production when generating a report in Excel. I get the following error: Reporting Services Erro -------------------------------------------------------------------------------- Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderi...more >>


DevelopmentNow Blog