Hi folks,
I've done some experimenting with the SQL Server Reporting Services and
like them very much.
However, I now have a problem I wasn't able to find a solution for: I need
to create a monthly report about my company's sales. I've set up my
subscription so that the report is mailed (as pdf) on every Monday in the
new month's first week.
Of course, I want to have the *LAST* month reported, not the current one,
so I'd need to compute the start- and end date of the report (which are
parameters). How can I do that?
Thanks!
JensCheck out the DateAdd function at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vblr7/html/vaorivbruntimelibrarykeywords.asp
roland|||I had exactly the same need (actually who doesn't! this should be easier ..)
and finally decided to write and external assembly that defines the ToDate
and FromDate based on relative periods stored in the DB (PeriodID passed )
The PeriodID allows me to find the calculation rule for taking today as a
starting point and start calculating relative Periods (range or single dates
( last month, last 3 month, first quarter, etc, etc.))
Sebastian|||In news:OtzAWWzYEHA.3564@.TK2MSFTNGP11.phx.gbl,
Sebastian Talamoni <sebastian.talamoni@.radventure.nl> typed:
> I had exactly the same need (actually who doesn't! this
> should be easier ..) and finally decided to write and
> external assembly that defines the ToDate and FromDate
> based on relative periods stored in the DB (PeriodID
> passed )
> The PeriodID allows me to find the calculation rule for
> taking today as a starting point and start calculating
> relative Periods (range or single dates ( last month,
> last 3 month, first quarter, etc, etc.))
> Sebastian
What I meant was: Don't provide any parameters on call. Schedule your
reports to run on every first of a month. Define defaults for the parameters
which calculate e.g. the first of the last month that way:
= new System.DateTime(Year(DateAdd(DateInterval.Month, -1,
Globals!ExecutionTime)), Month(DateAdd(DateInterval.Month, -1,
Globals!ExecutionTime)),1)
Other values in comparible manner, left to your phantasy :)
roland
Showing posts with label services. Show all posts
Showing posts with label services. Show all posts
Sunday, March 25, 2012
Computed Fields/Multiple Datasources
I am getting started with Reporting Services.
I am having trouble with computed fields. I have two issues:
1. I have a special dataset that I use to read parameters from a
database table. This table has only one row. I would like to add a
computed field that divides one of the columns in this row by another.
I created a computed field called ProRatedMultiplier with the following
definition:
=Fields!OPERATINGDAYSINMONTH.Value/Fields!INVOICINGDAY.Value
The problem is that when I insert this computed field into my report,
it wants to sum the output:
=Sum(Fields!DailyInvoiceProRateMultiplier.Value, "InputDataDS")
If I remove the SUM() function, I get compile errors.
I need to use this computed value in many places on the report and thus
would like to have the formula defined only once (instead of repeating
it in each field).
It seems SRS sees it as returning one or more rows and thus wants to
aggregate. Am I going about this the wrong way? Can I make any changes
to make this work?
2. Assuming I get the above to work, I will have this new computed
field on my dataset. I would like to create a computed field on another
dataset that uses this first computed field value.
This new, second computed field would multiply the first computed field
value (which is a pro-rata multiplier) by the sum() aggregate of a
column in the second dataset.
The definition would like something like this:
=SUM( Fields!INVOICEAMOUNT.Value) *
Fields!DailyInvoiceProRateMultiplier.Value, "InputDataDS"
This also will not compile.
Am I going about this the wrong way?For #1:
Use the First aggregate function:
=First(Fields!DailyInvoiceProRateMultiplier.Value, "InputDataDS")
So even if your InputDataDS dataset has more than one rows (for whatever
reasons), you will still get the expected result. Since you use the
calculated field value in another dataset, you cannot omit the aggregate
function (otherwise the fields collection would be scoped to the wrong
dataset).
For #2:
You could write an expression in a textbox like this:
=SUM( Fields!INVOICEAMOUNT.Value) * First(
Fields!DailyInvoiceProRateMultiplier.Value, "InputDataDS")
However, you cannot define a calculated field which uses aggregate
functions.
Probably a better solution for #1 & #2:
Since you have only 1 row - did you look into hidden textboxes, which
calculate the formulas instead of calculated fields? You could then
reference the value of the formula textbox in other textboxes by using an
expression like
=ReportItems!FormulaTextbox.Value
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Hunter Hillegas" <hunter.hillegas@.gmail.com> wrote in message
news:chqjea$pq0@.odak26.prod.google.com...
> I am getting started with Reporting Services.
> I am having trouble with computed fields. I have two issues:
> 1. I have a special dataset that I use to read parameters from a
> database table. This table has only one row. I would like to add a
> computed field that divides one of the columns in this row by another.
> I created a computed field called ProRatedMultiplier with the following
> definition:
> =Fields!OPERATINGDAYSINMONTH.Value/Fields!INVOICINGDAY.Value
> The problem is that when I insert this computed field into my report,
> it wants to sum the output:
> =Sum(Fields!DailyInvoiceProRateMultiplier.Value, "InputDataDS")
> If I remove the SUM() function, I get compile errors.
> I need to use this computed value in many places on the report and thus
> would like to have the formula defined only once (instead of repeating
> it in each field).
> It seems SRS sees it as returning one or more rows and thus wants to
> aggregate. Am I going about this the wrong way? Can I make any changes
> to make this work?
> 2. Assuming I get the above to work, I will have this new computed
> field on my dataset. I would like to create a computed field on another
> dataset that uses this first computed field value.
> This new, second computed field would multiply the first computed field
> value (which is a pro-rata multiplier) by the sum() aggregate of a
> column in the second dataset.
> The definition would like something like this:
> =SUM( Fields!INVOICEAMOUNT.Value) *
> Fields!DailyInvoiceProRateMultiplier.Value, "InputDataDS"
> This also will not compile.
> Am I going about this the wrong way?
>
I am having trouble with computed fields. I have two issues:
1. I have a special dataset that I use to read parameters from a
database table. This table has only one row. I would like to add a
computed field that divides one of the columns in this row by another.
I created a computed field called ProRatedMultiplier with the following
definition:
=Fields!OPERATINGDAYSINMONTH.Value/Fields!INVOICINGDAY.Value
The problem is that when I insert this computed field into my report,
it wants to sum the output:
=Sum(Fields!DailyInvoiceProRateMultiplier.Value, "InputDataDS")
If I remove the SUM() function, I get compile errors.
I need to use this computed value in many places on the report and thus
would like to have the formula defined only once (instead of repeating
it in each field).
It seems SRS sees it as returning one or more rows and thus wants to
aggregate. Am I going about this the wrong way? Can I make any changes
to make this work?
2. Assuming I get the above to work, I will have this new computed
field on my dataset. I would like to create a computed field on another
dataset that uses this first computed field value.
This new, second computed field would multiply the first computed field
value (which is a pro-rata multiplier) by the sum() aggregate of a
column in the second dataset.
The definition would like something like this:
=SUM( Fields!INVOICEAMOUNT.Value) *
Fields!DailyInvoiceProRateMultiplier.Value, "InputDataDS"
This also will not compile.
Am I going about this the wrong way?For #1:
Use the First aggregate function:
=First(Fields!DailyInvoiceProRateMultiplier.Value, "InputDataDS")
So even if your InputDataDS dataset has more than one rows (for whatever
reasons), you will still get the expected result. Since you use the
calculated field value in another dataset, you cannot omit the aggregate
function (otherwise the fields collection would be scoped to the wrong
dataset).
For #2:
You could write an expression in a textbox like this:
=SUM( Fields!INVOICEAMOUNT.Value) * First(
Fields!DailyInvoiceProRateMultiplier.Value, "InputDataDS")
However, you cannot define a calculated field which uses aggregate
functions.
Probably a better solution for #1 & #2:
Since you have only 1 row - did you look into hidden textboxes, which
calculate the formulas instead of calculated fields? You could then
reference the value of the formula textbox in other textboxes by using an
expression like
=ReportItems!FormulaTextbox.Value
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Hunter Hillegas" <hunter.hillegas@.gmail.com> wrote in message
news:chqjea$pq0@.odak26.prod.google.com...
> I am getting started with Reporting Services.
> I am having trouble with computed fields. I have two issues:
> 1. I have a special dataset that I use to read parameters from a
> database table. This table has only one row. I would like to add a
> computed field that divides one of the columns in this row by another.
> I created a computed field called ProRatedMultiplier with the following
> definition:
> =Fields!OPERATINGDAYSINMONTH.Value/Fields!INVOICINGDAY.Value
> The problem is that when I insert this computed field into my report,
> it wants to sum the output:
> =Sum(Fields!DailyInvoiceProRateMultiplier.Value, "InputDataDS")
> If I remove the SUM() function, I get compile errors.
> I need to use this computed value in many places on the report and thus
> would like to have the formula defined only once (instead of repeating
> it in each field).
> It seems SRS sees it as returning one or more rows and thus wants to
> aggregate. Am I going about this the wrong way? Can I make any changes
> to make this work?
> 2. Assuming I get the above to work, I will have this new computed
> field on my dataset. I would like to create a computed field on another
> dataset that uses this first computed field value.
> This new, second computed field would multiply the first computed field
> value (which is a pro-rata multiplier) by the sum() aggregate of a
> column in the second dataset.
> The definition would like something like this:
> =SUM( Fields!INVOICEAMOUNT.Value) *
> Fields!DailyInvoiceProRateMultiplier.Value, "InputDataDS"
> This also will not compile.
> Am I going about this the wrong way?
>
Tuesday, March 20, 2012
Compress/Zip Reporting Services Export options
Hey everyone,
I have an issue where i am sending out files with 30,000+ lines and they are reaching the 11mb, 12mb in size.
This is becoming and issue for us, as we are only allowed to email up to 10mb in size.
I have tried reducing all spaces in the data, removing any graphics etc from the report , but still the excel file is over 11mb. One thing i did find was that, if i export it to excel, then open the file and save as a different file name the file size drops 50% !!
I was wondering if anyone has been able to zip/compress the exported file before it gets emailed?
It would be a great feature for MS to include in the next service pack.. Take advantage of the built in Zip support in Windows..
Look forward to hearing any suggestions that the community may have,
Thanks
Scotty
Hi there-Unfortunately you'll have to create a custom delivery extension for your report server. You can look at the PrinterDeleiveryExample in the RS samples folder (located wherever you installed RS) to give you an idea of what you'll need to do.
If you are using .Net 2.0, then you can use the System.IO.Compression and System.Net.Mail libraries as part of your delivery extension. I unfortunately have a client that hasn't migrated to .Net 2.0 and I had to use .Net 1.1. I used two open source libraries to accomplish the task: DotNetOpenMail and SharpZipLib. I decided to use DotNetOpenMail, because you can create an attachment from an array of bytes, which you can't do with the System.Web.Mail library in .Net 1.1. So for my custom delivery extension, I zipped my report to a memory stream and then attached that stream's byte array to the e-mail.
Here are some links to get you started:
DotNetOpenMail - http://dotnetopenmail.sourceforge.net
SharpZipLib - http://www.icsharpcode.net/OpenSource/SharpZipLib
Hope that gives you a starting point to a solution. If you have any questions, please respond back here.
Regards,
Scott
Monday, March 19, 2012
Componente Services + win xp sp2
Hi.
I've intalled windows xp service pack 2, since there I cant' view Component
Services -> Transaction Statistics from a remote server.
I'm not using XP Firewall.
Any ideia?
Thanks
EsioI found the problem...
RPC changed.
http://msdn.microsoft.com/security/productinfo/XPSP2/networkprotection/restrict_remote_clients.aspx
Esio
"Esio Nunes" <esio_nunes@.hotmail.com> escreveu na mensagem
news:uznYoqk%23EHA.4092@.TK2MSFTNGP09.phx.gbl...
> Hi.
> I've intalled windows xp service pack 2, since there I cant' view
> Component Services -> Transaction Statistics from a remote server.
> I'm not using XP Firewall.
> Any ideia?
> Thanks
> Esio
>
I've intalled windows xp service pack 2, since there I cant' view Component
Services -> Transaction Statistics from a remote server.
I'm not using XP Firewall.
Any ideia?
Thanks
EsioI found the problem...
RPC changed.
http://msdn.microsoft.com/security/productinfo/XPSP2/networkprotection/restrict_remote_clients.aspx
Esio
"Esio Nunes" <esio_nunes@.hotmail.com> escreveu na mensagem
news:uznYoqk%23EHA.4092@.TK2MSFTNGP09.phx.gbl...
> Hi.
> I've intalled windows xp service pack 2, since there I cant' view
> Component Services -> Transaction Statistics from a remote server.
> I'm not using XP Firewall.
> Any ideia?
> Thanks
> Esio
>
Componente Services + win xp sp2
Hi.
I've intalled Windows XP service pack 2, since there I cant' view Component
Services -> Transaction Statistics from a remote server.
I'm not using XP Firewall.
Any ideia?
Thanks
EsioI found the problem...
RPC changed.
http://msdn.microsoft.com/security/...te_clients.aspx
Esio
"Esio Nunes" <esio_nunes@.hotmail.com> escreveu na mensagem
news:uznYoqk%23EHA.4092@.TK2MSFTNGP09.phx.gbl...
> Hi.
> I've intalled Windows XP service pack 2, since there I cant' view
> Component Services -> Transaction Statistics from a remote server.
> I'm not using XP Firewall.
> Any ideia?
> Thanks
> Esio
>
I've intalled Windows XP service pack 2, since there I cant' view Component
Services -> Transaction Statistics from a remote server.
I'm not using XP Firewall.
Any ideia?
Thanks
EsioI found the problem...
RPC changed.
http://msdn.microsoft.com/security/...te_clients.aspx
Esio
"Esio Nunes" <esio_nunes@.hotmail.com> escreveu na mensagem
news:uznYoqk%23EHA.4092@.TK2MSFTNGP09.phx.gbl...
> Hi.
> I've intalled Windows XP service pack 2, since there I cant' view
> Component Services -> Transaction Statistics from a remote server.
> I'm not using XP Firewall.
> Any ideia?
> Thanks
> Esio
>
component services, DTC network access
I am trying to get an XP machine to insert data into a linked Windows
2003 SBS Premium machine. I have done it w/ XP to 2003 but the SBS seems
to have a different Security Configuration on the MSDTC tab in the
COmponent Services. There are no options for inbound or outbound, only:
Network DTC access (checked)
Network Administration (not checked)
Network Transactions (not checked)
Network Clients (not checked)
Transaction Internet Protocol (TIP) Transactions (not checked)
XA Transactions (not checked)
I have done the Application Server option for Network DTC Access.
Any ideas why the screen is different and what I can do to fix?
The server properties say:
Microsoft Windows Server 2003
for Small Business Server
Darin
*** Sent via Developersdex http://www.codecomments.com ***
Hi
I assume that distributed transactions are not working? You may want to ask
in the SBS newsgroup why this is different microsoft.public.windows.server.sbs
John
"Darin" wrote:
> I am trying to get an XP machine to insert data into a linked Windows
> 2003 SBS Premium machine. I have done it w/ XP to 2003 but the SBS seems
> to have a different Security Configuration on the MSDTC tab in the
> COmponent Services. There are no options for inbound or outbound, only:
> Network DTC access (checked)
> Network Administration (not checked)
> Network Transactions (not checked)
> Network Clients (not checked)
> Transaction Internet Protocol (TIP) Transactions (not checked)
> XA Transactions (not checked)
> I have done the Application Server option for Network DTC Access.
> Any ideas why the screen is different and what I can do to fix?
> The server properties say:
> Microsoft Windows Server 2003
> for Small Business Server
> Darin
> *** Sent via Developersdex http://www.codecomments.com ***
>
2003 SBS Premium machine. I have done it w/ XP to 2003 but the SBS seems
to have a different Security Configuration on the MSDTC tab in the
COmponent Services. There are no options for inbound or outbound, only:
Network DTC access (checked)
Network Administration (not checked)
Network Transactions (not checked)
Network Clients (not checked)
Transaction Internet Protocol (TIP) Transactions (not checked)
XA Transactions (not checked)
I have done the Application Server option for Network DTC Access.
Any ideas why the screen is different and what I can do to fix?
The server properties say:
Microsoft Windows Server 2003
for Small Business Server
Darin
*** Sent via Developersdex http://www.codecomments.com ***
Hi
I assume that distributed transactions are not working? You may want to ask
in the SBS newsgroup why this is different microsoft.public.windows.server.sbs
John
"Darin" wrote:
> I am trying to get an XP machine to insert data into a linked Windows
> 2003 SBS Premium machine. I have done it w/ XP to 2003 but the SBS seems
> to have a different Security Configuration on the MSDTC tab in the
> COmponent Services. There are no options for inbound or outbound, only:
> Network DTC access (checked)
> Network Administration (not checked)
> Network Transactions (not checked)
> Network Clients (not checked)
> Transaction Internet Protocol (TIP) Transactions (not checked)
> XA Transactions (not checked)
> I have done the Application Server option for Network DTC Access.
> Any ideas why the screen is different and what I can do to fix?
> The server properties say:
> Microsoft Windows Server 2003
> for Small Business Server
> Darin
> *** Sent via Developersdex http://www.codecomments.com ***
>
component services, DTC network access
I am trying to get an XP machine to insert data into a linked Windows
2003 SBS Premium machine. I have done it w/ XP to 2003 but the SBS seems
to have a different Security Configuration on the MSDTC tab in the
COmponent Services. There are no options for inbound or outbound, only:
Network DTC access (checked)
Network Administration (not checked)
Network Transactions (not checked)
Network Clients (not checked)
Transaction Internet Protocol (TIP) Transactions (not checked)
XA Transactions (not checked)
I have done the Application Server option for Network DTC Access.
Any ideas why the screen is different and what I can do to fix?
The server properties say:
Microsoft Windows Server 2003
for Small Business Server
Darin
*** Sent via Developersdex http://www.codecomments.com ***Hi
I assume that distributed transactions are not working? You may want to ask
in the SBS newsgroup why this is different microsoft.public.windows.server.s
bs
John
"Darin" wrote:
> I am trying to get an XP machine to insert data into a linked Windows
> 2003 SBS Premium machine. I have done it w/ XP to 2003 but the SBS seems
> to have a different Security Configuration on the MSDTC tab in the
> COmponent Services. There are no options for inbound or outbound, only:
> Network DTC access (checked)
> Network Administration (not checked)
> Network Transactions (not checked)
> Network Clients (not checked)
> Transaction Internet Protocol (TIP) Transactions (not checked)
> XA Transactions (not checked)
> I have done the Application Server option for Network DTC Access.
> Any ideas why the screen is different and what I can do to fix?
> The server properties say:
> Microsoft Windows Server 2003
> for Small Business Server
> Darin
> *** Sent via Developersdex http://www.codecomments.com ***
>
2003 SBS Premium machine. I have done it w/ XP to 2003 but the SBS seems
to have a different Security Configuration on the MSDTC tab in the
COmponent Services. There are no options for inbound or outbound, only:
Network DTC access (checked)
Network Administration (not checked)
Network Transactions (not checked)
Network Clients (not checked)
Transaction Internet Protocol (TIP) Transactions (not checked)
XA Transactions (not checked)
I have done the Application Server option for Network DTC Access.
Any ideas why the screen is different and what I can do to fix?
The server properties say:
Microsoft Windows Server 2003
for Small Business Server
Darin
*** Sent via Developersdex http://www.codecomments.com ***Hi
I assume that distributed transactions are not working? You may want to ask
in the SBS newsgroup why this is different microsoft.public.windows.server.s
bs
John
"Darin" wrote:
> I am trying to get an XP machine to insert data into a linked Windows
> 2003 SBS Premium machine. I have done it w/ XP to 2003 but the SBS seems
> to have a different Security Configuration on the MSDTC tab in the
> COmponent Services. There are no options for inbound or outbound, only:
> Network DTC access (checked)
> Network Administration (not checked)
> Network Transactions (not checked)
> Network Clients (not checked)
> Transaction Internet Protocol (TIP) Transactions (not checked)
> XA Transactions (not checked)
> I have done the Application Server option for Network DTC Access.
> Any ideas why the screen is different and what I can do to fix?
> The server properties say:
> Microsoft Windows Server 2003
> for Small Business Server
> Darin
> *** Sent via Developersdex http://www.codecomments.com ***
>
Wednesday, March 7, 2012
Complex Quieries - Reporting Services
Greetings:
I have the following query which will get the column name of the table I am trying to work on ..
· SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS Where TABLE_NAME = 'MyDataTable'
This query will give me the column name of “MyDataTable”. But I need to add some calculated field – i.e get the number of rows which are not null from “myDataTable” for a particular column.
I tried :
SELECT COLUMN_NAME,
myField = (Select Count(*) from myDataTable);
FROM INFORMATION_SCHEMA.COLUMNS Where TABLE_NAME = 'MyDataTable'
The above one gives me the total number of rows in the “myDataTable”
myField should be base on the name of the column, so it should be something like
myField = (Select Count(COLUMN_NAME) from myDataTable);
But When I do that the COLUMN_NAME is not recognized during run-time.
Anybody that have some kind of idea for a work around please help.
Thanks,
Yared,
Dynamic query can be used.
http://msdn2.microsoft.com/en-us/library/ms157131.aspx
Sunday, February 19, 2012
Completely Removing SQL Server 2005 Express
I've recently tried to load SQL Server 2005 Express onto the main server that services our small company of 10 people. The server is a W2K Server, and acts as our domain controller. I've had NUMEROUS problems trying to get SQL Server 2005 Express to work on this system - so much so that I've given up trying. However, in attempting to uninstall this, I've now encountered even bigger issues. It seems that the uninstaller leaves files behind (such as VSS Writer, Set up Files) that then will not uninstall themselves. So, being the novice I am, I tried re-installing SQL Server Express as a whole, removing the above files, then uninstalling SQL Server Express "proper." Well, that didn't work either - I got the subordinate stuff to come off, but now the main files won't remove - nor can I reinstall the whole thing any more.
This is an absolute mess - and I need help getting out of it. Can anyone direct me to help on how to SAFELY remove the ENTIRE instance of SQL Server 2005 Express so that nothing else is interrupted/harmed? Any sound advice at this point is most appreciated.
I ve got the same Problem here. Ive installed the Beta of Visual Studie - even after de-installation it was not possible to install Sql Server Developer edition.
I think it is something wrong in registry...|||Not sure about uninstalling, but I think I saw a blurb somewhere on the books online stating you shouldn't install SQL 2005 on a domain controller...|||
SQLWriter and Support files (amongst other 'leftovers') should uninstall just fine after SQL is gone. They may pop up a message saying that removing them may cause other dependent applications to fail. But if you have already removed all instances of SQL Server 2005, you should be fine.
In the situation where you removed them while SQL Express was already on the box, I would suggest installing Express again (to let the installer put back what you deleted), then uninstalling Express, then uninstalling the leftovers.
If that fails, as a last resort you can use the Windows Installer clean up tool. However this may leave some services behind. I definitely recommend
http://download.microsoft.com/download/E/9/D/E9D80355-7AB4-45B8-80E8-983A48D5E1BD/msicuu2.exe
Complete Newbie Question
I have just installed Reporting Services and created a few reports that
I want to run in a web page - that seems easy enough to do but my boss
has asked me to provide a batch reporting solution.
He wants users to be able to request a report and the request be
written away to a sql db. I have a windows service that picks up all
new requests and fires up some .exe's depending on what sort of request
it is e.g password reset , password reminder etc..
When the reports are run I need them to be saved as PDF's into a
specific folder that can be accessed later from a web page.
Now all this is written and working using ActiveReports for .NET but we
hate that package and want to use sql reporting services. Can it be
done in sql reporting services and if so how do I do it - I mean I need
some real code examples
any help would be brilliant
cheers
JimI have been using log4net to log to SQL DB. You can log the web request when
reports are rendered. It is upto you to write the logic to who views the
page( for eg using session object who the user was like,
Session["UserName"]). log4net allows you to log when certain events are
triggered blah blah... Check out:
http://logging.apache.org/log4net/release/config-examples.html
Look for ADONETAppender which is what you want.
HTH
Rajesh Meenrajan
MCSD.NET
http://meenrajan.blogspot.com
"JimW13UK" wrote:
> I have just installed Reporting Services and created a few reports that
> I want to run in a web page - that seems easy enough to do but my boss
> has asked me to provide a batch reporting solution.
> He wants users to be able to request a report and the request be
> written away to a sql db. I have a windows service that picks up all
> new requests and fires up some .exe's depending on what sort of request
> it is e.g password reset , password reminder etc..
> When the reports are run I need them to be saved as PDF's into a
> specific folder that can be accessed later from a web page.
> Now all this is written and working using ActiveReports for .NET but we
> hate that package and want to use sql reporting services. Can it be
> done in sql reporting services and if so how do I do it - I mean I need
> some real code examples
> any help would be brilliant
> cheers
> Jim
>
I want to run in a web page - that seems easy enough to do but my boss
has asked me to provide a batch reporting solution.
He wants users to be able to request a report and the request be
written away to a sql db. I have a windows service that picks up all
new requests and fires up some .exe's depending on what sort of request
it is e.g password reset , password reminder etc..
When the reports are run I need them to be saved as PDF's into a
specific folder that can be accessed later from a web page.
Now all this is written and working using ActiveReports for .NET but we
hate that package and want to use sql reporting services. Can it be
done in sql reporting services and if so how do I do it - I mean I need
some real code examples
any help would be brilliant
cheers
JimI have been using log4net to log to SQL DB. You can log the web request when
reports are rendered. It is upto you to write the logic to who views the
page( for eg using session object who the user was like,
Session["UserName"]). log4net allows you to log when certain events are
triggered blah blah... Check out:
http://logging.apache.org/log4net/release/config-examples.html
Look for ADONETAppender which is what you want.
HTH
Rajesh Meenrajan
MCSD.NET
http://meenrajan.blogspot.com
"JimW13UK" wrote:
> I have just installed Reporting Services and created a few reports that
> I want to run in a web page - that seems easy enough to do but my boss
> has asked me to provide a batch reporting solution.
> He wants users to be able to request a report and the request be
> written away to a sql db. I have a windows service that picks up all
> new requests and fires up some .exe's depending on what sort of request
> it is e.g password reset , password reminder etc..
> When the reports are run I need them to be saved as PDF's into a
> specific folder that can be accessed later from a web page.
> Now all this is written and working using ActiveReports for .NET but we
> hate that package and want to use sql reporting services. Can it be
> done in sql reporting services and if so how do I do it - I mean I need
> some real code examples
> any help would be brilliant
> cheers
> Jim
>
Friday, February 17, 2012
compilation error while adding web reference RS05
hi,
if i try to add a web reference in my c# application to reporting services
2005 i got a compilation error.
a part of the displayed message:
--
source error:
line 4: <%@. Import Namespace="System.Xml" %> <-- is a red line
error message:
CS0234: The type or namespace name 'Xml' does not exist in the namspace
'System' (are you missing an assembly reference?
do anybody know a solution for this problem?
thx
MartinTake a look at this forum:
http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=10847
particularly the post from AkhilaL MSFT
Jens Konerow
if i try to add a web reference in my c# application to reporting services
2005 i got a compilation error.
a part of the displayed message:
--
source error:
line 4: <%@. Import Namespace="System.Xml" %> <-- is a red line
error message:
CS0234: The type or namespace name 'Xml' does not exist in the namspace
'System' (are you missing an assembly reference?
do anybody know a solution for this problem?
thx
MartinTake a look at this forum:
http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=10847
particularly the post from AkhilaL MSFT
Jens Konerow
compilation error
While compiling my ADF I am getting the foll. error:
Notification Services could not obtain an identifier needed to construct a Transact-SQL statement
I am trying to create an scheduled subscription with a user-defined rule. I followed the instructions on Shyam Pather's book on SQLNS and was able to create the event-trigerred subscription with user-defined logic. But when I tries to extend this to a scheduled subscription I got this error.
I have searched the net for this but could find no other info on this error?
Any idea what this could mean?
Thanks
DK
Detailed Error:
===================================
An attempt to run a Transact-SQL CREATE PROCEDURE statement failed.
Instance Name: ContentMonitorAlerts
Application Name: ContentAlerts
Stored Procedure Name: NSFireDeveloperDefined%RuleId%
SQL Command Text:
DECLARE @.ruleId INT
SELECT @.ruleId=RuleId
FROM [ContentMonitorAlerts].[ContentAlerts].[NSRules]
WHERE RuleName=N'MatchNewContentsForSubscription'
IF @.ruleId IS NULL
BEGIN
RAISERROR (N'9714: Notification Services could not obtain an identifier needed to construct a Transact-SQL statement.', 16, 1)
RETURN
END
DECLARE @.commandText NVARCHAR(MAX)
SET @.commandText = N'
CREATE PROCEDURE [ContentAlerts].[NSFireDeveloperDefined' + CAST(@.ruleId AS NVARCHAR(MAX)) + N']
AS
BEGIN
I noticed that the error says there was an error while running NSFireDeveloperDefined%RuleId%
I am not sure why NS is trying to run that SP - since I am creating a user-defined rule and not a developer defined rule.
Any light on this issue would be greatly appreciated.
Thanks
DK
I solved it by making some changes to the ADF file.
Thanks
|||What changes you have done to resolve your problem ?
compilation error
While compiling my ADF I am getting the foll. error:
Notification Services could not obtain an identifier needed to construct a Transact-SQL statement
I am trying to create an scheduled subscription with a user-defined rule. I followed the instructions on Shyam Pather's book on SQLNS and was able to create the event-trigerred subscription with user-defined logic. But when I tries to extend this to a scheduled subscription I got this error.
I have searched the net for this but could find no other info on this error?
Any idea what this could mean?
Thanks
DK
Detailed Error:
===================================
An attempt to run a Transact-SQL CREATE PROCEDURE statement failed.
Instance Name: ContentMonitorAlerts
Application Name: ContentAlerts
Stored Procedure Name: NSFireDeveloperDefined%RuleId%
SQL Command Text:
DECLARE @.ruleId INT
SELECT @.ruleId=RuleId
FROM [ContentMonitorAlerts].[ContentAlerts].[NSRules]
WHERE RuleName=N'MatchNewContentsForSubscription'
IF @.ruleId IS NULL
BEGIN
RAISERROR (N'9714: Notification Services could not obtain an identifier needed to construct a Transact-SQL statement.', 16, 1)
RETURN
END
DECLARE @.commandText NVARCHAR(MAX)
SET @.commandText = N'
CREATE PROCEDURE [ContentAlerts].[NSFireDeveloperDefined' + CAST(@.ruleId AS NVARCHAR(MAX)) + N']
AS
BEGIN
I noticed that the error says there was an error while running NSFireDeveloperDefined%RuleId%
I am not sure why NS is trying to run that SP - since I am creating a user-defined rule and not a developer defined rule.
Any light on this issue would be greatly appreciated.
Thanks
DK
I solved it by making some changes to the ADF file.
Thanks
|||What changes you have done to resolve your problem ?Sunday, February 12, 2012
compatibility issue between Reporting Services and IE7 !!!
Is there any compatibility issue between Reporting Services and IE7. We need to test compatibility with both SQL Server 2005/200 versions.
I have been using RS 2005 and IE 7 since IE 7 was released and have had no issues so far.|||The 2005 version of Reporting Services should work with no issues. The 2000 Version of Reporting Services has not been certified to work on IE7. There are known issues that make RS2000 less usable. One issue that I know of is that Document Maps do not work.|||We are having an Issue:
In IE 6 the Report runs correctly but in IE 7 it does not display the complete Report. It cuts off the bottom.
What direction should we look?
|||What version of Reporting Services are you using. RS2000 or 2005?
Please send me a simple repro and I can take a look to see what the issue is. bradsy@.removemicrosoft.com
|||It is SQL Reporting Service 2005.
Will send you more info via E-Mail.
|||We have Reporting services in SQL server 2000 . IE7 cannot download the exported files ( all pdf, excel ...). It prompts an error message when export button is clicked.It works perfectly in IE6.
Anyone has any solution.
|||I too am running into the issue of exporting reports and cannot find a solutions. Has anyone found a work around or has MS released a patch that anyone knows about?
Thanks,
Ben|||
Mr. Sullins,
I, too, am having the same problem. It appears to be something in the rdl, what it is I haven't pinned down. Interestingly, I can get the report to render without being cutoff by deleting this line in my master page:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
Thanks for your help,
Brian Morgan
compatibility issue between Reporting Services and IE7 !!!
Is there any compatibility issue between Reporting Services and IE7. We need to test compatibility with both SQL Server 2005/200 versions.
I have been using RS 2005 and IE 7 since IE 7 was released and have had no issues so far.|||The 2005 version of Reporting Services should work with no issues. The 2000 Version of Reporting Services has not been certified to work on IE7. There are known issues that make RS2000 less usable. One issue that I know of is that Document Maps do not work.|||We are having an Issue:
In IE 6 the Report runs correctly but in IE 7 it does not display the complete Report. It cuts off the bottom.
What direction should we look?
|||What version of Reporting Services are you using. RS2000 or 2005?
Please send me a simple repro and I can take a look to see what the issue is. bradsy@.removemicrosoft.com
|||It is SQL Reporting Service 2005.
Will send you more info via E-Mail.
|||We have Reporting services in SQL server 2000 . IE7 cannot download the exported files ( all pdf, excel ...). It prompts an error message when export button is clicked.It works perfectly in IE6.
Anyone has any solution.|||I too am running into the issue of exporting reports and cannot find a solutions. Has anyone found a work around or has MS released a patch that anyone knows about?
Thanks,
Ben|||
Mr. Sullins,
I, too, am having the same problem. It appears to be something in the rdl, what it is I haven't pinned down. Interestingly, I can get the report to render without being cutoff by deleting this line in my master page:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
Thanks for your help,
Brian Morgan
compatibility issue between Reporting Services and IE7 !!!
Is there any compatibility issue between Reporting Services and IE7. We need to test compatibility with both SQL Server 2005/200 versions.
I have been using RS 2005 and IE 7 since IE 7 was released and have had no issues so far.|||The 2005 version of Reporting Services should work with no issues. The 2000 Version of Reporting Services has not been certified to work on IE7. There are known issues that make RS2000 less usable. One issue that I know of is that Document Maps do not work.|||We are having an Issue:
In IE 6 the Report runs correctly but in IE 7 it does not display the complete Report. It cuts off the bottom.
What direction should we look?
|||What version of Reporting Services are you using. RS2000 or 2005?
Please send me a simple repro and I can take a look to see what the issue is. bradsy@.removemicrosoft.com
|||It is SQL Reporting Service 2005.
Will send you more info via E-Mail.
|||We have Reporting services in SQL server 2000 . IE7 cannot download the exported files ( all pdf, excel ...). It prompts an error message when export button is clicked.It works perfectly in IE6.
Anyone has any solution.
|||I too am running into the issue of exporting reports and cannot find a solutions. Has anyone found a work around or has MS released a patch that anyone knows about?
Thanks,
Ben|||
Mr. Sullins,
I, too, am having the same problem. It appears to be something in the rdl, what it is I haven't pinned down. Interestingly, I can get the report to render without being cutoff by deleting this line in my master page:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
Thanks for your help,
Brian Morgan
compatibility issue between Reporting Services and IE7 !!!
Is there any compatibility issue between Reporting Services and IE7. We need to test compatibility with both SQL Server 2005/200 versions.
I have been using RS 2005 and IE 7 since IE 7 was released and have had no issues so far.|||The 2005 version of Reporting Services should work with no issues. The 2000 Version of Reporting Services has not been certified to work on IE7. There are known issues that make RS2000 less usable. One issue that I know of is that Document Maps do not work.|||We are having an Issue:
In IE 6 the Report runs correctly but in IE 7 it does not display the complete Report. It cuts off the bottom.
What direction should we look?
|||What version of Reporting Services are you using. RS2000 or 2005?
Please send me a simple repro and I can take a look to see what the issue is. bradsy@.removemicrosoft.com
|||It is SQL Reporting Service 2005.
Will send you more info via E-Mail.
|||We have Reporting services in SQL server 2000 . IE7 cannot download the exported files ( all pdf, excel ...). It prompts an error message when export button is clicked.It works perfectly in IE6.
Anyone has any solution.|||I too am running into the issue of exporting reports and cannot find a solutions. Has anyone found a work around or has MS released a patch that anyone knows about?
Thanks,
Ben|||
Mr. Sullins,
I, too, am having the same problem. It appears to be something in the rdl, what it is I haven't pinned down. Interestingly, I can get the report to render without being cutoff by deleting this line in my master page:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
Thanks for your help,
Brian Morgan
Subscribe to:
Comments (Atom)