Report error

Hi all,

I just setup SQL 2005 Report Service, and then I used the browser to view the "folder.aspx"

Nothing showed up but I received an error page with the message like the following:

"The request failed with HTTP status 400: Bad Request."

So, what did I do wrong?

Thanks,

Frank

System Engineer

Start debugging with your http://localhost/reportserver. How were the RS virtual directories created? Try creating them using the configuration tools, and re-apply the script mappings.|||If the suggestions from James is not working, try to dive deeper into the error of the reporting services engine, by setting the logging mode to verbose and see where the error is based on. If you have a blank report server with not much reports one, try to reinstall the whole thing, that is sometimes better than (try) fixing the issues that popup. I had that a while ago, the cause was that there were file locks on the files that needed to be changed. The installer didn′t pop up a message and *bump* there were many erros coming up regarding authentication etc.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Report Does Not Display in Designer

Hello,

I am developing some reports for an ASP.NET solution, but my IDE does not display the design view of the reports. Instead, it only displays the XML definition even when I click View Designer. Yesterday the reports showed up correctly, and I know that the design view is there. Is there a setting that has been changed somewhere?

I guess you are trying to add the report to your ASP.Net application project. If you do that and view the report (.rdl file), you can only see the xml view. You can see the design view only if you add it to Report Server project under Business Intelligence Projects group.

Shyam

|||I figured it out. Thanks.

Report Designer

My company just installed SQL Reporting Services and they've given me
permissions to where I can view the home page of the Reporting Services site.
I'm using Visual Studio.net to develop in but I'm unclear on what I need to
install on my end to create the reports and deploy to the report server.
I've gone through RS demos and have seen the option to create a new report
but I don't appear to have that option so I must need a plug in of some sort.
Any help would be appreciated.In order to write reports you need to install Reporting Services on your
local PC. Once you do, you will see a new folder called Business
Intelligence. This is where you can create new reports.
Good luck.
Michael
"yrmeyer" wrote:
> My company just installed SQL Reporting Services and they've given me
> permissions to where I can view the home page of the Reporting Services site.
> I'm using Visual Studio.net to develop in but I'm unclear on what I need to
> install on my end to create the reports and deploy to the report server.
> I've gone through RS demos and have seen the option to create a new report
> but I don't appear to have that option so I must need a plug in of some sort.
> Any help would be appreciated.|||You can create your reports with out designer using the RDL reader/writer
http://www.rdlcomponents.com
Jerry
"MAGrimsley" wrote:
> In order to write reports you need to install Reporting Services on your
> local PC. Once you do, you will see a new folder called Business
> Intelligence. This is where you can create new reports.
> Good luck.
> Michael
> "yrmeyer" wrote:
> > My company just installed SQL Reporting Services and they've given me
> > permissions to where I can view the home page of the Reporting Services site.
> > I'm using Visual Studio.net to develop in but I'm unclear on what I need to
> > install on my end to create the reports and deploy to the report server.
> > I've gone through RS demos and have seen the option to create a new report
> > but I don't appear to have that option so I must need a plug in of some sort.
> > Any help would be appreciated.|||Thank you.
I've downloaded the Evaluation copy of RS until I can get the software sent
to me by my company. I'm unable to get past the screen where it asks for the
SQL Server Instance. Not sure what it's asking for.
"MAGrimsley" wrote:
> In order to write reports you need to install Reporting Services on your
> local PC. Once you do, you will see a new folder called Business
> Intelligence. This is where you can create new reports.
> Good luck.
> Michael
> "yrmeyer" wrote:
> > My company just installed SQL Reporting Services and they've given me
> > permissions to where I can view the home page of the Reporting Services site.
> > I'm using Visual Studio.net to develop in but I'm unclear on what I need to
> > install on my end to create the reports and deploy to the report server.
> > I've gone through RS demos and have seen the option to create a new report
> > but I don't appear to have that option so I must need a plug in of some sort.
> > Any help would be appreciated.|||You will see this is SQL Server is not installed on the local machine.
"yrmeyer" wrote:
> Thank you.
> I've downloaded the Evaluation copy of RS until I can get the software sent
> to me by my company. I'm unable to get past the screen where it asks for the
> SQL Server Instance. Not sure what it's asking for.
>
> "MAGrimsley" wrote:
> > In order to write reports you need to install Reporting Services on your
> > local PC. Once you do, you will see a new folder called Business
> > Intelligence. This is where you can create new reports.
> >
> > Good luck.
> >
> > Michael
> >
> > "yrmeyer" wrote:
> >
> > > My company just installed SQL Reporting Services and they've given me
> > > permissions to where I can view the home page of the Reporting Services site.
> > > I'm using Visual Studio.net to develop in but I'm unclear on what I need to
> > > install on my end to create the reports and deploy to the report server.
> > > I've gone through RS demos and have seen the option to create a new report
> > > but I don't appear to have that option so I must need a plug in of some sort.
> > > Any help would be appreciated.|||the url of homepage of reporting services site should be looking like
http://server1/reports
Once you've created report in Report Designer you need to open project
properties and specify location of reporting services server which should be
http://server1/reportserver
After specifying the rs server location you can try deploying your report to
report server (search for Deploy command in rep designer menu).
You should also be able to preview your report in report designer preview
tab without deploying.
If it fails to deploy it'll be one of two problems: either rs location is
invalid or you do not have permission to deploy reports on the report server
you specified.
In the second case you need to talk to admin and ask him to give you such
permission.
--
Alex Mineev
Software Design Engineer. Report expressions; Code Access Security; Xml;
SQE.
This posting is provided "AS IS" with no warranties, and confers no rights
"yrmeyer" <yrmeyer@.discussions.microsoft.com> wrote in message
news:79F0319C-587D-46AF-B631-1A7DB2E4AFA7@.microsoft.com...
> My company just installed SQL Reporting Services and they've given me
> permissions to where I can view the home page of the Reporting Services
site.
> I'm using Visual Studio.net to develop in but I'm unclear on what I need
to
> install on my end to create the reports and deploy to the report server.
> I've gone through RS demos and have seen the option to create a new report
> but I don't appear to have that option so I must need a plug in of some
sort.
> Any help would be appreciated.

Report Continually Refreshing

Hi All,

I had an interesting problem come up today. I have a report that when you preview on vs or click view report on the report server, the report continually refreshes itself. I cannot see that I have written anything different in this report than any other report.

I saw one other append here on a continually refreshing report but that was linked to a document map and this report has not document map.

Has anyone seen this problem of a continually refreshing report?

It's not a big deal as I figure I will just have to write it from scratch again, but I am interested to see if I can stop it before I re-write it.

Thanks in Advance

Peter

Peter, there is option in Report Properties that allows you to set a refresh rate. Click in the body of your report layout and then select Report and then Report Properties from the toolbar. At the bottom of the General tab you should see the option to check AutoRefresh and a number of seconds. Unselect this and the report should stop refreshing.

|||

Hi Cuck,

thanks very much for that...I have no idea how the refresh rate got set to 1 second but that was the problem.

I read about that option when I first started with Report Services but forgot it was there.

Thanks Again.

Peter

Report Continually Refreshing

Hi All,

I had an interesting problem come up today. I have a report that when you preview on vs or click view report on the report server, the report continually refreshes itself. I cannot see that I have written anything different in this report than any other report.

I saw one other append here on a continually refreshing report but that was linked to a document map and this report has not document map.

Has anyone seen this problem of a continually refreshing report?

It's not a big deal as I figure I will just have to write it from scratch again, but I am interested to see if I can stop it before I re-write it.

Thanks in Advance

Peter

Peter, there is option in Report Properties that allows you to set a refresh rate. Click in the body of your report layout and then select Report and then Report Properties from the toolbar. At the bottom of the General tab you should see the option to check AutoRefresh and a number of seconds. Unselect this and the report should stop refreshing.

|||

Hi Cuck,

thanks very much for that...I have no idea how the refresh rate got set to 1 second but that was the problem.

I read about that option when I first started with Report Services but forgot it was there.

Thanks Again.

Peter

sql

Report Builder: Custom Aggregate

Hi All,
I have used Report Builder to enable user to do Ad-Hoc Report that has
been great so far, but I have unique requirement for below table/view:
Month Headcount
================== January-06 45
February-06 41
March-06 43
April-06 42
May-06 38
June-06 30
July-06 50
(etc...)
Dec-06 42
Above table represents how many employees, one company/department has
during Month column. In January-06, there is 45 employees,
February-06, there is 44 employees, and so on.
If user choose to show Headcount attribute, Report Builder should
display each month headcount. The current problem is on the aggregate.
for example, report should show Headcount for Quarter 1 as 43, which
is headcount for March-06 (how many employees I have at the end of
Quarter 1), Quarter 2 should display 30, which is headcount for
June-06, and for Year of 2006 should be 42 (at Dec-06). There will be
more complexity: if now is still in the month of November 06 and no
data for December yet, report should show headcount of November 06 as
headcount for Year of 2006.
I don't think default available aggregates which are: Total, Average,
Max, Min, able to do this.
Q1, correct value should be 40 (March-06)
If I use Total Aggregate, it will be 99.
If I use Average, it will be 24.75
If I use Max, it will be 45.
If I use Min, it will be 41.
I need an aggregate that show number from last record in the dataset.
Is there any possible way how to do this? Any input is appreciated.
Thank you.On Jun 19, 4:59 pm, Gunady <Gun...@.gmail.com> wrote:
> Hi All,
> I have used Report Builder to enable user to do Ad-Hoc Report that has
> been great so far, but I have unique requirement for below table/view:
> Month Headcount
> ==================> January-06 45
> February-06 41
> March-06 43
> April-06 42
> May-06 38
> June-06 30
> July-06 50
> (etc...)
> Dec-06 42
> Above table represents how many employees, one company/department has
> during Month column. In January-06, there is 45 employees,
> February-06, there is 44 employees, and so on.
> If user choose to show Headcount attribute, Report Builder should
> display each month headcount. The current problem is on the aggregate.
> for example, report should show Headcount for Quarter 1 as 43, which
> is headcount for March-06 (how many employees I have at the end of
> Quarter 1), Quarter 2 should display 30, which is headcount for
> June-06, and for Year of 2006 should be 42 (at Dec-06). There will be
> more complexity: if now is still in the month of November 06 and no
> data for December yet, report should show headcount of November 06 as
> headcount for Year of 2006.
> I don't think default available aggregates which are: Total, Average,
> Max, Min, able to do this.
> Q1, correct value should be 40 (March-06)
> If I use Total Aggregate, it will be 99.
> If I use Average, it will be 24.75
> If I use Max, it will be 45.
> If I use Min, it will be 41.
> I need an aggregate that show number from last record in the dataset.
> Is there any possible way how to do this? Any input is appreciated.
> Thank you.
Reporting Services actually supports "Last" Aggregate (using regular
RDL file, e.g. developed using Visual Studio), which I think can solve
the problem. I notice that we can use
Count,CountDistinct,StDev,StDevP,Var, or VarP, in the Report Builder
editor itself, but there is no First or Last available. Does anyone
knows how to use this "Last" aggregate in report builder?

Report Builder Query

Can we view the query that is fired on the Report builder to debug as i am finding some error in data...

Can you run SQL Profiler to get the SQL command that is sent to SQL Server?

Jarret

|||

http://blogs.msdn.com/bobmeyers/archive/2006/07/05/657125.aspx tells how to do it.

R

Report Builder not appearing in Report Server 2005 Web page

I have provided required permissions, still user not able to view report builder option in his console.

what could be wrong? what needs to be done to provide report builder to users.

Deleep P

Please review the link below and let us know if this fixes your issue.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1697246&SiteID=1

|||

Thanks for that hint. I have an issue now regarding rights of system users. Now they have delete rights from Root directory. What needs to be done to avert this. I want system user be able to only modify his folders and contents.

Deleep P

|||

Double-click on My Computer, right-click on the root-drive in question and select properties and then select the security tab. Highlight the Users group [ ex: Users(Servername\Users) ] ensure that only the Special Permission box has a checkmark in it. Then click on the Advanced button and this will bring you to the permission tab where you can specify the rights you wish your users to have on the root drive.

|||

I think i misled you, after opening the webpage as follows "http://<report_server _ip>/reports " I get "HOME' page. Here i am creating folders. My intention is to create separate directories in the name of different teams first. Then provide complete access to the team within their folder. One team should not delete the folder created for another team from the home page. currently for all report server users i have given "System user" access through site SITE SETTING IN THE HOME PAGE. After clicking on the SITE SETTINGS I selected configure site wide security and provided "system user" rights to all report server users. Plus all users will have "folder view" rights on the HOME folder. this is provided through HOME PAGE, PROPERTIES, SECURITY, NEW ROLE ASSIGNMENT.

Report Builder not appearing in Report Server 2005 Web page

I have provided required permissions, still user not able to view report builder option in his console.

what could be wrong? what needs to be done to provide report builder to users.

Deleep P

Please review the link below and let us know if this fixes your issue.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1697246&SiteID=1

|||

Thanks for that hint. I have an issue now regarding rights of system users. Now they have delete rights from Root directory. What needs to be done to avert this. I want system user be able to only modify his folders and contents.

Deleep P

|||

Double-click on My Computer, right-click on the root-drive in question and select properties and then select the security tab. Highlight the Users group [ ex: Users(Servername\Users) ] ensure that only the Special Permission box has a checkmark in it. Then click on the Advanced button and this will bring you to the permission tab where you can specify the rights you wish your users to have on the root drive.

|||

I think i misled you, after opening the webpage as follows "http://<report_server _ip>/reports " I get "HOME' page. Here i am creating folders. My intention is to create separate directories in the name of different teams first. Then provide complete access to the team within their folder. One team should not delete the folder created for another team from the home page. currently for all report server users i have given "System user" access through site SITE SETTING IN THE HOME PAGE. After clicking on the SITE SETTINGS I selected configure site wide security and provided "system user" rights to all report server users. Plus all users will have "folder view" rights on the HOME folder. this is provided through HOME PAGE, PROPERTIES, SECURITY, NEW ROLE ASSIGNMENT.

Report Builder logon failed

I used an sql server logon to create the view and model in designer, I deployed the source and model from desigen, when I go to report builder I get this message:

Logon failed.

Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E) My server and web service are on the same server and I set up my server security to use mixed mode if that makes a difference.to answer my own question, even though it said it set up the rs service account correctly, it set up a new one with appropriate security and it now works, I just deleted the old id and use the new one.|||

hi there!

i encounter the same error... how did u find the id? i am using the domain account.. how can i make the necessary changes?

if i have to run my report in the client workstation, i got this error msg:

Logon failed.

For more information about this error navigate to the report server on the local server machine, or enable remote errors|||

I'm encountering the same error and cannot seem to get the issue resolved. I setup a new report server on my local machine and deployed a model to it and it works fine.

However, on my 2003 server I get the message

Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E)
-
Logon failed.

Can you please explain how exactly to rectify this error?

Thanks

|||

Go to management studio, create a LOGIN give it access to the msdb, reportsever database and reportserver temp database. See

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSinstall/htm/gs_installingrs_v1_75k2.asp

|||Goto Reporting Services Configuration (in Start Menu->Programs->Sql Server->Config Tools. Click on Execution Account Uncheck "Specify an execution account"

Report Builder logon failed

I used an sql server logon to create the view and model in designer, I deployed the source and model from desigen, when I go to report builder I get this message:

Logon failed.

Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E) My server and web service are on the same server and I set up my server security to use mixed mode if that makes a difference.to answer my own question, even though it said it set up the rs service account correctly, it set up a new one with appropriate security and it now works, I just deleted the old id and use the new one.|||

hi there!

i encounter the same error... how did u find the id? i am using the domain account.. how can i make the necessary changes?

if i have to run my report in the client workstation, i got this error msg:

Logon failed.

For more information about this error navigate to the report server on the local server machine, or enable remote errors|||

I'm encountering the same error and cannot seem to get the issue resolved. I setup a new report server on my local machine and deployed a model to it and it works fine.

However, on my 2003 server I get the message

Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E)
-
Logon failed.

Can you please explain how exactly to rectify this error?

Thanks

|||

Go to management studio, create a LOGIN give it access to the msdb, reportsever database and reportserver temp database. See

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSinstall/htm/gs_installingrs_v1_75k2.asp

|||Goto Reporting Services Configuration (in Start Menu->Programs->Sql Server->Config Tools. Click on Execution Account Uncheck "Specify an execution account"

Report Builder logon failed

I used an sql server logon to create the view and model in designer, I deployed the source and model from desigen, when I go to report builder I get this message:

Logon failed.

Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E) My server and web service are on the same server and I set up my server security to use mixed mode if that makes a difference.to answer my own question, even though it said it set up the rs service account correctly, it set up a new one with appropriate security and it now works, I just deleted the old id and use the new one.|||

hi there!

i encounter the same error... how did u find the id? i am using the domain account.. how can i make the necessary changes?

if i have to run my report in the client workstation, i got this error msg:

Logon failed.

For more information about this error navigate to the report server on the local server machine, or enable remote errors|||

I'm encountering the same error and cannot seem to get the issue resolved. I setup a new report server on my local machine and deployed a model to it and it works fine.

However, on my 2003 server I get the message

Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E)
-
Logon failed.

Can you please explain how exactly to rectify this error?

Thanks

|||

Go to management studio, create a LOGIN give it access to the msdb, reportsever database and reportserver temp database. See

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSinstall/htm/gs_installingrs_v1_75k2.asp

|||Goto Reporting Services Configuration (in Start Menu->Programs->Sql Server->Config Tools. Click on Execution Account Uncheck "Specify an execution account"|||Hi CadsKiran

Thanks for u'r solution.
it worked for me :) .

Thanks
Isuru

Report Builder Error

I have created a view with one table (CASEMASTER). When I look at the Visual
Studioâ's property of the Case Number field within table CASEMASTER, it is set
to AllowNull = False, which correctly corresponds with the property of this
field on the SQL Server.
However, I need this table to be replaced with a new named query because I
need to limit the data to only one county, plus I need to link other tables.
When I set it as a query, it changes the property of the Case Number field to
AllowNull = True. Consequently, when I try to deploy it, I get a "Nullable
Property Error".
Is there any way to change the AllowNull property OR prevent this from
happening so that I can deploy the view/model without errors?
Any suggestions are appreciated.
--
K. ThomasI removed the minOccurs="0" property in the code to get this to work properly.
--
K. Thomas
"K. Thomas" wrote:
> I have created a view with one table (CASEMASTER). When I look at the Visual
> Studioâ's property of the Case Number field within table CASEMASTER, it is set
> to AllowNull = False, which correctly corresponds with the property of this
> field on the SQL Server.
> However, I need this table to be replaced with a new named query because I
> need to limit the data to only one county, plus I need to link other tables.
> When I set it as a query, it changes the property of the Case Number field to
> AllowNull = True. Consequently, when I try to deploy it, I get a "Nullable
> Property Error".
> Is there any way to change the AllowNull property OR prevent this from
> happening so that I can deploy the view/model without errors?
> Any suggestions are appreciated.
> --
> K. Thomas

Report Builder Conditional IF Function Problem

Hi everyone,

I have created a view from the exisiting table to use in the report builder model and in the table whenever there is a null(when users does not enter a date for this particular field in the application) for datetime field either of these 2 ("1/1/1753" and "12/31/9999") dates are stored . Since I am creating my views based on these tables these dates will be in my views as well. Checking for this at the application level and cleaning up is not a option for me at this time.

So what I am trying to do is to check for these values and replace it with Null or blank in the model designer expression property. So that when user creates a report using this field they will not see these sql standard dates.

I tried using conditional IF in Model designer .

EX:

IF(Next MCR Review Date = 1/1/1753,EMPTY,Next MCR Review Date)

IF(Next MCR Review Date = 1/1/1753,NULL,Next MCR Review Date)

Both of these gives me errors.

Can anyone tell me what I am doing wrong and also are there any other ways to get to what I want.

I have already spent a lot of time digging for documentation but no luck any help is appreciated.

Thanks a Lot

Ashwini

I struggled with this for a while, it's a good question... and the model builder stuff really is a PITA.

Here is what I suggest: include the appropriate information in your view as an extra field and use that field instead of your "real" date" in your model.

In the view you can use something like

Code Snippet

CASE WHEN [Next MCR Review Date] = '1/1/1753' THEN NULL

ELSE [Next MCR Review Date] END AS ModelReviewDate

.. you can leave the original value in as a separate column in the view for additional purposes, comparison, etc.

>L<

|||

Thank you so much Lisa this works like a charm. I had tried this before but silly me I had not put the quotes '1/1/1753' like this Instead I was just typing it this way

Code Snippet

[Next MCR Review Date] = CASE TME.next_assessment_dt
WHEN 1/1/1753 THEN ' '

WHEN 12/31/9999 THEN ' '

ELSE TME.next_assessment_dt
END

Your code Snippet rang the bell Thanks again so much!!! You have made my day.

Ashwini

report builder - need help reporting from multiple tables

I created a data view and model that has two tables joined (one to many
relationship). When I go into report builder, I see both entities
available for me. When I click one of the entities, I am able to select
that entities data items to drag onto my report. However, the other
entity disapears. If I delete all the fields from the report, both
entities are available again. So it appears as if I can have as many
entities defined as I want, but can only use one at a time to report
on. I know I am doing something wrong because I have seen samples that
do what I am looking for - I just can't figure out how to do it.its because you don't have relationship between your 2 tables.
if you have some relation, in this case you can go from table A to table B
"directly"
else you have to go through other shared tables (with unexpected results)
"steve" <stevensherman@.comcast.net> wrote in message
news:1165065154.712904.183760@.f1g2000cwa.googlegroups.com...
>I created a data view and model that has two tables joined (one to many
> relationship). When I go into report builder, I see both entities
> available for me. When I click one of the entities, I am able to select
> that entities data items to drag onto my report. However, the other
> entity disapears. If I delete all the fields from the report, both
> entities are available again. So it appears as if I can have as many
> entities defined as I want, but can only use one at a time to report
> on. I know I am doing something wrong because I have seen samples that
> do what I am looking for - I just can't figure out how to do it.
>|||Thanks for your reply. I do have the relationship defined in the
reporting services model. Do I need to depict it somewhere else or am I
missing setting a property or something?|||Once the ralationships are defined in the datasource view, that is all
it takes. Report builder recognizes the relationship and will let you
select from both tables. If the tables are not joined in the datasource
view, then you will only be able to select attributes from one table or
the other - but not both.

Report Access

I have created a new report that all my users except for one can print and
view the same data on this report. One user gets the
report headers -- but no data.
I checked this user's active directory settings, and she is a member of the
same Reporting Group.
What could be the problem?Sounds like SQL data permissions issue. If I understand correctly the user
is seeing text that is static in the report but no data from the dataset.
Is the dataset SQL a stored procedure, or a select statement. If it's a
select statement probably doesn't have access to read the tables. Try
loging onto query analyzer with the users credentials (or similar) and
seeing what data is returned.
Steve MunLeeuw
"Cindy" <CindyMikeworth@.newsgroups.nospam> wrote in message
news:OHuLuAu7GHA.3644@.TK2MSFTNGP03.phx.gbl...
>I have created a new report that all my users except for one can print and
>view the same data on this report. One user gets the
> report headers -- but no data.
> I checked this user's active directory settings, and she is a member of
> the same Reporting Group.
> What could be the problem?
>|||Hello Cindy,
Does Steve's suggestion make any sense to you?
Also, you could try to test on other client with your user's credential. If
you could access the report on other client, you may need to check the IE
security setting.
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.)

Replication: Synchronization Status

In SQL 2005 when i expand the local publication , Under replication when i try to view Synchronization Status i see the below message.

The initial snapshot for publication '%Database' is not yet available.

can any one help me on this issue.

Thanks

You can open the replication monitor, go under this publication, go to the other agents tab, and start snapshot.|||This is because initial snapshot for the publication has not been generated. So generate snapshot first.