all groups > sql server reporting services > april 2005 > threads for monday april 11
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
IDBCommandAnalysis
Posted by Dan at 4/11/2005 10:03:02 PM
Has anyone implemented this interface?
If so would you be willing to share your code?
Cheers :D... more >>
IDbCommandAnalysis
Posted by Dan at 4/11/2005 9:40:02 PM
Has anyone implemented this interface before?
Would someone be willing to share some code please?... more >>
Previewing RDL without Designer
Posted by Rakesh at 4/11/2005 9:31:02 PM
Folks,
Is there a way to preview the "RDL" Reports programatically without
deploying to the report Server.
We needs this ability for the creation of ad-hoc reports where user designs
the contents of the report...
Any idea...? Appreciated...!
Rakesh
... more >>
Dynamic Grouping
Posted by Hari at 4/11/2005 7:46:02 PM
Hi all
I have a table which has employee information like
empno, empname, empsalary, empmgr. The empmgr column points to empno.
I want to create a report which will dynamically recognise the employees
under a employee and show his salary. The other requirement is that i want to
enable dr... more >>
Previous Business Day
Posted by Jadranka at 4/11/2005 6:04:02 PM
At the moment, I have a report that's using "=Today.AddDays(-1)" to return
yesterday's date in the date range parameters, but the client has now come
back and requested that they would prefer not to use weekends...e.g.: loading
the report on Monday should show last Friday's date.
Can this b... more >>
Multiplication Aggregate
Posted by ddinulos at 4/11/2005 5:20:02 PM
Hi,
Is there an equivalent to the SUM() aggregate function but instead of doing
a summation, I'd like to do a mulitiplication. Is there a way to achieve this?
Please help. Thanks!
... more >>
Report runs in preview in VS.net 2003, but not on Report server
Posted by Fredrick A. Zilz at 4/11/2005 5:12:15 PM
I have a report which I have published to my Report server (sql 2000 on
windows 2003). This report runs from my VS.net developers edition preview
page, but once I publish it to my Sql reporting services report server, it
will not run - there is a long delay, then I recieve repeated prompts fo... more >>
Textbox cell formating
Posted by lucl at 4/11/2005 2:00:33 PM
some description text in the database may contains html tags that has been
entered by the user through a web application. Is there any way to format a
Textbox using reporting services reports to apply these tags, or to just
ignore them? I don't want to see these tags at display.
thanks
... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Text Color does chnanges when Export to Excel
Posted by BALAJI KRISHNAN via SQLMonster.com at 4/11/2005 1:09:34 PM
Hi All,
I have a issue...
I am doing a conditional formatting of a field..
= iif(rtrim(Fields!bCorrectAnswer.Value) = "True", "Green","Black"), this
epxression is added on Color property of the field - Field!Answer...
Now when I run the report it is giving the color change and when I export... more >>
Programmatically doing new role assignments
Posted by david.seruyange NO[at]SPAM gmail.com at 4/11/2005 1:03:58 PM
Hello everyone -
A friend of mine is having some trouble using the browser based method
of assigning roles and I suggested that we do it programmatically just
in case errors were being suppressed by IE. So far I've seen a lot of
code that creates roles but none that assigns the role to a Wind... more >>
Update Report Bug?
Posted by Roman JR. at 4/11/2005 12:56:02 PM
Hi,
Could someone confirm if this is a known bug?
When I uploaded a new version of the report to the server, all linked
subscribers can only view the previous version of the report in their "My
Reports" folder. They can not access the new version of the report, until I
manually recreate ... more >>
LogonUser
Posted by darkeagle at 4/11/2005 12:55:02 PM
Hi All,
There is anyone that have a sample code (working) that show how to use the
LogonUser API?
Thank you
... more >>
Seeking Reporting Services Consultant
Posted by Chris W, AgriBank at 4/11/2005 12:04:02 PM
I have a short term requirement for a Reporting Services consultant.
Interested parties should contact cworthi@isd.net (off-line) for further
information.... more >>
Long Queries Hang VS; Other Productivity Killers
Posted by Bassist695 at 4/11/2005 11:55:01 AM
Whenever I run long SQL in VS whether it's in the Data tab or in Preview
mode, I can't seem to get a report out of it. I'm talking SQL in excess of
200 lines.
I can run the SQL fine in Query Analyzer but running it in the Data tab, it
freezes VS, and when I run the Preview, the report never... more >>
Page Size as a Report Parameter?
Posted by moflaherty at 4/11/2005 11:05:03 AM
This might be a newbie question, but can the page size be set as a report
parameter?
Thanks!
Michael... more >>
Formating
Posted by Vinny Vinn at 4/11/2005 10:10:03 AM
I have a field which returns a decimal (3.0000) i only want the whole
value(3) not the parts (.0000) to be displayed in the report.
when i right click on the textbox and select propeties then under the
'format' section i click on 'number' and select '1234' hit 'ok' and preview
the report it ... more >>
Sending Email Error
Posted by Dave at 4/11/2005 10:10:02 AM
I am still having problems sending reports via email through Reporting Service.
The error being thrown is:
ReportingServicesService!library!850!04/11/2005-12:55:02:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has... more >>
Unable to Connect After Admim PW Change
Posted by Brian Ackermann at 4/11/2005 10:05:53 AM
In a previous thread (Unable to Connect After Admim PW Change):
http://groups-beta.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_frm/thread/ce818354b7ccb707/5cf80dcf743691a6
Mr. Peter Blackburn suggests :
>What you can do is change the Domain Administrator's
>password back... more >>
Substring?
Posted by Vinny Vinn at 4/11/2005 9:22:02 AM
How can i substing a field within the report as opposed to substring the sql?
TIA,
Vinny... more >>
first day of previous month date parameter
Posted by pcalv at 4/11/2005 8:45:02 AM
Hi,
Hope somebody can help.
I am looking for the code to place in the default value of a parameter wich
will give me the previous months first days date (i.e. last month would be
01/03/2005).
I already have code for the last day: =DateSerial(Year(Now), Month(Now), 0)
so something sim... more >>
No longer able to open up .rptproj
Posted by DBA72 at 4/11/2005 8:18:02 AM
My visual studio .net application previously had not problem opening .rptroj
files, but now it tells me "Make sure the application for the project type
(.rptproj) is installed"
Also, when I try to create a new project, the "Business Intelligence"
project type is not listed. I have seen some... more >>
Bar width
Posted by Hawkeye at 4/11/2005 7:09:04 AM
My question:
- How can I change the width of the bars in a simple column chart diagram
generally?
- I've got the problem that all my bars look like lines.
... more >>
login prompting
Posted by kamel at 4/11/2005 6:43:08 AM
Hi,
Every time I browse folder hierarchy or opening report itself I got
additional widows auth. login prompts using
"http://ip_address/Reports" instead "http://ComputerName/Reports".
I am using Basic Authentication and Windows 2003 Server which is Domain
Controler.
Need help to solve tha... more >>
Printing an image or PDF from C#
Posted by Lee Davies at 4/11/2005 6:14:01 AM
I am returning a PDF stream from SQL Reporting Services and I want to send
the output straight to a printer without any user interaction.
Any ideas how this can be done?
I would rather not use the Printing extensions of SQL Reporting because of
limited time.
... more >>
Generating a personalised report for every vendor and mailing out the same
Posted by karenmiddleol NO[at]SPAM yahoo.com at 4/11/2005 4:40:45 AM
I have the following reporting scenario.
I have a table which contains a list of customers/vendors and each
record in this table as the customer/vendor number, name and email
address of the vendor and also the record as the value of the business
done by the vendor/customer for this month, year... more >>
Still problems with Windows 2003 sp1
Posted by NH at 4/11/2005 2:10:01 AM
Hi,
I am just reposting an issue here, hopefully by reporting it it might catch
someones eye. Help on this would really be appreciated. I have tried the
suggested fix from this post..
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=d2f44745-4... more >>
Binary parameters to stored procedures?
Posted by Damian Cugley at 4/11/2005 12:00:00 AM
I have a stored procedure that takes a byte string as an argument:
CREATE PROCEDURE Reporting_TicketSelectGroups
@publicPart NVARCHAR(400),
@checkField BINARY(46),
@langCode VARCHAR(9)
AS
...
I've created a DataSet with the name of the stored ... more >>
Shared Data Source Problem
Posted by Sceptical at 4/11/2005 12:00:00 AM
Hello,
I create a RS project in VS 2003 and add a shared data source, then add a
report and the report uses the shared data source, so far everything's
great, when I add one more project to the current project, I can not use the
data source I created on the other project. Instead I need to... more >>
Creating user groups with Forms Authentication
Posted by Sceptical at 4/11/2005 12:00:00 AM
Hello,
Is there a way to implement groups with forms authentication? Currently I am
only able to create users and being able to generate groups would greatly
help.
Thanks
... more >>
Report get time out.
Posted by Sandeep at 4/11/2005 12:00:00 AM
Hi all,
I am facing a problem of report time out for some of the my reports.The
report seems to be taking too long and then times out.But when the new
browser is opened immediately after the report comes in minutes. And the if
I close the browser before it's get timed out and open the new bro... more >>
|