Integrated Security: report

Showing posts with label report. Show all posts

Friday, March 30, 2012

Internal Email subscription fail

I'm having an issue with subscriptions. I created a subscription to
email a report both to an external address and internal address. The
subscription worked fine (Mail sent to ... ) in RS. The outside
entity received the email, but the internal entity does not receive
the email. Is there some configuration I'm missing on the exchange
side in order to accept a connection from RS? Thanks
DaveOn Aug 31, 3:29 pm, Dave <david.brueg...@.gmail.com> wrote:
> I'm having an issue with subscriptions. I created a subscription to
> email a report both to an external address and internal address. The
> subscription worked fine (Mail sent to ... ) in RS. The outside
> entity received the email, but the internal entity does not receive
> the email. Is there some configuration I'm missing on the exchange
> side in order to accept a connection from RS? Thanks
> Dave
It sounds more like your Exchange Server is filtering out the
extension type (i.e., PDF, MHTML, etc) of the report attached to the
email. Also, I'm not sure what the 'from' email is set to from SSRS;
however, if it is different than what is expected by the Exchange
Server, it may flag it as Spam. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultantsql

Wednesday, March 28, 2012

intermittent locks

We are experiencing problems intermittently.

Users report problems of various types including timeout messages. We investigate and find a user has acquired a lock which is blocking other users.

We contact the user and they have usually completed their activity and are not always aware of any problem despite them owning a lock.

When the user logs out of the application the lock clears and the system returns to normal.

Indexes have been rebuilt, auto update statistics is on.

Does anyone have any suggestions? :cool:The first thing I'd do is start watching for locks to determine how often they occur, and ask the users if they know of any activity that causes the problems associated with locking/blocking (that may give you clues about what you need to watch).

Once you understand what you are looking for, run a trace using SQL Profiler at the same time as a Performance Monitor trace watching for locking/blocking. The PerfMon trace will show you when the problem occurs, the Profiler trace will show you what caused the problem.

When you understand the cause of the problem, you can then look at changing the application to avoid the problem.

-PatP|||We are trying to gather more information from the users to track this down.

Anecdotally users believe that they have finished their activity and are simply still logged on or are running searches.

We haven't needed to kill a session, the user simply logs off.

It's almost as though the lock has been taken but not released when the activity has finished.

Does this sound likely/possible? If so any ideas what could be causing it?|||Does this sound likely/possible? If so any ideas what could be causing it?Yes, it sounds rather likely.

I'd suspect that the problem is something that the code is doing "behind the curtains" that the user is completely unaware of, but is still causing havok. Until you can compare the two traces (or provide LOTS of additional insight into your application and server configuration), we can only guess.

-PatP

Intermittent field display

This is either a bug, or I am crazy.

I have developed a report that pulls its data from an SSAS cube. The report is grouped on Fields!FacilityName. On each "page" of the report, I have information for the displayed facility.

At the top of each page in my report I have a textbox whose value is =Fields!FacilityName. Further down on the report I have another text box whose value is set exactly the same. When I preview the report, I always have a value in the upper box, but only sometimes have a value in the lower box. If I change the value in the lower box to just a text string, it will always display, but when I put in the actual field reference it does not. It always doesn't display for the same facility names. Remember, the upper textbox on the form always displays 100% of the time.

I have a Dundas chart in the middle of the page on the report between these textboxes, but another field that pulls parameters and even a matrix all render correctly below that chart.

They both have the same parent according to the properties. I have even copied and pasted the working textbox further down the screen, with no improvement. When I changed the value of the textbox to "=cstr(len(Fields!FacilityName))", on the pages when it wants to be blank, it reads 0, and on other pages it shows a larger number. But the other textbox on the screen will always properly show the FacilityName.

I have also tried changing the name of the textbox, settings output to YES instead of Auto. If I slide the non-working textbox up to the top of the page and the working textbox down to the bottom area of the page, the bevavior switches.

Does anybody know of rendering issues with textboxes showing the same infomation?

Are you running at least SSRS2005 SP1 (on the server and for BI Dev.Studio)?

-- Robert

|||My server is running Microsoft SQL Server Reporting Services Version 9.00.2047.00, and I am using VS 2005 with the most recent service pack on my development PC. Both exibit the behavior I describe.
Could it be something odd in the XML of the report that I just cannot see in the IDE?
|||We are running 9.00.2047.00 on the server, and my VS 2005 is up to date. Maybe there is something buried in the XML of the RDL that I just cannot see in the IDE that is causing the problem.|||I also have a ticket in with Dundas since when I remove the chart off the report, the textbox renders correctly. Perhaps the chart is breaking the recordset in some way.

Intermittent email issue

We are having a problem with a report that is scheduled to be emailed
only works sometimes. Other time it fails with a "Reporting Services
Failure sending mail: Cannot access a closed file" error message.
The report is running off a snapshot that is generated every half hour
and a subscription is setup to email the report to some users. The
snapshot is generated even when the email fails.
It seems the problem is pointed to by userName: [DOMAIN\username]not
found in the database. This seems to be a security problem - but why
would it work sometimes? The log file is below for reference. The user
in question is in the same domain as the report service is running
under.
Environment:
Report service SP2 running on a Windows 2003 EE with SQL Server 2000
Active Director Domain server running on Windows 2003 EE
The report server service is running under a domain account that is in
the local administrator group on the local server.
Has anyone seen this problem?
Thanks
ReportingServicesService!library!2b4!09/02/2005-09:09:38:: i INFO:
Initializing EnableExecutionLogging to 'True' as specified in Server
system properties.
ReportingServicesService!session!2b4!09/02/2005-09:09:38:: i INFO:
LoadSnapshot: Item with session: tc2ixx55bnczhjifyjr2z42q, reportPath:
/Company Reports/MyReport, userName: [DOMAIN\username]not found in the
database
ReportingServicesService!chunks!2b4!09/02/2005-09:09:38:: i INFO: ###
GetReportChunk('MyReport_style', 1), chunk was not found!
this=38c10bb1-1bae-4d41-a03e-f56437fc3c86
ReportingServicesService!emailextension!2b4!09/02/2005-09:09:38:: Error
sending email. System.ObjectDisposedException: Cannot access a closed
file.
at System.IO.__Error.FileNotOpen()
at System.IO.FileStream.Read(Byte[] array, Int32 offset, Int32
count)
at
Microsoft.ReportingServices.Library.PartitionFileStream.Read(Byte[]
buffer, Int32 offset, Int32 count)
at
Microsoft.ReportingServices.Library.MemoryUntilThresholdStream.Read(Byte[]
buffer, Int32 offset, Int32 count)
at Microsoft.ReportingServices.Library.RSStream.Read(Byte[] buffer,
Int32 offset, Int32 count)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.EmbedReport(IMessage
message, RenderedOutputFile[] reportData, Notification notification,
SubscriptionData data)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.ConstructMessageBody(IMessage
message, Notification notification, SubscriptionData data)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.CreateMessage(Notification
notification)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification
notification)
ReportingServicesService!notification!2b4!09/02/2005-09:09:38::
Notification 2180101f-6faa-41b7-b1a0-b3217c5d630e completed. Success:
False, Status: Failure sending mail: Cannot access a closed file.,
DeliveryExtension: Report Server Email, Report: MyReport, Attempt 0
ReportingServicesService!dbpolling!2b4!09/02/2005-09:09:38::
NotificationPolling finished processing item
2180101f-6faa-41b7-b1a0-b3217c5d630ejmbackup1024@.gmail.com wrote:
> We are having a problem with a report that is scheduled to be emailed
> only works sometimes. Other time it fails with a "Reporting Services
> Failure sending mail: Cannot access a closed file" error message.
> The report is running off a snapshot that is generated every half hour
> and a subscription is setup to email the report to some users. The
> snapshot is generated even when the email fails.
> It seems the problem is pointed to by userName: [DOMAIN\username]not
> found in the database. This seems to be a security problem - but why
> would it work sometimes? The log file is below for reference. The user
> in question is in the same domain as the report service is running
> under.
> Environment:
> Report service SP2 running on a Windows 2003 EE with SQL Server 2000
> Active Director Domain server running on Windows 2003 EE
> The report server service is running under a domain account that is in
> the local administrator group on the local server.
> Has anyone seen this problem?
> Thanks
> ReportingServicesService!library!2b4!09/02/2005-09:09:38:: i INFO:
> Initializing EnableExecutionLogging to 'True' as specified in Server
> system properties.
> ReportingServicesService!session!2b4!09/02/2005-09:09:38:: i INFO:
> LoadSnapshot: Item with session: tc2ixx55bnczhjifyjr2z42q, reportPath:
> /Company Reports/MyReport, userName: [DOMAIN\username]not found in the
> database
> ReportingServicesService!chunks!2b4!09/02/2005-09:09:38:: i INFO: ###
> GetReportChunk('MyReport_style', 1), chunk was not found!
> this=38c10bb1-1bae-4d41-a03e-f56437fc3c86
> ReportingServicesService!emailextension!2b4!09/02/2005-09:09:38:: Error
> sending email. System.ObjectDisposedException: Cannot access a closed
> file.
> at System.IO.__Error.FileNotOpen()
> at System.IO.FileStream.Read(Byte[] array, Int32 offset, Int32
> count)
> at
> Microsoft.ReportingServices.Library.PartitionFileStream.Read(Byte[]
> buffer, Int32 offset, Int32 count)
> at
> Microsoft.ReportingServices.Library.MemoryUntilThresholdStream.Read(Byte[]
> buffer, Int32 offset, Int32 count)
> at Microsoft.ReportingServices.Library.RSStream.Read(Byte[] buffer,
> Int32 offset, Int32 count)
> at
> Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.EmbedReport(IMessage
> message, RenderedOutputFile[] reportData, Notification notification,
> SubscriptionData data)
> at
> Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.ConstructMessageBody(IMessage
> message, Notification notification, SubscriptionData data)
> at
> Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.CreateMessage(Notification
> notification)
> at
> Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification
> notification)
> ReportingServicesService!notification!2b4!09/02/2005-09:09:38::
> Notification 2180101f-6faa-41b7-b1a0-b3217c5d630e completed. Success:
> False, Status: Failure sending mail: Cannot access a closed file.,
> DeliveryExtension: Report Server Email, Report: MyReport, Attempt 0
> ReportingServicesService!dbpolling!2b4!09/02/2005-09:09:38::
> NotificationPolling finished processing item
> 2180101f-6faa-41b7-b1a0-b3217c5d630e
Experiencing a very similar issue, running SP1. I created a
parameterized report, from which 93 link reports point to. Those 93
linked reports are set to run nightly at 2:00 am by generating a
snapshot (for historical purposes). All 93 snapshots were created
within about 3 mintutes of 2:00 am. The subscription is suposed to
fire an email whenever it is updated, but only half or so are
successful. On those that are unsuccessful, I get no error message at
all.
It seems timed subscriptions work just fine. Perhaps what I will do is
send the email based only on a timed subscription and also create a
snapshot for historical purposes...I would much rather not have to do
double the processor work, as many more reports are needed for
conversion.

Intermittent Drill down Problems

I have a report deployed to dev server with a drill down that works
fine. I deployed the same report to the prod server with the same
configuration and I'm getting intermittent problems with the drill
down, it works fine on one users machine, on another when you click the
+, the screen just refreshes and jumps to about the middle of the page.
It does this everytime you try to drill down. Now here is the kicker
the same user can then point at the dev server and the report works
fine. Ive searched this site and at MS all day and can't find a
solution. I appreciate any advice any of you folks might have.
PS I set the logging to Vebose and it didn't tell me anything.
ThanksAlthough I have never seen this... Check all of the Reporting Services Logs
to see if there is anything wierd in there..
Also do a thorough comparison between the Internet Explorer Versions, and
settings between the 2 machines...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
<Matt.Beagle@.gmail.com> wrote in message
news:1126126082.059835.136910@.o13g2000cwo.googlegroups.com...
>I have a report deployed to dev server with a drill down that works
> fine. I deployed the same report to the prod server with the same
> configuration and I'm getting intermittent problems with the drill
> down, it works fine on one users machine, on another when you click the
> +, the screen just refreshes and jumps to about the middle of the page.
> It does this everytime you try to drill down. Now here is the kicker
> the same user can then point at the dev server and the report works
> fine. Ive searched this site and at MS all day and can't find a
> solution. I appreciate any advice any of you folks might have.
> PS I set the logging to Vebose and it didn't tell me anything.
> Thanks
>sql

Monday, March 26, 2012

Intermittent 401: Not Authorized

The first time I try to access a RS report after an IISreset, I get a
"System.Net.WebException: The request failed with HTTP status 401:
Unauthorized." error. If I try to access it again, I get in without a
problem.
In addition to the "first attempt after the iisreset", which happens
consistently, we also intermittently experience the same error, infrequently.
Any idea what is going on here? Caching of Credentials?
Michael DorfmanHello Michael,
To understand the issue better, I'd like to know the following information:
1. Does the issue only occur with a specific RS report or any RS report
such as sample reports including in RS installation?
2. Do you have anonymous access enabled on Report Manager or Report Server
virtual directories?
Also, this issue might be related to a known issue in .Net framework 1.1
sp1, I suggest that you contact CSS to get 887563 installed hotfix 887563
to see if it helps:
884537 FIX: You may receive a "System.Net.WebException" error message when
you
http://support.microsoft.com/?id=884537
887563 Availability of the .NET Framework 1.1 Post-Service Pack 1 rollup
http://support.microsoft.com/?id=887563
Also, please search if there are multiple copies of security.dll on your
SQL Reporting Services machine. If there are security.dll other than
%windir%\system32 folder, please tempoarily rename them to test the
situation.
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
| Thread-Topic: Intermittent 401: Not Authorized
| thread-index: AcVTuOW2QlsDZxZ1SwW4LqLFvzorxw==| X-WBNR-Posting-Host: 62.97.217.178
| From: =?Utf-8?B?TWljaGFlbCBEb3JmbWFu?= <mercatus2004@.online.nospam>
| Subject: Intermittent 401: Not Authorized
| Date: Sun, 8 May 2005 03:30:04 -0700
| Lines: 11
| Message-ID: <E81A662F-4F37-45EB-8174-9C17787D5295@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:43126
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| The first time I try to access a RS report after an IISreset, I get a
| "System.Net.WebException: The request failed with HTTP status 401:
| Unauthorized." error. If I try to access it again, I get in without a
| problem.
|
| In addition to the "first attempt after the iisreset", which happens
| consistently, we also intermittently experience the same error,
infrequently.
|
| Any idea what is going on here? Caching of Credentials?
|
| Michael Dorfman
||||Are you using 2003 server and applied SP1? If so, I did the following and
solved my same problem:
"create a DWORD entry called DisableLoopbackCheck to
HKLM\System\CurrentControlSet\Control\Lsa. Set this key to a value of 1"
This is an issue which occures after appling SP1 to 2003 server.
I hope, this helps.
Barbaros Saglamtimur
MCDBA, MCAD
"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:wrpXrMFVFHA.2476@.TK2MSFTNGXA01.phx.gbl...
> Hello Michael,
> To understand the issue better, I'd like to know the following
> information:
> 1. Does the issue only occur with a specific RS report or any RS report
> such as sample reports including in RS installation?
> 2. Do you have anonymous access enabled on Report Manager or Report Server
> virtual directories?
> Also, this issue might be related to a known issue in .Net framework 1.1
> sp1, I suggest that you contact CSS to get 887563 installed hotfix 887563
> to see if it helps:
> 884537 FIX: You may receive a "System.Net.WebException" error message when
> you
> http://support.microsoft.com/?id=884537
> 887563 Availability of the .NET Framework 1.1 Post-Service Pack 1 rollup
> http://support.microsoft.com/?id=887563
> Also, please search if there are multiple copies of security.dll on your
> SQL Reporting Services machine. If there are security.dll other than
> %windir%\system32 folder, please tempoarily rename them to test the
> situation.
>
> Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
>
> --
> | Thread-Topic: Intermittent 401: Not Authorized
> | thread-index: AcVTuOW2QlsDZxZ1SwW4LqLFvzorxw==> | X-WBNR-Posting-Host: 62.97.217.178
> | From: =?Utf-8?B?TWljaGFlbCBEb3JmbWFu?= <mercatus2004@.online.nospam>
> | Subject: Intermittent 401: Not Authorized
> | Date: Sun, 8 May 2005 03:30:04 -0700
> | Lines: 11
> | Message-ID: <E81A662F-4F37-45EB-8174-9C17787D5295@.microsoft.com>
> | MIME-Version: 1.0
> | Content-Type: text/plain;
> | charset="Utf-8"
> | Content-Transfer-Encoding: 7bit
> | X-Newsreader: Microsoft CDO for Windows 2000
> | Content-Class: urn:content-classes:message
> | Importance: normal
> | Priority: normal
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
> | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | Xref: TK2MSFTNGXA01.phx.gbl
> microsoft.public.sqlserver.reportingsvcs:43126
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | The first time I try to access a RS report after an IISreset, I get a
> | "System.Net.WebException: The request failed with HTTP status 401:
> | Unauthorized." error. If I try to access it again, I get in without a
> | problem.
> |
> | In addition to the "first attempt after the iisreset", which happens
> | consistently, we also intermittently experience the same error,
> infrequently.
> |
> | Any idea what is going on here? Caching of Credentials?
> |
> | Michael Dorfman
> |
>|||I have 4 different security.dll files...
C:\WINDOWS\system32 - version 5.2.3790.0
C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\Temporary ASP.NET
Files\reportserver\28ed0657\f12b7b77\assembly\dl2\d011044e\8fb1f7af_6dc3c401
C:\WINDOWS\system32\dllcache
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer\bin - version 1.0.1770.24267
should I keep the Reporting Services version or the Windows version?
"Peter Yang [MSFT]" wrote:
> Hello Michael,
> To understand the issue better, I'd like to know the following information:
> 1. Does the issue only occur with a specific RS report or any RS report
> such as sample reports including in RS installation?
> 2. Do you have anonymous access enabled on Report Manager or Report Server
> virtual directories?
> Also, this issue might be related to a known issue in .Net framework 1.1
> sp1, I suggest that you contact CSS to get 887563 installed hotfix 887563
> to see if it helps:
> 884537 FIX: You may receive a "System.Net.WebException" error message when
> you
> http://support.microsoft.com/?id=884537
> 887563 Availability of the .NET Framework 1.1 Post-Service Pack 1 rollup
> http://support.microsoft.com/?id=887563
> Also, please search if there are multiple copies of security.dll on your
> SQL Reporting Services machine. If there are security.dll other than
> %windir%\system32 folder, please tempoarily rename them to test the
> situation.
>
> Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>
> --
> | Thread-Topic: Intermittent 401: Not Authorized
> | thread-index: AcVTuOW2QlsDZxZ1SwW4LqLFvzorxw==> | X-WBNR-Posting-Host: 62.97.217.178
> | From: =?Utf-8?B?TWljaGFlbCBEb3JmbWFu?= <mercatus2004@.online.nospam>
> | Subject: Intermittent 401: Not Authorized
> | Date: Sun, 8 May 2005 03:30:04 -0700
> | Lines: 11
> | Message-ID: <E81A662F-4F37-45EB-8174-9C17787D5295@.microsoft.com>
> | MIME-Version: 1.0
> | Content-Type: text/plain;
> | charset="Utf-8"
> | Content-Transfer-Encoding: 7bit
> | X-Newsreader: Microsoft CDO for Windows 2000
> | Content-Class: urn:content-classes:message
> | Importance: normal
> | Priority: normal
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
> | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:43126
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | The first time I try to access a RS report after an IISreset, I get a
> | "System.Net.WebException: The request failed with HTTP status 401:
> | Unauthorized." error. If I try to access it again, I get in without a
> | problem.
> |
> | In addition to the "first attempt after the iisreset", which happens
> | consistently, we also intermittently experience the same error,
> infrequently.
> |
> | Any idea what is going on here? Caching of Credentials?
> |
> | Michael Dorfman
> |
>

Friday, March 23, 2012

Intergrity of forms and windows Auth

i Have an ASP.NET Application with forms authentication which uses sql
reporting for report purpose ,but report server works on windows
authentication ,due to which dialog box is popping up,i need to know a way of
integratinf the two to have a single sign on Process?Rags,
You have two options:
1. Generating the report on the server side of the application by using the
Render SOAP API. The advantage of this approach is that it is more secure
since the user doesn't see the report URL (everything takes place on the
server). The tradeoff is that the interactive features (drilldown,
drillthrough, etc.) will not work with SOAP since their require direct
access to the Report Server by URL. If you decide to take this approach, you
can pass the web app identity to the Report Server and grant a minimum set
of permissions in RS to this account.
2. Replace the RS Windows security with Forms Authentication by writing a
custom security extension. This will allow you to incorporate interactive
features in your reports. In this scenario, the reports will be requested on
the client side of the application (e.g. by using the Report Viewer sample
control). If you decide to take this approach check out the sample security
extension from MS at
(http://msdn.microsoft.com/library/?url=/library/en-us/dnsql2k/html/ufairs.a
sp?frame=true#ufairs_topic3).
So, you have to carefully weight out your requirements for security,
reporting features and your application architecture to determine the best
integration scenario.
--
Hope this helps.
---
Teo Lachev, MCSD, MCT
Author: "Microsoft Reporting Services in Action"
http://www.prologika.com
"Rags Iyer" <RagsIyer@.discussions.microsoft.com> wrote in message
news:0066D811-7499-4FFD-BB70-D97D8051D1F5@.microsoft.com...
> i Have an ASP.NET Application with forms authentication which uses sql
> reporting for report purpose ,but report server works on windows
> authentication ,due to which dialog box is popping up,i need to know a way
of
> integratinf the two to have a single sign on Process?

Interesting subscription question...I could use some brainstorming help

I have a report that needs to be emailed to 40 diffferent technicians.
Each tehnician handles a different US region so the report will be
driven via a parameter (most likely a technician ID). We don't want
other technicians seeing data for someone elses region. This all has
to be automated, no user interaction with this report other than each
technician getting an email with his/her data (based on his/her
results).
What would be the best way to handle this with a subscription?I do know that this will have to be a data-driven subscription. Is it
possible for the value in a data driven query be used as a parameter in
the report'
kimcheebowl wrote:
> I have a report that needs to be emailed to 40 diffferent technicians.
> Each tehnician handles a different US region so the report will be
> driven via a parameter (most likely a technician ID). We don't want
> other technicians seeing data for someone elses region. This all has
> to be automated, no user interaction with this report other than each
> technician getting an email with his/her data (based on his/her
> results).
> What would be the best way to handle this with a subscription?|||Absolutely - DDS will be just what the doctor ordered. You will need
to feed the parameter values into a table for the DDS to pull from. I
use both Access DB and Excel spreadsheet uploads to upload subscription
parameters into a SQL Server table, which is then used by the DDS.
Matt A
kimcheebowl wrote:
> I do know that this will have to be a data-driven subscription. Is it
> possible for the value in a data driven query be used as a parameter in
> the report'
>
> kimcheebowl wrote:
> > I have a report that needs to be emailed to 40 diffferent technicians.
> > Each tehnician handles a different US region so the report will be
> > driven via a parameter (most likely a technician ID). We don't want
> > other technicians seeing data for someone elses region. This all has
> > to be automated, no user interaction with this report other than each
> > technician getting an email with his/her data (based on his/her
> > results).
> >
> > What would be the best way to handle this with a subscription?sql

Wednesday, March 21, 2012

Interesting Problem/Bug with Logos in the page header

Scenario:

I have a report with a logo in the page header.

This report has 2 parameters: 1) Date 2) Boolean to Show/Hide detail.

When I put in the date and show the report, everything is fine. If I then change the boolean parameter to show or hide the detail, the logo file cannot be found (Displays a red X)

If I export the report like this, the red X is rendered in the export. The logo is not there.

Has anyone else experienced this issue?

Anyone know how to resolve it?

Thanks!

BobP

This is a known bug. The fix will be included in the next release.

interesting problem..related to selection criteria..

Have report where the user should be able to enter some selection critera to EXCLUDE from the result set displayed.

I deally Iwould liek to include it in the sql parameters to avoid retunring a larger then necessary result set, but Couldn't I also use it inthe filter criteria?

Has anyone done anything like this.

ie: a drop down box where people could add exclusions.

ie: Apples, Oranges

would be excluded from the result list.

So If I entered Apples, Oranges

the resultset would eclude these from the returned dataset.

I realize using a multi param box is fruitless. WOndering if there is another way to do this

Why wouldn't multi-param work?

Select something from sometable where (@.multiparam is null or fruit not in (@.multiparam))

Does this look ok?

cheers,

Andrew

Interesting custom functionality in Reports ... highlighting?

Hello,

I have a report of processes which either go into a Log table or an Error log table. They also have start / finish datetimes and a timespan value. So I want to report the process elapsed time or the error condition, depending on which table the process finished up in.

I then compare the elapsed time to the timespan and then show either a red flag (errored) green flag(worked within timespan) or yellow flag(worked but ran over allotted time) depending on what happened.

Is this possible?

I think it would be easy for me to get the info I want into a dataset using .net code but how do you link that in with SSRS?

Any help appreciated,

Thanks.

Try putting something like this into the background color property of the textbox you want to highlight:

=Switch(Fields!Error.Value = 1, "Red", Fields!timespan.Value > [AllottedTimeValue] , "Yellow", Fields!timespan.Value <= [AllottedTimeValue], "Green")

Hope this helps.

Jarret

sql

Interesting conumdrum.. question about filters...

Got a dataset coming from a stored procedure.

There is a parameter I must put on the report that filters the dataset.

the choices are "exclude" and "only", based on that I have to filter my dataset like

if they select exclude then I have to filter where "debitType <> 'Intercompany'"

if they select on;y then I have to filter where "debitType = 'Intercompany'"

Is this at all possible in the filter part?

It is easy as pie in Crystal record selector.

Hello,

Try this as your filter:

Expression: =cBool((Fields!debitType.Value <> "Intercompany" AND Parameters!Param1.Value = "Exclude") OR (Fields!debitType.Value = "Intercompany" AND Parameters!Param1.Value = "Only"))

Operator: =

Value: =cBool(True)

Hope this helps.

Jarret

|||

oh, that's good. didn't knwo you could use epxressions like that in the left side of the filter table.

Thanks alot.

Interesting Challenge..

I am making a report in Visual Studio..Now my question is,is there anyway that i can add a tab control for my rdl?Hope to here from anyone out there with a know how..Thanks guys!!

Are you saying that you want your report that is rendered in HTML to have a tab control on it? Or are you asking if you can design the report page just like an HTML page, and drop all sorts of components on to it?

|||

uhm..my reports were being exported in HTML,Excel and PDF..But i dont really know if it is possible to add a tab control to an rdl.I am trying to add a tab control in the COM Components,but i cannot see a tab control for it.

|||do you mean you want to see the RDL (i.e. the xml rather than the GUI)?

just right click on the report in solution explorer and 'view code' - it should open up a new tab with just the raw xml as text|||

thanks for the reply,but what im trying to say here,is that,if it is possible to add a "Tab Control" (like what we see in excel) into the rdl..

|||The RDL is being rendered by the ReportView control and thus can't contain any WinForm or WebForm components. You may be able to simulate what you are wanting to do by using the hidden properties of items such as rectangles. For a wild example of what can be accomplished, take a look at the Etch A Sketch built by Brian Welcher http://blogs.msdn.com/bwelcker/archive/2005/10/29/486534.aspx

(note: the report doesn't appear to be online anymore; download the source, it is well worth it)

If you post or send mock ups of what you are trying to do, I will try and help you build it.

Larry

|||

I just cant download the source.And as for what you are saying,i had tried some tricks like that,but it seems that it is not very effective.One reason is that,if one sheet in any case is too long,then it will push my custom tab(compose of textboxes with navigation to subreports) to go beneaththe page which not supposed to be.But there is no way that you can make it fixed location right.But as what u said that i cannot add a winform,i may agree to that,thanks.But if you still had any other idea,i would be very greatful to hear that.Thank you so much..And by the way for you too see what i had done,i will send one of my form.If you just want to take a look..

<?xml version="1.0" encoding="utf-8"?>

<Body>

</Drillthrough>

</Action>

<Style>

<TextAlign>Center</TextAlign>

<BackgroundColor>LightGrey</BackgroundColor>

</Style>

<Value>Sheet 3</Value>

</Textbox>

</Drillthrough>

</Action>

<Style>

<TextAlign>Center</TextAlign>

<BackgroundColor>LightGrey</BackgroundColor>

</Style>

</Textbox>

<Style>

<BackgroundColor>LightGrey</BackgroundColor>

</Style>

</Rectangle>

</Drillthrough>

</Action>

<Style>

<TextAlign>Center</TextAlign>

</Style>

<Value>Sheet 2</Value>

</Textbox>

<rdefaultName>textbox1</rdefaultName>

</Drillthrough>

</Action>

<Style>

<TextAlign>Center</TextAlign>

<BackgroundColor>LightGrey</BackgroundColor>

</Style>

<Value>Sheet 1</Value>

</Textbox>

<Source>Embedded</Source>

<Value>exgraph</Value>

</Image>

</ReportItems>

<Style>

<Default>Solid</Default>

</BorderStyle>

</Style>

</Body>

<rd:ReportID>fd68b021-3677-4bda-94a8-cee7c9065a99</rd:ReportID>

<ImageData>I had removed the encrypted data for my picture..Maybe you can sub<ImageData>

<MIMEType>image/jpeg</MIMEType>

</EmbeddedImage>

</EmbeddedImages>

</Report>

Again,Thanks.... o_O

By the way,i hadn't notice,the one that i had sent to you was the one that i had placed my custom tab(as if it was,hehe) above the page.

|||

Why do you need to do it this way? You could make 2 seperate reports, embed them in a HTML page and use some javascript to select different divs which changes between the reports... You also don't have to worry about printing issues/exporting with overlaid items...etc. You could even get fancy with some AJAX if you wanted! I dunno, if you can present a clear reason behind why you want to do it that way... But I kind of see it as:

Create tabs on a report...user might not view other tabs = all data must be loaded on report execution = longer load time = unhappy user Sad

Anyways, I'd still be interested if you get it working if you do decide to pursue that path!

|||

Thanks Salvo0194, but honestly speaking,i am not familiar in User Interface because we are in a three - tier framework.And that is what they want me do to.But based on my research,there really is no way that i can try to put a tab control in a rdl.And based as what you had said,i think also that it could only be the best way to do the trick.Thank you so much.But still i am waiting for some other comments that will benefit all of us for certain issues..hehe.. By the way,thanks for reminding,no programmer wants a user to be ..hehe.. o_O

|||

I found a good example at http://blogs.msdn.com/lukaszp/archive/2005/10/11/479791.aspx

but I built one just for you with 'tabs' that work the way I believe you want them. The tab body is a rectangle and the tab tops are text boxes. The tab tops link back to the same report with a parameter set that handles the visibility.

Here is the code:

Code Snippet

<?xml version="1.0" encoding="utf-8"?>
<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinitionhttp://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition">http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition</A< A>>" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
'>http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
; <BottomMargin>1in</BottomMargin>
<RightMargin>1in</RightMargin>
<ReportParameters>
<ReportParameter Name="ToggleItem">
<DataType>Integer</DataType>
<DefaultValue>
<Values>
<Value>1</Value>
</Values>
</DefaultValue>
<AllowBlank>true</AllowBlank>
<Prompt>Report_Parameter_0</Prompt>
<Hidden>true</Hidden>
</ReportParameter>
</ReportParameters>
<rd:DrawGrid>true</rd:DrawGrid>
<InteractiveWidth>8.5in</InteractiveWidth>
<rd:SnapToGrid>true</rd:SnapToGrid>
<Body>
<ReportItems>
<Textbox Name="textbox6">
<Left>0.375in</Left>
<ZIndex>8</ZIndex>
<Width>1in</Width>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.25in</Height>
<Value>=Code.IsHidden(1)</Value>
</Textbox>
<Textbox Name="textbox5">
<Left>1.375in</Left>
<ZIndex>7</ZIndex>
<Width>1in</Width>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.25in</Height>
<Value>=Code.IsHidden(2)</Value>
</Textbox>
<Textbox Name="textbox4">
<Left>2.375in</Left>
<rd:DefaultName>textbox4</rd:DefaultName>
<ZIndex>6</ZIndex>
<Width>1in</Width>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.25in</Height>
<Value>=Code.IsHidden(3)</Value>
</Textbox>
<Textbox Name="TabTop1">
<Left>0.375in</Left>
<Top>0.25in</Top>
<ZIndex>5</ZIndex>
<Action>
<Drillthrough>
<ReportName>Report1</ReportName>
<Parameters>
<Parameter Name="ToggleItem">
<Value>1</Value>
</Parameter>
</Parameters>
</Drillthrough>
</Action>
<Width>1in</Width>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<BackgroundColor>LemonChiffon</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.25in</Height>
<Value>TabTop1</Value>
</Textbox>
<Textbox Name="TabTop2">
<Left>1.375in</Left>
<Top>0.25in</Top>
<ZIndex>4</ZIndex>
<Action>
<Drillthrough>
<ReportName>Report1</ReportName>
<Parameters>
<Parameter Name="ToggleItem">
<Value>2</Value>
</Parameter>
</Parameters>
</Drillthrough>
</Action>
<Width>1in</Width>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<BackgroundColor>LemonChiffon</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.25in</Height>
<Value>TabTop2</Value>
</Textbox>
<Textbox Name="TabTop3">
<Left>2.375in</Left>
<Top>0.25in</Top>
<ZIndex>3</ZIndex>
<Action>
<Drillthrough>
<ReportName>Report1</ReportName>
<Parameters>
<Parameter Name="ToggleItem">
<Value>3</Value>
</Parameter>
</Parameters>
</Drillthrough>
</Action>
<Width>1in</Width>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<BackgroundColor>LemonChiffon</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.25in</Height>
<Value>TabTop3</Value>
</Textbox>
<Rectangle Name="Tab1">
<Left>0.125in</Left>
<ReportItems>
<Textbox Name="textbox2">
<Left>0.375in</Left>
<Top>0.625in</Top>
<rd:DefaultName>textbox2</rd:DefaultName>
<Width>1in</Width>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.25in</Height>
<Value>TabGuts1</Value>
</Textbox>
</ReportItems>
<Top>0.5in</Top>
<ZIndex>2</ZIndex>
<Visibility>
<Hidden>=Code.IsHidden(1)</Hidden>
</Visibility>
<Width>6.25in</Width>
<Style>
<BackgroundColor>LemonChiffon</BackgroundColor>
</Style>
<Height>1.375in</Height>
</Rectangle>
<Rectangle Name="Tab2">
<Left>0.125in</Left>
<ReportItems>
<Textbox Name="textbox3">
<Left>0.875in</Left>
<Top>0.75in</Top>
<Width>1in</Width>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.25in</Height>
<Value>TabGuts2</Value>
</Textbox>
</ReportItems>
<Top>0.5in</Top>
<ZIndex>1</ZIndex>
<Visibility>
<Hidden>=Code.IsHidden(2)</Hidden>
</Visibility>
<Width>6.25in</Width>
<Style>
<BackgroundColor>LemonChiffon</BackgroundColor>
</Style>
<Height>1.375in</Height>
</Rectangle>
<Rectangle Name="Tab3">
<Left>0.125in</Left>
<ReportItems>
<Textbox Name="textbox1">
<Left>0.875in</Left>
<Top>0.5in</Top>
<Width>1in</Width>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.25in</Height>
<Value>TabGuts3</Value>
</Textbox>
</ReportItems>
<Top>0.5in</Top>
<Visibility>
<Hidden>=Code.IsHidden(3)</Hidden>
</Visibility>
<Width>6.25in</Width>
<Style>
<BackgroundColor>LemonChiffon</BackgroundColor>
</Style>
<Height>1.375in</Height>
</Rectangle>
</ReportItems>
<Height>3.625in</Height>
</Body>
<rd:ReportID>c853717f-f8cb-4fff-8177-c8c9c3f5548b</rd:ReportID>
<LeftMargin>1in</LeftMargin>
<Code>Function IsHidden(ByVal currentTab As Integer) As Boolean
If Not currentTab = Report.Parameters!ToggleItem.Value Then
Return True
Else
Return False
End If
End Function</Code>
<Width>9.75in</Width>
<InteractiveHeight>11in</InteractiveHeight>
<Language>en-US</Language>
<TopMargin>1in</TopMargin>
</Report>

|||

Larry thanx for the code.Funny we almost had the similar trick,but yours is nicer..hehe..uhm that finished it up..Maybe thats the only thing that we can do.But there only is one issue,uhm i dont know if you had just forgotten it,or what,but by th way,the rectangles are overlapping and it will give the user a warning,which is not good,uhm..but still thanks for that reply.It clears up thing now.But if still,you have a solution about overlapping,it is still greatly accepted(hehe..too much of me)..but maybe it would also be useful to others.Thank You o_O

|||Sorry about that, simply stack them vertically and the rendering engine should reclaim the space if they are not visible. I didn't see the warning on mine.

|||

Ok..thanks so much for the great help..

Interesting Challenge..

I am making a report in Visual Studio..Now my question is,is there anyway that i can add a tab control for my rdl?Hope to here from anyone out there with a know how..Thanks guys!!

|||

|||do you mean you want to see the RDL (i.e. the xml rather than the GUI)?

just right click on the report in solution explorer and 'view code' - it should open up a new tab with just the raw xml as text|||

thanks for the reply,but what im trying to say here,is that,if it is possible to add a "Tab Control" (like what we see in excel) into the rdl..

(note: the report doesn't appear to be online anymore; download the source, it is well worth it)

If you post or send mock ups of what you are trying to do, I will try and help you build it.

Larry

|||

<?xml version="1.0" encoding="utf-8"?>

<Body>

</Drillthrough>

</Action>

<Style>

<TextAlign>Center</TextAlign>

<BackgroundColor>LightGrey</BackgroundColor>

</Style>

<Value>Sheet 3</Value>

</Textbox>

</Drillthrough>

</Action>

<Style>

<TextAlign>Center</TextAlign>

<BackgroundColor>LightGrey</BackgroundColor>

</Style>

</Textbox>

<Style>

<BackgroundColor>LightGrey</BackgroundColor>

</Style>

</Rectangle>

</Drillthrough>

</Action>

<Style>

<TextAlign>Center</TextAlign>

</Style>

<Value>Sheet 2</Value>

</Textbox>

<rdefaultName>textbox1</rdefaultName>

</Drillthrough>

</Action>

<Style>

<TextAlign>Center</TextAlign>

<BackgroundColor>LightGrey</BackgroundColor>

</Style>

<Value>Sheet 1</Value>

</Textbox>

<Source>Embedded</Source>

<Value>exgraph</Value>

</Image>

</ReportItems>

<Style>

<Default>Solid</Default>

</BorderStyle>

</Style>

</Body>

<rd:ReportID>fd68b021-3677-4bda-94a8-cee7c9065a99</rd:ReportID>

<ImageData>I had removed the encrypted data for my picture..Maybe you can sub<ImageData>

<MIMEType>image/jpeg</MIMEType>

</EmbeddedImage>

</EmbeddedImages>

</Report>

Again,Thanks.... o_O

By the way,i hadn't notice,the one that i had sent to you was the one that i had placed my custom tab(as if it was,hehe) above the page.

|||

Create tabs on a report...user might not view other tabs = all data must be loaded on report execution = longer load time = unhappy user Sad

Anyways, I'd still be interested if you get it working if you do decide to pursue that path!

|||

I found a good example at http://blogs.msdn.com/lukaszp/archive/2005/10/11/479791.aspx

Here is the code:

Code Snippet

|||

|||Sorry about that, simply stack them vertically and the rendering engine should reclaim the space if they are not visible. I didn't see the warning on mine.|||Ok..thanks so much for the great help..

Interesting Challenge..

I am making a report in Visual Studio..Now my question is,is there anyway that i can add a tab control for my rdl?Hope to here from anyone out there with a know how..Thanks guys!!

|||

|||do you mean you want to see the RDL (i.e. the xml rather than the GUI)?

just right click on the report in solution explorer and 'view code' - it should open up a new tab with just the raw xml as text|||

thanks for the reply,but what im trying to say here,is that,if it is possible to add a "Tab Control" (like what we see in excel) into the rdl..

(note: the report doesn't appear to be online anymore; download the source, it is well worth it)

If you post or send mock ups of what you are trying to do, I will try and help you build it.

Larry

|||

<?xml version="1.0" encoding="utf-8"?>

<Body>

</Drillthrough>

</Action>

<Style>

<TextAlign>Center</TextAlign>

<BackgroundColor>LightGrey</BackgroundColor>

</Style>

<Value>Sheet 3</Value>

</Textbox>

</Drillthrough>

</Action>

<Style>

<TextAlign>Center</TextAlign>

<BackgroundColor>LightGrey</BackgroundColor>

</Style>

</Textbox>

<Style>

<BackgroundColor>LightGrey</BackgroundColor>

</Style>

</Rectangle>

</Drillthrough>

</Action>

<Style>

<TextAlign>Center</TextAlign>

</Style>

<Value>Sheet 2</Value>

</Textbox>

<rdefaultName>textbox1</rdefaultName>

</Drillthrough>

</Action>

<Style>

<TextAlign>Center</TextAlign>

<BackgroundColor>LightGrey</BackgroundColor>

</Style>

<Value>Sheet 1</Value>

</Textbox>

<Source>Embedded</Source>

<Value>exgraph</Value>

</Image>

</ReportItems>

<Style>

<Default>Solid</Default>

</BorderStyle>

</Style>

</Body>

<rd:ReportID>fd68b021-3677-4bda-94a8-cee7c9065a99</rd:ReportID>

<ImageData>I had removed the encrypted data for my picture..Maybe you can sub<ImageData>

<MIMEType>image/jpeg</MIMEType>

</EmbeddedImage>

</EmbeddedImages>

</Report>

Again,Thanks.... o_O

By the way,i hadn't notice,the one that i had sent to you was the one that i had placed my custom tab(as if it was,hehe) above the page.

|||

Create tabs on a report...user might not view other tabs = all data must be loaded on report execution = longer load time = unhappy user Sad

Anyways, I'd still be interested if you get it working if you do decide to pursue that path!

|||

I found a good example at http://blogs.msdn.com/lukaszp/archive/2005/10/11/479791.aspx

Here is the code:

Code Snippet

|||

sql

Friday, March 30, 2012

Internal Email subscription fail

Wednesday, March 28, 2012

intermittent locks

Intermittent field display

Intermittent email issue

Intermittent Drill down Problems

Monday, March 26, 2012

Intermittent 401: Not Authorized

Friday, March 23, 2012

Intergrity of forms and windows Auth

Interesting subscription question...I could use some brainstorming help

Wednesday, March 21, 2012

Interesting Problem/Bug with Logos in the page header

interesting problem..related to selection criteria..

Interesting custom functionality in Reports ... highlighting?

Interesting conumdrum.. question about filters...

Interesting Challenge..

Interesting Challenge..

Interesting Challenge..

Integrated Security

Blog Archive

About Me