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

Deploying problem with reports

Hi,

I have two aquestions.

1. How do I select data ovewrite option in SSRS? When I deploy a report i got a following error message.

Warning : Cannot deploy data source mydatasource to the server because it already exists and OverwriteDataSources is not specified.

2. When I try to snapshot a report on report manager, I get a error message.

"Credentials used to run this report are not stored

Then I went to Management Studio and selected the data source and open the report data source property box. I gave a login name and a password under credential stored securely on the server. Can this login name and password be random ones or do they come from smwhere else? Even After I did this still i get the error.

Thanks

Click project -> Properties in your report project. There is an option for OverwriteDataSources. Personally, I use a shared datasource though. Is your datasource shared?

|||

OK thanks In this case no..my data source is not shared........Is there any disadvantage if i select Overwrite option?

what if the data source is shared? still can I used this option?

I'm supposed to create few reports and execute in daily and monthly basis. So which option should I use?

|||If you use a shared datasource then you don't need the overwrite option. If the data source is not shared and you are constantly redeploying it then you want to use the overwrite option.|||OK I understood..Thanks lot

I found the anwer for second question too. If I make snapshots, I can not select impersation option.

Thanks lot

Deploy project - error

When i deployed my data source and reports, i see in my output screen
warning message
'Warning : Cannot deploy data source ReportsDS to the server because it
already exists and OverwriteDataSources is not specified.'
What is this mean?In VS, right click on the Project name in the Solution explorer window to
see the properties, change OverwriteDataSources from false to true (if you
want to deploy a revised data source)
"GGill" <GGill@.discussions.microsoft.com> wrote in message
news:07D8BE07-848F-472D-9991-95F5689E3B62@.microsoft.com...
> When i deployed my data source and reports, i see in my output screen
> warning message
> 'Warning : Cannot deploy data source ReportsDS to the server because it
> already exists and OverwriteDataSources is not specified.'
> What is this mean?