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 2006 > threads for wednesday september 6

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

how to hide refresh button
Posted by jmr at 9/6/2006 8:53:09 PM
I'm using vb.net and using Microsoft.Reporting.WebForms.ReportViewer Since I'm not using refreshing button on report tool bar I need to hide it so client won't confuse is any body help me how to hide refresh button on report tool bar any help would be nice ...more >>

Validating user input
Posted by JL at 9/6/2006 7:34:12 PM
I am new to Report Services and can not find out how to validate or force a format for a user entered parameter. For example, I want to select on a date field so I want to be sure the user enters a date value. Please advise how this is done (or I want a numeric, non-zero value, etc) TIA John...more >>

How to use the TOP(N) Filter syntax?
Posted by Tarun Mistry at 9/6/2006 6:12:06 PM
Im tearing my hair out on this one. Could anyone provide information on how to use the "TOP(N)" filter syntax? I want to return the top 10 aggregate rows. Not sure if it can do this? Please help! Thanks Taz ...more >>

Limiting bars on a chart?
Posted by Tarun Mistry at 9/6/2006 5:59:36 PM
Hi, I have a chart control that is working very nicely indeed. Is there a simple way to limit the number of bar that are drawn? I.e. I only want say the top 10 bars showing. My dataset is large and displayed 300 bars is too much/a mess. I dont want to filter the dataset, as the bars are co...more >>

Dataset filtering... how?
Posted by Tarun Mistry at 9/6/2006 4:53:16 PM
Hi all, I want to create a summary page for one of my report, depending on a parameter, I would like to filter the dataset before creating the summary fields. I cannot figure out how to perform this filtering, my approach has been to insert a Table control and map it to my dataset, then ...more >>

How do I get decimal set to 2 in a column?
Posted by SRussell at 9/6/2006 4:44:42 PM
I am getting frustrated that I can't force a column to display .50 or .00 thus allowing numbers (double) to line up properly? now I have units in the column NEXT to this one so I don't want to apply formatting to all columns :) This is a C# form based report if that means anything different...more >>

Selecting 'All' from the Data tab in Visual Studio
Posted by nthompson NO[at]SPAM gmail.com at 9/6/2006 3:38:49 PM
This has been bugging me for ages.... In the Data Tab when you run a query to preview the data before it gets merged with the layout, Visual Studio will prompt you for the values of any parameters it needs. What do you have to enter in order to view all results? (ie. to get the equivalent o...more >>

Remove "blank" space?
Posted by Ripley at 9/6/2006 3:38:09 PM
I have a report that contains a table with two rows. Each of these rows contains a table with a header row, detail row and footer row. When the report loads, these inner tables expand to 5-20 rows of data. All well and good. However, sometimes the top inner table has no data to render. But whe...more >>



Drilldown reports
Posted by Mark Goldin at 9/6/2006 2:44:58 PM
I want to show a list of accounts and when a user clicks on one show account's details. What is a best way of approaching that? Thanks ...more >>

Autoname exported pdf
Posted by panna_balaji NO[at]SPAM yahoo.com at 9/6/2006 1:17:22 PM
Hi , We have a report that is frequently exported to pdf by the users Is there a way such that after a report is exported to pdf , when the user says save a copy it shows the user a default name (using a parameter passed to the report) instead of something like my%5port%5report2.pdf ? ...more >>

Report Builder and Oracle Database?
Posted by panna_balaji NO[at]SPAM yahoo.com at 9/6/2006 12:54:26 PM
Hi, I'm trying to use the report builder for the first time. Is there a way to create an Oracle datasource in a report model project ? Thanks, Panna ...more >>

Tab Delimited Export
Posted by JT-ARL at 9/6/2006 12:10:02 PM
I am trying to configure the CSV Rendering extension to export a tab delimited text file. According to all the documentation, it seems like I have everything configured properly. However, when I export the data I get a comma delimited file. Is there something in the export data that could...more >>

Force No Page Break
Posted by dev648237923 at 9/6/2006 11:12:23 AM
Hi -- I have a Report that generates a table with a lot of rows. Reporting Services breaks my report up into 13 pages. I'd like it to be all one giant table. Is there a way to force no page breaks? Thank you! ...more >>

custom subscription schedule
Posted by Lynn at 9/6/2006 9:46:02 AM
Is it possible to modify the subscription schedules such that you can avoid sending reports on non-production days? Holidays, for example? I've got a few simple subscriptions, each configured to run the reports on 'Every Weekday'. But, what of the holidays? Is there anyway to account for ...more >>

Attempted to divide by zero
Posted by bjkaledas at 9/6/2006 8:21:02 AM
I have the following expression as a Calculated Field: =IIf(Fields!PROJ_Y.Value <> 0 Or Not Fields!PROJ_Y.Value Is Nothing, ((Fields!PROJ_Y.Value-Fields!ACTUAL_Y1.Value)/Fields!PROJ_Y.Value), 0) and I get the error "The Value expression for the field ‘GROWTH_Y’ contains an erro...more >>

Error 444 - Permission denied.
Posted by dbutler at 9/6/2006 7:20:02 AM
OK, I'm at a complete loss. Any advice on the following would be greatly appreciated. What I've got is multiple reports that are heavy process intensive(multiple datasets, multiple joins, etc). Reports usually take between 25 and 35 minutes. All was fine until yesterday. Now the reports seem ...more >>

clicking the green triangle
Posted by M NO[at]SPAM at 9/6/2006 6:15:54 AM
a lot of these posts for changing the subtotal value talk about clicking on the green triangle. I do that, but nothing happens. Do I need to enable something? ...more >>

report services for 2000 sql
Posted by rjj2004 at 9/6/2006 5:16:01 AM
does anyone know where i can go download report services 2000 for sql? i can not find my orginal cd's. thank you,...more >>


DevelopmentNow Blog