pdssql.dll

I developed small program VB 6.0 and SQL SERVER 2000 but an error happen in displaying any crystal report file with pdssql.dll not found actually this message appear in some of computer, I tried to find this file and copy it in system file but I couldnt found. What the solution of this problem? And is copying pdssql.dll file solution?May check the CD for this file.|||how??|||From FIND FILES utility on Windows.|||Sorry but I can't get your requst|||On Windows from START --> Programs --> Find files and enter the filename and under the lookin specify the CD drive path.

PDF not displaying Header and moving overlapping tables

Hi there,
I'm having a problem with pdf rendering in my report. Basically it is two
tables slightly overlapped to give the appearance of once, as I am using two
different datasets on each. Although everything works fine in HTML/image
view, when I try to export a pdf two things happen:
1. The header information which is set to repeat on every page, does not
display on the final page with body footer.
2. The overlapping tables "move" slightly despite being perfectly aligned.
Any help would be most gratefully received :)
Thanks,I've now sorted the overlapping tables but still no joy with the Header
problem ~ any ideas?
Thanks
"Laura-Anne" wrote:
> Hi there,
> I'm having a problem with pdf rendering in my report. Basically it is two
> tables slightly overlapped to give the appearance of once, as I am using two
> different datasets on each. Although everything works fine in HTML/image
> view, when I try to export a pdf two things happen:
> 1. The header information which is set to repeat on every page, does not
> display on the final page with body footer.
> 2. The overlapping tables "move" slightly despite being perfectly aligned.
> Any help would be most gratefully received :)
> Thanks,

PDF Exporting problem

I am using report viewer and exporting my report to pdf format.The report is displaying very odd there.Can anyone help me to adjust the original format there.

What do you mean by odd?

Not to hijack your post, but maybe you are having the same problem as I am.

My report has three columns of yearly sales (in dollars), when I export the report the columns will shift to the left if any of the columns are blank.

|||

try putting the information in a rectangle so that they can stay together if any part of ur data is missing.

|||

FYI, I fixed my problem, by taking the Yearly columns out of a filtered List and just filtered the textbox with an "If.. Then.." and made it return $0.00 instead of a blank.

|||

If you're report width is too wide then while exporting to pdf it wraps the content exceeding the standard width (8.5") and pushes it to the next page. If you apply colors to the various ctrls on your report including its body you can debug where exactly it spills over.

Remember while exporting to pdf or printing, the interactive height of the report should be 8.5" x 11" . Your report's body width should also be 8.5" however the height can be as long as you want it.

............................................................................

Remember to mark as "Answer" on the post that helped you

http://technoblab.blogspot.com

|||Hi,My problem is same as your problem.I think this is the report problem itself.I had a table and it has 5 columns,when i export data from my repot viewer to pdf so the column shifted to next pages.and 2 column is display in one page and next is shifted in next page.Using rectangle is another way.Can i use third party control.|||

you should be able to fix any problem with the normal report controls etc. Please describe your problem a bit more thoroughly. THanks!