all groups > sql server reporting services > march 2006 > threads for monday march 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 31
Changes on the design of the templates not showing
Posted by Lucrecia at 3/6/2006 9:49:27 PM
I made some changes on the design of the report's templates. I do that
locally, and then deploy and upload to the server. I haven't been able to see
those changes on the working website. I have the following:
Windows 2003 SP1
IIS 6.0
..Net Framework 1.1 SP2
SQL 2000 Enterprise Edition
SQL... more >>
ReportBuilder.exe parameters
Posted by Chris Taylor at 3/6/2006 9:36:24 PM
Hi,
Is there any way to specify to ReportBuilder.exe which server you would like
it to go to? Or at least what web service you want it to talk to via the
..application file or the .manifest file?
Thanks!
Chris
... more >>
Label Positioning
Posted by anthonysjo at 3/6/2006 7:50:26 PM
Hello All,
I have a bar chart with vertical bars. Under each bar is a label that
describes that particular bar. At some point I found a property where I
could change the positoning of the test to display either vertically or
horizontally but now I can't find that property again.
Any ... more >>
Parent child dimension from OLAP (AS) in Maxtrix control for SRS 2
Posted by Henrik Juel at 3/6/2006 5:38:36 PM
Having a Parent-Child dimension in a AS cube.
For a matrixreport I am using the buildin property UniqueName and
ParentUniqueName for grouping and drill functionality.
The report is shown fine in the VS Preview and everythings is working. When
the report is rendered in the reportmanager it ... more >>
Parameter selection that depends upon other parameter values
Posted by Ed Allison at 3/6/2006 4:37:22 PM
Hi everyone,
I am writing a report to display information for sales branches. The report
has two parameters, BranchID and StaffID. Both queries have available
values supplied by stored procedures.
BranchID is easy enough. It's query is a stored procedure with the SQL:
SELECT BranchID... more >>
Report requesting 8.5 x 14 paper
Posted by WebPhenom at 3/6/2006 2:52:44 PM
Hello,
I have created a report in Reporting Services 2.0 using Visual Studio 2005
Report Designer. The report is defined as 8.5w x 11h.
For some reason when I preview the report using the Report Viewer and choose
to print the report, the printer is requesting 8.5w x 14h paper. I don't se... more >>
Error 1603 trying to install SRS on client machines
Posted by dbcricket NO[at]SPAM hotmail.com at 3/6/2006 2:44:37 PM
Hello all. I'm hoping I can get some insight as to what's going wrong
here. We have CRM 3.0 and want to give developers SRS Report Designer
on their workstations to design some reports. I'm trying to install SRS
2000 on the first developer's machine, and after running setup it gives
me three war... more >>
Cannot create a connection to data source 'myservername'.
Posted by dba123 at 3/6/2006 2:13:19 PM
No matter how many times I redeploy my report and data sources from my
project to Report Manager, I keep getting this error when trying to run
the report from Reprt manager. It runs fine in VS 2005 though. I
don't know what else to do. I see no way to delete the report from
Report Manager in ... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Fields disappear at List
Posted by Shaw at 3/6/2006 1:13:27 PM
I just try a List data region with SQL query. It repeats few times and has
multiple pages. The first page is fine. But from second page, the first List
area (at top of page) misses all fields (only shows labels), and the rest of
page is just fine. The second page looks like that:
Label1:
L... more >>
Parameter prompt value
Posted by bosstan1 NO[at]SPAM gmail.com at 3/6/2006 12:14:44 PM
is there a way to get parameter prompt value inside the report?
If i have parameter 1 with a prompt value "Customer ID", how can i get
"Customer ID" string value?
... more >>
Can we implement Pivot Tables using MSRS?
Posted by Yogi at 3/6/2006 10:38:35 AM
Can we implement Pivot Tables using Reporting Services 2005? I need to
allow user to select the pivot column at runtime. I mean dynamically
changing the criteria for pivot tables after report is rendered.
Thanks,
Yogesh
... more >>
Easy way to copy over calculated fields to another dataset
Posted by dba123 at 3/6/2006 7:47:22 AM
I have a dataset in which I created about 10 calculated fields. I
often use this dataset for other reports. How can I copy over those
fields to the dataset I create in my other reports quickly?
... more >>
string to date
Posted by rosco at 3/6/2006 3:29:28 AM
Hi All,
I have an employee table with a safe pass column. This is 18 characters
long
e.g. SP1/84/056351/0406
The last four numbers represent the expiry date of the safe pass (in
this case April 2006). Has anyone any ideas on how to convert this?
... more >>
grouping data to a field
Posted by Jimbo at 3/6/2006 2:59:45 AM
Hey
Im doing a report wich is causing me some trouble:
Im doing a dataset selecting all values regarding the company, and then
im mapping the fields to textboxes in my VS designer. This should
result in a list with all my customers and their data.
Now below each customer i would like to p... more >>
Label field on table header
Posted by Pasquale at 3/6/2006 2:59:35 AM
I need to put on table header a label formed by a string concatenated with a
field value.
I try to do it unsuccessfully!
Is there a method to solve this issue?
Many thanks for your suggests.... more >>
VS 2005 & RS 2000
Posted by Steven Cark at 3/6/2006 2:21:04 AM
Hi All
Hope someone can help me out here. My company has forced us to start
developing in Visual Studio 2005 however they have not allowed us to update
to SQL 2005 yet due to "evaluation issues".
We currently have Reporting Services for SQL 2000 installed on the
production environment, ... more >>
Matrix Sub Total
Posted by Ganesh Ramamurthy at 3/6/2006 12:00:00 AM
Hi Experts...
I am using a matrix report. I am showing the subtotals of one of the columns
and it is comming correctly on the Right hand side of the column. My problem
is that I want the sub total to appear on the Left hand side of the selected
column insted of the Right side.
Is there a... more >>
Report deployment with RS2k, SP1
Posted by Laurent at 3/6/2006 12:00:00 AM
Hello,
I have a problem with report's deployment (SQL 2k, RS SP1). All my reports
have only hidden parameters (parameters with a prompt blank).
When I deploy from VS. NET 2003 to an empty folder on my RS server, the
prompts reappear and the checkbox "prompt user" is unchecked. That means
... more >>
|