all groups > sql server reporting services > april 2006 > threads for monday april 3
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
Fields in page header...
Posted by Pradeep at 4/3/2006 6:00:05 PM
Hello,
In my sales quotation report, I need to display the name of the
customer on every page of the report. The customer name is passed as a
data source. However, Reporting Services does not let you apply
dataset fields in a page header.
>From googling, it seems this is a common problem t... more >>
Subscribe a report with Include Report option fail.
Posted by Terrence Chan at 4/3/2006 4:32:02 PM
What I am trying to do is subscribe a report and send it as Excel.
I created two users under my SQL Server 2005. They both got sysadmin
privilege in SQL server.
1) user1
2) mydomain\user1
I have tried to use each of them and still getting different error messages.
Test1
====... more >>
How can I send the report to printer directly?
Posted by Manda Ho at 4/3/2006 4:01:08 PM
I preview the report by URL, but I'd like to know how can I send the report
to printer directly without preview?
Thanks!
... more >>
Performance Benefits of Using Multiple Servers
Posted by blabore at 4/3/2006 3:14:02 PM
My SQL Database and Reporting service are installed on the same server. I've
noticed that occasionally, the server gets pretty sluggish, which is likely
from reports being run. I have another server available which isn't really
being used much. Would there be any significant performance benefi... more >>
Is it possible to custom format the parameter dropdownlist?
Posted by ReportDesigner at 4/3/2006 2:41:46 PM
I have a reporting services 2000 report that has only one string report
parameter with a prompt 'Select a Project'. The project list contains
project names that are so long that they take up about 95% of the page
width and the View report button becomes a partially visible button
with a horizon... more >>
Accessing table cell
Posted by appu at 4/3/2006 2:24:09 PM
I have a simple table that has a couple of fixed number of columns and the
rows are populated from the database. I have a need to get the value from the
cell which i know will always be the second column and third row. Is there a
way to access that cell by maybe using indexes or is this even p... more >>
will Report Services for sqlsvr2k work on .Net Framework 2.0?
Posted by Rich at 4/3/2006 2:18:02 PM
Hello,
We are using VS2005 (and VS2003) at my place with sql server 2000. All the
workstations have .Net Framework 2.0, but the server is still on .Net
framework 1.1. Reporting services is working fine so far from VS2003 and the
server on .Net Framework 1.1. The only thing that isn't wo... more >>
Formatting a Text box
Posted by E at 4/3/2006 1:50:04 PM
I need to format a phone number parameter the user enters. Currently
when I print the parameter it displays like this ##########.
I want to format it to look like ###-###-####.
It can't be done with SQL, it must be done in the VB of that textbox.
Does anyone have any ideas?? It would save ... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Hidden parameter
Posted by Markgoldin at 4/3/2006 12:47:02 PM
I am trying to set one of report parameters to hidden. When I run the report
I am getting an error that the hdden parameter is missing a value. Can
someone help?... more >>
Missing Borders
Posted by Patrix317 at 4/3/2006 12:37:03 PM
Hi, All! I've searched through this group and cannot find a similar question.
I have a very simple report that I need to draw borders in the cells. For
example, a box around the entire report in the page or a line that goes
across the middle.
However, when I do a print preview, I can see... more >>
adding various fonts/weights to values in a string
Posted by Susan R at 4/3/2006 12:34:03 PM
HI
I am creating a form that needs to have strings of text in the text box.
The strings have numbers included and the numbers need to be a different
font. The form is built in a table, so splitting the row will not work.
Example:
Textbox 10 has the following value:
8. Fax Number
... more >>
visibility of an image
Posted by JIM.H. at 4/3/2006 11:53:02 AM
I was trying to make visibility of an image in the header true or false as
shown below.
=IIF(Fields!HeaderOnOff.Value = 0,true,false)
It seems in the heather I could not use a database field. Is there anyway I
can accomplish what I need?
... more >>
Page Breaks
Posted by David at 4/3/2006 11:45:02 AM
I want to force a page break at the end of a page at a logical place. How
can I do this?... more >>
Visibility Formula in a Matrix Report?
Posted by _Stephen at 4/3/2006 10:18:16 AM
How do I compare columns values in the report?
The Dataset options in the editor show "First" I want to show only when the
data's value in column 2 is > the value of column 1.
= (First(Fields!status.Value, "ECDBProd") < Second(Fields!status.Value,
"ECDBProd"), "true", "false")
That use of... more >>
simple IIF
Posted by Suresh at 4/3/2006 6:15:01 AM
Hi,
I have a field in which the data can come in as -1 or any other number >=0.
In my field, I have this following expression:
=iif(Fields!Feb_Result.Value,Fields!Feb_Result.Value," - ")
For -1, I want an "hyphen" in the field, otherwise whatever number that
comes in.
The expression ... more >>
|