Hi there,
Just started using Reporting Services instead of Crystal Reports and have a
few questions:
1.) In Crystal, I can add a details section and hide it 'not
onfirstrecord'...which essentially hides all instances of it except the first
one. This allows me to add headers to details in drill-down down reports and
not have them repeat. Is there any way in RS to reference the first instance
of a record and thereby suppress the other instances of it in the Visibility
section?
2.) Is the printing issue in RS going to be addressed anytime soon? (you
have to export RS to excel or adobe for it to print properly right now). I
heard this will be addressed in the next service pack...any idea when this is
going to be out?
Thanks for any ideas on this!
CraigI don't know the answer to #1. MS has stated that client side printing will
be in SP2. No date yet for SP2 has been announced.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Craig R" <Craig R@.discussions.microsoft.com> wrote in message
news:2544345C-7E15-42F9-A27D-13FDF1D16B06@.microsoft.com...
> Hi there,
> Just started using Reporting Services instead of Crystal Reports and have
a
> few questions:
> 1.) In Crystal, I can add a details section and hide it 'not
> onfirstrecord'...which essentially hides all instances of it except the
first
> one. This allows me to add headers to details in drill-down down reports
and
> not have them repeat. Is there any way in RS to reference the first
instance
> of a record and thereby suppress the other instances of it in the
Visibility
> section?
> 2.) Is the printing issue in RS going to be addressed anytime soon? (you
> have to export RS to excel or adobe for it to print properly right now).
I
> heard this will be addressed in the next service pack...any idea when this
is
> going to be out?
> Thanks for any ideas on this!
> Craig
>|||The answer to your first question is yes - you can do that. In the grid, go
into the cell that contains the value that you don't want to have repeated.
Go to its properties and check the box labeled "hide duplicates". Then in
the box below it, select the grouping field that you don't want duplicated.
It will then only display that field value on the report when it changes. It
works - I'm using it on several reports.
sebring1130
"Craig R" wrote:
> Hi there,
> Just started using Reporting Services instead of Crystal Reports and have a
> few questions:
> 1.) In Crystal, I can add a details section and hide it 'not
> onfirstrecord'...which essentially hides all instances of it except the first
> one. This allows me to add headers to details in drill-down down reports and
> not have them repeat. Is there any way in RS to reference the first instance
> of a record and thereby suppress the other instances of it in the Visibility
> section?
> 2.) Is the printing issue in RS going to be addressed anytime soon? (you
> have to export RS to excel or adobe for it to print properly right now). I
> heard this will be addressed in the next service pack...any idea when this is
> going to be out?
> Thanks for any ideas on this!
> Craig
>
Showing posts with label crystal. Show all posts
Showing posts with label crystal. Show all posts
Monday, March 26, 2012
Wednesday, March 21, 2012
Reporting Services Newbie
Im developing an asp.net 2.0 application which has SQL 2005 at the backend.
I was intending to develop reports using Crystal but I thought I'd first take
a look at Reporting services. I never used before so you'll have to bear
with me.
Im trying to work through a Books Online Tutorial. All is fairly
straightforward, until I come to publish the report. Im getting the
following error
"The report server cannot decrypt the symmetric key used to access sensitive
or encrypted data in a report server database. You must either restore a
backup key or delete all encrypted content. Check the documentation for more
information. (rsReportServerDisabled)"
Im not really sure what is going on here and the info Ive found on web has
not helped.
Ive checked my services and "SQL Server Reporting Services (MSSQLSERVER)" is
Started. The Log On account is "Local System Account" - This is unchanged
from installation.
Also, as far as I can tell, the report does not contain any encryped data.
The report is a simple grouped report based on the following SQL
(adventureworks)
SELECT S.OrderDate, S.SalesOrderNumber, S.TotalDue, C.FirstName, C.LastName
FROM HumanResources.Employee E INNER JOIN
Person.Contact C ON E.ContactID = C.ContactID INNER JOIN
Sales.SalesOrderHeader S ON E.EmployeeID = S.SalesPersonID
A more general question that I have is whether reporting services is a
replacement for Crystal. Will I be able to generate reports with subreports.
Will I be able to access them from my web app and will I be able to have my
app pdf them and attach them to emails? If so, are there tutorials available
for these uses of reporting services?
All help appreciated> "The report server cannot decrypt the symmetric key used to access sensitive
> or encrypted data in a report server database. You must either restore a
> backup key or delete all encrypted content. Check the documentation for more
> information. (rsReportServerDisabled)"
OK, Ive managed to resolve this by doing the following suggestion found in
another post:
go to commna prompt
go to C:\Program Files\Microsoft SQL Server\80\Tools\Binn
you should find rskeymgmt,rsconfig etc etc
from this location do this --> "rsKeyMgmt -d"
This deletes all the old symmetric keys
Then restart your IIS
then go back to the command prompt and do "rsconfig -e -u (domain\username)
-p (password)"
This will create the encrypted symmetric keys again.
The user name and password to use are the ones the report server is running
under. (maybe your windows account).
I set the SQL Reporting Service to run under my Admin account ie changed it
from System account (Im not sure what account best practice says this
service, or any of the other SQL services, should run under - could someone
advise)
> A more general question that I have is whether reporting services is a
> replacement for Crystal. Will I be able to generate reports with subreports.
> Will I be able to access them from my web app and will I be able to have my
> app pdf them and attach them to emails? If so, are there tutorials available
> for these uses of reporting services?
Having had a bit of a play, I can see that SQL Reporting Services has huge
potential for our organisation. Initially my main task would be to get to
grips with the ASP ReportViewer control and programmatically setting
parameter values for reports. I'd really appreciated some pointers for
decent books, online resources that show 'real' examples of using Reporting
Services within an ASP application|||Terry,
Check out http://www.gotreportviewer.com/. It is the most comprehensive
report viewer control site around. There is also a newsgroup dedicated to the
controls here:
http://forums.microsoft.com/msdn/showforum.aspx?forumid=75&siteid=1
--
Andy Potter
blog: http://sqlreportingservices.spaces.live.com/
"Terry Holland" wrote:
> > "The report server cannot decrypt the symmetric key used to access sensitive
> > or encrypted data in a report server database. You must either restore a
> > backup key or delete all encrypted content. Check the documentation for more
> > information. (rsReportServerDisabled)"
> OK, Ive managed to resolve this by doing the following suggestion found in
> another post:
> go to commna prompt
> go to C:\Program Files\Microsoft SQL Server\80\Tools\Binn
> you should find rskeymgmt,rsconfig etc etc
> from this location do this --> "rsKeyMgmt -d"
> This deletes all the old symmetric keys
> Then restart your IIS
> then go back to the command prompt and do "rsconfig -e -u (domain\username)
> -p (password)"
> This will create the encrypted symmetric keys again.
> The user name and password to use are the ones the report server is running
> under. (maybe your windows account).
> I set the SQL Reporting Service to run under my Admin account ie changed it
> from System account (Im not sure what account best practice says this
> service, or any of the other SQL services, should run under - could someone
> advise)
> > A more general question that I have is whether reporting services is a
> > replacement for Crystal. Will I be able to generate reports with subreports.
> > Will I be able to access them from my web app and will I be able to have my
> > app pdf them and attach them to emails? If so, are there tutorials available
> > for these uses of reporting services?
> Having had a bit of a play, I can see that SQL Reporting Services has huge
> potential for our organisation. Initially my main task would be to get to
> grips with the ASP ReportViewer control and programmatically setting
> parameter values for reports. I'd really appreciated some pointers for
> decent books, online resources that show 'real' examples of using Reporting
> Services within an ASP application|||I found the Step by Step book for Reporting Services 2005 gave a good
introduction.
Microsoft SQL Server 2005 Reporting Services Step By Step
ISBN: 0735622507
amazon link:
http://www.amazon.com/Microsoft-Server-2005-Reporting-Services/dp/0735622507/ref=sr_1_5/103-1359644-0587846?ie=UTF8&s=books&qid=1175393092&sr=1-5
"Terry Holland" <MSDNNospam248@.nospam.nospam> wrote in message
news:CBC4ECC2-1023-4449-9838-5577A9C3B17C@.microsoft.com...
>> "The report server cannot decrypt the symmetric key used to access
>> sensitive
>> or encrypted data in a report server database. You must either restore a
>> backup key or delete all encrypted content. Check the documentation for
>> more
>> information. (rsReportServerDisabled)"
> OK, Ive managed to resolve this by doing the following suggestion found in
> another post:
> go to commna prompt
> go to C:\Program Files\Microsoft SQL Server\80\Tools\Binn
> you should find rskeymgmt,rsconfig etc etc
> from this location do this --> "rsKeyMgmt -d"
> This deletes all the old symmetric keys
> Then restart your IIS
> then go back to the command prompt and do "rsconfig -e -u
> (domain\username)
> -p (password)"
> This will create the encrypted symmetric keys again.
> The user name and password to use are the ones the report server is
> running
> under. (maybe your windows account).
> I set the SQL Reporting Service to run under my Admin account ie changed
> it
> from System account (Im not sure what account best practice says this
> service, or any of the other SQL services, should run under - could
> someone
> advise)
>> A more general question that I have is whether reporting services is a
>> replacement for Crystal. Will I be able to generate reports with
>> subreports.
>> Will I be able to access them from my web app and will I be able to have
>> my
>> app pdf them and attach them to emails? If so, are there tutorials
>> available
>> for these uses of reporting services?
> Having had a bit of a play, I can see that SQL Reporting Services has huge
> potential for our organisation. Initially my main task would be to get to
> grips with the ASP ReportViewer control and programmatically setting
> parameter values for reports. I'd really appreciated some pointers for
> decent books, online resources that show 'real' examples of using
> Reporting
> Services within an ASP applicationsql
I was intending to develop reports using Crystal but I thought I'd first take
a look at Reporting services. I never used before so you'll have to bear
with me.
Im trying to work through a Books Online Tutorial. All is fairly
straightforward, until I come to publish the report. Im getting the
following error
"The report server cannot decrypt the symmetric key used to access sensitive
or encrypted data in a report server database. You must either restore a
backup key or delete all encrypted content. Check the documentation for more
information. (rsReportServerDisabled)"
Im not really sure what is going on here and the info Ive found on web has
not helped.
Ive checked my services and "SQL Server Reporting Services (MSSQLSERVER)" is
Started. The Log On account is "Local System Account" - This is unchanged
from installation.
Also, as far as I can tell, the report does not contain any encryped data.
The report is a simple grouped report based on the following SQL
(adventureworks)
SELECT S.OrderDate, S.SalesOrderNumber, S.TotalDue, C.FirstName, C.LastName
FROM HumanResources.Employee E INNER JOIN
Person.Contact C ON E.ContactID = C.ContactID INNER JOIN
Sales.SalesOrderHeader S ON E.EmployeeID = S.SalesPersonID
A more general question that I have is whether reporting services is a
replacement for Crystal. Will I be able to generate reports with subreports.
Will I be able to access them from my web app and will I be able to have my
app pdf them and attach them to emails? If so, are there tutorials available
for these uses of reporting services?
All help appreciated> "The report server cannot decrypt the symmetric key used to access sensitive
> or encrypted data in a report server database. You must either restore a
> backup key or delete all encrypted content. Check the documentation for more
> information. (rsReportServerDisabled)"
OK, Ive managed to resolve this by doing the following suggestion found in
another post:
go to commna prompt
go to C:\Program Files\Microsoft SQL Server\80\Tools\Binn
you should find rskeymgmt,rsconfig etc etc
from this location do this --> "rsKeyMgmt -d"
This deletes all the old symmetric keys
Then restart your IIS
then go back to the command prompt and do "rsconfig -e -u (domain\username)
-p (password)"
This will create the encrypted symmetric keys again.
The user name and password to use are the ones the report server is running
under. (maybe your windows account).
I set the SQL Reporting Service to run under my Admin account ie changed it
from System account (Im not sure what account best practice says this
service, or any of the other SQL services, should run under - could someone
advise)
> A more general question that I have is whether reporting services is a
> replacement for Crystal. Will I be able to generate reports with subreports.
> Will I be able to access them from my web app and will I be able to have my
> app pdf them and attach them to emails? If so, are there tutorials available
> for these uses of reporting services?
Having had a bit of a play, I can see that SQL Reporting Services has huge
potential for our organisation. Initially my main task would be to get to
grips with the ASP ReportViewer control and programmatically setting
parameter values for reports. I'd really appreciated some pointers for
decent books, online resources that show 'real' examples of using Reporting
Services within an ASP application|||Terry,
Check out http://www.gotreportviewer.com/. It is the most comprehensive
report viewer control site around. There is also a newsgroup dedicated to the
controls here:
http://forums.microsoft.com/msdn/showforum.aspx?forumid=75&siteid=1
--
Andy Potter
blog: http://sqlreportingservices.spaces.live.com/
"Terry Holland" wrote:
> > "The report server cannot decrypt the symmetric key used to access sensitive
> > or encrypted data in a report server database. You must either restore a
> > backup key or delete all encrypted content. Check the documentation for more
> > information. (rsReportServerDisabled)"
> OK, Ive managed to resolve this by doing the following suggestion found in
> another post:
> go to commna prompt
> go to C:\Program Files\Microsoft SQL Server\80\Tools\Binn
> you should find rskeymgmt,rsconfig etc etc
> from this location do this --> "rsKeyMgmt -d"
> This deletes all the old symmetric keys
> Then restart your IIS
> then go back to the command prompt and do "rsconfig -e -u (domain\username)
> -p (password)"
> This will create the encrypted symmetric keys again.
> The user name and password to use are the ones the report server is running
> under. (maybe your windows account).
> I set the SQL Reporting Service to run under my Admin account ie changed it
> from System account (Im not sure what account best practice says this
> service, or any of the other SQL services, should run under - could someone
> advise)
> > A more general question that I have is whether reporting services is a
> > replacement for Crystal. Will I be able to generate reports with subreports.
> > Will I be able to access them from my web app and will I be able to have my
> > app pdf them and attach them to emails? If so, are there tutorials available
> > for these uses of reporting services?
> Having had a bit of a play, I can see that SQL Reporting Services has huge
> potential for our organisation. Initially my main task would be to get to
> grips with the ASP ReportViewer control and programmatically setting
> parameter values for reports. I'd really appreciated some pointers for
> decent books, online resources that show 'real' examples of using Reporting
> Services within an ASP application|||I found the Step by Step book for Reporting Services 2005 gave a good
introduction.
Microsoft SQL Server 2005 Reporting Services Step By Step
ISBN: 0735622507
amazon link:
http://www.amazon.com/Microsoft-Server-2005-Reporting-Services/dp/0735622507/ref=sr_1_5/103-1359644-0587846?ie=UTF8&s=books&qid=1175393092&sr=1-5
"Terry Holland" <MSDNNospam248@.nospam.nospam> wrote in message
news:CBC4ECC2-1023-4449-9838-5577A9C3B17C@.microsoft.com...
>> "The report server cannot decrypt the symmetric key used to access
>> sensitive
>> or encrypted data in a report server database. You must either restore a
>> backup key or delete all encrypted content. Check the documentation for
>> more
>> information. (rsReportServerDisabled)"
> OK, Ive managed to resolve this by doing the following suggestion found in
> another post:
> go to commna prompt
> go to C:\Program Files\Microsoft SQL Server\80\Tools\Binn
> you should find rskeymgmt,rsconfig etc etc
> from this location do this --> "rsKeyMgmt -d"
> This deletes all the old symmetric keys
> Then restart your IIS
> then go back to the command prompt and do "rsconfig -e -u
> (domain\username)
> -p (password)"
> This will create the encrypted symmetric keys again.
> The user name and password to use are the ones the report server is
> running
> under. (maybe your windows account).
> I set the SQL Reporting Service to run under my Admin account ie changed
> it
> from System account (Im not sure what account best practice says this
> service, or any of the other SQL services, should run under - could
> someone
> advise)
>> A more general question that I have is whether reporting services is a
>> replacement for Crystal. Will I be able to generate reports with
>> subreports.
>> Will I be able to access them from my web app and will I be able to have
>> my
>> app pdf them and attach them to emails? If so, are there tutorials
>> available
>> for these uses of reporting services?
> Having had a bit of a play, I can see that SQL Reporting Services has huge
> potential for our organisation. Initially my main task would be to get to
> grips with the ASP ReportViewer control and programmatically setting
> parameter values for reports. I'd really appreciated some pointers for
> decent books, online resources that show 'real' examples of using
> Reporting
> Services within an ASP applicationsql
Monday, March 12, 2012
Reporting Services in VS 2005
I have installed Reporting Services as part of the SQL Server 2005 developer installation. I know Crystal Reports is installed as a report designer by default. How do I enable Reporting Services as a Report Designer in VS 2005? Does it install as part SQL Server 2005 client tools? In the previoius version, I believe there was a seperate client installation for Reporting Services in VS 2003..
Thanks!
dotnetnow
In RS2000 you had to use VS 2003 to build reports, now RS 2005 includes a Report Builder.http://msdn2.microsoft.com/en-us/library/ms155933(en-US,SQL.90).aspx|||
Thanks for the information.
Is the RS client part of the SQL Server 2005 client software installation?
Thanks again!
dotnetnow
Saturday, February 25, 2012
reporting services disclaimer in footer from database
Hi,
I have a crystal report im try to convert to sql reporting. This crystal rep
ort has a disclaimer banner which is a sub report which gets the text from t
he database. Also the sub report is in the footer.
Sql reports will not allow me to put a sub report/dataset in the footer or t
he header as i would like to do something
similar!!
I hate crystal so come on MS gives us the flexability we need!!!
Any ideas of workarounds etc
StuFirst thing is to change the subreport into a second dataset in the report.
You don't need a subreport for multiple queries. You could put the field in
a table footer, First(Fields!Dislaimer.Value, "Dataset2") and set the footer
to repeat on new pages.
The best place to post these types of questions is in the
microsoft.public.sqlserver.reportingsvcs newsgroup.
Brian Welcker
Group Program Manager
SQL Server Reporting Services
"Stu" <s.dee@.cognatus.com> wrote in message
news:7AD51F5D-A7FA-4E80-9D05-2E826A676817@.microsoft.com...
report has a disclaimer banner which is a sub report which gets the text
from the database. Also the sub report is in the footer.
the header as i would like to do something
I have tried that
And when i drag the field into the footer and compile it
says
the value for the textbox 'text_1' refers to a field. Fields cannot be
used int headers or footers
Stu
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!|||Could you move this over to the reporting services newsgroup? There are more
people over there who can answer Reporting Services questions than this
group.
You actually can't put a field directly in the page footer. You can put it
in the body and then put a reference to it in the footer, e.g.
ReportItems!Textbox.Value.
Brian Welcker
Group Program Manager
SQL Server Reporting Services
The Microsoft legal department would like me to remind you that this posting
is provided "AS IS" with no warranties, and confers no rights.
"stuart Dee" <s.dee@.cognatus.com> wrote in message
news:eRaIPfQ6DHA.2064@.TK2MSFTNGP11.phx.gbl...
I have a crystal report im try to convert to sql reporting. This crystal rep
ort has a disclaimer banner which is a sub report which gets the text from t
he database. Also the sub report is in the footer.
Sql reports will not allow me to put a sub report/dataset in the footer or t
he header as i would like to do something
similar!!
I hate crystal so come on MS gives us the flexability we need!!!
Any ideas of workarounds etc
StuFirst thing is to change the subreport into a second dataset in the report.
You don't need a subreport for multiple queries. You could put the field in
a table footer, First(Fields!Dislaimer.Value, "Dataset2") and set the footer
to repeat on new pages.
The best place to post these types of questions is in the
microsoft.public.sqlserver.reportingsvcs newsgroup.
Brian Welcker
Group Program Manager
SQL Server Reporting Services
"Stu" <s.dee@.cognatus.com> wrote in message
news:7AD51F5D-A7FA-4E80-9D05-2E826A676817@.microsoft.com...
quote:
> Hi,
> I have a crystal report im try to convert to sql reporting. This crystal
report has a disclaimer banner which is a sub report which gets the text
from the database. Also the sub report is in the footer.
quote:
> Sql reports will not allow me to put a sub report/dataset in the footer or
the header as i would like to do something
quote:|||Hi Brian,
> similar!!
> I hate crystal so come on MS gives us the flexability we need!!!
> Any ideas of workarounds etc
> Stu
>
I have tried that
And when i drag the field into the footer and compile it
says
the value for the textbox 'text_1' refers to a field. Fields cannot be
used int headers or footers
Stu
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!|||Could you move this over to the reporting services newsgroup? There are more
people over there who can answer Reporting Services questions than this
group.
You actually can't put a field directly in the page footer. You can put it
in the body and then put a reference to it in the footer, e.g.
ReportItems!Textbox.Value.
Brian Welcker
Group Program Manager
SQL Server Reporting Services
The Microsoft legal department would like me to remind you that this posting
is provided "AS IS" with no warranties, and confers no rights.
"stuart Dee" <s.dee@.cognatus.com> wrote in message
news:eRaIPfQ6DHA.2064@.TK2MSFTNGP11.phx.gbl...
quote:
> Hi Brian,
> I have tried that
> And when i drag the field into the footer and compile it
> says
> the value for the textbox 'text_1' refers to a field. Fields cannot be
> used int headers or footers
> Stu
>
> *** Sent via Developersdex http://www.examnotes.net ***
> Don't just participate in USENET...get rewarded for it!
Subscribe to:
Posts (Atom)