Question with Email Subscription

Hi,

I have installed Visual Studio 2005 Reporting Services and try to make some subscription. The strange thing is that after I clicked "New Subscription" in the Reporting Manager and Report Delivery Option only shows the option "Report Server File Share" .I cannot select email subscription. Did I miss something out here?

THanks for the help

Josh

Hi Josh,

sure that you have configured the mail-settings using the RS-Frontend?

cheers
markus

Question related to Reporting Services vs Crystal Report

I am migrating my reports from crystal 8 to reporting services 2005 but before this my client wants answers of following question.Can anybody provide me answer or link related to mentioned question...

1 -Will there be any performance improvement when the same Report (considering big data) is being run with Sql-Server reporting services compared to the one with Crystal report engine?

2- Is it possible to make the labels which are part of Top Palette like “1 of 1”, “Find”, “Next”, “Select a format”, ‘Export” according to the Account language?

3- Can both Versions of Reporting Tools (SQL-Reporting service and Crystal Report) run on the same machine?

4- What are the limitations of this Tools like whether there are any additional load on Database Server because of the involvement of Reporting services which are installed on DB Server.

5- Whether there are additional (to Crystal Report) types of Graph formats, Export file types available?

6- How is the licensing done for SQL-Server Report services?

Please provide me the answers ASAP.

This link might help. It is a white sheet on migrating from CR to RS... http://www.microsoft.com/sql/techinfo/whitepapers/migrate-crystal-to-reporting-services.mspx

We have CR and RS on the same machine and there were no problems.

Hope this helps.

|||

WOndering how someone would get the title of "Sr. Software Engineer, SIEMENS Sr. Software Engineer, SIEMENS " and not be able to do his own homework.

Sounded to me like a school report question.

|||

hey mainiac,

If you are not aware about the things then these type of comments doesn't suits on you.

I am a pure C# and VC++ developer and currently working on three tasks simultaniously.

I am putting fresh hand on CR & RS and due to time constraint I wanted quick & exact

solution of mentioned questions.

If we can save our time by this then i think its good approach...

Although if you are not able to answer such queries then don't waste your time

here by commenting like this because this is Information Sharing Plateform for

all of us.There is no place for you and your comments in this technical word.

I hope you will understand the things.

Take care next time...

byee

|||

hi guyinkalamazoo3,

very many thanks to you for your quick reply...

Its great information..

sql

Question regarding calculated fields in reporting services 2005

Is there a concept of scope for calculated fields? I tried the
following and VS crashed.
=IIf(RowNumber("GroupName") = 1, MyValue, 0)
Example of what I am trying to accomplish.
GroupID, MyValue
1, 5
1, 5
1, 5
2, 10
3, 20
3, 20
========== Average MyValue should be (5 + 10 + 20)/3...not (5+5+5+10+20+20)/5.
MyValue would be the same for each GroupID. Does this make sense?Hi,
Infact you can use "Avg()" itself it has a scope parameter.
Amarnath
"Nergock@.gmail.com" wrote:
> Is there a concept of scope for calculated fields? I tried the
> following and VS crashed.
> =IIf(RowNumber("GroupName") = 1, MyValue, 0)
> Example of what I am trying to accomplish.
> GroupID, MyValue
> 1, 5
> 1, 5
> 1, 5
> 2, 10
> 3, 20
> 3, 20
> ==========> Average MyValue should be (5 + 10 + 20)/3...not (5+5+5+10+20+20)/5.
> MyValue would be the same for each GroupID. Does this make sense?
>

question on training providers in Nj/NY area

Does anyone know of training orgs that offer reporting services training? I was given a brief overview,but want a more advanced class.
For those who are using this tool, Is there ad-hoc user reporting? how would you compare this tool to others, like Cognos,etc
any thoughts on this tool would helpful. we currently use crstal reports, but looking for something more sophisticated
bevfor the add-hoc report part in your question it will be supported in reporting service 2005 see the following link
http://www.devx.com/dbzone/Article/28047?trk=DXRSS_DB
if you arelooking for something more sophisticated the answer it is not the reporting service as it is simple , fast and easy to make a report but in the same time it has some limits so u need to knew what do you need exactly?? and choose your tool.|||

I think the level of sophistication is drill downs, etc. Also would be nice to be incorporated in an .net application, either web based or client server. the reporting services seems to have it's own URL, etc

I know cognos is nice, but very pricey. Does anyone have recommendations on similiar report apps? Or if you use cognos, is it worth the price, for the level of reporting, drill down,etc

thanks for any info you may have

bev

|||The SQL Server 2005 version will compare to Cognos but development skills required, with the release of Business Object 11 the SQL Server team is making the development easier because the offerings are similar but Business Object can be used by the executive. One main difference Business Object implemented Time Interval at time span level which will make Time series aggregation easier, I read recently SQL Server 2005 ANSI SQL Time Interval was taken out so fine grain time series aggregation will take more code. Hope this helps.

Question on Report Parameters in SQL Server Reporting Services

I have a question about the Report parameters box size. Is there a way to
adjust the size for the parameter box display. I need inc. the size.
I am using Microsoft Visual Studio to create the reports.
Thanks
--
Tarun PatelOn Oct 23, 2:55 pm, TarunMP <Taru...@.discussions.microsoft.com> wrote:
> I have a question about the Report parameters box size. Is there a way to
> adjust the size for the parameter box display. I need inc. the size.
> I am using Microsoft Visual Studio to create the reports.
> Thanks
> --
> Tarun Patel
Unfortunately, there is not. There might be a way in Reporting
Services 2008, which is rumored to have better CSS control. Sorry that
I could not be of greater assistance.
Regards,
Enrique Martinez
Sr. Software Consultant

Question on passing multi-value parameter for multiple branches

Hello. We are using asp .net and reporting services, and trying to pass a multi-value parameter into reporting services that will show data for multiple branches.

Dim paramList As New Generic.List(Of Microsoft.Reporting.WebForms.ReportParameter)

paramList.Add(New Microsoft.Reporting.WebForms.ReportParameter("BranchNumber", 1))

ReportViewer1.ServerReport.SetParameters(paramList)

pInfo = ReportViewer1.ServerReport.GetParameters()

Let me know if you have any suggestions!

Thanks.

Did you try passing "1,2,3,4" instead of "1" ?

Jens K. Suessmeyer

http://www.sqlserver2005.de
|||We tried that also, without any luck.|||

We have already figured out how to move between seperate branches, we just want a corporate option that will show all branches as a whole.

Any ideas?

Thanks

|||There is no way to post the "All" option, you will either have to pass all values to display or use an additional (hidden) parametert which uses the "All" option behind the scenes, something like:

Where SomeVar IN (@.TheValues) OR @.TheMagicParameter = 1 (Where TheMagicParameter is the magic hidden parameter)

Jens K. Suessmeyer.

http://www.sqlserver2005.de

Question on dynamic sorting

Hi,
I am trying to implement dynamic sorting using Reporting Services. I have 3
dropdowns on a page which contain the list of fields returned by a
stored procedure. What I am doing is creating the <Sorting> tag and its
children dynamically based on the sort the user selected. Then I am loading
the report definition (.rdl) into an Xml doc and I am adding the dynamically
created <Sorting> string to the doc at the appropriate location in the
document as if I had added sorting to the report using the Visual Studio IDE.
Then I turn the Xml doc into Byte[] and I am using this updated Byte[] array
to update the report definition. The problem is when I render the report
using the Render method, sorting does not take place as if the original .rdl
is used instead of the one I updated? Is there a way to dynamically deploy
the updated report definition? Is caching the culprit? Am I missing a step?
Is there a simpler way to implement dynamic sorting using RS?
Thanks muchyou could use the parameter "value" to drive the sorting for your table or
list. Under the sort properties, use =Fields(Parameters!SortBy.Value).Value
to have dynamic sorting.
"ISGADMIN" wrote:
> Hi,
> I am trying to implement dynamic sorting using Reporting Services. I have 3
> dropdowns on a page which contain the list of fields returned by a
> stored procedure. What I am doing is creating the <Sorting> tag and its
> children dynamically based on the sort the user selected. Then I am loading
> the report definition (.rdl) into an Xml doc and I am adding the dynamically
> created <Sorting> string to the doc at the appropriate location in the
> document as if I had added sorting to the report using the Visual Studio IDE.
> Then I turn the Xml doc into Byte[] and I am using this updated Byte[] array
> to update the report definition. The problem is when I render the report
> using the Render method, sorting does not take place as if the original .rdl
> is used instead of the one I updated? Is there a way to dynamically deploy
> the updated report definition? Is caching the culprit? Am I missing a step?
> Is there a simpler way to implement dynamic sorting using RS?
> Thanks much

Question on Data out of sync

Greetings,
Here is the scenario: Server A is Prod, Server B is reporting or
history
Server A does Transactional replication to Server B. Server A gets
records purged at the given point of retention. So as you can tell
Server B will have much more data than Server A. Today, I get the
dreaded call of that data in server A does not seem to be at Server B.
We may have had some issues with replication a couple of weeks ago but
it appeared that they were corrected and replication has been working
fine since.
So , to my questions
Is there any way of pushing over all data on Server A to B to make
sure they are in sync without losing the older data as well?
Any good way of comparing the data in Server A to Server B without
having to go row by row through each table?
I am afraid that we may be out of synch and would like to recify it
without having to drop all replication, bcp out and then bcp back in
to get them back in sync. As you can imagine that is a major headache
and would be my last resort. Any and all ideas are welcome.
Thanks,
MM
You could also have a look at Innovartis DB Ghost at
http://www.innovartis.co.uk/ which can compare & synchronize your
database schema AND data (plus build, verify & version control). I have
found you can use SQL Enterprise Manager to generate scripts to quickly
drop & re-create replication and run DB Ghost to ship your missing rows.
John McGrath MCSE
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!

Question on an unuall issue in SQL reporting Service

There is a developer here running a report using SQL reporting services, It
is a fairly large report and it seems to run fine, But when he tries to
export it to a CSV or EXCEL, it runs for two minutes then brings up an
authentication window, After he inputs his credentials it runs approx another
two minutes then wants him to re-authenticate, after the third instance of
this it fails and will not export. However if he tries to export a smaller
file, it works Okay. One caviat, I recieve an Event ID:10016 around the same
time and it says something about The COM not having a required permission, is
this a factor in my issue?
--
Scott A Cummins
Sr. Systems Engineer
Equity Analytics
( A division of Merrill Lynch)
14614 N. Keirland Blvd
Scottsdale, AZ 85254
480-998-3515On Mar 9, 12:19 pm, Scott Cummins <scumm...@.equitymethods.com> wrote:
> There is a developer here running a report using SQL reporting services, It
> is a fairly large report and it seems to run fine, But when he tries to
> export it to a CSV or EXCEL, it runs for two minutes then brings up an
> authentication window, After he inputs his credentials it runs approx another
> two minutes then wants him to re-authenticate, after the third instance of
> this it fails and will not export. However if he tries to export a smaller
> file, it works Okay. One caviat, I recieve an Event ID:10016 around the same
> time and it says something about The COM not having a required permission, is
> this a factor in my issue?
> --
> Scott A Cummins
> Sr. Systems Engineer
> Equity Analytics
> ( A division of Merrill Lynch)
> 14614 N. Keirland Blvd
> Scottsdale, AZ 85254
> 480-998-3515
It sounds like it. Normally, once a datasource has been set up for a
report, there is no further authentication necessary. Also, I myself
have never seen this occur when exporting to any format w/Reporting
Services (and I don't utilize COM objects in the process).
Regards,
Enrique Martinez
Sr. SQL Server Developer

Question on Action on SQL Server 2005 Analysis services OLAP Cubes in Excel 2007

Hi, all experts here,

I am having a question on actions implemented on SQL Server 2005 Analysis Services OLAP cubes, will SQL Server 2005 reporting services report action implemented on those cubes can also be available from Excel 2007?

Hope my question is clear for your advices and help and I am looking forward to hearing from you shortly.

With best regards,

Yours sincerely,

Hello Helen. Actions(SSRS2005 Actions and others) are supported in Excel 2007.

You can find out more about this in this document: http://www.microsoft.com/downloads/details.aspx?FamilyId=2D779CD5-EEB2-43E9-BDFA-641ED89EDB6C&displaylang=en

HTH

Thomas Ivarsson

|||

Hi, Thomas,

Thanks a lot for your help. It's been very helpful.

With best regards,

Yours sincerely,