all groups > sql server reporting services > october 2006 > threads for friday october 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
Dynamic SQL Stored Procedure problem
Posted by AB at 10/20/2006 6:20:39 PM
Hi,
I have a project that all its reports are based on Dynamic SQL Stored
Procedure. First, I had to handle the problem that in the Layout Tab
there were no fields by adding them manually. However, when I try to
show the report in the Preview tab I got the error: "Procedure x
Expects a paramete... more >>
Reporting services caching data !!!
Posted by fitim skenderi at 10/20/2006 3:53:07 PM
Hi all,
I have a smart client application that hosts an instance of IE. After user
selects different seetings (parameters) create a URL and ask the IE to
navigate to it. First time I get proper data.
The problem starts when user clicks on the button to view the same report
with same parameter... more >>
double-hop authentication for SSRS and ASP
Posted by susiedba NO[at]SPAM hotmail.com at 10/20/2006 3:25:03 PM
hey
I work in a SSRS environment; I also do some web dev.. and we keep on
having authentication problems getting a token to pass from one user to
the webserver; and then to the database server.
this is called 'double-hop' authentication.. right?
I'm of the understanding that I need to che... more >>
No Report Server was found at http://<servername>/ReportServer
Posted by mmc at 10/20/2006 12:42:02 PM
I installed two instances of SQL Server in one machine (2000/2005).
1. On SQL 2000 (after the .rds and .rdl files are set up) - Whenever I
press F5 on VS.NET 2003 the error is: "No Report Server was found at
http://<servername>/ReportServer
2. On SQL 2005 (after the DS,DSV,RM are set up)... more >>
Parameter bar collapsed with JumpTo
Posted by Steve at 10/20/2006 12:01:02 PM
I have a report that I am jumping to from another report. It has several
parameters that are passed in, which I don't want to show. That part works
fine. It also has one that is defaulted that I want displayed so that the
user can change the values. The problem is that when the report is jumpe... more >>
ReportViewer does not print on first attempt
Posted by Cathy at 10/20/2006 12:00:03 PM
Hi,
Has anyone found a solution to the problem of the reportviewer not printing
the first time you try to print? We found a solution on another newsgroup
but it doesn't fully resolve the problem.
Me.ReportViewer1.SetDisplayMode(Microsoft.Reporting.WinForms.DisplayMode.PrintLayout)Me.Report... more >>
Formating a numeric string, that is sometimes text
Posted by msflinx at 10/20/2006 11:30:02 AM
The old string didn't move up when I replied to it, so copied the information
into this new question
---------------------------------------------------------------------------------
OK -- this works to a point. I have real string data in my field that I want
to display, if the field is not... more >>
complex report
Posted by Chop at 10/20/2006 10:43:01 AM
have the following data from a query
age sex
39 M
48 F
14 M
etc...
need to be displayed as
Age Group Number of Male Number of Female Total in Age Group
0 -2 2 3
5
3 - 9 ... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
displaying date ranges in the report header
Posted by jai at 10/20/2006 10:19:04 AM
I am using a table to structure my report.
Body of the report
Table header
Group Header
Details
Group Footer
Table Footer
Earlier I had put the report name with the company logo in the report
header section but now I moved it to the body of the report just above
the table. I am trying... more >>
Custom assembly call in footer looses property values.
Posted by Steve MunLeeuw at 10/20/2006 9:22:21 AM
Custom assembly call in footer looses property values.
I have a custom assembly that uses a method in the body to pass in a data
field. When I fetch the data in the body I get my data back. When I do the
same in the footer I don't get any data. I have an active call in with
Microsoft so wi... more >>
Possible to grab Report Authors name to use in report?
Posted by JH at 10/20/2006 8:31:03 AM
Hi all,
We would like to put the Report Authors name in the footer of our reports. I
know there is a global "User!UserID" that picks up whoever runs the report,
but is it possible to pick up the windows logon, or something to
automatically fill in a field for report author?
Thanks
JH
... more >>
how to limit the characters in the string report parameter?
Posted by Vinod at 10/20/2006 8:26:03 AM
i have added one string parameter in the report. is it possible to
limit the characters in the string parameter. so that use cannt enter
the characters more than 30.
any suggestions
Thanks
Vinod
... more >>
Problems using Split function
Posted by JH at 10/20/2006 7:39:02 AM
Hi,
I'm trying to use the common text function "Split" to split the report name.
An example report name would be "REF001-Title of Report". I'd like to be
able to split this report name global into "REF001" and "Title of Report"
However I can't get my head around the way Reporting Services... more >>
sql_variant is invalid error
Posted by randy1200 at 10/20/2006 6:41:02 AM
Using Visual Studio 2005 is create Reporting Service 2005 reports.
In the Layout tab, I click Report -> Report Properties -> Code tab, and
enter the function below.
Then I go to the Data tab, click the elipse (...), and go to the Parameters
tab.
I create a parameter as follows:
@UtcL... more >>
String Date Reformat
Posted by randy1200 at 10/20/2006 6:03:01 AM
I get a date value as a string from the following t-sql:
select Convert(varchar(30), GetDate(), 11) as 'TheDate'
which returns a yy/mm/dd format.
Please don't ask me to changethe t-sql. In this instance, that's out of my
control.
In my Reporting Service 2005 report, I thought I could r... more >>
Report Services Bug? ----Sub Report and Page break!!!
Posted by CEO at 10/20/2006 4:55:02 AM
When the main report calls the meeting sub report, if the content of the sub
report is longer than the pare space on the current page, it will jump to the
next page without filling the rest space on the current page.
Is it a bug of Report Services?... more >>
Users Cannot See Report Builder Button
Posted by Paul Paintin at 10/20/2006 12:00:00 AM
Hey.
New server, SQL2005 including Reporting Services - as a domain admin I can
log onto the Report Manager website, see & click the Report Build button all
good.
A 'normal' user browses the site and cannot see the Report Builder button;
they can run the Report Builder app using the dire... more >>
|