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 monday april 11

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

IDBCommandAnalysis
Posted by Dan at 4/11/2005 10:03:02 PM
Has anyone implemented this interface? If so would you be willing to share your code? Cheers :D...more >>


IDbCommandAnalysis
Posted by Dan at 4/11/2005 9:40:02 PM
Has anyone implemented this interface before? Would someone be willing to share some code please?...more >>

Previewing RDL without Designer
Posted by Rakesh at 4/11/2005 9:31:02 PM
Folks, Is there a way to preview the "RDL" Reports programatically without deploying to the report Server. We needs this ability for the creation of ad-hoc reports where user designs the contents of the report... Any idea...? Appreciated...! Rakesh ...more >>

Dynamic Grouping
Posted by Hari at 4/11/2005 7:46:02 PM
Hi all I have a table which has employee information like empno, empname, empsalary, empmgr. The empmgr column points to empno. I want to create a report which will dynamically recognise the employees under a employee and show his salary. The other requirement is that i want to enable dr...more >>

Previous Business Day
Posted by Jadranka at 4/11/2005 6:04:02 PM
At the moment, I have a report that's using "=Today.AddDays(-1)" to return yesterday's date in the date range parameters, but the client has now come back and requested that they would prefer not to use weekends...e.g.: loading the report on Monday should show last Friday's date. Can this b...more >>

Multiplication Aggregate
Posted by ddinulos at 4/11/2005 5:20:02 PM
Hi, Is there an equivalent to the SUM() aggregate function but instead of doing a summation, I'd like to do a mulitiplication. Is there a way to achieve this? Please help. Thanks! ...more >>

Report runs in preview in VS.net 2003, but not on Report server
Posted by Fredrick A. Zilz at 4/11/2005 5:12:15 PM
I have a report which I have published to my Report server (sql 2000 on windows 2003). This report runs from my VS.net developers edition preview page, but once I publish it to my Sql reporting services report server, it will not run - there is a long delay, then I recieve repeated prompts fo...more >>

Textbox cell formating
Posted by lucl at 4/11/2005 2:00:33 PM
some description text in the database may contains html tags that has been entered by the user through a web application. Is there any way to format a Textbox using reporting services reports to apply these tags, or to just ignore them? I don't want to see these tags at display. thanks ...more >>



Text Color does chnanges when Export to Excel
Posted by BALAJI KRISHNAN via SQLMonster.com at 4/11/2005 1:09:34 PM
Hi All, I have a issue... I am doing a conditional formatting of a field.. = iif(rtrim(Fields!bCorrectAnswer.Value) = "True", "Green","Black"), this epxression is added on Color property of the field - Field!Answer... Now when I run the report it is giving the color change and when I export...more >>

Programmatically doing new role assignments
Posted by david.seruyange NO[at]SPAM gmail.com at 4/11/2005 1:03:58 PM
Hello everyone - A friend of mine is having some trouble using the browser based method of assigning roles and I suggested that we do it programmatically just in case errors were being suppressed by IE. So far I've seen a lot of code that creates roles but none that assigns the role to a Wind...more >>

Update Report Bug?
Posted by Roman JR. at 4/11/2005 12:56:02 PM
Hi, Could someone confirm if this is a known bug? When I uploaded a new version of the report to the server, all linked subscribers can only view the previous version of the report in their "My Reports" folder. They can not access the new version of the report, until I manually recreate ...more >>

LogonUser
Posted by darkeagle at 4/11/2005 12:55:02 PM
Hi All, There is anyone that have a sample code (working) that show how to use the LogonUser API? Thank you ...more >>

Seeking Reporting Services Consultant
Posted by Chris W, AgriBank at 4/11/2005 12:04:02 PM
I have a short term requirement for a Reporting Services consultant. Interested parties should contact cworthi@isd.net (off-line) for further information....more >>

Long Queries Hang VS; Other Productivity Killers
Posted by Bassist695 at 4/11/2005 11:55:01 AM
Whenever I run long SQL in VS whether it's in the Data tab or in Preview mode, I can't seem to get a report out of it. I'm talking SQL in excess of 200 lines. I can run the SQL fine in Query Analyzer but running it in the Data tab, it freezes VS, and when I run the Preview, the report never...more >>

Page Size as a Report Parameter?
Posted by moflaherty at 4/11/2005 11:05:03 AM
This might be a newbie question, but can the page size be set as a report parameter? Thanks! Michael...more >>

Formating
Posted by Vinny Vinn at 4/11/2005 10:10:03 AM
I have a field which returns a decimal (3.0000) i only want the whole value(3) not the parts (.0000) to be displayed in the report. when i right click on the textbox and select propeties then under the 'format' section i click on 'number' and select '1234' hit 'ok' and preview the report it ...more >>

Sending Email Error
Posted by Dave at 4/11/2005 10:10:02 AM
I am still having problems sending reports via email through Reporting Service. The error being thrown is: ReportingServicesService!library!850!04/11/2005-12:55:02:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The Report Server has...more >>

Unable to Connect After Admim PW Change
Posted by Brian Ackermann at 4/11/2005 10:05:53 AM
In a previous thread (Unable to Connect After Admim PW Change): http://groups-beta.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_frm/thread/ce818354b7ccb707/5cf80dcf743691a6 Mr. Peter Blackburn suggests : >What you can do is change the Domain Administrator's >password back...more >>

Substring?
Posted by Vinny Vinn at 4/11/2005 9:22:02 AM
How can i substing a field within the report as opposed to substring the sql? TIA, Vinny...more >>

first day of previous month date parameter
Posted by pcalv at 4/11/2005 8:45:02 AM
Hi, Hope somebody can help. I am looking for the code to place in the default value of a parameter wich will give me the previous months first days date (i.e. last month would be 01/03/2005). I already have code for the last day: =DateSerial(Year(Now), Month(Now), 0) so something sim...more >>

No longer able to open up .rptproj
Posted by DBA72 at 4/11/2005 8:18:02 AM
My visual studio .net application previously had not problem opening .rptroj files, but now it tells me "Make sure the application for the project type (.rptproj) is installed" Also, when I try to create a new project, the "Business Intelligence" project type is not listed. I have seen some...more >>

Bar width
Posted by Hawkeye at 4/11/2005 7:09:04 AM
My question: - How can I change the width of the bars in a simple column chart diagram generally? - I've got the problem that all my bars look like lines. ...more >>

login prompting
Posted by kamel at 4/11/2005 6:43:08 AM
Hi, Every time I browse folder hierarchy or opening report itself I got additional widows auth. login prompts using "http://ip_address/Reports" instead "http://ComputerName/Reports". I am using Basic Authentication and Windows 2003 Server which is Domain Controler. Need help to solve tha...more >>

Printing an image or PDF from C#
Posted by Lee Davies at 4/11/2005 6:14:01 AM
I am returning a PDF stream from SQL Reporting Services and I want to send the output straight to a printer without any user interaction. Any ideas how this can be done? I would rather not use the Printing extensions of SQL Reporting because of limited time. ...more >>

Generating a personalised report for every vendor and mailing out the same
Posted by karenmiddleol NO[at]SPAM yahoo.com at 4/11/2005 4:40:45 AM
I have the following reporting scenario. I have a table which contains a list of customers/vendors and each record in this table as the customer/vendor number, name and email address of the vendor and also the record as the value of the business done by the vendor/customer for this month, year...more >>

Still problems with Windows 2003 sp1
Posted by NH at 4/11/2005 2:10:01 AM
Hi, I am just reposting an issue here, hopefully by reporting it it might catch someones eye. Help on this would really be appreciated. I have tried the suggested fix from this post.. http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=d2f44745-4...more >>

Binary parameters to stored procedures?
Posted by Damian Cugley at 4/11/2005 12:00:00 AM
I have a stored procedure that takes a byte string as an argument: CREATE PROCEDURE Reporting_TicketSelectGroups @publicPart NVARCHAR(400), @checkField BINARY(46), @langCode VARCHAR(9) AS ... I've created a DataSet with the name of the stored ...more >>

Shared Data Source Problem
Posted by Sceptical at 4/11/2005 12:00:00 AM
Hello, I create a RS project in VS 2003 and add a shared data source, then add a report and the report uses the shared data source, so far everything's great, when I add one more project to the current project, I can not use the data source I created on the other project. Instead I need to...more >>

Creating user groups with Forms Authentication
Posted by Sceptical at 4/11/2005 12:00:00 AM
Hello, Is there a way to implement groups with forms authentication? Currently I am only able to create users and being able to generate groups would greatly help. Thanks ...more >>

Report get time out.
Posted by Sandeep at 4/11/2005 12:00:00 AM
Hi all, I am facing a problem of report time out for some of the my reports.The report seems to be taking too long and then times out.But when the new browser is opened immediately after the report comes in minutes. And the if I close the browser before it's get timed out and open the new bro...more >>


DevelopmentNow Blog