Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Issue in designing the report


Issue in designing the report

Author
Message
Arunkumar S P
Arunkumar S P
SSC Veteran
SSC Veteran (299 reputation)SSC Veteran (299 reputation)SSC Veteran (299 reputation)SSC Veteran (299 reputation)SSC Veteran (299 reputation)SSC Veteran (299 reputation)SSC Veteran (299 reputation)SSC Veteran (299 reputation)

Group: General Forum Members
Points: 299 Visits: 870
Hi All,

I'm facing tremendous issue when desiging the SSRS report. What i designed in layout page is not exactly coming in the report manager(line height is changing, rectanagle width is changing,etc..,) but i'm able to get the exact design in preview and even in PDF. I'm facing this issue over many times and i can't find why.

Is this bug of SSRS?. Or am i designing badly?. I'm using SSRS 2005.

Can you please help me out?

-----------------------------------------------------------------------------------------------------------------------------------------------------------
Please feel free to let me know if you are not clear or I’ve misunderstood anything.

Thanks,
Arunkumar S P


Dave Klug
Dave Klug
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1199 Visits: 1174
When you run it on the server and then export to PDF, does it look as it does when run from BIDS?
Arunkumar S P
Arunkumar S P
SSC Veteran
SSC Veteran (299 reputation)SSC Veteran (299 reputation)SSC Veteran (299 reputation)SSC Veteran (299 reputation)SSC Veteran (299 reputation)SSC Veteran (299 reputation)SSC Veteran (299 reputation)SSC Veteran (299 reputation)

Group: General Forum Members
Points: 299 Visits: 870
Yes. I'm getting the same design in PDF as in layout while exporting from Report manager. But while viewing in reportmanager/ report serve its not good.
Can you help me please?

-----------------------------------------------------------------------------------------------------------------------------------------------------------
Please feel free to let me know if you are not clear or I’ve misunderstood anything.

Thanks,
Arunkumar S P


peterzeke
peterzeke
SSC-Addicted
SSC-Addicted (454 reputation)SSC-Addicted (454 reputation)SSC-Addicted (454 reputation)SSC-Addicted (454 reputation)SSC-Addicted (454 reputation)SSC-Addicted (454 reputation)SSC-Addicted (454 reputation)SSC-Addicted (454 reputation)

Group: General Forum Members
Points: 454 Visits: 1766
I've witnessed the same problem in SSRS 2005 Report Manager, too. The report is designed and displayed perfectly in BIDS, but fails to render the same in Report Manager. Viewing the report in the .net viewer seems to be ok, though.

So, I don't have a solution to the problem. All I ever seem to do is flip back-n-forth between what I designed and how it shows up in report manager... repeat until the display in report manager is "good enough." A crappy, wasteful way to work.

There must be documentation somewhere that explains the rendering differences...



Arunkumar S P
Arunkumar S P
SSC Veteran
SSC Veteran (299 reputation)SSC Veteran (299 reputation)SSC Veteran (299 reputation)SSC Veteran (299 reputation)SSC Veteran (299 reputation)SSC Veteran (299 reputation)SSC Veteran (299 reputation)SSC Veteran (299 reputation)

Group: General Forum Members
Points: 299 Visits: 870
Thanks Peterzeke. But while changing the design to look better in report manager, mean time in PDF its not looking good where it looked good previously.

I'm very irritating to design the reports.

-----------------------------------------------------------------------------------------------------------------------------------------------------------
Please feel free to let me know if you are not clear or I’ve misunderstood anything.

Thanks,
Arunkumar S P


Siva Gurusamy
Siva Gurusamy
SSC Veteran
SSC Veteran (249 reputation)SSC Veteran (249 reputation)SSC Veteran (249 reputation)SSC Veteran (249 reputation)SSC Veteran (249 reputation)SSC Veteran (249 reputation)SSC Veteran (249 reputation)SSC Veteran (249 reputation)

Group: General Forum Members
Points: 249 Visits: 386
Don't you give up Arun.

In my case I did a merge cells on all columns for a header row in a table and one page in the report when exported to pdf was printing in bits and pieces across several pages.

After so many attempts at rebuilding the reports for several days, by chance I discovered this. Merging cells for a report table title is a common thing and never would I have realised that this would cause printing problems.

So, again do not give up, try building the report from scratch. do not make a copy of the existing report and make design changes. you never know what caused the craziness in the original report.

Like I said, it is only by trials we perfect the art.
Also, space(), chr(), vbcrlf, newline() might behave differently in Rpt Mgr, Excel, PDF......

View Siva Gurusamy's profile on LinkedIn

"Software changes. This is a rather obvious statement, but it is a fact that must be ever present in the minds of developers and architects. Although we tend to think of software development as chiefly an engineering exercise, the analogy breaks down very quickly. When was the last time someone asked the designers of the Empire State building to add ten new floors at the bottom, put a pool on the top, and have all of this done before Monday morning? " : Doug Purdy, Microsoft Corporation
Arunkumar S P
Arunkumar S P
SSC Veteran
SSC Veteran (299 reputation)SSC Veteran (299 reputation)SSC Veteran (299 reputation)SSC Veteran (299 reputation)SSC Veteran (299 reputation)SSC Veteran (299 reputation)SSC Veteran (299 reputation)SSC Veteran (299 reputation)

Group: General Forum Members
Points: 299 Visits: 870
Thanks Siva.

Most of the time i'm redesigning the reports from the scrath.Getting bored.Thats why i asked.
Thanks for your reply.

-----------------------------------------------------------------------------------------------------------------------------------------------------------
Please feel free to let me know if you are not clear or I’ve misunderstood anything.

Thanks,
Arunkumar S P


cfloyd
cfloyd
Forum Newbie
Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)

Group: General Forum Members
Points: 2 Visits: 51
I have run into a similar issue and to prevent this from occuring, I added a transparent box around the outside border of the report and sent this to the back. Now when you run the report, the transparent box will act like a fence for your other objects.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search