all groups > sql server reporting services > january 2006 > threads for tuesday january 31
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
Moving Reporting Services
Posted by Jason Wood at 1/31/2006 8:51:55 PM
I have two servers, one being the SQL server with RS db, one being the
webserver with reporting services on it. I want to replace this webserver
slowly by installing reporting services on a new server but at the same time
being able to access the reports on the old server until we take it off... more >>
DateTime Picker does not work all the times
Posted by Minal at 1/31/2006 5:22:26 PM
Hi,
I am using DateTime parameters for SQL 2005 Reports that are converted
from SQL 2000. The report works fine for me but my client complains that the
Datetime pop-up does not come up always on clicking the date button. It comes
up but at times after 3-4 clicks.
Any idea as to why ... more >>
Possible to Create Report model - mySQL
Posted by carolus.holman at 1/31/2006 1:40:30 PM
Is it possible to create a Report Model based on a mySQL server? i am getting
errors: ERROR [42000] [MySQL][ODBC 3.51 when connecting. Ihave been able to
write standard reports but am running into this issue. Also I was looking
into using the DotNet Data connector but cannot figure out how to ... more >>
ReportViewer control doesn't accept Parameters
Posted by Raghu at 1/31/2006 1:14:15 PM
Hello,
I have developed a web application that uses ReportViewer Web control
supplied with VS 2005 RTM version. The ReportViewer control uses
Network credentials to connect to a remote SQL 2005 server to get the
reports. It works fine for reports that doesn't use any parameters.
But, for the ... more >>
Help with embedded code for SSRS Report
Posted by dba123 at 1/31/2006 1:06:27 PM
How can I create a VB.NET function to run my query below that my SSRS
report can run to retreive TotalPostingDays so I can show that in a
textbox in my report? I need help creating the function in the Report
properties of my SSRS report and not sure how to call this stored
procedure to return T... more >>
custom sercurity extention and ssl
Posted by Marvin at 1/31/2006 12:48:34 PM
can the custome security extension for forms authentication use ssl?... more >>
Report Builder problem with no All level on Scenario?
Posted by FurmanGG at 1/31/2006 12:15:29 PM
At first glance, this appears to be a bug in Reporting Services...
I have a 2005 cube with a Scenario dimension. On the Scenario attribute I
set IsAggregatable to False (since it doesn't make sense to add Actuals and
Budgets). This effectively removes the All level, as I understand it. I've
... more >>
Annoying feature - report service rewrite query automatically.
Posted by qye2020 at 1/31/2006 12:06:46 PM
This feature is very annoying, report service 2k rewrites my query, even the
format of query is changed too. How to disable this feature?
Thanks really a lot.
... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
User Roles / add remove users
Posted by SC at 1/31/2006 11:11:27 AM
Hello
Does anyone know why the Home page of the reporting services displays ALL
the reports to ALL the domain users?
I would like to set the site so that I can restrict or not the users to see
the reports.
Thank you so much in advance... more >>
Upper case format
Posted by Kyriakos at 1/31/2006 9:13:27 AM
Hello all,
does anybody know the format code for upper case field formating?
I.E. in MS Access it's the greater sign ">" and turn all the fields text to
upper case.
Thanks.... more >>
Login problem publishing to my machine from VS2005
Posted by dgk at 1/31/2006 9:10:32 AM
So I'm trying my first Report project from Visual Studio 2005 and I
get a good connection string and run the project. When I run it it
tries to deploy to http://localhost/reportserver, and asks for a login
and password. But nothing works. I don't even think I have a password
set up for reporting... more >>
VS.NET Crashes EVERYTIME
Posted by carolus.holman at 1/31/2006 7:11:27 AM
Everytime I use VS.NET 2005 to Author Reports the IDE Crashes. It crashes
when I click Exit, it crashes when I uses the Query designer, I fully expect
it to crash everytime! Anyone else see this happening? Any one know why it
crashes all the time? ... more >>
Dynamic grouping problem
Posted by msdnuser at 1/31/2006 6:56:30 AM
Hi all,
I need a certain functionality in my Reporting service report.
I need a report with 4 levels of grouping above the detail level. The
initial visibility of all the lower levels should be hidden expect the top
most level. For all the levels toggle item is set in the group properties... more >>
Tabel in table -> Header missing
Posted by Maran at 1/31/2006 6:51:30 AM
I have a table(No.1) with several groups. I have inserted another table(No.2)
in one of the groups footer. Both tables have the same DataSet as source and
groups with same Column.
Everything works fine except that the Header and Footer, for table2, will
not be rendered. I have hardcoded val... more >>
Trying to email out reports
Posted by JaffaB at 1/31/2006 4:29:07 AM
Hello,
I have a SBS2003 running with SQL Reporter, and I want to try and get
it to email to the excahnge server (on the same box) the copy of the
report. Can anybody point me to what the settings should be in the
RSReportServer.config file?
At the moment, I am emailing it out to my yahoo ... more >>
IIF Function in Dataset
Posted by Sme at 1/31/2006 1:55:27 AM
I am trying to build my dataset WHERE clause with the IIF function.
I have 4 parameters that include a "ALL" option and that is what I am trying
to cater for.
Have done is successfully when there is only one parameter involved,
IIF (Parameters!Rep.Value = "0", " WHERE A.Region = '" &
Parame... more >>
Best Practice, Stored Procedures & Datasets
Posted by Jay Sanderson at 1/31/2006 12:00:00 AM
Hi,
Would be interested to hear your thoughts on whether is best to minimise or
maximise the use of stored procedures in SQL Reporting. Is it best to have
as much as possible coming from Stored Procedures or is it better to have as
little as possible. At this stage I am more concerned abou... more >>
Creating Subscriptions
Posted by Jay Sanderson at 1/31/2006 12:00:00 AM
Does anyone have any good examples of programmatically creating
subscriptions using the SQLRS web service ?
rgds,
Jay
... more >>
|