all groups > sql server reporting services > october 2005 > threads for wednesday october 26
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
converting reports
Posted by HSalim[MVP] at 10/26/2005 9:03:13 PM
Hello.
Any one know of a utility to convert reports from Access and Crystal into
SRS?
Thanks in advance for any input
Regards
HS
... more >>
Update Parameter Value based on another parameter being changed
Posted by Kezza at 10/26/2005 7:39:03 PM
Hi All
I have to parameters they effectively offer 2 methods of finding the same
kind of data.
First the id, second the employee name (with the id as the value)
If a user selects an id then I would like the second parameter's value to
reflect the change(jump to the same record so that they ... more >>
vbNewLine bug -- please provide a workaround
Posted by davedave at 10/26/2005 7:08:02 PM
If I set the value of a textbox to
=vbNewLine & vbNewLine & vbNewLine & 12345 & vbNewLine & vbNewLine & 67890.
then I would expect it to be rendered as
-- blank line --
-- blank line --
-- blank line --
12345
-- blank line --
67890
but instead, when rendering to PDF, it comes out as
12... more >>
Generating reports dynamically
Posted by IP at 10/26/2005 6:10:02 PM
I am new to reporting and Yukon and trying to understand reporting services.
I am trying
to determine if it is possible to define reports programmatically and send
them to a yukon server (or SQL server 2000) and have it generate an Excel
report and place it at the specified location on the f... more >>
rs:about the Scope parameter of a aggregate function
Posted by aoeabc at 10/26/2005 4:44:02 PM
A valid scope is the name of a grouping, dataset, or data region. Only
groupings or data regions valid scope is the name of a grouping, dataset, or
data region. Only groupings or data regions .
the meaning of data region? for example?... more >>
Perform aggregate against group value
Posted by SevDer at 10/26/2005 4:36:13 PM
Is there a way that I can perform my aggregate function agains the value in
group row instead of details row?
Because I do not show numeric values in the details but group row.
--
SevDer
http://www.sevder.com
A new .NET Source For .NET Developers
... more >>
Report subscription execution order in a schedule?
Posted by Susan at 10/26/2005 4:18:29 PM
When a schedule is triggered are the subscribed reports all executed
immediately or sequentially?
... more >>
Specifying Parameter Default value as NULL
Posted by pmud at 10/26/2005 3:00:05 PM
Hi,
In the parameter properties dialogue box, i want to set the Default Value of
a parameter as null. how can I do that?
I tried = Null in the Default value. But that didnt work.
Any help is appreciated.
Thanks
--
pmud... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
ice…
Posted by NotCpiP at 10/26/2005 1:47:14 PM
Just find out that for small size table, reporting service works fine. When
the size/total record of the table is increasing, the display process becomes
slower and slower. I managed to trace it and find out that in my case,
300,000 records consumes more than 2 minutes for the report manage to... more >>
RS 2005 - Paraemeter "Groups"
Posted by Jason L Lind at 10/26/2005 1:11:04 PM
Hi, I am investigating moving one of my client's reports from ASP 3.0 based
to RS 2005. Many of their reports have Paremeter "Groups" such that a report
can be displayed by entering a daterange, a week number or a month. The
stored procs are designed to only take the daterange paremeters and t... more >>
EXPORT TO PDF - double lines won't export
Posted by krister tidics | FOX IT at 10/26/2005 12:58:07 PM
Has anyone seen this before:
if you set the borderstyle for any cell to double, when you export to
PDF, it appears as a single line. Is there a work-around for this,
aside from a adding another row? These are pretty complicated reports,
and I don't want the added overhead of managing the visibil... more >>
ReportViewer control and scaling issue
Posted by Keith at 10/26/2005 12:30:02 PM
When using the reportviewer control on a web page, we would like to set the
width and heighth to a percentage of the container that it is placed in. It
appears that the defaults are 400px. Of course these can be changed, but you
may experience horizontal and/or vertical scroll bars or a wind... more >>
Enable parameter selection
Posted by Alex at 10/26/2005 11:38:03 AM
I have two reports. On Report1, I have a hyperlink action that brings up
Report2, passing the required parameters it needs. But when Report2 is shown,
I don't have the ability to change the parameters, E.g. in Report2, I have a
parameter in a list with a Show\Hide options. When getting redirec... more >>
Optimizing Reports
Posted by Weston Weems at 10/26/2005 9:47:45 AM
I've got a report thats somewhat time consuming that runs on my
reporting server, and what I've found is that if I select anything more
than a few months in my daterange parameters, its like 5 minutes to run.
What I'd like to know...
Can I snapshot a years worth of default data, and have t... more >>
My browser times out after 30 seconds; others don't
Posted by Bob at 10/26/2005 9:38:41 AM
I have several reports on a Reporting Services server. Most reports
take less than 30 seconds to download to my browser - I can see them
fine. One particular report takes a minute to download - others can see
it, but my browser times out after 30 seconds.
I get the message:
"The page you are ... more >>
RS 2005 with other browsers?
Posted by Ross at 10/26/2005 9:17:59 AM
Hi all
Can anyone report on how well the early releases of RS 2005 works for
browers other than Internet Explorer, especially FireFox? This was the
main thing that prevented us using RS behind our customer portal
website.
I'm not so concerned about the toolbar etc but more the html for
rel... more >>
Formatting a string from the code
Posted by chalexan at 10/26/2005 9:15:02 AM
I have a textbox that displays the amout of free disk space in megabytes.
I'm working on converting it to gigabytes and if it's less that one gig, I
want to display the string "Critical" bold and in red. Can this be done?
Thanks.... more >>
font color inside bar graph
Posted by chalexan at 10/26/2005 9:12:21 AM
Is there a way to change the point lable color of the font if it's inside of
the chart beside a bar? I have a chart that shows the percentage of disk
space free. Once the chart gets less that 25% it runs out of room to put the
point lable percentage beside the bar so it puts it on the bar. ... more >>
chart control
Posted by Bill at 10/26/2005 9:12:04 AM
I would like to set some of the properties in the chart control at run time
from the database. Is there a way to set the properties at execution time?... more >>
Installation - Only help file installs, No virtual directories or
Posted by K M Dhariwal at 10/26/2005 8:36:06 AM
Hi,
I am trying to install Reporting Services on Windows 2003 server (with no
service pack). Initially it says Visual Studio is not present which is fine,
i press next, then it goes into installation and there are no prompts for rs
components, sql database creation etc. once installation is f... more >>
Move Reporting Services Web Installation to another Web Server
Posted by Paul Ennamorato at 10/26/2005 8:03:02 AM
Setting Parameters
Posted by Chris Tollisen at 10/26/2005 7:44:06 AM
In the Parameters section of Report Manager you can specify a default value
for a parameter and then uncheck the prompt user box so the report always
runs with that parameter.
Can this functionality be set in the Report Designer or does it require
manual intervention every time?
Hope someone... more >>
Support for Mac / other browsers in 2005 version?
Posted by TNS at 10/26/2005 6:53:26 AM
We are currently considering basing a new project for a large client on
SQL Server 2005 and Reporting Services. But a large number of the users
have Mac's. Will they be able to view and create reports?
I haven't been able to find any info about what is supported on Mac and
in other browsers than... more >>
Q: SP2
Posted by JIM.H. at 10/26/2005 6:10:07 AM
Hello,
Is RS service packs cumulative, meaning can I just directly install SP2
without SP1?
Thanks,
... more >>
Should I use Reporting Services?
Posted by Peter Wong at 10/26/2005 12:36:02 AM
Hi there, I have been asked to rewrite some Access forms which generate
reports into 'ASP.NET' technology. There is a current ASP.NET system in use
with a SQL Server 2000 database. The Access forms connect to the SQL database
along with its local tables, so it would be best to remove the Acces... more >>
Sum of all groups, which scope?
Posted by SevDer at 10/26/2005 12:00:00 AM
Hi,
I have a situation as follows
TABLE
Header1---------------------
Header2---------------------
GROUP1 MoneyValue1 MoneyValue2 OtherValues
Details someotherValue1 someOtherValue2
GROUP2 AnotherValue
Footer
The output is as follows
TABLE NAME
No Heading11 Heading... more >>
Drill Down - VS ok - Report Server not ok
Posted by Kim Ellis at 10/26/2005 12:00:00 AM
I have RS reports which when run from within Visual Studio, work perfectly.
When deployed to the Report Server, drill down does not work. All other
aspects of the reports work correctly, but not drill down. Clicking the +
shows what looks like activity but the drill down section is not expande... more >>
|