SQL tool for MSDE: reporting

Showing posts with label reporting. Show all posts

Thursday, March 29, 2012

alignement data

My application has production server and backup sever for data reporting .
There is some tools in SQL 2K (or third part tool) for alignement data at
run time between two servers?
Thanks in advance
StperAre you talking about transforming data? Have you explored DTS? See SQL
Server Books Online for more information.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"stefano perabò" <stefano.perabo@.speedautomazione.it> wrote in message
news:%23wzR3DxbEHA.556@.tk2msftngp13.phx.gbl...
My application has production server and backup sever for data reporting .
There is some tools in SQL 2K (or third part tool) for alignement data at
run time between two servers?
Thanks in advance
Stper|||Hi Vyas,
It seems Stper need to syncronize the report server with production server
online.
Stper,
If above is the case you can go for either of the below approach
1. Transactional Replication
2. Log Shipping
This method will sync. the Report server database with report server.
Thanks
Hari
MCDBA
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:uDRYaMxbEHA.3988@.tk2msftngp13.phx.gbl...
> Are you talking about transforming data? Have you explored DTS? See SQL
> Server Books Online for more information.
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
>
> "stefano perabò" <stefano.perabo@.speedautomazione.it> wrote in message
> news:%23wzR3DxbEHA.556@.tk2msftngp13.phx.gbl...
> My application has production server and backup sever for data reporting
.
> There is some tools in SQL 2K (or third part tool) for alignement data at
> run time between two servers?
> Thanks in advance
> Stper
>
>|||In that case, I'd strongly recommend transactional replication. It is meant
to satisfy reporting requirements.
Log shipping is ideal for maintaining standby servers, but not really for
reporting purposes.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:%23AoYEqxbEHA.3480@.TK2MSFTNGP11.phx.gbl...
Hi Vyas,
It seems Stper need to syncronize the report server with production server
online.
Stper,
If above is the case you can go for either of the below approach
1. Transactional Replication
2. Log Shipping
This method will sync. the Report server database with report server.
Thanks
Hari
MCDBA
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:uDRYaMxbEHA.3988@.tk2msftngp13.phx.gbl...
> Are you talking about transforming data? Have you explored DTS? See SQL
> Server Books Online for more information.
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
>
> "stefano perabò" <stefano.perabo@.speedautomazione.it> wrote in message
> news:%23wzR3DxbEHA.556@.tk2msftngp13.phx.gbl...
> My application has production server and backup sever for data reporting
.
> There is some tools in SQL 2K (or third part tool) for alignement data at
> run time between two servers?
> Thanks in advance
> Stper
>
>|||Thanks Hari, i think the Transactional Replication is the solution for my
problem. Now i must study the configuration
I found this an article in
www.awprofessional.com/articles/article.asp?p=170234
Do you have some suggestion for examples and/or configuration
Thanks
Stper
"Hari Prasad" <hari_prasad_k@.hotmail.com> ha scritto nel messaggio
news:#AoYEqxbEHA.3480@.TK2MSFTNGP11.phx.gbl...
> Hi Vyas,
> It seems Stper need to syncronize the report server with production server
> online.
> Stper,
> If above is the case you can go for either of the below approach
> 1. Transactional Replication
> 2. Log Shipping
> This method will sync. the Report server database with report server.
> Thanks
> Hari
> MCDBA
> "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> news:uDRYaMxbEHA.3988@.tk2msftngp13.phx.gbl...
> > Are you talking about transforming data? Have you explored DTS? See SQL
> > Server Books Online for more information.
> > --
> > HTH,
> > Vyas, MVP (SQL Server)
> > http://vyaskn.tripod.com/
> >
> >
> > "stefano perabò" <stefano.perabo@.speedautomazione.it> wrote in message
> > news:%23wzR3DxbEHA.556@.tk2msftngp13.phx.gbl...
> > My application has production server and backup sever for data
reporting
> .
> > There is some tools in SQL 2K (or third part tool) for alignement data
at
> > run time between two servers?
> > Thanks in advance
> >
> > Stper
> >
> >
> >
>|||stper,
Books Online is a very valuable reference.
http://www.mssqlserver.com/replication/primer_p1.asp has a nice primer
to replication. There is a book coming soon on Snapshot and
Transactional replication from Hilary Cotter which is excellent, see the
link in my sig.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
stper wrote:
> Thanks Hari, i think the Transactional Replication is the solution for my
> problem. Now i must study the configuration
> I found this an article in
> www.awprofessional.com/articles/article.asp?p=170234
> Do you have some suggestion for examples and/or configuration
> Thanks
> Stper
> "Hari Prasad" <hari_prasad_k@.hotmail.com> ha scritto nel messaggio
> news:#AoYEqxbEHA.3480@.TK2MSFTNGP11.phx.gbl...
>>Hi Vyas,
>>It seems Stper need to syncronize the report server with production server
>>online.
>>Stper,
>>If above is the case you can go for either of the below approach
>>1. Transactional Replication
>>2. Log Shipping
>>This method will sync. the Report server database with report server.
>>Thanks
>>Hari
>>MCDBA
>>"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
>>news:uDRYaMxbEHA.3988@.tk2msftngp13.phx.gbl...
>>Are you talking about transforming data? Have you explored DTS? See SQL
>>Server Books Online for more information.
>>--
>>HTH,
>>Vyas, MVP (SQL Server)
>>http://vyaskn.tripod.com/
>>
>>"stefano perabò" <stefano.perabo@.speedautomazione.it> wrote in message
>>news:%23wzR3DxbEHA.556@.tk2msftngp13.phx.gbl...
>>My application has production server and backup sever for data
> reporting
>>.
>>There is some tools in SQL 2K (or third part tool) for alignement data
> at
>>run time between two servers?
>>Thanks in advance
>>Stper
>>
>>
>|||i made the configuration and now i testing my first "PULL SUbscription".
Unfortunately i have my first error message : "Unexpected EOF encountered in
BCP data-file" when i run with alignement.
Do yuo have some suggestion ?
stper
"Mark Allison" <marka@.no.tinned.meat.mvps.org> ha scritto nel messaggio
news:#7aQdhybEHA.4092@.TK2MSFTNGP11.phx.gbl...
> stper,
> Books Online is a very valuable reference.
> http://www.mssqlserver.com/replication/primer_p1.asp has a nice primer
> to replication. There is a book coming soon on Snapshot and
> Transactional replication from Hilary Cotter which is excellent, see the
> link in my sig.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> stper wrote:
> > Thanks Hari, i think the Transactional Replication is the solution for
my
> > problem. Now i must study the configuration
> > I found this an article in
> > www.awprofessional.com/articles/article.asp?p=170234
> > Do you have some suggestion for examples and/or configuration
> >
> > Thanks
> > Stper
> >
> > "Hari Prasad" <hari_prasad_k@.hotmail.com> ha scritto nel messaggio
> > news:#AoYEqxbEHA.3480@.TK2MSFTNGP11.phx.gbl...
> >
> >>Hi Vyas,
> >>
> >>It seems Stper need to syncronize the report server with production
server
> >>online.
> >>
> >>Stper,
> >>
> >>If above is the case you can go for either of the below approach
> >>
> >>1. Transactional Replication
> >>
> >>2. Log Shipping
> >>
> >>This method will sync. the Report server database with report server.
> >>
> >>Thanks
> >>Hari
> >>MCDBA
> >>
> >>"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> >>news:uDRYaMxbEHA.3988@.tk2msftngp13.phx.gbl...
> >>
> >>Are you talking about transforming data? Have you explored DTS? See SQL
> >>Server Books Online for more information.
> >>--
> >>HTH,
> >>Vyas, MVP (SQL Server)
> >>http://vyaskn.tripod.com/
> >>
> >>
> >>"stefano perabò" <stefano.perabo@.speedautomazione.it> wrote in message
> >>news:%23wzR3DxbEHA.556@.tk2msftngp13.phx.gbl...
> >>My application has production server and backup sever for data
> >
> > reporting
> >
> >>.
> >>
> >>There is some tools in SQL 2K (or third part tool) for alignement data
> >
> > at
> >
> >>run time between two servers?
> >>Thanks in advance
> >>
> >>Stper
> >>
> >>
> >>
> >>
> >>
> >
> >|||After testing and testying i can say (like Pitagora) : EUREKA !!!
now i must tuning the task but the functionality work very well.
Thanks
Stper
"stper" <stefano.perabo@.speedautomazione.it> ha scritto nel messaggio
news:eZICqZzbEHA.596@.TK2MSFTNGP11.phx.gbl...
> i made the configuration and now i testing my first "PULL SUbscription".
> Unfortunately i have my first error message : "Unexpected EOF encountered
in
> BCP data-file" when i run with alignement.
> Do yuo have some suggestion ?
> stper
> "Mark Allison" <marka@.no.tinned.meat.mvps.org> ha scritto nel messaggio
> news:#7aQdhybEHA.4092@.TK2MSFTNGP11.phx.gbl...
> > stper,
> >
> > Books Online is a very valuable reference.
> > http://www.mssqlserver.com/replication/primer_p1.asp has a nice primer
> > to replication. There is a book coming soon on Snapshot and
> > Transactional replication from Hilary Cotter which is excellent, see the
> > link in my sig.
> >
> > --
> > Mark Allison, SQL Server MVP
> > http://www.markallison.co.uk
> >
> > Looking for a SQL Server replication book?
> > http://www.nwsu.com/0974973602.html
> >
> >
> >
> > stper wrote:
> > > Thanks Hari, i think the Transactional Replication is the solution for
> my
> > > problem. Now i must study the configuration
> > > I found this an article in
> > > www.awprofessional.com/articles/article.asp?p=170234
> > > Do you have some suggestion for examples and/or configuration
> > >
> > > Thanks
> > > Stper
> > >
> > > "Hari Prasad" <hari_prasad_k@.hotmail.com> ha scritto nel messaggio
> > > news:#AoYEqxbEHA.3480@.TK2MSFTNGP11.phx.gbl...
> > >
> > >>Hi Vyas,
> > >>
> > >>It seems Stper need to syncronize the report server with production
> server
> > >>online.
> > >>
> > >>Stper,
> > >>
> > >>If above is the case you can go for either of the below approach
> > >>
> > >>1. Transactional Replication
> > >>
> > >>2. Log Shipping
> > >>
> > >>This method will sync. the Report server database with report server.
> > >>
> > >>Thanks
> > >>Hari
> > >>MCDBA
> > >>
> > >>"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> > >>news:uDRYaMxbEHA.3988@.tk2msftngp13.phx.gbl...
> > >>
> > >>Are you talking about transforming data? Have you explored DTS? See
SQL
> > >>Server Books Online for more information.
> > >>--
> > >>HTH,
> > >>Vyas, MVP (SQL Server)
> > >>http://vyaskn.tripod.com/
> > >>
> > >>
> > >>"stefano perabò" <stefano.perabo@.speedautomazione.it> wrote in
message
> > >>news:%23wzR3DxbEHA.556@.tk2msftngp13.phx.gbl...
> > >>My application has production server and backup sever for data
> > >
> > > reporting
> > >
> > >>.
> > >>
> > >>There is some tools in SQL 2K (or third part tool) for alignement
data
> > >
> > > at
> > >
> > >>run time between two servers?
> > >>Thanks in advance
> > >>
> > >>Stper
> > >>
> > >>
> > >>
> > >>
> > >>
> > >
> > >
>sql

Tuesday, March 27, 2012

align the parameters in reports

IS it possible to design the Parameters Layout in Reporting Service
reports
miniYou can modify styles in HTMLViewer.css style sheet present in Reporting
Services\ReportServer\Styles folder but you will only affect appearance of
the elements, not the distribution or type of controls you want to show.
If you want to fully customize that layout, you need to use reporting
services API, as I have done. For example, I have used radio buttons to
choose report parameters instead of the default combobox.
Jaime
"mini" wrote:
> IS it possible to design the Parameters Layout in Reporting Service
> reports
> mini
>|||thanks Jaime
can u explain how you use reporting
services API?
Can u reduce the Textbox width displayed in parameter layout?
thanks
mini

Aliasing a column name

Hi,
I'm trying to write a SQL event (view or storied proceedure). I have a table that is meant for reporting....the data is arranged verticle. I deal in Fiscal Years ie 2006/2007, 2007/2008, ect. The table in question has generic column lables ie FY1, FY2. I'm writing a report off the table and I want to dynamically turn FY1 into the current FiscalYear, FY2 into current FiscalYear + 1. I tried:

SELECT dbo.tblBudgetConfig.CurrentBudgetYear, dbo.tblBudgetProjectedCurrent.FY4 AS Left ([dbo.tblbudgetConfig.CurrentBudgetYear],4)+3 & "/" & Right([dbo.tblbudgetConfig.CurrentBudgetYear],4)+3
FROM dbo.tblBudgetConfig INNER JOIN
dbo.tblBudgetProjectedCurrent ON dbo.tblBudgetConfig.CurrentBudgetYear = dbo.tblBudgetProjectedCurrent.CurrentBudgetYear

But SQL squawks everytime I try this and tells me that there is something a miss near 'Left'.

Any help will be appreciated.

Nope, you cannot dynamically alias columns. Columns are part of the definition of the query and have to be there at the end of compile phase, not execution. To do this you would need to use dynamic SQL like EXEC ('query string'). You would have to build up the AS in a prior query .

A couple of things to note:

& does not work in SQL. You have to use + for concatenation (and you have to cast everything to the proper datatype_

"value" does not mean a literal, it means a column name. Use single quotes 'value'

Consider using the user interface to manage such things. This wouldn't be likely possible query anyhow because the data could change row by row, so you could then have a variable column name (it may not in your case, but SQL doesn't know that.) Instead of using the column names, add a column named fiscal year and store your value in there. Then let the UI put it in the right places and make it look all pretty for the user.

|||

AFAIK, you can′t compose the Aliases on the fly.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||Thanks for your help. Its not the answer I was hoping for but what you are saying does make sense. And thanks for the t-sql tips too. I am really new at this so any help is appreciated.

Aliasing a column name

But SQL squawks everytime I try this and tells me that there is something a miss near 'Left'.

Any help will be appreciated.

A couple of things to note:

& does not work in SQL. You have to use + for concatenation (and you have to cast everything to the proper datatype_

"value" does not mean a literal, it means a column name. Use single quotes 'value'

|||

AFAIK, you can′t compose the Aliases on the fly.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||Thanks for your help. Its not the answer I was hoping for but what you are saying does make sense. And thanks for the t-sql tips too. I am really new at this so any help is appreciated.

Sunday, March 25, 2012

Alerts

I have a Windows 2003 server running SQL 2000 SP4. I want to start setting
up email alerts and reporting on the SQL server. The network admin team is
not ok with installing any mail client. Is there any other way to have
email alerts setup without installing any mail client?use http://www.sqldev.net/xp/xpsmtp.htm
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"docsql" <docsql@.noemail.nospam> wrote in message
news:OLBxJoIHGHA.2444@.TK2MSFTNGP11.phx.gbl...
>I have a Windows 2003 server running SQL 2000 SP4. I want to start setting
>up email alerts and reporting on the SQL server. The network admin team is
>not ok with installing any mail client. Is there any other way to have
>email alerts setup without installing any mail client?
>
>|||You can use http://www.karaszi.com/SQLServer/util_smtp_alerter.asp. But I haven't looked at the code
for a long while now. If you want to use this and run into problem, I can provide you with source
code (VB.NET) so you can go in and fix stuff.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"docsql" <docsql@.noemail.nospam> wrote in message news:OLBxJoIHGHA.2444@.TK2MSFTNGP11.phx.gbl...
>I have a Windows 2003 server running SQL 2000 SP4. I want to start setting up email alerts and
>reporting on the SQL server. The network admin team is not ok with installing any mail client. Is
>there any other way to have email alerts setup without installing any mail client?
>
>

Alerts

I have a Windows 2003 server running SQL 2000 SP4. I want to start setting
up email alerts and reporting on the SQL server. The network admin team is
not ok with installing any mail client. Is there any other way to have
email alerts setup without installing any mail client?use http://www.sqldev.net/xp/xpsmtp.htm
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"docsql" <docsql@.noemail.nospam> wrote in message
news:OLBxJoIHGHA.2444@.TK2MSFTNGP11.phx.gbl...
>I have a Windows 2003 server running SQL 2000 SP4. I want to start setting
>up email alerts and reporting on the SQL server. The network admin team is
>not ok with installing any mail client. Is there any other way to have
>email alerts setup without installing any mail client?
>
>|||You can use http://www.karaszi.com/SQLServer/util_smtp_alerter.asp. But I ha
ven't looked at the code
for a long while now. If you want to use this and run into problem, I can pr
ovide you with source
code (VB.NET) so you can go in and fix stuff.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"docsql" <docsql@.noemail.nospam> wrote in message news:OLBxJoIHGHA.2444@.TK2MSFTNGP11.phx.gbl
..
>I have a Windows 2003 server running SQL 2000 SP4. I want to start setting
up email alerts and
>reporting on the SQL server. The network admin team is not ok with install
ing any mail client. Is
>there any other way to have email alerts setup without installing any mail
client?
>
>

Alerts

I have a Windows 2003 server running SQL 2000 SP4. I want to start setting
up email alerts and reporting on the SQL server. The network admin team is
not ok with installing any mail client. Is there any other way to have
email alerts setup without installing any mail client?
use http://www.sqldev.net/xp/xpsmtp.htm
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"docsql" <docsql@.noemail.nospam> wrote in message
news:OLBxJoIHGHA.2444@.TK2MSFTNGP11.phx.gbl...
>I have a Windows 2003 server running SQL 2000 SP4. I want to start setting
>up email alerts and reporting on the SQL server. The network admin team is
>not ok with installing any mail client. Is there any other way to have
>email alerts setup without installing any mail client?
>
>
|||You can use http://www.karaszi.com/SQLServer/util_smtp_alerter.asp. But I haven't looked at the code
for a long while now. If you want to use this and run into problem, I can provide you with source
code (VB.NET) so you can go in and fix stuff.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"docsql" <docsql@.noemail.nospam> wrote in message news:OLBxJoIHGHA.2444@.TK2MSFTNGP11.phx.gbl...
>I have a Windows 2003 server running SQL 2000 SP4. I want to start setting up email alerts and
>reporting on the SQL server. The network admin team is not ok with installing any mail client. Is
>there any other way to have email alerts setup without installing any mail client?
>
>

Tuesday, March 20, 2012

AJAX Style funcionality with Reportviewer?

Hi everyone my name is Egli

well i was just wondering is it possible to include/mix the AJAX partial page update functionality with the Reporting service reportviewer? i know that the reportviewer has an async option available, but theres still a postback hapening when the report is initially set to viewstate false (when passing from false to true)... hey fellas im just curious

Many thanks in advance... Yes

Hi Egli,

I am also invloved in avoiding postbacks on the reportviewer control . Is there any way to implement Ajax functionality with the Reportviewer control. Please let e know if find out anything on this.

Great Thanks. Yes

AJAX Renderer

I'm in the process of writing a new renderer for Reporting Services to get
around some of the problems it's main HTML renderer has - fixed headers,
screen flash, losing scroll position on refresh, customisable refresh rate
etc.
Although it's been fun trying to do this with almost no documentation at
all, the project is almost at an end. However, there is one last thing I'd
like to implement to make life a little more efficient. That is to only send
the changes to the client once the original page has been rendered.
Something like Gmail does with it's JavaScript arrays.
My request is for ideas on how I can create diffs from within the renderer.
Do I need to cache the entire report object model until the next update
request or is there some easy field in the model to say "it's changed"? Does
anyone have any other ideas about how I might do this? What is the best way
of identifying an individual client from within the renderer (my only
current idea is to generate a guid or similar and embed that in the initial
rendering)?
Regards,
James SnapeHello James,
This seems to be more related to report execution and cache management
other than a rendering extension. Based on my scope, the report server
makes every attempt to render a report from its cached copy when caching
has been configured for an individual report. There are some cases in
which the report may not be rendered from cache:
Report parameter values do not match the report parameter values that were
used when executing the report stored in cache.
If a report cannot be rendered from a cached copy the report is be executed
against the data source(s).
Cache Invalidation can based on a period of time or schedule. Usually it is
not feaisble to only create changes between different snapshots so that you
could update client with this differences because there is no method to
reference previous snapshot inside renderring extension.
I believe this may require a bit more in depth attention and may fall under
the umbrella of Advisory Services. Microsoft now offers short-term and
proactive assistance for specific planning, design, development or
assistance with installing, deploying, and general "how to" advice via
telephone. For more information:
http://support.microsoft.com/default.aspx?scid=fh;en-us;advisoryservice
Thanks & 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.
=====================================================
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
Others: https://partner.microsoft.com/US/technicalsupport/supportoverview/
If you are outside the United States, please visit our International
Support page:
http://support.microsoft.com/default.aspx?scid=%2finternational.aspx.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
--
| From: "James Snape" <jim_snape.at.hotmail.com@.online.nospam>
| Subject: AJAX Renderer
| Date: Thu, 6 Oct 2005 12:11:52 +0100
| Lines: 23
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
| X-RFC2646: Format=Flowed; Original
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
| Message-ID: <u0LpGbmyFHA.1256@.TK2MSFTNGP09.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: ip-213-92-131-1.aramiska-arc.aramiska.net 213.92.131.1
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:53834
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| I'm in the process of writing a new renderer for Reporting Services to
get
| around some of the problems it's main HTML renderer has - fixed headers,
| screen flash, losing scroll position on refresh, customisable refresh
rate
| etc.
|
| Although it's been fun trying to do this with almost no documentation at
| all, the project is almost at an end. However, there is one last thing
I'd
| like to implement to make life a little more efficient. That is to only
send
| the changes to the client once the original page has been rendered.
| Something like Gmail does with it's JavaScript arrays.
|
| My request is for ideas on how I can create diffs from within the
renderer.
| Do I need to cache the entire report object model until the next update
| request or is there some easy field in the model to say "it's changed"?
Does
| anyone have any other ideas about how I might do this? What is the best
way
| of identifying an individual client from within the renderer (my only
| current idea is to generate a guid or similar and embed that in the
initial
| rendering)?
|
| Regards,
| James Snape
|
|
||||Hi Peter,
I think you have mostly answered my question in that any differences would
have to be calculated by me and that will create a lot of memory pressure to
store pervious versions of the object model for a large number of clients.
One follow up I have is about when a datasource query happens.. There is no
point having a refreshing report if it is going to just render the same data
from a cache every 10 seconds or so. Currently I'm forcing a
ClearSession=true to make sure the data changes. Can you confirm that this
with ensure data sources are requeried? Are there any other side affects
that I should be aware of?
Regards,
James Snape
"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:ETChb%23vyFHA.780@.TK2MSFTNGXA01.phx.gbl...
> Hello James,
> This seems to be more related to report execution and cache management
> other than a rendering extension. Based on my scope, the report server
> makes every attempt to render a report from its cached copy when caching
> has been configured for an individual report. There are some cases in
> which the report may not be rendered from cache:
> Report parameter values do not match the report parameter values that were
> used when executing the report stored in cache.
> If a report cannot be rendered from a cached copy the report is be
> executed
> against the data source(s).
> Cache Invalidation can based on a period of time or schedule. Usually it
> is
> not feaisble to only create changes between different snapshots so that
> you
> could update client with this differences because there is no method to
> reference previous snapshot inside renderring extension.
> I believe this may require a bit more in depth attention and may fall
> under
> the umbrella of Advisory Services. Microsoft now offers short-term and
> proactive assistance for specific planning, design, development or
> assistance with installing, deploying, and general "how to" advice via
> telephone. For more information:
> http://support.microsoft.com/default.aspx?scid=fh;en-us;advisoryservice
> Thanks & 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.
> =====================================================> Business-Critical Phone Support (BCPS) provides you with technical phone
> support at no charge during critical LAN outages or "business down"
> situations. This benefit is available 24 hours a day, 7 days a week to all
> Microsoft technology partners in the United States and Canada.
> This and other support options are available here:
> BCPS:
> https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
> Others: https://partner.microsoft.com/US/technicalsupport/supportoverview/
> If you are outside the United States, please visit our International
> Support page:
> http://support.microsoft.com/default.aspx?scid=%2finternational.aspx.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> --
> | From: "James Snape" <jim_snape.at.hotmail.com@.online.nospam>
> | Subject: AJAX Renderer
> | Date: Thu, 6 Oct 2005 12:11:52 +0100
> | Lines: 23
> | X-Priority: 3
> | X-MSMail-Priority: Normal
> | X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
> | X-RFC2646: Format=Flowed; Original
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
> | Message-ID: <u0LpGbmyFHA.1256@.TK2MSFTNGP09.phx.gbl>
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: ip-213-92-131-1.aramiska-arc.aramiska.net
> 213.92.131.1
> | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09.phx.gbl
> | Xref: TK2MSFTNGXA01.phx.gbl
> microsoft.public.sqlserver.reportingsvcs:53834
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | I'm in the process of writing a new renderer for Reporting Services to
> get
> | around some of the problems it's main HTML renderer has - fixed headers,
> | screen flash, losing scroll position on refresh, customisable refresh
> rate
> | etc.
> |
> | Although it's been fun trying to do this with almost no documentation at
> | all, the project is almost at an end. However, there is one last thing
> I'd
> | like to implement to make life a little more efficient. That is to only
> send
> | the changes to the client once the original page has been rendered.
> | Something like Gmail does with it's JavaScript arrays.
> |
> | My request is for ideas on how I can create diffs from within the
> renderer.
> | Do I need to cache the entire report object model until the next update
> | request or is there some easy field in the model to say "it's changed"?
> Does
> | anyone have any other ideas about how I might do this? What is the best
> way
> | of identifying an individual client from within the renderer (my only
> | current idea is to generate a guid or similar and embed that in the
> initial
> | rendering)?
> |
> | Regards,
> | James Snape
> |
> |
> |
>|||Hello James,
I think it is dependent how the report is configured to execute. By
default, each time a user navigates to a report and selects it for viewing
the report server communicates with and queries the report?s data
source(s), formats the report and renders the report to the specified
format. If the the data within the data source(s) does not change
frequently or if you may want to manage computing resources that are
associated with the execution of a report, you may optionally cache the
report.
Optionally you may configure an individual report to be cached when the
execution of a report is against a live data source(s). If configured to
be cached, when a report is executed for the first time, a copy of the
report (intermediate format) is stored in the cache. Subsequent requests
to the report are served from the cache.
The cached copy of the report may be invalidated based on one of the
following configurable options.
- Cache invalidation based on a period of time expressed in minutes.
- Cache invalidation based on a specific, recurring date and time (Scoped
or Shared Schedule).
Also, a reports cached copy may be invalidated when one of the following
events occur to a report.
- Report Parameters change
- Report Definition changes
- Data Source Credentials change
- Cache Options change
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.
| From: "James Snape" <jim_snape.at.hotmail.com@.online.nospam>
| References: <u0LpGbmyFHA.1256@.TK2MSFTNGP09.phx.gbl>
<ETChb#vyFHA.780@.TK2MSFTNGXA01.phx.gbl>
| Subject: Re: AJAX Renderer
| Date: Fri, 7 Oct 2005 09:38:11 +0100
| Lines: 134
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
| X-RFC2646: Format=Flowed; Original
| Message-ID: <eieZ5pxyFHA.2312@.TK2MSFTNGP14.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: ip-213-92-131-1.aramiska-arc.aramiska.net 213.92.131.1
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP14.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:53920
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Hi Peter,
|
| I think you have mostly answered my question in that any differences
would
| have to be calculated by me and that will create a lot of memory pressure
to
| store pervious versions of the object model for a large number of clients.
|
| One follow up I have is about when a datasource query happens.. There is
no
| point having a refreshing report if it is going to just render the same
data
| from a cache every 10 seconds or so. Currently I'm forcing a
| ClearSession=true to make sure the data changes. Can you confirm that
this
| with ensure data sources are requeried? Are there any other side affects
| that I should be aware of?
|
| Regards,
| James Snape
|
| "Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
| news:ETChb%23vyFHA.780@.TK2MSFTNGXA01.phx.gbl...
| > Hello James,
| >
| > This seems to be more related to report execution and cache management
| > other than a rendering extension. Based on my scope, the report server
| > makes every attempt to render a report from its cached copy when caching
| > has been configured for an individual report. There are some cases in
| > which the report may not be rendered from cache:
| > Report parameter values do not match the report parameter values that
were
| > used when executing the report stored in cache.
| >
| > If a report cannot be rendered from a cached copy the report is be
| > executed
| > against the data source(s).
| >
| > Cache Invalidation can based on a period of time or schedule. Usually
it
| > is
| > not feaisble to only create changes between different snapshots so that
| > you
| > could update client with this differences because there is no method to
| > reference previous snapshot inside renderring extension.
| >
| > I believe this may require a bit more in depth attention and may fall
| > under
| > the umbrella of Advisory Services. Microsoft now offers short-term and
| > proactive assistance for specific planning, design, development or
| > assistance with installing, deploying, and general "how to" advice via
| > telephone. For more information:
| >
| > http://support.microsoft.com/default.aspx?scid=fh;en-us;advisoryservice
| >
| > Thanks & 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.
| >
| > =====================================================| >
| > Business-Critical Phone Support (BCPS) provides you with technical phone
| > support at no charge during critical LAN outages or "business down"
| > situations. This benefit is available 24 hours a day, 7 days a week to
all
| > Microsoft technology partners in the United States and Canada.
| >
| > This and other support options are available here:
| >
| > BCPS:
| >
https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
| >
| > Others:
https://partner.microsoft.com/US/technicalsupport/supportoverview/
| >
| > If you are outside the United States, please visit our International
| > Support page:
| > http://support.microsoft.com/default.aspx?scid=%2finternational.aspx.
| >
| > =====================================================| >
| > This posting is provided "AS IS" with no warranties, and confers no
| > rights.
| >
| > --
| > | From: "James Snape" <jim_snape.at.hotmail.com@.online.nospam>
| > | Subject: AJAX Renderer
| > | Date: Thu, 6 Oct 2005 12:11:52 +0100
| > | Lines: 23
| > | X-Priority: 3
| > | X-MSMail-Priority: Normal
| > | X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
| > | X-RFC2646: Format=Flowed; Original
| > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
| > | Message-ID: <u0LpGbmyFHA.1256@.TK2MSFTNGP09.phx.gbl>
| > | Newsgroups: microsoft.public.sqlserver.reportingsvcs
| > | NNTP-Posting-Host: ip-213-92-131-1.aramiska-arc.aramiska.net
| > 213.92.131.1
| > | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09.phx.gbl
| > | Xref: TK2MSFTNGXA01.phx.gbl
| > microsoft.public.sqlserver.reportingsvcs:53834
| > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
| > |
| > | I'm in the process of writing a new renderer for Reporting Services to
| > get
| > | around some of the problems it's main HTML renderer has - fixed
headers,
| > | screen flash, losing scroll position on refresh, customisable refresh
| > rate
| > | etc.
| > |
| > | Although it's been fun trying to do this with almost no documentation
at
| > | all, the project is almost at an end. However, there is one last thing
| > I'd
| > | like to implement to make life a little more efficient. That is to
only
| > send
| > | the changes to the client once the original page has been rendered.
| > | Something like Gmail does with it's JavaScript arrays.
| > |
| > | My request is for ideas on how I can create diffs from within the
| > renderer.
| > | Do I need to cache the entire report object model until the next
update
| > | request or is there some easy field in the model to say "it's
changed"?
| > Does
| > | anyone have any other ideas about how I might do this? What is the
best
| > way
| > | of identifying an individual client from within the renderer (my only
| > | current idea is to generate a guid or similar and embed that in the
| > initial
| > | rendering)?
| > |
| > | Regards,
| > | James Snape
| > |
| > |
| > |
| >
|
|
|

Monday, March 19, 2012

Aggregete() function doesn't work for SQL query results! - Part 2

I am writing my own MDX query inside Reporting Services, bypassing the graphic MDX generator.

Both MDX query and SQL query return identical results and both have detail level values and high level values.

During the flattenning process, null value from MDX is still null, but null value from SQL is translated into blank.

Thus only the MDX result works for Aggregate() function, not the SQL result. Because Aggregate() function is triggered by null value, not blank.

Someone suggested to use MDX stored procedure to do custom calculations. Thus my report is calling a MDX query, not a SQL query. I have tried this approach already, but MDX is not as flexible as SQL. For example, in SQL, I can easily join, pivot, order by, group by, filter...None of these is easy in MDX.

If I know how to make reporting services treat null as null or to make Aggregate() function be triggered by a blank value, then my problem is solved.

Does Aggregate() funciton only works with MDX, not SQL?

Thanks,

Bo Dong

bo_dong@.yahoo.com

The Aggregate() function only works in combination with a data extension that implements the IDataReaderExtension interface (see: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_ref_clr_dataproc_9lit.asp).

The "Analysis Services" data extension available in RS 2005 implements this interface and internally detects aggregation rows based on nulls in hierarchies and exposes that information through the IDataReaderExtension interface.

Note: The "SQL Server" data extension available in RS 2005 does not implement this interface.

You can implement your own custom data extension (http://msdn2.microsoft.com/en-us/library/ms154655.aspx) and then implement the IDataReaderExtension interface - based on that you have full control in your custom data extension of how exactly aggregate rows from your relational query are marked.

-- Robert

Aggregete() function doesn't work for SQL query results!

Reporting Services translates null value into blank on SQL query results, but not on MDX query results. But Aggregate() functions is triggered only by null value.

So Aggregate() function only works for MDX query results, not for SQL query results.

MDX example:

select {[Measures].[Sales]} on columns,

{[Account].[Hierarchy].Members} on rows

FROM Cube

SQL example:

SELECT * FROM OPENQUERY(Linked_Cube, '
select {[Measures].[Sales]} on columns,

{[Account].[Hierarchy].Members} on rows

FROM Cube')

Now you build a report with a table, then add a grouping and use "=Aggregate(Fields!Sales.Value)" for the group level cell. If you bind MDX query to this table, then aggregates show up correctly. But if you bind SQL query to this table, there are no aggregates at all.

I need to use SQL query to drive my reports, because MDX query results need to be merged with results from other calculations.

How can I make Aggregate() function to work for SQL query results?

Thanks,

Bo Dong

bo_dong@.yahoo.com

How can I make it to work for SQL as well?

Please read my answer on your other thread: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=668524&SiteID=1

-- Robert

Sunday, March 11, 2012

Aggregation and granularity levels

I'm having problems implementing the following in reporting services 2005.
My hierarchy looks like this (just to illustrate the problem...):
University->Student->Exam
My query returns the following fields:
University, Student, StudentPayment, ExamName, ExamScore
I need to create a report that will show the hierarchy and to smartly
aggregate the StudentPayment to both the Student and the University levels.
The problem is that the StudentPayment field is being multiplied by the
number of exams in the upper level aggregation.
If only I could set the granularity level of the StudentPayment measurement...
Note that I don't have access to the query, so I can't change anything on
that front.
Thanks,
EfiHello Efi,
I would like to know this more detailed.
How you calculated the StudentPayment?
Did you mean that you use a constant like $10 to multiplied by the count
amount of the exams the student takes?
If you have used a group for each level of University and Student, you
could have a aggregation expression like this:
AVG(Fields!StudentPayment, 'Group_name')
You could refer this article.
Aggregate Functions (Reporting Services)
http://msdn2.microsoft.com/en-us/library/aa255811(SQL.80).aspx
Hope this will be helpful.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hello Efi,
I understand this issue.
It seems that the dataset you use is not a 3NF data. So we may not
calculated the Student Payment.
You may use some embbed code to sum the column. I am researching this.
Sincerely,
Wei Lu
Microsoft Online Community 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.|||Hello Efi,
Unfortunately, I did not find the solution yet.
A workaround maybe using the custom code to sum the Payment by code.
Or you could add a second dataset to get the distinct Payment for the
Student and aggregate it.
Sincerely,
Wei Lu
Microsoft Online Community 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.|||Can you please send me an example of a custom code the aggregates a field?
Thanks,
"Wei Lu [MSFT]" wrote:
> Hello Efi,
> Unfortunately, I did not find the solution yet.
> A workaround maybe using the custom code to sum the Payment by code.
> Or you could add a second dataset to get the distinct Payment for the
> Student and aggregate it.
> Sincerely,
> Wei Lu
> Microsoft Online Community 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.
>|||Hello Efi,
Currently, I did not have any examples yet. I will try to figure out any
example for you but it will be some time consuming so I appreciate your
patience. Thank you!
Sincerely,
Wei Lu
Microsoft Online Community 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.|||Hello Efi,
My internal colleague suggest that you need to change your dataset. Which
means you need to modify the sql statement you use to get the dataset or
create a new dataset.
Could you please let me know if you could do this?
Could you contact your DBA to create a new stored procedure to get the
information you want?
Sincerely,
Wei Lu
Microsoft Online Community 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.|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community 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.

Thursday, March 8, 2012

aggregate query reporting different results

forgive the absense of DDL and data to reproduce this problem, but it
is 8 tables and hundreds of thousands of rows of data. instead, let me
just post the query and the symptom and we'll see how far that can get
me.
select r.description, sum(t.amount), count(*)
from salesregion as r
join metroarea as w on r.salesregionid = w.salesregionid
join saleitems as a on a.website = w.id
join transactions as t on t.adid = a.adid
join orders as o on t.orderid = o.orderid
join products as p on t.productid = p.productid
where o.orderpaid = 1
and datepart(mm, o.datecreated) = 2
and datepart(year, o.datecreated) = 2006
and p.type in (1, 3)
group by r.description
order by r.description asc
when this query is run in our production support environment, which has
almost no load, it produces completely predictable results every time.
however, when this same query is run in our production environment,
which has identical data, but a much higher load, the aggregate
functions fluctuate very slightly (one to three rows).
i have read on this issue and found two possible remedies:
1) "option (maxdop 1)" (a response i've seen in many threads on this
ng) - i applied this, it had no effect at all on the stability of the
results
2) apply sql service pack 4 (known parallelism bug described at
http://support.microsoft.com/kb/814509) - my question here is: does
load affect parallelism? because production and production support
environments both have service pack 3 applied, but it's happening in
one and not the other. i will apply the service pack if necessary, but
i want to make sure that the parallelism bug is known to occur only
under high load.
thanks in advance for any help,
jasonoh, an additional note:
when i further narrow the search results to just calculate the
aggregates for a single salesregion, like so:
select r.description, sum(t.amount), count(*)
from salesregion as r
join metroarea as w on r.salesregionid = w.salesregionid
join saleitems as a on a.website = w.id
join transactions as t on t.adid = a.adid
join orders as o on t.orderid = o.orderid
join products as p on t.productid = p.productid
where o.orderpaid = 1
and datepart(mm, o.datecreated) = 2
and datepart(year, o.datecreated) = 2006
and p.type in (1, 3)
AND r.description = 'Arizona' -- NEW LINE
group by r.description
order by r.description asc
then it becomes deterministic again!

Tuesday, March 6, 2012

aggregate function in the argument to another aggregate function

Hello all,
I am new to SQL Reporting services and I am having trouble performing a
group sum. I Currently have a group within another group the embedded
group (group2) is performing a group sum
(=3DCount(Fields!FacilityTemp1.V=ACalue/Fields!Temp2.Value) and this works
fine but now I would like to use the outside group to perform a sum of
all values within group2 however SQL reporting Services does not allow
aggregate function in the argument to another aggregate function. Does
anyone no how I can simply get around this. Expression that does not
work:
=3DSUM(Count(Fields!FacilityTemp=AC1.Value/Fields!Temp2.Value)
Thanks=20
ChrisSince this question is specific to SQL Server Reporting Services, you
should post it in the microsoft.public.sqlserver.reportingsvcs group.
Razvan

Monday, February 13, 2012

After Intallation

I have a box with SQL Server DataServices with W2K3 SP2 & SQL2005 SP2, then
I have a box with W2K3 with SP2 where I have Reporting Services, at the
configuration page, everything is green and all services started,
initialized and I get this error from:
http://<server>/reports
"Unable to connect to the remote server"
Any Ideas?
Thanks,
VictorOn Jun 18, 12:52 pm, "Victor Rodriguez" <lasals...@.newsgroups.nospam>
wrote:
> I have a box with SQL Server DataServices with W2K3 SP2 & SQL2005 SP2, then
> I have a box with W2K3 with SP2 where I have Reporting Services, at the
> configuration page, everything is green and all services started,
> initialized and I get this error from:
> http://<server>/reports
> "Unable to connect to the remote server"
> Any Ideas?
> Thanks,
> Victor
Have you made sure that IIS is running on your Reporting Services box?
It's turned off by default in Win2003.
rb|||I have 10 different sites on the same box and they're all working.
Victor
"roger.bigger@.good-dog.net" <roger.bigger@.gmail.com> wrote in message
news:1182186112.402444.169070@.m36g2000hse.googlegroups.com...
> On Jun 18, 12:52 pm, "Victor Rodriguez" <lasals...@.newsgroups.nospam>
> wrote:
>> I have a box with SQL Server DataServices with W2K3 SP2 & SQL2005 SP2,
>> then
>> I have a box with W2K3 with SP2 where I have Reporting Services, at the
>> configuration page, everything is green and all services started,
>> initialized and I get this error from:
>> http://<server>/reports
>> "Unable to connect to the remote server"
>> Any Ideas?
>> Thanks,
>> Victor
> Have you made sure that IIS is running on your Reporting Services box?
> It's turned off by default in Win2003.
> rb
>|||Hello Victor,
To know the issue better, please let me know the following:
1. Can you access http://<server>/reportserver properly?
2. Please check if the following ls listed properly in
RSWebApplication.config. If you have SSL enabled for the report server,
please make sure the following is listed
<UrlRoot>https://<server>/ReportServer</UrlRoot>
<ReportServerUrl>https://<server>/ReportServe</ReportServerUrl>
RSWebApplication.config is under
C:\Program Files\Microsoft SQL Server\MSSQL.x\Reporting
Services\ReportManager
In addition, this issue could occur if some Antivirus program is installed.
You may want to check if the issue occurs if they are disabled on your
server.
If you have any update, please feel free to let's know. Thank you.
Best 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.|||When I try to run http://<server>/reportserver, i get:
<server>/ReportServer - /
Microsoft SQL Server Reporting Services Version 9.00.3042.00
I don't have SSL on the website, don't have antivirus on the server.
Anything else I could check?
Thanks,
Victor
""Peter YangMSFT]"" <petery@.online.microsoft.com> wrote in message
news:RzcYHihsHHA.3672@.TK2MSFTNGHUB02.phx.gbl...
> Hello Victor,
> To know the issue better, please let me know the following:
> 1. Can you access http://<server>/reportserver properly?
> 2. Please check if the following ls listed properly in
> RSWebApplication.config. If you have SSL enabled for the report server,
> please make sure the following is listed
> <UrlRoot>https://<server>/ReportServer</UrlRoot>
> <ReportServerUrl>https://<server>/ReportServe</ReportServerUrl>
> RSWebApplication.config is under
> C:\Program Files\Microsoft SQL Server\MSSQL.x\Reporting
> Services\ReportManager
> In addition, this issue could occur if some Antivirus program is
> installed.
> You may want to check if the issue occurs if they are disabled on your
> server.
> If you have any update, please feel free to let's know. Thank you.
> Best 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.
>
>|||Hello Victor,
From the result, it seems the issue only occurs on report manager. Going
forward, please let me know what's the configuration of <UrlRoot> and
<ReportServerUrl> in the file RSWebApplication.config. Please make sure the
server name is correct, and you may want to use the FQDN such as
server.domain.com if it's a memeber server of a domain.
If the issue persists, please collect the ReportServerWebApp log under the
following folder and let's know the detailed error information:
C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\LogFiles
If you have other related information, please feel free to let's know.
Thanks.
Best 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.|||Thanks for your response,
I don't have UrlRoot and the <ReportServerUrl></ReportServerUrl> is like
this.
This is the error I get on the logfile:
w3wp!ui!5!6/20/2007-11:28:57:: e ERROR: Unable to connect to the remote
server
w3wp!ui!5!6/20/2007-11:28:58:: e ERROR: HTTP status code --> 500
--Details--
System.Net.WebException: Unable to connect to the remote server -->
System.Net.Sockets.SocketException: No connection could be made because the
target machine actively refused it
at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot,
SocketAddress socketAddress)
at System.Net.Sockets.Socket.InternalConnect(EndPoint remoteEP)
at System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure,
Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState
state, IAsyncResult asyncResult, Int32 timeout, Exception& exception)
-- End of inner exception stack trace --
at
Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
at
Microsoft.ReportingServices.UI.Global.RSWebServiceWrapper.GetSecureMethods()
at
Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String
methodname)
at
Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
at
Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel
level)
at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object
sender, EventArgs args)
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Web.UI.Control.OnInit(EventArgs e)
at System.Web.UI.Page.OnInit(EventArgs e)
at System.Web.UI.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
w3wp!ui!5!6/20/2007-11:29:00:: e ERROR: Exception in ShowErrorPage:
System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean
preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
errMsg) at at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean
preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
errMsg)
Victor
""Peter YangMSFT]"" <petery@.online.microsoft.com> wrote in message
news:S20P4KwsHHA.2316@.TK2MSFTNGHUB02.phx.gbl...
> Hello Victor,
> From the result, it seems the issue only occurs on report manager. Going
> forward, please let me know what's the configuration of <UrlRoot> and
> <ReportServerUrl> in the file RSWebApplication.config. Please make sure
> the
> server name is correct, and you may want to use the FQDN such as
> server.domain.com if it's a memeber server of a domain.
> If the issue persists, please collect the ReportServerWebApp log under the
> following folder and let's know the detailed error information:
> C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\LogFiles
> If you have other related information, please feel free to let's know.
> Thanks.
> Best 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.
>
>|||Hello Victor,
Did you try to change <ReportServerUrl></ReportServerUrl> to
ReportServerUrl>http://servername/ReportServer</ReportServerUrl>?
Also, please check the appliation pool of report manager by running
"inetmgr", and make sure the user of appliation pool has the full
permission of reporting service physical folder.
I look forward to your reply. Thank you.
Best 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.|||Thanks for your response, I tried all your recommendation and still in the
same place, any other suggestions?
Victor
""Peter YangMSFT]"" <petery@.online.microsoft.com> wrote in message
news:FA1vfM9sHHA.2316@.TK2MSFTNGHUB02.phx.gbl...
> Hello Victor,
> Did you try to change <ReportServerUrl></ReportServerUrl> to
> ReportServerUrl>http://servername/ReportServer</ReportServerUrl>?
> Also, please check the appliation pool of report manager by running
> "inetmgr", and make sure the user of appliation pool has the full
> permission of reporting service physical folder.
> I look forward to your reply. Thank you.
> Best 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.
>
>|||Hello,
Will you post the content of the file RSWebApplication.config? You may want
to check if it has the following lines:
<ReportServerUrl>http://servername/ReportServer</ReportServerUrl>
<ReportServerVirtualDirectory></ReportServerVirtualDirectory>
<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
Also, please change the <UrlRoot>machine name/reportserver</<UrlRoot> to
<UrlRoot>FQDN/reportserver</<UrlRoot> in RSReportServer.config file.
You may want to restart IIS by running "iisrest" to take effect.
Best 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.|||Hello Victor, have you made it by this time?
I still can't figure it out. If I fill the <ReportServerUrl> (which is
blank by default in my environment) I get the following error message:
"The configuration file contains an element that is not valid. The
ReportServerUrl element is not a configuration file element."
I do not have SSL. Does anyone have an idea? Still stuck on this
issue... :-(
Leo Lopes @. L3

After installing reporting services Dev edition ASP does not work

I was running ThinSlicer a ASP application fine on my Windows 2000
professional workstation running SQL develeper edition. This was
running fine under IIS 5 until I installed reporting services developer
edition on the same Win 2k Professional running IIS 5 now thinslicer
does not work so is quite a few ASP applications I am not sure what
reporting services install as done to IIS that these other ASP
applications are stuffed.
I get the following error when I access Thinslicer now after installing
reporting services :
when I run
http://myworkstation/Thinslicer/Ts.asp
This was working fine before I installed reporting services not sure
what changes reporting services as done.
The page cannot be displayed
There is a problem with the page you are trying to reach and it cannot
be displayed.
----
Please try the following:
Click the Refresh button, or try again later.
Open the myworkstation home page, and then look for links to the
information you want.
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services
----
Technical Information (for support personnel)
Error Type:
Microsoft VBScript runtime (0x800A01C2)
Wrong number of arguments or invalid property assignment: 'objTS.Cut'
/Thinslicer/ts.asp, line 81
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; (R1 1.5); .NET CLR
1.1.4322)
Page:
GET /Thinslicer/ts.asp
Time:
Saturday, May 14, 2005, 6:57:19 PM
More information:
Microsoft SupportSounds like somehow the ThinSlicer components have become hidden from the
application. I don't know why this would happen, but if ThinSlicer came with
an installation program you could try running it again.
"karenmiddleol@.yahoo.com" wrote:
> I was running ThinSlicer a ASP application fine on my Windows 2000
> professional workstation running SQL develeper edition. This was
> running fine under IIS 5 until I installed reporting services developer
> edition on the same Win 2k Professional running IIS 5 now thinslicer
> does not work so is quite a few ASP applications I am not sure what
> reporting services install as done to IIS that these other ASP
> applications are stuffed.
> I get the following error when I access Thinslicer now after installing
> reporting services :
> when I run
> http://myworkstation/Thinslicer/Ts.asp
>
> This was working fine before I installed reporting services not sure
> what changes reporting services as done.
>
> The page cannot be displayed
> There is a problem with the page you are trying to reach and it cannot
> be displayed.
> ----
> Please try the following:
> Click the Refresh button, or try again later.
> Open the myworkstation home page, and then look for links to the
> information you want.
> HTTP 500.100 - Internal Server Error - ASP error
> Internet Information Services
> ----
> Technical Information (for support personnel)
> Error Type:
> Microsoft VBScript runtime (0x800A01C2)
> Wrong number of arguments or invalid property assignment: 'objTS.Cut'
> /Thinslicer/ts.asp, line 81
>
> Browser Type:
> Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; (R1 1.5); .NET CLR
> 1.1.4322)
> Page:
> GET /Thinslicer/ts.asp
> Time:
> Saturday, May 14, 2005, 6:57:19 PM
>
> More information:
> Microsoft Support
>

Thursday, February 9, 2012

Advise on Forms Authentication

ok i am doing a system in asp.net and also using reporting services to
generate some reports for user to view.
My system consists of two parts which is the Suggestor and the Evaluator.
Firstly the suggestor will go to a aspx page whereby they can submit new
suggestions by filling up the page and before they submit the suggestion,
they had to choose from a dropdownlist box which contains all the available
Evaluator Full Name, so that this suggestion will only be sent to the choosen
Evaluator to be evaluated. And all data will be store in SQL Server 2000.
So now the suggestions need to be rejected or accepted by the evaluator and
i am using reporting services to generate the page for the evaluator to view
the suggestions that had been submitted to them. and i am not sure of how to
go about using forms authentication to allow the evaluator to login, so that
when they login successfully, they will be allow to view suggestions that is
associated to them. Do i use Active Directory login in asp.net then link to
reporting services? or is there any other method that i can use so that the
Evaluator that had been login can view their own suggestions in the reporting
services.
For your information, all the evaluator profiles are store in Active
Directory server thats why i thought of using AD login to carry out my task.
Ok in order to let u all have a clearer view of what i want to achieved, i
will use the following example.
For example now i am going to submit a suggestions. and i go to the aspx
page and fill up all the necessary data and lastly select a Evaluator from
the dropdownlist box. take for example i selected "Tan Boon Keng" as the
evaluator and i submitted my suggestion. So now "Tan Boon Keng" need to
evaluate my suggestion n inorder to evaluate the suggestion, he need to login
through some forms authentication so that he can only see the suggestions
that is related to him, n not seeing ALL the suggestions that had been
submitted. and the page where they view the suggestions is generate by
reporting services so how should i go about implementing this system to work
as what i want to achieved.
Sorry for the long post and thanks in advance...Hi, is there anybody that can help me or give me advise on how should i do
this?
i tried using forms authentication in asp.net then when evaluator login
through that page, they will be direct to the reporting services page and
they can view their suggestions only. but i not sure how to get the logon
user session id to query the database for the suggestions related to that
particular logon user.
"JiaN" wrote:
> ok i am doing a system in asp.net and also using reporting services to
> generate some reports for user to view.
> My system consists of two parts which is the Suggestor and the Evaluator.
> Firstly the suggestor will go to a aspx page whereby they can submit new
> suggestions by filling up the page and before they submit the suggestion,
> they had to choose from a dropdownlist box which contains all the available
> Evaluator Full Name, so that this suggestion will only be sent to the choosen
> Evaluator to be evaluated. And all data will be store in SQL Server 2000.
> So now the suggestions need to be rejected or accepted by the evaluator and
> i am using reporting services to generate the page for the evaluator to view
> the suggestions that had been submitted to them. and i am not sure of how to
> go about using forms authentication to allow the evaluator to login, so that
> when they login successfully, they will be allow to view suggestions that is
> associated to them. Do i use Active Directory login in asp.net then link to
> reporting services? or is there any other method that i can use so that the
> Evaluator that had been login can view their own suggestions in the reporting
> services.
> For your information, all the evaluator profiles are store in Active
> Directory server thats why i thought of using AD login to carry out my task.
> Ok in order to let u all have a clearer view of what i want to achieved, i
> will use the following example.
> For example now i am going to submit a suggestions. and i go to the aspx
> page and fill up all the necessary data and lastly select a Evaluator from
> the dropdownlist box. take for example i selected "Tan Boon Keng" as the
> evaluator and i submitted my suggestion. So now "Tan Boon Keng" need to
> evaluate my suggestion n inorder to evaluate the suggestion, he need to login
> through some forms authentication so that he can only see the suggestions
> that is related to him, n not seeing ALL the suggestions that had been
> submitted. and the page where they view the suggestions is generate by
> reporting services so how should i go about implementing this system to work
> as what i want to achieved.
> Sorry for the long post and thanks in advance...

Thursday, March 29, 2012

alignement data

alignement data

alignement data

Tuesday, March 27, 2012

align the parameters in reports

Aliasing a column name

Aliasing a column name

Sunday, March 25, 2012

Alerts

Alerts

Alerts

Tuesday, March 20, 2012

AJAX Style funcionality with Reportviewer?

AJAX Renderer

Monday, March 19, 2012

Aggregete() function doesn't work for SQL query results! - Part 2

Aggregete() function doesn't work for SQL query results!

Sunday, March 11, 2012

Aggregation and granularity levels

Thursday, March 8, 2012

aggregate query reporting different results

Tuesday, March 6, 2012

aggregate function in the argument to another aggregate function

Monday, February 13, 2012

After Intallation

After installing reporting services Dev edition ASP does not work

Thursday, February 9, 2012

Advise on Forms Authentication

SQL tool for MSDE

Blog Archive

About Me