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 14

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

Exception of type System.OutOfMemoryException was thrown
Posted by Ponnurangam at 9/14/2004 5:19:59 PM
Hi, Once in a while I get this error when working in reporting services I am unable to save the changes made if I get this error I increased PF Usage Memory size, but that does not work can someone help me with this Thanks Ponnurangam ...more >>


RunningValue Function for Year over Year Comparison
Posted by sfibich at 9/14/2004 3:58:36 PM
I have a query which returns sales dollars grouped on a yearly basis, along with some other groupings. How would I display the year information in a matrix and still be able to compare the first year to the second. The data set returned has a column for dollars and one for years, it does n...more >>

assigning a data source
Posted by Richard Cranium at 9/14/2004 3:35:38 PM
Is there any other way to a assign a data source to a report other than through the Report Manager. The reason I ask is because when I try to browse for data sources in Report Manager, I get "Object reference not set to an instance of an object". Microsoft tech support seems unable to help ...more >>

Clients??!
Posted by Kjell Brandes at 9/14/2004 3:35:22 PM
Is there any way to write reports for WAP, or other clients?? K ...more >>

Generating a Group of Reports
Posted by Dex at 9/14/2004 2:46:20 PM
We are thinking of a possible requirement for our custom application (which will use Reporting Services), but we are unsure if it is possible. Say you have 20 individual reports. And, these 20 reports are split up into 4 report groups (5 reports per report group). This is more of a logical g...more >>

2 charts, a matrix and a possible bug...
Posted by JohnHennesey at 9/14/2004 2:00:00 PM
I have a report that has 2 charts on top, followed by a table, then another table, then a matrix and I am seeing some strange behavior: The two charts are side by side, then the rest is in a veritcal fashing going down. when the chart on the right is to the right of the matrix definition on ...more >>

Formatting parameters
Posted by Bender at 9/14/2004 12:56:10 PM
Hi! I would like to change date parameter from 4/30/2002 12:00:00 AM to 30.4.2002 in report. How can parameters be formatted? Thanks Roman ...more >>

Header and Footer in Sub Report
Posted by Ponnurangam at 9/14/2004 12:05:59 PM
Hi.... I have a Main Report that has a sub report When I preview the Main Report, the header and footer of sub report does not gets displayed in the Main Report Can someone help me with this Thanks Ponnurangam ...more >>



Hosting providers for Reporting Services
Posted by Scott at 9/14/2004 11:40:38 AM
Does anyone know of any hosting providers who support Reporting Services? Thanks, Scott ...more >>

quick question!
Posted by Richard Cranium at 9/14/2004 11:38:58 AM
Can RS Developer Edition be installed on machines which do not have Visual Studios installed? -- ...more >>

exporting to pdf
Posted by Lee Hopkins at 9/14/2004 11:31:24 AM
I have a report I am trying to export to PDF but it is only showing one page and then it won't turn landscape. I have set up the page as landscape on the report page and also when I open the report. and I still only get one page no it is about 4 or 5 long....more >>

Diagram, sorting and series groups
Posted by Tibor Karaszi at 9/14/2004 11:25:10 AM
Say you have two values for each region: current month and previous month. I have a column in datase called period_offset (0 for current month and -1 for previous month). I want to sort the diagram over current month, where previous month is just for informational purposes (previous month is a...more >>

Reporting Services Architecture Question
Posted by Christian Donner at 9/14/2004 10:59:22 AM
I am planning to use RS from a Java application and I was wondering if someone can share experiences and discuss lessons learned with me, particularily in regard to using the Web Services interface vs. the URL interface. I would like to stream the reports through my Java application and have a p...more >>

Changing Parameters Dynamically
Posted by chrispragash NO[at]SPAM hotmail.com at 9/14/2004 10:57:39 AM
Hello All, How do I change paramters dynamically based on user selection. For example if I let the user select country in a drop down, and based on the country, I need to load the states parameter, and based on the states, the counties parameter etc...Is such a dynamic layout possible using r...more >>

dynamic reporting
Posted by Sumudu Prasad at 9/14/2004 10:09:55 AM
Hi Experts... I want to create report on the fly, for given mdx query , I mean without having a pre build report format, and I am using FoodMart 2000 sample database. pls give me some ideas...... Thanks in Advance.... ...more >>

Excel Rendering Extension: Width of excel cell in the excel sheet exceeded the maximum limit of 1726.5 Points.
Posted by Benjamin Pierce at 9/14/2004 9:58:51 AM
Hello, I have a fairly simple report (with a lot of columns) that I'm trying to export to Excel. Everytime I do this, I get the following error: "Excel Rendering Extension: Width of excel cell in the excel sheet exceeded the maximum limit of 1726.5 Points." I know that 1726.5 equates to ...more >>

Very Large Log Files
Posted by Dean at 9/14/2004 9:29:15 AM
Today I noticed that the C:\ drive on our test server was out of disk space. I researched and found that 7.7 GB of data was contained in the following folder: C:\program files\microsoft sql server\mssql\reporting services\logfiles Most of the log files are 6 - 45 k, but on 9/11/04, 239 files...more >>

Using pocketpcs
Posted by Gerry Salceda at 9/14/2004 8:02:18 AM
Hello, Has anyone tried to run reports from Pocket Explorer on an HP IPAQ? I could only get the menu bar and not the report body itself. Is there a compatibility issue with Pocket Explorer? Would it be better to publish or export the reports to HTML instead? Thanks for the advice. ...more >>

Regional settings for date in Reporting Services?
Posted by Si Downes at 9/14/2004 3:19:02 AM
I'm not sure whether I'm missing something but are there some reginoal settings in Reporting Services/Report Manager to set the format of the date? date fields are being brought from SQL Server in UK format but displayed in Preview and on the deployment server in US format, MM/DD/YYYY. I...more >>

URGENT : How to add columns dynamically at Runtime?
Posted by SqlJunkies User at 9/14/2004 2:30:57 AM
Hi, I am a novice in SQL Server Reports. I need to create a report wherein user will key in the parameter and depending on the parameter the columns in the report shd vary at runtime. i.e. i am trying to produce output based on a from date and to date with an interval which the user will ent...more >>


DevelopmentNow Blog