all groups > sql server reporting services > july 2004 > threads for tuesday july 20
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
XML Data Input
Posted by May Liu at 7/20/2004 11:45:02 PM
I want to use my own application to retrieve SQL and process the data base on business logic. Then the result set is save in XML file. Does Reporting Service can import this XML file which already contain the data ??? ... more >>
Problem with multi parameters
Posted by Angi at 7/20/2004 11:04:40 PM
Hi,
I use this syntax to enter multi value in a parameter textbox.
="SELECT OrderID FROM Orders" & IIF(Parameters!ID.Value="","","WHERE OrderID
IN (" + Parameters!ID.Value + ")")
When value is empty "", I can get all of the OrderID.
But when I enter OrderID like 001 (the datatype of the O... more >>
Report Generator in VS.NET
Posted by adrian m at 7/20/2004 8:17:23 PM
We have a SQL server 2000 w/ Reporting services installed. I have a laptop
I use for development running Windows XP, w/ VS.Net enterprise installed.
[I know if you intall Reporting services on a Sql server with VS.net
installed you get the Business Intelligent Project types and, therefore,
ha... more >>
Exporting only a portion of a Report
Posted by Samuel at 7/20/2004 6:03:36 PM
Hi,
How I can export only a portion of report? For example can I export only
first 15 pages of a report?
TIA
Samuel
... more >>
how to export current viewing HTML report to a PDF file programmatically - to simulate the Export button in the HTML viewer
Posted by Guo, Lianghong at 7/20/2004 4:39:18 PM
I created a Windows report viewer and use the RS HTML viewer to view a
report. In order to print the report, I added two buttons in to the viewer,
one button is for Print-Preview and the other is for Print. For various
reasons I decide to use Acrobat Reader as the print/preview tool. I know how
... more >>
parameters not showing up in report manager
Posted by Dan at 7/20/2004 3:26:51 PM
Hi,
My MAIN report jumps to REPORT1 using the "jump to report:" hyperlink
action of a textbox. REPORT1 has one parameter.
Every thing works fine except I would like to be able to change REPORT1
parameter after I execute it, but it does not display when in Report
Manager.
ie. I jump from M... more >>
Security Problem
Posted by Alex at 7/20/2004 2:57:12 PM
Hi,
As report designer, when I deploy and view report, there is no problem but
for other people they get error:
Login failed for user (null). Not associated with a trusted SQL Server
connections.
What permission should be assigned to viewers?
Thanks
... more >>
How do i refer to previous row in a report?
Posted by shankar at 7/20/2004 2:56:36 PM
How do i refer to previous row in a report?
... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
localization and RS
Posted by Patrick Ruhnow at 7/20/2004 2:23:53 PM
Hi,
i want to make a report which could be called in several countries.
My question is, what kind of regional settings do RS use ???
I tried the VB.NET Functions FormatCurrency etc and i
set the regional settings on (server + client) from german to english,
but the currency value is still in ... more >>
Using temp tables in RS
Posted by Ha Vo at 7/20/2004 2:15:46 PM
Hello,
I am using a stored procedure that's using table variables and a temp table
for querying purposes. I want to create a report in Reporting Services using
this stored procedure as a datasource but it will not allow temp tables. I
am currently using SQL2000. Please help.
Thanks,
Alliso... more >>
chart and image problem
Posted by jimmy stewart at 7/20/2004 12:08:56 PM
I'm having a problem with charts and images showing up as "broken images".
It seems to work just fine when I preview a report but after I deploy them
the chart and images show up as broken.
... more >>
Dynamically Writing & Rendering Report
Posted by Simon Dingley at 7/20/2004 11:45:55 AM
I have a report which will change almost everytime it is requested. I am
building the query and writing the RDL on the fly. I don't want to save the
RDL to the report server as it will be of no future use. Is there a way to
pass the RDL as perhaps a string or something similar and ask the
Report... more >>
How can I install Report Server without VS.NET?
Posted by Stan at 7/20/2004 11:06:10 AM
VS.NET 2003 is required for the installation of the reporting services.
Question is how can I install the Reporting Server on a staging or
production box?
Thanks,
-Stan
... more >>
Microsoft .NET Framework: Unhandled Exception
Posted by Adam Bliss at 7/20/2004 8:55:32 AM
Hi,
I built a very simple report that uses a shared data source to access
an SQL server. I wanted to select all columns from a table on a linked
server. My query is simply "select * from SERVER.DATABASE.USER.table"
and it works fine in Query Analyzer. However, when I enter this query
into t... more >>
Determine what server i'm running on
Posted by G at 7/20/2004 8:29:55 AM
I've generated a report that will need to display different information
based upon where it is being run. For instance, if the report is executing
on our DVLP server, i need a title to say "Developement". Is there is simple
way to determine what environment the report is being run in? Check the U... more >>
Customize SRS Home Page
Posted by CurtisK at 7/20/2004 7:36:01 AM
I need to customize the SQL Reporting services home page with my company logo and some text. Is there a way of doing this. Thanks!... more >>
pull-down menu based on user id
Posted by JIM.H. at 7/20/2004 7:25:08 AM
Hello,
When I lunch my report I want to display a pull-down menu
based on the user id. I know how to get userid but I do
not know how I can use it to display pull-down menu, for
some user id I should not display anything. Also if I
display the pull-down, after selection I should write
val... more >>
Paging & Visibility?
Posted by fzuma NO[at]SPAM yahoo.com at 7/20/2004 7:12:45 AM
I have been trying to figure out why paging was not working on my
reports. I checked the report layout and could find nothing wrong.
Then I started turning off "features" and found that if I use this
statement in the Table Visibility box
"=IsNothing(Fields!CampaignMasterName.Value)" (w/o quote... more >>
Reporting Oracle Long datatypes
Posted by RW at 7/20/2004 7:00:03 AM
I am including a Oracle Long datatype dataset field in a table report item textbox cell and only getting 100 characters of the field displayed. Is this the maximum length possible or is it possible to display more characters?
I am connecting to the Oracle database with the Oracle provider for OLE... more >>
Navigating to another report with date parameter
Posted by Paddy at 7/20/2004 4:25:01 AM
When I navigate to another report which requires a date parameter I get the following error :
....\AppsAndAwds.rdl An unexpected error occurred while compiling expressions. Native compiler return value: ‘[BC30260] 'EH_School' is already declared as 'Class EH_School' in this class.’.
Any id... more >>
How to ... Create Custom Assembly
Posted by Chris McGuigan at 7/20/2004 3:00:38 AM
I was struggling to get started with custom assemblies until I found this post, it was a great help.
http://blogs.sqlxml.org/bryantlikes/articles/824.aspx?Pending=true
Regards
Chris McGuigan... more >>
Page Breaks
Posted by SqlJunkies User at 7/20/2004 2:00:02 AM
How can i design my data region so that i shown only 10 records per page. I mean 10 records in page1 and next 10 records in page2 and so on.
Thankx for ur help.
---
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine suppor... more >>
Running Total
Posted by May Liu at 7/20/2004 1:29:01 AM
I try to sum the weight by putting the expression
=Sum(IIf(Fields!EQP_LEN.Value = 20 And Fields!EQP_TYPE.Value = "L", Fields!CONTAINER_WEIGHT.Value, 0))
in group footer section but #Error is returned. On the contrast if the expression: =Sum(IIf(Fields!EQP_LEN.Value = 20 And Fields!EQP_TYPE.Valu... more >>
Allow null value option in Report Parameters
Posted by thepacket at 7/20/2004 12:09:03 AM
Hi,
I have very simple parameter driven report that accepts a null value.
When I enable "Allow null value" option under VisualStudio's Report Parameter, the null checkbox is checked by default when I run the report.
Is there anyway that I can uncheck the null check box by default via Visual S... more >>
|