all groups > sql server reporting services > august 2006 > threads for thursday august 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 31
SSRS 2005 - Logon Failure: Unknown user name or password
Posted by wardellcastles at 8/3/2006 7:35:19 PM
Whenever I run a report in SSRS 2005, I receive the message:
Logon failed (rsLogonFailed)
Logon failure: unknown user name or bad password. (Exception from
HRESULT: 0x8007052E)
Can someone give me a hint as to what the report was logging into when
it failed?
Was it the data source log... more >>
Possible todo some form of DISTINCT filtering?
Posted by Tarun Mistry at 8/3/2006 5:43:08 PM
Hi guys, I have a dataset that returns rows that look like the following
field | value
-----------
1 | 7
1 | 7
2 | 4
8 | 90
Is it possible to remove the duplicate (1 | 7) row directly within a LIST
control (or similar?)? I cannot use a DISTINCT directly in the SQL as
e... more >>
how to total fields within footer
Posted by silverblatt NO[at]SPAM att.net at 8/3/2006 1:21:27 PM
I have a report footer which includes a number of totals fields. Each
of those fields is computed based on various fields in the data set,
using some rather long expressions.
What I need now is to add a new "super total" field that displays the
sum of three of the other total fields. The onl... more >>
next line
Posted by Ben Watts at 8/3/2006 12:45:39 PM
is there a way in an expression that I can tell it to carry over to the next
line?
... more >>
chart visibility
Posted by Ben Watts at 8/3/2006 12:19:23 PM
Is there a way to may a chart show up if there is no data shwoing up. I
have a pie chart and when there is nothing to sum it doesnt show, I would
either like it to show up or display a message in lieu of that.
Thanks
... more >>
Learning the Basics
Posted by CLM at 8/3/2006 11:32:01 AM
What's the best way to learn the basics of Reporting Services (for 2005 for
starters)? Is there a site/article/book/link that has what I need to get
going?
I just want to get the installation going and set up a few basic reports.... more >>
Convert DateTime Parameter to String
Posted by RAGHAVAN JAYARAMAN at 8/3/2006 11:16:11 AM
I have 2 reports and i have enabled Drilldown(Navigation) for the 1st Report.
One of the Parameter is DateTime which is passed to the 2 reports which should
treat this parameter as string since it's defined as string. How will i
convert the
DateTime to string Parameter for the Drilldown report.... more >>
Report Builder Problem
Posted by Mike Read at 8/3/2006 11:03:21 AM
I am having trouble with the Report Builder toolbar button is not showing up
on the reports pages of my reporting services.
If I run
http://servername/reportserver/reportbuilder/reportbuilder.application then
it will open the report builder and I can built reports and save back to my
rep... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Error report: Interactive sorting loses the image reference
Posted by Steve MunLeeuw at 8/3/2006 9:47:00 AM
I have a table using the interactive sort feature and an image on each row.
On the report server when I sort the column the images are lost and a broken
link is displayed. In the Designer preview window the images are not lost.
Anyone else share my experience, and does anyone know how to work... more >>
Very Strange Pagination Problem
Posted by randy1200 at 8/3/2006 9:02:01 AM
Working with SSRS2005.
A while back, I created a report that makes a new report page for every
record in the database. I found that making the background one big list1 box,
then putting textboxes with values like field!recordid.value in them gave me
exactly the one database record per page ... more >>
Insert a Page
Posted by sperotti at 8/3/2006 8:17:03 AM
Is there any way to insert a page into a report programatically or otherwise.
I have a report where the users want to choose to insert a coverpage in a
report. The scenario is that the user has a report options screen in the
user interface. One of the options is to create a coverpage. If t... more >>
Custome code not working in Report manager
Posted by RajDeep at 8/3/2006 2:07:41 AM
Hi all,
I have Written the Custom code to compare two different dates and
show a message Box depending on their values .It was Working Fine in
preview tab.But it is not working when i deploy to web.Only rhe message
box part is not working in Web
I do have the Custom code like this
Publi... more >>
Change all FontFamily
Posted by ad at 8/3/2006 12:00:00 AM
How can I change all the font family of all controls in a report?
... more >>
Dynamic columns in report
Posted by Tanmaya Kulkarni at 8/3/2006 12:00:00 AM
hi,
In RS2005, is it possible to add / remove report columns dynamically. I mean
the user will have choice to see which columns he wants to see in the
report. Depending on his selection, the report will be rendered.
Is this possible?
TIA,
Tan
... more >>
Comments
Posted by Steve Dearman at 8/3/2006 12:00:00 AM
Does anyone know how to add a comment in a sql statement in reporting
services, all the normal types e.g
/*comment*/
and
-- comment
Dont work, it just removes then as soon as you move away from the sql
window.
could maybe be a menu choice but i cant find it!
Help please
Steve D
... more >>
|