Groups | Blog | Home


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 > may 2005 > threads for monday may 2

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

Subscription
Posted by Ashkan Daie at 5/2/2005 9:21:40 PM
I have deployed the sample reports to reporting server. When trying to subscribe to any of the sample reports I get the following error: --------------------------- Microsoft Internet Explorer --------------------------- Subscriptions cannot be created because the credentials used to run the ...more >>


Installation Problems - sqlspars.dll
Posted by Kevin D at 5/2/2005 6:25:19 PM
I'm trying to install Reporting Services onto a Win2k3 SBS from the MSDN CD pack and cannot get past the initial Setup application. Looking in the event log, I see the following error: Faulting application SETUP.EXE, version 2000.80.743.0, faulting module sqlspars.dll, version 2000.80.743.0,...more >>

Korean wording appear as ? in PDF
Posted by May Liu at 5/2/2005 6:01:06 PM
Can anyone help me ??? My question is : My report contains some Korean wording. When I export to PDF, the Korean word appear as ?. Then I export the report in Excel format, there is no problem in the Korean wording. But when I try to print it, the default page orientation is 'Landscape'...more >>

Access is denied exception when loading an assembly from custom data processing extension
Posted by Jeff Schultz at 5/2/2005 5:26:14 PM
Hello, I have been banging my head against this for the better part of today. Here's the scenario. I have a custom data processing extension which tries to make calls into another .NET assembly. As soon as this second assembly is loaded, an "Access is denied: name_of_the_assembly" System.Ex...more >>

Sub Total outside of Table
Posted by Marc Castrechini at 5/2/2005 5:10:57 PM
I have 1 dataset with a field that has positive and negative amounts. I then use filters to create two different tables. One showing the positives. One showing the negatives. I know I can easily create a sub-total in the table footer for each specific table. However, I am having trouble ...more >>

user authentication
Posted by Mardy at 5/2/2005 3:59:02 PM
Need some ideas. My users want to be able to access reports directly from the Report Manager BUT I need to restrict the data that each user sees in the report to just the data for each users location. Users must not be able to see data for locations other than their own. So, somehow I n...more >>

Export to Excel madness
Posted by DJM at 5/2/2005 3:08:31 PM
Why is it when I export a series of textboxes, all of which have the same height and top, and each one whose left position is exactly equal to the left position plus the width of the textbox to the left, they do not export to a single row in Excel? And not just that, but they'll be *half* a r...more >>

Place one Chart on top of another one
Posted by Peter Revere at 5/2/2005 2:45:06 PM
I am trying to place one chart on top of another chart in report designer. Everything looks go. So, I publish the report to Reporting Servers and for some reason the graphs are placed next to one another instead of being on top of each other. How can I fix this problem? The reason why I ...more >>



Fields in Page Headers/Footers?
Posted by DJM at 5/2/2005 2:06:38 PM
I have a shipment document report that takes as a parameter a shipment's database record ID. This report then pulls a few datasets based on that shipment ID to populate the different sections of the document (general "Header" information [shipment number, shipment date, project number], shi...more >>

doing a sum on a counted field
Posted by the finger at 5/2/2005 1:45:10 PM
i have a dataset with a column that has 2 values. YES or NO. i have to use a textbox inside a filtered(for yes) list that are to get a count of yes. I have to use another list to do the same for NO. using--Count(Fields!answer.Value). Now i want to perform a calculation on the counts and for the ...more >>

Embedded images aren't showed
Posted by vbellino NO[at]SPAM uol.com.br at 5/2/2005 1:44:41 PM
Hi, When I access the Product Catalog of SampleReports in ReportServer using the server name in the URL, that is, http://MY_SERVER_NAME/ReportServer?/SampleReports/Product Catalog, I can't see any images embedded in the report, I get a red "X" instead. But when I access the same URL using LO...more >>

Variables in the code window
Posted by Fez at 5/2/2005 1:30:08 PM
Is it possible to declare variables in the code window. And if you can, can you please show an example?...more >>

Stability Issue-**Urgent
Posted by Mark at 5/2/2005 1:14:58 PM
Has anyone experienced any stability issues since upgrading to SP2? I am having a problem with the SQL server since the install & want to rule out Reporting services before I uninstall. I installed 4/28 everything worked fine 4/29. 5/2 server restarting at random. The server has restarted 3...more >>

Getting values for page header
Posted by Fez at 5/2/2005 1:02:01 PM
Hi I am trying to get the value of a dataset to populate in a pageheader. I am not sure about how to do this. The sproc returns one row and one field with the value I want. I put a list in the body of the report and place the field in the listbox. In my page header I reference the textbox in t...more >>

Unable to Export to Excel from remote machine using SSO Login
Posted by Balaji at 5/2/2005 12:45:50 PM
Hey Peeps, Can somebody help me with my issue. I am trying to export a sql report from the report manager that is existing on remote box and all other reports are exporting just fine except for this one report. When I export this "One" report, it makes me wait for like 5 minutes(which is ir...more >>

Does SP2 have calendar control?
Posted by Jake Smythe at 5/2/2005 9:47:48 AM
Hello, If I recollect as the VSLive! conference Microsoft stated that SP2 would have a calendar control for RS. Is this true? Thanks in advance. ...more >>

Bind many tables from a single sp on many tables on a single repor
Posted by luspo at 5/2/2005 7:08:01 AM
Hi, i've a single stored procedure that return many tables from different select queries. it is possible to bind on a single report all "recordset" on different tables? in other words how i can "navigate" the source dataset, is possible to refer to a kind of dataset index? ex. dsname[1], dsn...more >>

execute functions in sql reporter service
Posted by DEME-Carlo at 5/2/2005 7:03:04 AM
Hello a. How can I calculate in a function in SQL reporter the date for tomorrow. Now I've filled in a criteria {fn > now()} which shows me all the coming projects from today. I only want to show reports for tomorrow. I know how to do it in VB.NET but can I used in SQL reporter service ?...more >>

Works on Firefox, not on IE
Posted by Eric at 5/2/2005 6:10:08 AM
Hi, I try to browse my report on Internet Explorer and images never load. The data that should initially appears on the page loads, but when i try to collapse or expand datalists nothing happens. The only instance in which it works fine is when I load a PDF, then I try to expand a datal...more >>

Changing field type
Posted by Anna at 5/2/2005 4:47:11 AM
I'm using my own data processing extension to provide a dataset to a report - the dataset is beging generatied by VB code and passed in form of XML to the report as a parameter. Everything works fine except from that type of all fields is String (although they are passed as doubles in the code...more >>

Filter options
Posted by Juergen at 5/2/2005 12:31:05 AM
I can combine two filter conditions only by AND, but not by OR? Why? ...more >>

URL Parameter Passing Syntax!!!
Posted by James Woo via SQLMonster.com at 5/2/2005 12:00:00 AM
Have two bar Chart reports One called DrillThrough and another is DrillTO. The DrillTo accepts two parameters: pManager and pManagerName. Under ACTION >> Jump to URL I have the follwoing syntax on the DrillThrough report: http://myserver/reportserver?%2fReportsByManagerS% 2fByManagerRolledup&...more >>

Code Access for user Authentication Custom Assembly not working!
Posted by Kevin at 5/2/2005 12:00:00 AM
I have modified the CustomSecurity forms authentication assembly to include a call to Authenticate users to an external MySql database. The code calls the MySql.Data.dll assembly 1.0.4 from MySql. I have added the MySql.data.dll assembly to a codegroup in the rssrvpolicy.config for Code Acce...more >>


DevelopmentNow Blog