all groups > sql server reporting services > october 2006 > threads for thursday october 12
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
SQL Timeout building report model
Posted by Davidlev at 10/12/2006 10:08:01 PM
Hi,
I am trying to build a report model that contains a very large table (22
million rows). When the wizard gets to the part 'Calculating Column
Uniqueness' on the very large table, I get an SQL timeout. Is there a way to
increase the timeout on this process? My datasource that it uses has a ... more >>
why is BIDS cutting my Sql Statement in HALF?
Posted by susiedba NO[at]SPAM hotmail.com at 10/12/2006 6:08:19 PM
hey MS
i'm pasting this sql statement into a subquery in BIDS
AND IT KEEPS ON DROPPING THE WHERE CLAUSE
grow some balls MS and hire some real testers you fat lazy stupid lame
company.. and for once; why dont you hire some people that SPEAK
ENGLISH
I mean seriously here.
WHO THE FUCK... more >>
Dundas help topic missing: 'Start from Zero' property
Posted by Steve MunLeeuw at 10/12/2006 5:27:26 PM
I searched the Dundas help for this property but found nothing. I've been
experimenting with a stacked bar chart trying to work around another issue
related to sorting the bars from left to right with a zero line and having
the same order in the legend. I don't see that the property affects ... more >>
Dundas: Feature request: Allow expression on enabled property of chart legend
Posted by Steve MunLeeuw at 10/12/2006 3:51:32 PM
In our horizontal stacked bar charts we use a zero line as a watermark.
Because we need to re-arange the sort order from left to right, rather than
from the zero line we use a custom legend. Depending on the data availible
we show one of two sets of statistics. I'd like to build two custom l... more >>
Can't Access Reports, Server App Unavailable, and Error and SQLServerAgent Can't Access EventLog Error
Posted by EoRaptor013 at 10/12/2006 2:29:13 PM
Somehow or another, our http://OurSQLServer/Reports has gone south. On
the web interface we get this message:
"Server Application Unavailable
The web application you are attempting to access on this web server is
currently unavailable. Please hit the "Refresh" button in your web
browser to r... more >>
Table control columns difficult to resize with embeded rectangles and tables.
Posted by Steve MunLeeuw at 10/12/2006 1:47:40 PM
I can't remember where you post feature suggestions, so if you know please
respond with a link.
I'm maintaining a report that contains a table with nested tables,
rectangles, and merged columns. I wanted to add a column on the far left to
indent a section of the table. After doing this I'... more >>
hot key for "Expression" in VS2005
Posted by Dmitry Duginov at 10/12/2006 1:27:37 PM
Is there a hotkey for "Expression" right-click menu item in report designer?
--
Regards,
Dmitry... more >>
A connection could not be made to report server
Posted by AB at 10/12/2006 12:40:22 PM
Hi,
:Every time I try to Deploy report I get this error
A connection could not be made to report server
http:// localhost/reports/pages/folder.aspx
I have already tried:
1. Define my user
2. I can see the report manager from the browser
3. change to asp.net 2
4. find out that the IIS use... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Creating a hyperlink within a report to access specific CRM screen
Posted by Tony at 10/12/2006 12:29:01 PM
Does anybody know how to create a hyperlink within a report to access
specific CRM screen?
Thanks!... more >>
repoting services charts rendering
Posted by Passx at 10/12/2006 12:13:00 PM
Hi Guys
Can any body help me for this problem.
I am having a table and two charts. These charts are places one below
the other. When ever i view the report the first chart shows up fine at
the side of the table. But the other chart which was placed below the
first chart shows up after the t... more >>
"Pages breaks" when I add a page footer to the report
Posted by gdjoshua at 10/12/2006 11:04:01 AM
i have a report that calls several subreports. I had everything working fine
until I added a page footer to the main report. All I put in it was a small
textbox that is going to hold page numbers....
Anybody know why its page breaking? I hope it has nothing to do with the
implicit keep t... more >>
Saving subscription reports in database
Posted by John Scott at 10/12/2006 10:10:01 AM
I was wondering if it was possible to have a Subscription report write back
into a table on the database??
Thanks in advance,
John Scott.... more >>
timeout expired when building model
Posted by Dan D. at 10/12/2006 8:25:02 AM
Using VS2003. I was trying to build a model for a table with 17M rows. The
process timed out around 90 minutes. Where can I increase the timeout setting?
Thanks,
--
Dan D.... more >>
Secruing RS
Posted by Brennan at 10/12/2006 7:36:02 AM
Hi All:
We are using RS 2005.
I want to take away the New Data Source and Upload File options from the end
user interface for regular users. Is this possible?
Thanks
... more >>
"Global" Report Parameters
Posted by florian at 10/12/2006 7:06:00 AM
Hi,
I have a report with 3 different datasets. How can I add a parameter to
this report which works or is valid for all the 3 datasets?
Thanks
... more >>
List of all folder permissions
Posted by madrigal at 10/12/2006 6:53:57 AM
Is there a way to get a list of all folder permissions per folder? We
are in the process of cleaning up two Reporting Services boxes that
have gotten way out of control, including permissions. Part of this
process is assigning users to roles, rather than individual permissions
on folders. But... more >>
rsInvalidReportServerDatabase-Error after installing SP2
Posted by Sandra Geisler at 10/12/2006 5:17:01 AM
Hello all,
I have a W2003 Server machine running Sql Server 2000 SP4 and Reporting
Services with *now* installed SP2 (before SP1). After installing the service
pack, I get the following error (sry, its german):
"Die Version der Berichtsserver-Datenbank liegt in einem Format vor, das
nich... more >>
Dynamicly displaying Page Header and Page Footer
Posted by Wendy at 10/12/2006 1:47:02 AM
I need to show or hide Page Header and Footer on the last page of a report
based on a parameter. Is there a way of doing this?
Thanks in advance
... more >>
How to add parameters to a MDX query in RS 2005?
Posted by Kaisa M. Lindahl Lervik at 10/12/2006 12:00:00 AM
I'm currently struggling with parameters when doing reports based on SSAS
2005 in RS 2005.
How do I add a new parameter to an MDX query, after having built the query
using the wysiwig query builder? I could probably start all over again to
use the query builder, but I can't figure out how to ... more >>
Problem with Report viewer
Posted by Tan at 10/12/2006 12:00:00 AM
Hi,
I recently upgraded by ASP.Net 1.1 application to 2.0. 1.1 application =
was using awReportViewer to view the reports.
But, when upgraded, awreportViewer doesnt display the RS2005 =
enhancements like sorting, etc...so I decided to replace it with Report =
Viewer control in VS2005.
Now ... more >>
for dgk and anyone else who knows
Posted by Nick Hatzis at 10/12/2006 12:00:00 AM
Thanks a lot dgk. You covered both cases and the second was the case
needed. Although an other problem arised. I got this error message :
"The source of the report definition has not been specified"
I thought that when you set the report in the report viewer control
the work is done but unfo... more >>
Incorrect page rotation when printing
Posted by Grant Morgan at 10/12/2006 12:00:00 AM
I have two machines on my network, that when printing a RS2005 report,
rotate the page incorrectly. ie. Print a portrait report in landscape,
cutting off the bottom of the report.
I am printing by using the print button in the RS2005 control from a web
browser.
... more >>
|