I'm getting different views where I run the report from the Report Manager
and then after its exported to pdf. The results are the same when the report
is viewed from the Preview Mode in the Report Deisigner.
The Report has 3 groupings on data and I'm hiding some column values using
"Hide Duplicates". As menioned above, the "hide duplicates" functionality
works well in the Report Designer & Report Manager before exporting to pdf.
Is this a bug in the export functionality? How do I take care of this
discrepancy?
ThanksWhat is more exactlly the discrepancy? Are the textboxes still visible in
pdf? Could you send us the report and data to repro, please?
--
Nico Cristache [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"newmem" <""> wrote in message news:u9OR7jTXEHA.3640@.TK2MSFTNGP11.phx.gbl...
> I'm getting different views where I run the report from the Report Manager
> and then after its exported to pdf. The results are the same when the
report
> is viewed from the Preview Mode in the Report Deisigner.
> The Report has 3 groupings on data and I'm hiding some column values using
> "Hide Duplicates". As menioned above, the "hide duplicates" functionality
> works well in the Report Designer & Report Manager before exporting to
pdf.
> Is this a bug in the export functionality? How do I take care of this
> discrepancy?
> Thanks
>
Showing posts with label views. Show all posts
Showing posts with label views. Show all posts
Friday, March 30, 2012
Monday, March 26, 2012
hidden views
i have created views in database Test, in sqlServer.when i had to export Test to another database Test1, the views become hiddden.
i can't see the views and when i try to create them again, i get this msg:
There is already an object named 'view1' in the database.
so how can i resolve this problem?
thanks,
when u export view from one database to another the view is created as table in the target database. To migrate view , create script of the view and run that script in Target DB... ... do not select view in Export wizards only select tables...
if you are getting View1 already exists then :-
Check in Tables there will be a table called View1 , first drop that and run the script for view1 to create...
Madhu
|||When you choose to Generate script for the database objects, then it should have that value to drop the object before creating it, follow as suggested.|||
Well, thanks!
As u said, the views were created as tables in the target DB. So i droped them and made a new script for the views.
Myra
|||thanks for ur help!
myra
Subscribe to:
Posts (Atom)