Clearing browser session when using ReportViewer
I have a ASP.net page that contains a reportviewer control which I use
to show any one of a number of reports that are chosen on a previous
page. I do this by setting the ReportViewer.ServerReport.ReportPath
property to a value passed in from the previous page. I am getting
the problem that users are being shown a browser cached copy of the
report rather than it being updated to the live position.
If I was just pointing the browser to the report URL I could add
rs:ClearSession=true to the querystring, but how do I perform this
within code. I have tried appending this to the end of the
ReportPath, but its not having it... Tag: Using Two Columns Tag: 73629
Matrix Last Column Sort Descending
I would like to sort the following matrix data:
July-07 Aug-07 Sep-07
Type A 5 1 4
Type B 6 3 3
Type C 4 2 6
Other 5 5 5
by the maximum date column (i.e. Sep), please note this month will
change each month
July-07 Aug-07 Sep-07
Type C 4 2 6
Type A 5 1 4
Type B 6 3 3
Other 5 5 5
I have tried the following in: Properties / Groups / Rows / Sorting
EXPRESSION
=IIF(Fields!Date.Value = Max(Fields!Date.Value), IIF(Fields!Type.Value
= "Other", -100, Fields!Amount.Value), -1000)
DIRECTION
Descending
With no success.
Any help would be greatly appreciated
Thanks
Sarah Tag: Using Two Columns Tag: 73617
Not saving data with report...
Anyone know how I can *not* save data with my SQL 2005 Reporting Services
reports? I've looked everywhere, google'd, etc. You could do this with
Crystal; can you do it with SSRS? I've got lots of reports and this just
doubles the # of files to deal with...
TIA,
Mike Tag: Using Two Columns Tag: 73615
Dynamic Page Headers
Ok, I'm working on a report, it will give a list of pet charts, the
main page will have all the data for the pet, and each pet visits an
office for a checkup or problem. Each visit will be on its own page. I
currently have this working with a sub report. What I need is the data
from the pet to show up in the page header for each page on the
report. The report will be run for several pets at a time. So is there
any way to get data from the currently displayed list item into the
page header? Tag: Using Two Columns Tag: 73611
Dynamic Page Headers
Ok, I'm working on a report, it will give a list of pet charts, the
main page will have all the data for the pet, and each pet visits an
office for a checkup or problem. Each visit will be on its own page. I
currently have this working with a sub report. What I need is the data
from the pet to show up in the page header for each page on the
report. The report will be run for several pets at a time. So is there
any way to get data from the currently displayed list item into the
page header? Tag: Using Two Columns Tag: 73610
Report Server Roles - Gaining access to
Does anyone out there know how to programatically determine the Role(s) of
the Logged In User running a report?
Thanks,
Bill Mell Tag: Using Two Columns Tag: 73609
SQL Server 2005 Workgroup Edition Reporting Services
Reporting Services functionality appears to be available for SQL Server 2005
Workgroup Edition; however, Workgroup Edition setup.exe does not present an
installation option. Any advice would be much appreciated. Tag: Using Two Columns Tag: 73608
login problem with new project
I have several reports in a project that I deploy to a debug/development
environment and to production. I'm writing some different kinds of reports
so I created a new project. I've created different folders for these new
reports to go to. I updated the project configuration to point debug and
prod to the same servers but to different folders. The authentication is the
same. I use a SQL Server ID and PW stored within the report. I am admin on
both dev and prod servers.
When I try to deploy the new project reports to either environment, I get
the Reporting Services Login prompt, which I don't remember getting before.
I entered my domain user ID and PW but that did not work. I can still deploy
my old project reports with no issues. I must just be missing some sort of
project set-up step. Any ideas?
Stephanie Tag: Using Two Columns Tag: 73605
Sum Groups, Not Detail
I am running a stored procedure that calculate scores for each
measure. What I would like to do is add all the measures together to
get a total score.
The problem is, if there is more than one row of detail, the score for
that measure increases. The detail rows in my stored proc correspond
to comments people are making. Problem is, more comments increase the
total.
Is there a way to sum up group totals? Everytime I try to do a sum of
that cell, it adds in too much. I've seen ignore duplicates, but
that's not working. I even tried running total, but I can't seem to
get that right.
here's the stored proc:
SELECT
e.[Name],
[ObjectiveShortName] = o.[ShortName],
[ObjectiveDescription] = o.[Description],
[MeasureShortName] = m.[ShortName],
[MeasureDescription] = m.[Description],
[MeasureBusinessRule] = m.[BusinessRule],
[MeasureMeasure1] = m.[Measure1],
[MeasureMeasure2] = m.[Measure2],
[MeasurePartial] = m.[partialScore],
--[SortOrder] = m.[sortOrder],
[Fullscore] = m.Score,
[partial] = m.[partialScore] * m.score,
[Measure1] = CASE WHEN sc.[MeasureID] IN (26)
THEN CASE sc.[Measure1] WHEN 0 THEN 0 ELSE sc.[Measure2] / sc.
[Measure1] END
ELSE sc.[Measure1] END,
[Measure2] = CASE WHEN sc.[MeasureID] IN (26)
THEN sc.[Measure4]
ELSE sc.[Measure2] END,
[Score] = dbo.udfn_M1vsM2(
/* takes 5 args */
/*measure1*/
CASE WHEN sc.[MeasureID] IN (26)
THEN (CASE sc.[Measure1] WHEN 0 THEN 0 ELSE sc.[Measure2] / sc.
[Measure1] END)
ELSE sc.[Measure1] END,
/*measure2*/
CASE WHEN sc.[MeasureID] IN (26)
THEN sc.[Measure4]
ELSE sc.[Measure2] END,
/*busrule*/
m.BusinessRule,
/*partial score percentage */
m.[partialScore],
/*score */
m.Score),
[QTRMeasure1] = dbo.udfn_QTRM1(sc.EnterpriseID, sc.MeasureID,
year(@date1), month(@date1)),
[QTRMeasure2] = dbo.udfn_QTRM2(sc.EnterpriseID, sc.MeasureID,
year(@date1), month(@date1)),
[QTRScore] = dbo.udfn_M1vsM2(
dbo.udfn_QTRM1(sc.EnterpriseID, sc.MeasureID, year(@date1),
month(@date1)),
dbo.udfn_QTRM2(sc.EnterpriseID, sc.MeasureID,
year(@date1), month(@date1)),
m.BusinessRule,
m.[partialScore],
m.Score),
--[QTRTotalScore] = dbo.udfn_QuarterlyScore(@date1, sc.EnterpriseID),
[YTDMeasure1] = dbo.udfn_YTDM1(sc.EnterpriseID, sc.MeasureID,
year(@date1), month(@date1)),
[YTDMeasure2] = dbo.udfn_YTDM2(sc.EnterpriseID, sc.MeasureID,
year(@date1), month(@date1)),
[YTDScore] = dbo.udfn_M1vsM2(
dbo.udfn_YTDM1(sc.EnterpriseID, sc.MeasureID, year(@date1),
month(@date1)),
dbo.udfn_YTDM2(sc.EnterpriseID, sc.MeasureID,
year(@date1), month(@date1)),
m.BusinessRule,
m.[partialScore],
m.Score),
--[YTDTotalScore] = dbo.udfn_QuarterlyScore(@date1, sc.EnterpriseID),
comm.comment,
(case when o.[ShortName] = 'CUST' then 1 else
(case when o.[ShortName] = 'CLIN' then 2 else
(case when o.[ShortName] = 'HR' then 3 else
(case when o.[ShortName] = 'FIN' then 4 else 5 end) end)end)end)
sortOrder
FROM ScoreCard sc INNER JOIN
Enterprise e ON sc.EnterpriseID = e.EnterpriseID
INNER JOIN
Measure m ON sc.MeasureID = m.MeasureID INNER
JOIN
Objective o ON m.ObjectiveID = o.ObjectiveID
LEFT OUTER JOIN
(
select facID, measure, comment
from scorecardentrycomments scec
where scec.facid in (Select convert(int,Value) from
dbo.Split(@entid,','))
) comm on comm.facID = sc.EnterpriseID and comm.measure =
m.shortname
WHERE (@entid IS NULL OR
e.EnterpriseID in (Select convert(int,Value)
from dbo.Split(@entid,','))) AND
(sc.[Year] = year(@date1)) AND
(sc.[Month] = month(@date1)) AND
(e.EnterpriseID NOT IN (101, 102))
ORDER BY sortOrder, e.[Name], o.[ShortName], m.[ShortName] Tag: Using Two Columns Tag: 73604
Grouping
How could not repeat the description over and over in report with description
group?
Regards
--
Jose Valentin Rodriguez
MCP-GP
MCBMSS-GP Tag: Using Two Columns Tag: 73599
Url command. Hide part of toolbar
Hi
I want to hide a part of the toolbar "the part where you can export" in my
report, but I still want to have my parameters visible.
I have searched for commands like &rc:Toolbar=False but that command
disables even the parameter view.
Any suggestions??
Thank You
Lars Tag: Using Two Columns Tag: 73593
Security question with hidden parameters
OK, I've finally integrated our reports with our application and everything
is working as I want it except for one thing.
I have a report that hides the employee id so that users can only run a
voucher report against their own vouchers. This works like a charm except
that the employeeid shows up in the URL and all the user has to do is change
it and run the report against any one they want. (I tried this and,
unfortunately it works.)
I then tried the rc:toolbar=false and it messes up the parameters. (There
is begindate, enddate, and the hidden paramter, employeeid.) The non-hidden
parameters don't seem to be able to prompt for their values with the toolbar
turned off.
Does anyone have any idea how to prevent a user from changing the URL to run
against anyone they want?
Thanks,
Liz Tag: Using Two Columns Tag: 73579
Parameter?
In my Tabular Report i have 6 columns, for example;
Column1, Column2, Column3, Column4, Column5, Column6, Column7. Seven
different fields. My parameter is these 7 fields. So if i check only 3
fields, then i would like to see only 3 columns in my report. Is this posible?
Thanks. Tag: Using Two Columns Tag: 73578
Email problem please Help!!!
I am trying to send reports from server 1 to my department. I am using
RS2000. I keep getting the following messages below. My log file is listed
below. What do the last 3 lines mean. How can I fix this.
thanks in advance
2007-09-17 11:23:37 - ? [100] Microsoft SQLServerAgent version 8.00.2039
(x86 unicode retail build) : Process ID
2007-09-17 11:23:37 - ? [100] Microsoft SQLServerAgent version 8.00.2039
(x86 unicode retail build) : Process ID 1464
2007-09-17 11:23:37 - ? [101] SQL Server EAVARCHSQLR01 version 8.00.2039 (0
connection limit)
2007-09-17 11:23:37 - ? [102] SQL Server ODBC driver version 3.85.1025
2007-09-17 11:23:37 - ? [103] NetLib being used by driver is DBMSSHRN.DLL;
Local host server is
2007-09-17 11:23:37 - ? [310] 1 processor(s) and 768 MB RAM detected
2007-09-17 11:23:37 - ? [339] Local computer is EAVARCHSQLR01 running
Windows NT 5.2 (3790)
2007-09-17 11:23:37 - ? [129] SQLSERVERAGENT starting under Windows NT
service control
2007-09-17 11:23:37 - ? [392] Using MAPI32.DLL from C:\WINDOWS\SYSTEM32
(version 1.0.2536.0)
2007-09-17 11:23:37 - ? [196] Attempting to start mail session using profile
'eadsqlexec'...
2007-09-17 11:23:38 - ? [353] Mail session started (using MAPI1)
2007-09-17 11:24:44 - + [000] Schedule 114 has already been cached by job
0x37BB26ACF2F5504197AC64712D29C180
2007-09-17 11:25:00 - + [162] Internal request (from SetJobNextRunDate
[reason: schedule will not run again]) to deactivate schedule 114
2007-09-17 11:25:00 - + [163] 1 operations applied (0 remaining)
2007-09-17 11:33:53 - + [000] Schedule 115 has already been cached by job
0x60F08993E26C984890A82DC4376FAE17
2007-09-17 11:34:01 - + [162] Internal request (from SetJobNextRunDate
[reason: schedule will not run again]) to deactivate schedule 115
2007-09-17 11:34:01 - + [163] 1 operations applied (0 remaining)
2007-09-17 11:39:33 - + [000] Schedule 116 has already been cached by job
0xF149B3A417DA3347AC2D785F316E0F63
2007-09-17 11:43:31 - + [000] Schedule 117 has already been cached by job
0x7D3E710B7FAD2A4A865447BED79914FF
2007-09-18 13:01:51 - + [000] Schedule 118 has already been cached by job
0x0BF94B98A28CE44A940D6A156ED9162C
2007-09-18 13:03:57 - + [000] Schedule 119 has already been cached by job
0xF0936ABE00B4AE44B12C18F1655E6321
2007-09-18 13:04:31 - + [000] Schedule 120 has already been cached by job
0xFE872C88CF35504AB07A12D0A1BFFAF9 Tag: Using Two Columns Tag: 73576
Error in RSExecutionLog_Update job
I set up the RSExecutionLog_Update job from the following instructions:
http://technet.microsoft.com/en-us/library/ms161561.aspx
But when I execute this job, I get the following error:
Executed as user: SAVERSRPT1\SYSTEM. ... 9.00.3042.00 for 32-bit Copyright
(C) Microsoft Corp 1984-2005. All rights reserved. Started: 11:29:36 AM
Error: 2007-09-07 11:29:45.39 Code: 0xC020902A Source: Update
Parameters Derived Column [979] Description: The "component "Derived
Column" (979)" failed because truncation occurred, and the truncation row
disposition on "output column "ParametersStr" (999)" specifies failure on
truncation. A truncation error occurred on the specified object of the
specified component. End Error Error: 2007-09-07 11:29:45.39 Code:
0xC0047022 Source: Update Parameters DTS.Pipeline Description: SSIS
Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component
"Derived Column" (979) failed with error code 0xC020902A. The identified
component returned an error from the ProcessInput method. The error is
specific to the component, but the error is fatal and will cause the Data
Flow task to st... The package execution fa... The step failed.
Why this is happening and how can I resolve it?
Thanks. Tag: Using Two Columns Tag: 73571
KB 842423 - error delivering email
I have SQL Reporting Services 2005 and I got a problem described on KB
842423 : (error during delivery of an e-mail subscritpion with attacments).
KB is for RS 2000, but I am getting the problem on RS 2005.
I do not want change reporting services windows service account (currently
it is Network service account), so according to KB I need to add "the account
that I use to run SQL reporting services" to some AD groups. I am not sure
what account they refer to, considering that I can not add a local account to
AD.
Have anybody used this KB without changind the RS service account?
Thanks Tag: Using Two Columns Tag: 73570
Adding hyperlinks to rows in a table report
Is it possible to add hyperlinks to a table report.
I have been asked to add a link for each result in a table report to a
specific webpage.
I build the link to the webpage using queried data. (i.e.
="www.mywebsite.com/mypage/transientkey=" & fields.transientkey.value &
"&CompanyNum=" & fields.companynum.value & "&")
Any suggestions are greatly appreciated.
Thank you for your help.
--
Samyra Tag: Using Two Columns Tag: 73569
nest subreport in a tables detail section
I'm running ssrs 2k and need to put a sub report in a table row. I ran a
simple test by creating a sub report with no data source and just has
textboxes with different colored backgrounds and named it zColors.rdl. I
dragged zColors into a table cell in the detail section. I also dragged a
valid data field into another table cell and ran the report. I can see the
data cell but zColors does not show. I even resized the table row big
enough to assure being able to see the contents of zColors.
Is this even possible in ssrs 2k? and if so, how do I do this?
Thanks.
--
moondaddy@newsgroup.nospam Tag: Using Two Columns Tag: 73567
Is there a way to set the report description from the BI Dev Studi
Is there a way to set the report description from the SQL Server Business
Intelligence Development Studio? It would be nice to set the description
there and have it deployed along with the report instead of having to
create/update the description manually.
If not can someone at Microsoft consider this an enhancement request?
Thanks, Tag: Using Two Columns Tag: 73564
Query regrding extracting rdl file and developing installer for reports.
Hi experts,
I am working on MSSRS 2005 and i want to know few things about it.
I am developing reports on my system and deploying them on my client
server.
Now There are some reports which i dont have developed and i dont have
their design and query. Now if i want to
modify them how i can do that without redesigning them from scratch.
And second thing if i want to make a installer of my reports which i
have so that i can install those on any system
how i can do this.
I am not finding anything regarding these so please if any one have
any idea about the above two problems then
please suggest me ow to do this.
Regards
Dinesh Tag: Using Two Columns Tag: 73560
1 Report and 2 DBs
Hi,
I have 2 DBs with the same Tables (different Datas).
Now I will create a report over the Tables of one DB. But the user should
connect the report to the other DB.
Can I create a dynamic Connection in a report? Or can I Use report parameter
to set up the DSN?
Thanks.
Jens Tag: Using Two Columns Tag: 73552
Report Viewer Slow to Render Simple Reports
Hi I'm using the ReportViewer.Winform control verions 8.0.0.0 runtime version
2.0.50727 in my C#.NET client app. I'm experiencing extremely slow
performance rendering simple reports 35sec. I'm using 'Remote' Processing
mode, when I step through my code everything is fine until the
SetParameters() method of the ServerReport class. I've tried ensuring the
IIS does not unload the worker process by setting the idle timeout to 8hrs
but still the first hit to the server is slow and subsequent hits are slow
too (maybe slightly faster at 30sec). When I access the report outside of
ReportViewer ie. from the RS Web interface the report renders in 2sec fine.
Any suggestions please? Tag: Using Two Columns Tag: 73549
No XML export
...Newbie alert...
I am picking up a project that makes significant use of SQL2005 reporting
services. The app, as it is currently, triggers the report by launching a new
window with a URL pointing at the report server and including the parameters
rs:Command=Render&rs:clearsession=true&rs:format=HTML4.0
The new window shows the "Report is being generated" message and eventually
it is displayed. I want to get the XML version of the report, but the EXPORT
drop down only offers Excel and PDF.
This seems to be consistent with a .net report viewer control in "local
mode" (whatever that is), but I don't think that this is what's going on.
If I go to the reportserver virtual directory, there is a
ReportServer.config file. It contains, in part the following:
<ExcludedRenderFormats>
<RenderingExtension>HTMLOWC</RenderingExtension>
<RenderingExtension>NULL</RenderingExtension>
<RenderingExtension>RGDI</RenderingExtension>
</ExcludedRenderFormats>
under <Delivery> for various <Extension Name="..."> tags
It also shows
<Render>
<Extension Name="XML"
Type="Microsoft.ReportingServices.Rendering.XmlDataRenderer.XmlDataReport,Microsoft.ReportingServices.XmlRendering"/>
...
So it doesn't seem to actively exclude xml rendering and it does seem to
provide a renderer for the file type.
I've done this using the client's service provider and also on my own
out-of-the-box SQL2005 installation and have the same result on each.
I'm obviously missing something silly, but I can't figure out what it is.
Thx
Marc Tag: Using Two Columns Tag: 73535
SSRS2005 = fubar
I have installed the reporting services, configured them, created a demo report that previews.
I cannot get a deployment to operate without an error.
"Unable to connect to the remote server (Microsoft.ReportingServices.Designer)"
If I go to my localhost/ReportingServices/Home.aspx it fails.
I have given anonymous access in IIS to the RS virtual folder as well as the RS Temp.
I have given local\ASPNET dbo access as a test for both databases.
It appears that the web server is not configured. The RS configuration has been run and outside of the Encryption keys, Email Settings and Execution Account everything is shown with a CHECK.
Any ideas?
From http://www.developmentnow.com/g/115_0_0_0_0_0/sql-server-reporting-services.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com Tag: Using Two Columns Tag: 73532
Reporting service access control
Were working on a classic asp app and are trying to implement some
reports through reporting service. I have a few questions.
First the application were working on will have multiple instances, so
one a single server there can be upto 15 identical apps connecting to
different databases, is there a way to have reporting service limit
what data source reporting service can access depending on what IIS
website/application pool the browsers are accessing?
Badgers.servername.com/reportserver should open the reports with the
badgers db
Squirrels.servername.com/reportserver db=squirrels
Servername.com:54333 db=badgers
Servername.com:54334 db=squirrels Tag: Using Two Columns Tag: 73529
Scheduling SSRS reports using an external scheduling package
We use a scheduling package to coordinate the scheduling of our batch
processes on most of our systems. Is there a way to trigger the
running of an SSRS report this way? And, what the specifics of what
is takes with some examples of how and what needs to be interfaced?
Thanks, Tag: Using Two Columns Tag: 73527
SQL generated by ReportBuilder
I am getting an error when trying to access an Oracle database with a
report model in ReportBuilder. Is there a way to see the SQL that was
generated by ReportBuilder? Tag: Using Two Columns Tag: 73526
Building my own Query Designer
I have created a Custom Data Extention to query SharePoint List data directly
from within Reporting Services. I would like to replace the Generic Query
designer with my own code to make selecting columns or adding selection
critera an easier and more friendly process and can see that Microsoft have
built query designers for SAP etc.. so it would appear possible??
I have been unable to find any documentation on developing Query designers
but I am hoping that someone can help me?
Thanks
Jason Tag: Using Two Columns Tag: 73525
Report Builder/Manager Question
Hello All,
I have a report created with Report Builder that has a prompted filter. The
filter asks for 2 dates. It works beautifully. My problem is within Report
Manager. I have found that if I go into the Manager and I click on the
report then Properties>>Parameters and change the "Display Name" for my
dates ranges, I cannot get it to stay. It works for that instant, but if I
close out and go back in later to run the report it defaults back to the
default text for that field. Any suggestions on how to get my changes to
stick other than clicking on the apply button? I've done that. TIA for any
suggestions!
--
Malissa Traver
A+, Net+, MCDST, MCSA, MCT, MCBMSS, MCTS, MCITP Tag: Using Two Columns Tag: 73524
Custom Security and Deploy from VS2005
I have configured the custom Security Sample to allow forms authentication
against Reporting Services 2005.
When I navigate to the http://MyMachine/reports page I am redirected to a
login page where I enter my creds and then I am brought to the Report Manager
where all the links and reports workâ?¦ So Far So Good.
In SSMS I can connect, using forms authentication, to the report server
using the url http://MyMachine/Report Server and all works as it shouldâ?¦ So
Far so Good.
However, when I try to deploy a new report or model from Visual Studio, the
Reporting Services Dialog pops up, I enter the creds and hit OK and the
dialog pops up again (and again and again). When I cancel out of the dialog
I get the dialog â??Microsoft Semantic Model Designerâ?? which tells me that
â??A connection could not be made to the report server
http://MyMachine/reportserverâ??
Any nudge in the correct direction would be greatly appreciated.
Kindest Regards and thanks in advance. Tag: Using Two Columns Tag: 73523
Visibility and Page Width
I love the use of the iif statement for visiblity when certain criteria are
met; however, when I apply this to columns in a table my page does not resize
to either get smaller when the visible columns disappear.
Is there a way to resize a page width when visible columns become invisible?
--
A person not willing to take risk is also not willing to get reward. Tag: Using Two Columns Tag: 73522
Report automatically runs with null params allowed. SSRS 2000
I see that other people have had a problem with this, but I never saw
a solution or a work around. Has anyone found a work around to this
issue? I want to allow nulls in all the parameters, but I don't want
the report to run by itself in Report Manager.
And does anyone know if this is fixed in SSRS 2005? We'll be
migrating to that later this year.
TIA Tag: Using Two Columns Tag: 73520
Emails Are Being Lost - Not Sent
I am running SQL Server 2000 Reporting Services SP2.
I have data driven subscriptions that are being logged in the
reporting services logs as being emailed successfully, but there is no
record of them in the email server logs. Only some of the recipeints
are not receiving the emails - most of them do go through succesfully.
Has anyone else experienced anything like this? Where should I look? Tag: Using Two Columns Tag: 73518
passing row to custom code
I wish to pass the current row to a custom function in reporting
services....does anyone have the syntax for this?
It would looking like: txtMybox.value =
ParseInformation( current_row)
Thanks Tag: Using Two Columns Tag: 73517
Performance Issues when executing Stored Procedure from RS2005
Dear All,
We are facing a really strange performance issue while dealing with
the Reporting Services 2005. Here are the facts :
-RS 2005 calls a stored procedure to display the report
-the stored procedure takes around 30 seconds when executed from the
Query Analyzer
-the same stored procedure with the same parameters called from the
Reporting Services takes more than 200 seconds !!!!
Can anyone give me at least an idea of where to look to solve this
problem?
Best regards,
Stefan
http://www.itsconsulting.fr Tag: Using Two Columns Tag: 73516
Help with error
What does that mean:
a.. Execution 'q31hav45ug5ptl553ott5tjl' cannot be found
(rsExecutionNotFound) a.. a.. Tag: Using Two Columns Tag: 73508
Shared Schedule and many reports
Hello,
Does anyone know if reports added to a shared schedule are executed
sequentially or all at the same time? We have a lot of intensive reports
that run nightly and would like to put 30+ on the same shared schedule for
ease of administration but don't want to bring the sql server to a screeching
halt. We have one clustered database server holding the application
databases (and report server databases) and two load-balanced web servers
running the reporting services service and front end.
Thanks,
Rob Tag: Using Two Columns Tag: 73507
Reporting Services and Barcodes
How do I embed a barcode in my report without using 3rd party software?
Thanks
Smitty Tag: Using Two Columns Tag: 73501
Issues Installing Microsoft CRM 3.0
I've set-up Microsoft Small Business Server 2003 R2. I had set-up Microsoft
Office 2007 so I could install Business Contact Manager with SQL Express
2005. I deleted it so I could upgrade the system for Microsoft CRM 3.0.
I attempted to install it but as soon as I try, it gives me this error
message:
DBNETLIB][ConnectionOpen(Connect()).]SQL Server does not exist or access
denied
I'm not sure what to do. Can anyone help? Tag: Using Two Columns Tag: 73499
RS.exe
I have a web based application that allows users to apply for
employment via the web. Once the appllcaition is submitted I want to
send the details to HR via email using SSRS 2005.
I'm not very familiar with rs.exe utility which is the tool I think I
need to use.
I would appreciate it if anyone has done something like this before
and can point me in the right direction it would be greatly
appreciated. Tag: Using Two Columns Tag: 73495
Grouping/Sorting question
When using Grouping in a report, is there a way to force a group to start on
the next page if the group will not fit on the current page? I believe in
Access or Crystal Reports there is an option called keep together that
provides this functionality.
Thanks. Tag: Using Two Columns Tag: 73493
Uploading a Report
I just finished editing a report in reporting services...I want to upload the
report but the menu isnt available to me when I go to
http://localhost/reports. Also when I log into the reporting services engine
using sql server 2005 studio I try to right click any node to get the
properties, the feature is grayed out. This is both when I log in as a
domain admin and when I log in using the sa account. How can I upload my
report!!!
-Jim Tag: Using Two Columns Tag: 73488
Rowcount in subject of mail
When creating an email subcription it is possible to create a subject with
reportname and executiontime. Is it possible somehow to show the numbers of
rows in the report in the subjectline ? A cutomers want this to indicate
that the report is empty..
TIA
Bobby Henningsen Tag: Using Two Columns Tag: 73486
Determining Report Server Role of Logged in User
How can I find the Report Server role of the User running a report?
Would the Globals variable of UserID be used?
If so, how, if not how does one do it.
Thanks,
Bill Mell Tag: Using Two Columns Tag: 73485
data driven subscription for a very large number of reports
I created a data driven report for each of our clients for my
department. Management asked if I could run it for every client for
the entire firm (about 8,000 clients!). Each report is about 10 pages
and includes multiple graphs. I'm afraid it will take too long to
create the reports. I was thinking about creating multiple data
driven subscriptions, so it will create multiple reports at the same
time.
How does reporting services handle a data driven report? Does it
create a queue and create multiple reports at the same time? Would
creating multiple subscriptions (using a different set of clients)
speed up the process?
I don't know a way to cancel a data driven subscription. Will
creating these reports greatly affect other users who are running
reports on the server? Can reporting services handle this, or am I
going to bring down the server by doing this? Tag: Using Two Columns Tag: 73484
Reports only render sometimes
I am experiencening the folowing problem with RS SP2. My reports do not
render all of the time, sometimes they run fine in a few seconds other times
they simply do not run. These are small reports with only a few hundred
records in the dataset.
They are using store procedures to generate the data and the stored
procedures always finish, so i am assuming it is at the rendering stages
where i am experiencing this intermittent problem.
Has anyone any idea where to start looking or diagnosing. I can see no
logic or pattern that is causing the reports to fail only sometimes.
I would be the most grateful man in the world if somebody could help.
--
Gerry Connolly Tag: Using Two Columns Tag: 73483
Find servers runnign reporting services
How can I enumerate only those servers running reporting services in
c#.
I can get a list of all SQL Server instances on the local network
using:
SmoApplication.EnumAvailableSqlServers(false)
How can i filter this list to include only those instances where
Reporting Services is running?
Thanks in advance
Dave Arkley Tag: Using Two Columns Tag: 73480
Using .NET business classes as a data source for SSRS
Hi, all,
Suppose I have a set of .NET business classes to return data.
How can I use them as a data source for an SSRS report? (this is for
ssrs2005)
As far as I can tell, the only way is to create an XML web service that
calls the .NET classes, and then define that XML web service as the data
source.
Is there another way?
Thanks,
Kevin Tag: Using Two Columns Tag: 73466
How to display the time stamp of a cached report
Anyone know how to include in a report a text box with a function that shows
the time/date of the most recent cache? This is a cached report, no history,
with an expiration interval of 60 mins. I see no functions that would
display the time of the most recent cache (when the snapshot was taken), nor
do I see any ways to display it in report manager.
Thanks for any advice. Tag: Using Two Columns Tag: 73465
Filtering a calculated field
Hi everyone, I created a calculated field (=Fields!RUN_RATE.Value /
Fields!STANDARD.Value)
this field gives me my % of Standard field. I want to be able to
display anything over 200%. I tried filtering it as a group filter,
but when it runs it first shows everythin ok, I put my dates
(parameter), right when I click to view report, it gives me an error
displaying:
An error has occured during report processing.
The processing of filter expression for the table 'table1' cannot be
performed. The comparison failed. Please check the data type returned
by filter expression.
Any ideas, comments, remarks?????
Thanks,
Abner Tag: Using Two Columns Tag: 73464
How do I keep parts of a column row from being added to column two etc.?