Deserialization failed: error message

This is the message I get when I try to create a report that has a lot of fields, I'm guessing that might be the problem.

Warning 1 Deserialization failed: The value must be between 0cm and 406.34921cm.
Parameter name: Width Line 10, position 30. 10 0

When you say lots of field how many are you talking about I wrote one that generated 165 valid pages with many concatenated columns.

|||

Thanks for the reply.

54 fields so doubt that is the issue.

|||sorry wrong query; the query involved returns 623 fields lol I think I will have to cut it down

|||

I don't think you are getting that many fields from a database, if you are then you need to design it because if you do files and association the core of relational design 623 can be reduced to less than 100 fields. Hope this helps.

|||

Not my database and yes I am getting that many fields as I counted them.

Thanks for the replies I have sent the query back to the provider, will see what happens.

|||

I think you are getting Excel files in database files because relational design reduces such bloat to manageable tables and columns. Post again later because with design you can move the columns to a view and just call the view for that report.

sql

Deserialization failed

I am installing SSRS for the first time. I tried to create a simple report and I am getting the following error:

Deserialization failed: The type initializer for 'Microsoft.ReportDesigner.Drawing.RptStyleConstValue' threw an exception. Line 2, position 2.

Does anyone know how to fix this error?

Thanks,

Patrick

You have a problem http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=811976&SiteID=1 sql

Desapering rows

Hi.

I have an mdx query which return some rows and for some values there are null values for 1 column (it's ok). But when the report is rendered have disapeared all these rows. I need to show these rows because they have value for other columns.

Thanks in advance.I refresh the datasource by editing the query and refresh and that's all.

I don't know what happend.

Deployment Version Problem

We are trying to deploy a report server project from an XP Dev box to a
Server2003 production environment.
Both computers are running SQL Server 2005 with SP1 installed.
We have tried to deploy by (1) a deploy over the network and (2) a database
backup of the ReportServer database and then a restore to the Server 2003
system.
Both methods give us exactly the same error...
The version of the report server database is either in a format that is not
valid, or it cannot be read. The found version is 'Unknown'. The expected
version is 'C.0.8.43'. To continue, update the version of the report server
database and verify access rights.
Why are we getting this error?
Regards,
GaryHi Gary,
Thank you for your posting!
Based on my research and experience, I think you need to reinstall the SP1
on the Server 2003 box.
Please let me know if you get any error message when you reinstall the SP1.
You could send the setup error log to me if you get any error. By default,
the error log file folder is C:\WINDOWS\Hotfix
Please let me know the result. Thank you!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Gary,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Wei,
It turned out that [apparently] the person who installed sp1 was not a
"member of the SQL Server Administrators Group" and when we followed the
recommeded fix in configuration manager the problem went away.
A mystery that remains for me is that I can't find a "SQL Server
Administrators Group". Do you know exactly what that is? Is it a user with
sysadmin privlidges?
Gary
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:t1rUdcOoGHA.2024@.TK2MSFTNGXA01.phx.gbl...
> Hi Gary,
> How is everything going? Please feel free to let me know if you need any
> assistance.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||Hi Gary,
Thank you for the update and glad to hear the issue has been resolved.
I think the SQL Server Administrators Group means the SQL Server sysadmin
group. Members of the sysadmin fixed server role can perform any activity
in the server. By default, all members of the Windows
BUILTIN\Administrators group, the local administrator's group, are members
of the sysadmin fixed server role.
If you have any questions or concern, please feel free to let me know.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.

Deployment to Production problems

Somewhat newbie here trying to deploy my first Report. Production machine is
on Windows 2003 - finally got around the reporting service prompting for
windows authentication and now I'm trying to deploy my report through VS
2003. Which reports successful deployment.
If I press the "Run" button in VS 2003 it displays a web page:
[To Parent Directory]
Tuesday, March 29, 2005... Name of my report
No fancy Reporting Service front end, just a hyperlink. If I click on the
link, it displays my report.
If I navigate to http://[servername]/Reports/Pages/Folder.aspx it displays
the web page of SQL Server Reporting Services Home (with the appropriate
GUI), but no folders are listed.
There's obviously some extra step I need to do with 2003 that I didn't need
to setup on my local XP system that I developed and debugged on.Sounds like you haven't given permissions for anyone to see the reports. By
default, only admins can see contents of the server.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"dtaylor" <dtaylor@.discussions.microsoft.com> wrote in message
news:F158F5D6-E52B-40F6-9F31-31C49358C33D@.microsoft.com...
> Somewhat newbie here trying to deploy my first Report. Production machine
> is
> on Windows 2003 - finally got around the reporting service prompting for
> windows authentication and now I'm trying to deploy my report through VS
> 2003. Which reports successful deployment.
> If I press the "Run" button in VS 2003 it displays a web page:
> [To Parent Directory]
> Tuesday, March 29, 2005... Name of my report
> No fancy Reporting Service front end, just a hyperlink. If I click on the
> link, it displays my report.
> If I navigate to http://[servername]/Reports/Pages/Folder.aspx it displays
> the web page of SQL Server Reporting Services Home (with the appropriate
> GUI), but no folders are listed.
> There's obviously some extra step I need to do with 2003 that I didn't
> need
> to setup on my local XP system that I developed and debugged on.sql

Deployment Report Folder

Hi,

I would like to be able to deploy a report to a particular folder in the report server. It seems when I deploy a report it always shows up in the root even after I have moved it into another folder where I wish it to reside.

Thanks,

DD

You set the deployment path of reports (and datasources in 2005) using the project property pages.

Right click on the project (in solution explorer) - select "properties", then if you expand "configuration properties" in the left hand pane of the dialog and select "general"

You can now see the "target report folder" (and if using 2005 "target data source folder")

you can amend this as follows

if you want the following folder

root/adminReports/server

just put

"adminReports/server" in the "target report folder" textbox

|||Right, but that changes the deployment folder for the whole project. I don't seem to be able to change the reports individually. What would be sweet would be if you add folders to your solution and the deployment process puts the reports in the corresponding folders.|||

You have these options:

1) Create 1 solution per folder group that you require, set them to point at the folders you requires

2) Use configuration manager to create different deployment folders, deploy the reports individually once you've picked your target folder using config mgr

3) Use a tool like Reporting Services scripter to generate a deployment script, then edit this (and the winnt folder structure) accordingly - "find in folders" using vs.net is easy enough [http://www.sqldbatips.com/]

|||

Thanks for the valuable tips. I will check out that Linked Report tool.

I ended up creating a project for every folder.

Thanks,

DD

Deployment question

After I develop my report on my development computer how do I actually
deploy the report on the client's site?
ThanksOn Jun 22, 2:29 pm, "Mark Goldin" <mgol...@.ufandd.com> wrote:
> After I develop my report on my development computer how do I actually
> deploy the report on the client's site?
> Thanks
As long as you have the Report Manager setup/configured correctly, you
should be able to just upload the RDL file into the main directory or
some subdirectory that you create beforehand. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Will that also create all data sources?
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1182577024.421699.267330@.u2g2000hsc.googlegroups.com...
> On Jun 22, 2:29 pm, "Mark Goldin" <mgol...@.ufandd.com> wrote:
>> After I develop my report on my development computer how do I actually
>> deploy the report on the client's site?
>> Thanks
>
> As long as you have the Report Manager setup/configured correctly, you
> should be able to just upload the RDL file into the main directory or
> some subdirectory that you create beforehand. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||When you develop your report in BI studio you have created data sources.
When you deploy from BI Studio it will also create the data sources. This
can be scripted but the easiest way is to deploy from the development
environment.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Mark Goldin" <mgoldin@.ufandd.com> wrote in message
news:uOMtp%23ztHHA.1584@.TK2MSFTNGP05.phx.gbl...
> Will that also create all data sources?
> "EMartinez" <emartinez.pr1@.gmail.com> wrote in message
> news:1182577024.421699.267330@.u2g2000hsc.googlegroups.com...
>> On Jun 22, 2:29 pm, "Mark Goldin" <mgol...@.ufandd.com> wrote:
>> After I develop my report on my development computer how do I actually
>> deploy the report on the client's site?
>> Thanks
>>
>> As long as you have the Report Manager setup/configured correctly, you
>> should be able to just upload the RDL file into the main directory or
>> some subdirectory that you create beforehand. Hope this helps.
>> Regards,
>> Enrique Martinez
>> Sr. Software Consultant
>|||I did not see scriting option there. Can you give me more details, please?
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:etjFzY0tHHA.4424@.TK2MSFTNGP04.phx.gbl...
> When you develop your report in BI studio you have created data sources.
> When you deploy from BI Studio it will also create the data sources. This
> can be scripted but the easiest way is to deploy from the development
> environment.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
>
> "Mark Goldin" <mgoldin@.ufandd.com> wrote in message
> news:uOMtp%23ztHHA.1584@.TK2MSFTNGP05.phx.gbl...
>> Will that also create all data sources?
>> "EMartinez" <emartinez.pr1@.gmail.com> wrote in message
>> news:1182577024.421699.267330@.u2g2000hsc.googlegroups.com...
>> On Jun 22, 2:29 pm, "Mark Goldin" <mgol...@.ufandd.com> wrote:
>> After I develop my report on my development computer how do I actually
>> deploy the report on the client's site?
>> Thanks
>>
>> As long as you have the Report Manager setup/configured correctly, you
>> should be able to just upload the RDL file into the main directory or
>> some subdirectory that you create beforehand. Hope this helps.
>> Regards,
>> Enrique Martinez
>> Sr. Software Consultant
>>
>|||In Book Online search on the word scripts.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Mark Goldin" <mgoldin@.ufandd.com> wrote in message
news:OIzQsw0tHHA.536@.TK2MSFTNGP06.phx.gbl...
>I did not see scriting option there. Can you give me more details, please?
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:etjFzY0tHHA.4424@.TK2MSFTNGP04.phx.gbl...
>> When you develop your report in BI studio you have created data sources.
>> When you deploy from BI Studio it will also create the data sources. This
>> can be scripted but the easiest way is to deploy from the development
>> environment.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>>
>> "Mark Goldin" <mgoldin@.ufandd.com> wrote in message
>> news:uOMtp%23ztHHA.1584@.TK2MSFTNGP05.phx.gbl...
>> Will that also create all data sources?
>> "EMartinez" <emartinez.pr1@.gmail.com> wrote in message
>> news:1182577024.421699.267330@.u2g2000hsc.googlegroups.com...
>> On Jun 22, 2:29 pm, "Mark Goldin" <mgol...@.ufandd.com> wrote:
>> After I develop my report on my development computer how do I actually
>> deploy the report on the client's site?
>> Thanks
>>
>> As long as you have the Report Manager setup/configured correctly, you
>> should be able to just upload the RDL file into the main directory or
>> some subdirectory that you create beforehand. Hope this helps.
>> Regards,
>> Enrique Martinez
>> Sr. Software Consultant
>>
>>
>

Deployment problem

I am attempting to deploy a report that I created with "Business Intelligent
Projects". When I attempt the deploy I get a message that my user account
doesn't have the rights to do it. It is an administrative account and the
same one used to start the service.
I have another development machine and it works fine. Any ideas?
Any help is greatly appreciated.On Apr 24, 1:54 pm, "Greg Smith" <g...@.umn.edu> wrote:
> I am attempting to deploy a report that I created with "Business Intelligent
> Projects". When I attempt the deploy I get a message that my user account
> doesn't have the rights to do it. It is an administrative account and the
> same one used to start the service.
> I have another development machine and it works fine. Any ideas?
> Any help is greatly appreciated.
Does your Windows Authentication user have administrative rights to
the Report Manager on the server w/the deployment issue?
Enrique Martinez
Sr. Software Consultant

Deployment of SSRS Reports

Hi,

How do we deploy SSRS Reports to various server. One option which we

are using currently is deploying from the report project. We want to

automate the Reports Deployment. Can any of you who have done this in

the past share the experience?

Thanks,

S Suresh

YOu can use the APIS of the reporting Services. Deploying is quite straight forward with them, see the link here for an example http://groups.google.de/group/microsoft.public.sqlserver.reportingsvcs/browse_frm/thread/d265ba0a4f82369e

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

Deployment of Server Reports

HI,
We have Server Reports in our application deployed on the Report
Server(local host). What all steps need to be done when we make an MSI of the
project for deplying reports on the new server? Do we need to first deploy
the reports on new server and then make an MSI? Need help.
Thanks in Advance.
ParimalYou do not/cannot use MSI to deploy reports. There are three ways to deploy
reports.
1. Use the IDE to deploy reports to production server (that is what I do).
2. Copy reports to server and then use Report Manager to add reports
3. Write a script. Search Books Online under scripting, samples
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Parimal" <Parimal@.discussions.microsoft.com> wrote in message
news:FC5A0A06-B81B-4183-83F4-98C4414A1B0A@.microsoft.com...
> HI,
> We have Server Reports in our application deployed on the Report
> Server(local host). What all steps need to be done when we make an MSI of
> the
> project for deplying reports on the new server? Do we need to first
> deploy
> the reports on new server and then make an MSI? Need help.
> Thanks in Advance.
> Parimal

Deployment of Rdl files and datasource to Production Server

Hi All,
I have develoded the SRS report using vs.net , and deployed to my local
sever using vs.net all works fine.
No i need to deploy these reports to a production server where vs.net is
not present.
So can any one tell me how to automate this process of deployment to
production server insteed of mannualy uploading the rld files and creating
data source in report manager.
Can set up be made for this scenarion to my production server.
Please help me it's urgent,
Thanks in advanceYou can create a deployment script with the rss utility in RS. Please
refer to the two scripts that ship with the product and customize it to
deploy to your production server. Command line arguments can be
specified for the datasource, connection string , report server url
etc.|||You have here the code for deploy the report on any SQLRS server
http://www.rdlcomponents.com/ASPExamples/default.aspx
Jerry
"RN" wrote:
> You can create a deployment script with the rss utility in RS. Please
> refer to the two scripts that ship with the product and customize it to
> deploy to your production server. Command line arguments can be
> specified for the datasource, connection string , report server url
> etc.
>

Deployment issues

Hi All,

I am running SQL RS 2005 on Windows Server 2003

My client is XP sp2 with .NET 2005 Team

When I try to deploy a RS report to my web server I get an error;

Error 4 The permissions granted to user 'MyDomain\MyUser' are insufficient for performing this operation.

What folders/user/permissions need to be opened on the server so that I can deploy reports from my client machine?

regards,

Bill

Did you install SP1 for windows 2003 server?|||

I did.

SP1 for SQL Server as well.

Thing is, I had everything working fine a week ago. We had to uninstall SQL Server 2005. I put it back on today. No issues at all in the setup except for this.

|||Can no one tell me what permissions I need to deploy reports to the server, or is this really a rare issue?

Deployment issue - users cannot view reports

Hi All,
I am having some difficulty allowing users to view reports. I have
developed a series of reports on RS and deployed them to Report Manager.
However It is only myself that can view the reports on report mnanager -
whenever anyone else tries to log on and view them they get a blank page -
what am i doing wrong?
Thanks and HAPPY XMAS!!
GregGreg wrote:
> Hi All,
> I am having some difficulty allowing users to view reports. I have
> developed a series of reports on RS and deployed them to Report
> Manager. However It is only myself that can view the reports on
> report mnanager - whenever anyone else tries to log on and view them
> they get a blank page - what am i doing wrong?
>
> Thanks and HAPPY XMAS!!
> Greg
It may sound like a stupid question but ... have you checked their
permissions!
If they can see the Report Manager, but not see any reports, then the
security on the reports is too tight.
As administrator you will be able to click on properties and security
of the various folders and reports and add the appropriate users or
groups.
After that you will need to make sure the Datasources have suitable
logon credentials set too.
Regards (and merry christmas!)
Chris|||Hi chris - thanks for the pointer - ill check it out and get back!
"Chris McGuigan" wrote:
> Greg wrote:
> > Hi All,
> >
> > I am having some difficulty allowing users to view reports. I have
> > developed a series of reports on RS and deployed them to Report
> > Manager. However It is only myself that can view the reports on
> > report mnanager - whenever anyone else tries to log on and view them
> > they get a blank page - what am i doing wrong?
> >
> >
> > Thanks and HAPPY XMAS!!
> >
> > Greg
> It may sound like a stupid question but ... have you checked their
> permissions!
> If they can see the Report Manager, but not see any reports, then the
> security on the reports is too tight.
> As administrator you will be able to click on properties and security
> of the various folders and reports and add the appropriate users or
> groups.
> After that you will need to make sure the Datasources have suitable
> logon credentials set too.
> Regards (and merry christmas!)
> Chris
>|||I have what may be a similar issue. All users on our local intreanet can
view the reports, but people from the outside cannot. They can browse to
the page, and see the list of reports, but when they try to view a report,
they get "The Page cannot be Displayed".
Could this be the same as Greg's problem?
Thanks,
Daniel Williams
"Greg" <Greg@.discussions.microsoft.com> wrote in message
news:48094DE4-52C0-4522-A822-352BADD676E4@.microsoft.com...
> Hi All,
> I am having some difficulty allowing users to view reports. I have
> developed a series of reports on RS and deployed them to Report Manager.
> However It is only myself that can view the reports on report mnanager -
> whenever anyone else tries to log on and view them they get a blank page -
> what am i doing wrong?
>
> Thanks and HAPPY XMAS!!
> Greg
>|||This is different. In the current version, Report Manager uses a frame to
access the reports. You probably need to set the ReportServerExternalURL
property. See
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/drp_deploying_v1_0h9e.asp.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
"Daniel Williams" <daniel@.aniworld.com> wrote in message
news:eabjGuP7EHA.2568@.TK2MSFTNGP10.phx.gbl...
> I have what may be a similar issue. All users on our local intreanet can
> view the reports, but people from the outside cannot. They can browse to
> the page, and see the list of reports, but when they try to view a report,
> they get "The Page cannot be Displayed".
> Could this be the same as Greg's problem?
> Thanks,
> Daniel Williams
> "Greg" <Greg@.discussions.microsoft.com> wrote in message
> news:48094DE4-52C0-4522-A822-352BADD676E4@.microsoft.com...
>> Hi All,
>> I am having some difficulty allowing users to view reports. I have
>> developed a series of reports on RS and deployed them to Report Manager.
>> However It is only myself that can view the reports on report mnanager -
>> whenever anyone else tries to log on and view them they get a blank
>> page -
>> what am i doing wrong?
>>
>> Thanks and HAPPY XMAS!!
>> Greg
>|||Hi Daniel
Yes i think Brian is right - What Chris said helped me out - I had not
previously defined the permissions for my user group. Think yours may be a
separate issue.
Thanks Chris!
Greg
"Brian Welcker [MS]" wrote:
> This is different. In the current version, Report Manager uses a frame to
> access the reports. You probably need to set the ReportServerExternalURL
> property. See
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/drp_deploying_v1_0h9e.asp.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Daniel Williams" <daniel@.aniworld.com> wrote in message
> news:eabjGuP7EHA.2568@.TK2MSFTNGP10.phx.gbl...
> >
> > I have what may be a similar issue. All users on our local intreanet can
> > view the reports, but people from the outside cannot. They can browse to
> > the page, and see the list of reports, but when they try to view a report,
> > they get "The Page cannot be Displayed".
> >
> > Could this be the same as Greg's problem?
> >
> > Thanks,
> > Daniel Williams
> >
> > "Greg" <Greg@.discussions.microsoft.com> wrote in message
> > news:48094DE4-52C0-4522-A822-352BADD676E4@.microsoft.com...
> >> Hi All,
> >>
> >> I am having some difficulty allowing users to view reports. I have
> >> developed a series of reports on RS and deployed them to Report Manager.
> >> However It is only myself that can view the reports on report mnanager -
> >> whenever anyone else tries to log on and view them they get a blank
> >> page -
> >> what am i doing wrong?
> >>
> >>
> >> Thanks and HAPPY XMAS!!
> >>
> >> Greg
> >>
> >
> >
>
>|||You're right. Our problem was that we did not have a
<ReportServerExternalURL> value, so it was trying to use the internal
address when rendering the report. Completely different issue.
Cheers,
Daniel Williams
"Greg" <Greg@.discussions.microsoft.com> wrote in message
news:70AA6573-50BB-4D9F-BBE3-13E599B6673F@.microsoft.com...
> Hi Daniel
> Yes i think Brian is right - What Chris said helped me out - I had not
> previously defined the permissions for my user group. Think yours may be
> a
> separate issue.
> Thanks Chris!
> Greg
> "Brian Welcker [MS]" wrote:
>> This is different. In the current version, Report Manager uses a frame to
>> access the reports. You probably need to set the ReportServerExternalURL
>> property. See
>> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/drp_deploying_v1_0h9e.asp.
>> --
>> Brian Welcker
>> Group Program Manager
>> Microsoft SQL Server
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "Daniel Williams" <daniel@.aniworld.com> wrote in message
>> news:eabjGuP7EHA.2568@.TK2MSFTNGP10.phx.gbl...
>> >
>> > I have what may be a similar issue. All users on our local intreanet
>> > can
>> > view the reports, but people from the outside cannot. They can browse
>> > to
>> > the page, and see the list of reports, but when they try to view a
>> > report,
>> > they get "The Page cannot be Displayed".
>> >
>> > Could this be the same as Greg's problem?
>> >
>> > Thanks,
>> > Daniel Williams
>> >
>> > "Greg" <Greg@.discussions.microsoft.com> wrote in message
>> > news:48094DE4-52C0-4522-A822-352BADD676E4@.microsoft.com...
>> >> Hi All,
>> >>
>> >> I am having some difficulty allowing users to view reports. I have
>> >> developed a series of reports on RS and deployed them to Report
>> >> Manager.
>> >> However It is only myself that can view the reports on report
>> >> mnanager -
>> >> whenever anyone else tries to log on and view them they get a blank
>> >> page -
>> >> what am i doing wrong?
>> >>
>> >>
>> >> Thanks and HAPPY XMAS!!
>> >>
>> >> Greg
>> >>
>> >
>> >
>>sql

Deployment Issue

We have a requirement to display some 80,000 records in the report. The Stored procedure in the back end is displaying results in less than 2 mins..but the system hangs when we run the report.

Any work around for this strange behaviour?

When you run a report, not only do you have to collect the data, you also have to render the report, 80K records is 800 pages if you have 100 records per page.

What happens if you run the report as a scheduled report, and set the run time to the middle of the night when database and report server activity is low?

Deployment Issue

Hi,
I had a few sets of Reports, who were working fine. today I added a report
to my solution file at my dev machine and deployed it on the reportserver.
The Report got deployed successfully but when I browse the Report from the
browser before opening it shows the windows dialog box for "File Download"
and with the message "some files can harm your computer...." with the name
of the file as <reportfilename>.html. After clicking cancel the browser does
not shows the report. On clicking Save/Open the browser tries to download
some file which never ends.
Ironically it can preview my report from the dev machine.
My dev machine is Win XP and the Report server is Win 2000. I m using
Enterprise SQL Server MS Reports.
Is there any setting in reports/IE for this sudden behaviour
any idea will be highly appreciated..
siajHi,
I found the solution to my problem ...
There appears to be a bug in the MS RS version 8.00.743.00. If we name the
rdl file with a keyword containing "Attachmnet" Then we can deploy the file
but cant view the file..
I had named the file as "Look for Attachment.rdl" It did not work. I changed
the name it worked.
Would appreciate if some MS guy woule comment on this.
Cheers,
Jai
"siaj" wrote:
> Hi,
> I had a few sets of Reports, who were working fine. today I added a report
> to my solution file at my dev machine and deployed it on the reportserver.
> The Report got deployed successfully but when I browse the Report from the
> browser before opening it shows the windows dialog box for "File Download"
> and with the message "some files can harm your computer...." with the name
> of the file as <reportfilename>.html. After clicking cancel the browser does
> not shows the report. On clicking Save/Open the browser tries to download
> some file which never ends.
> Ironically it can preview my report from the dev machine.
> My dev machine is Win XP and the Report server is Win 2000. I m using
> Enterprise SQL Server MS Reports.
> Is there any setting in reports/IE for this sudden behaviour
> any idea will be highly appreciated..
> siaj

Deployment error: Expected C.0.8.43

We are trying to deploy a report server project from an XP Dev box to a Server2003 production environment.

Both computers are running SQL Server 2005 with SP1 installed.

We have tried to deploy by (1) a deploy over the network and (2) a database backup of the ReportServer database and then a restore to the Server 2003 system.

Both methods give us exactly the same error...

The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'Unknown'. The expected version is 'C.0.8.43'. To continue, update the version of the report server database and verify access rights.

Why are we getting this error?

Regards,

Gary

Reporting Services data is encrypted. Did you backup and restore the symetric key from the old to the new system ? Otherwiese the information from the report database like report definitions can′t be read.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

Check out this link. It does not directly apply to your problem, but it may lead you in right direction for a fix. Using the Configuration tool may be helpfull.

http://blogs.msdn.com/lukaszp/archive/2006/05/18/601340.aspx

deployment error

A report runs well in Visual Studio environment. Once it is deployed to the local report server, got an #Error indication without an actual message. The report has an embedded code with a database connection in it. Any idea what the problem is?

Thank you very much!

Could be a security issue regarding the database connection. If i understand you correctly, you connect to a database in custom code? If you have trusted connection in your custom code, maybe it is not the same user that makes the database call when the report runs in ReportServer as in Visual Studio and you get an exception?|||

Thanks for your response. I thought it could be a security issue too. So I enabled trusted connection and tried using specific uid and pwd too. Neither of them worked.

|||What dp you get if you do a try/catch and return the exception text to a textbox in the report?

What does this custom code do? What does it do with the report? The reason i am asking is that there might be some other way to solve it.|||

The custom code retrieves and outputs another set of data based on the dynamic id outputted from the first set of data.

I'll see what text message I'll get if I use try/catch and let you know.

Thanks for your help.

|||I found out it has something to do with the Code Access Security in .NET. I did some research and found this article was very helpful: http://www.devx.com/codemag/Article/33656/1954?pf=true. Once I followed it step by step, the problem was resolved. Just wanted to share with the community, in case if there is anybody encountered the same problem as I did.

deployment error

A report runs well in Visual Studio environment. Once it is deployed to the local report server, got an #Error indication without an actual message. The report has an embedded code with a database connection in it. Any idea what the problem is?

Thank you very much!

Could be a security issue regarding the database connection. If i understand you correctly, you connect to a database in custom code? If you have trusted connection in your custom code, maybe it is not the same user that makes the database call when the report runs in ReportServer as in Visual Studio and you get an exception?|||

Thanks for your response. I thought it could be a security issue too. So I enabled trusted connection and tried using specific uid and pwd too. Neither of them worked.

|||What dp you get if you do a try/catch and return the exception text to a textbox in the report?

What does this custom code do? What does it do with the report? The reason i am asking is that there might be some other way to solve it.|||

The custom code retrieves and outputs another set of data based on the dynamic id outputted from the first set of data.

I'll see what text message I'll get if I use try/catch and let you know.

Thanks for your help.

|||I found out it has something to do with the Code Access Security in .NET. I did some research and found this article was very helpful: http://www.devx.com/codemag/Article/33656/1954?pf=true. Once I followed it step by step, the problem was resolved. Just wanted to share with the community, in case if there is anybody encountered the same problem as I did.sql

Deployment Error

I am getting the following error when deploying to the Sharepoint from my Report Designer. I was able to deploy the reports before by providing the TargetServer url. What could be going wrong?

The path of the item "/Sample Reports/Test Sample Report " is not valid. The path must be less than 260 characters long and must start with slash. Other restrictions apply.

Very wiered... I was able to deploy the report even with deployment error... Any way I changed the name of the report and am not getting any deployment errors.

deployment and reports

Hi,

When I deploy a report i am assuming the report is deployed to the reporting service DB (ReportServer). Then when i try to view report in a browser I presume the following happens:

Navigate to http://localhost/Reports and click report you want to view

A web service call is made to retrieve report data from a DB eg Northwind

The data is the rendered based on the defined formatting in the RDL file and displayed in browser.

If this is correct does anyone known where the report is deployed to (DB or Web service) I cannot see the rdl files in any of these places and if I delete my project report viewing still works.

I know you can view all reports if you are in SQL management studio and go connect->reporting services but this is not a DB. Is this the web service and if so why cant i see files in IIS?

Thanks for replies

It's because they're not stored as files. When you deploy any files to the report server, they are stored in a table called Catalog and are serialized into an image column called Content.

Report Manager, Management Studio or whatever just connect to the web service and query it about which reports are stored in the database. The web service is basically the interface into the database.