Showing posts with label export. Show all posts
Showing posts with label export. Show all posts

Wednesday, March 28, 2012

Problem with BorderStyle while Exporting to PDF

Hi,
I have lines of BoderStyle: Dotted, BorderWidth: 0.5pt in my report
When I preview it and print it I get the dotted lines
But if I export the same report to PDF and then print I get Dashed lines
instead of Dotted Lines
It's very important that I get Dotted lines.
Can Someone Help me with this
Thanks in Advance
PonnurangamThis is a known issue that will be addressed in a future release.
Unfortunately I do not have a work around to suggest you.
Anyone else?
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ponnurangam" <ponnurangam@.trellisys.net> wrote in message
news:OL1Dft%23nEHA.744@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I have lines of BoderStyle: Dotted, BorderWidth: 0.5pt in my report
> When I preview it and print it I get the dotted lines
> But if I export the same report to PDF and then print I get Dashed lines
> instead of Dotted Lines
> It's very important that I get Dotted lines.
> Can Someone Help me with this
> Thanks in Advance
> Ponnurangam
>

Problem with barcode in pdf export

I have a report that requires a barcode. I'm using a wasp128 barcode. The barcode works fine except when I export it to a pdf. It shows the barcode only it is spread out like somebody has slipped some spaces every couple of lines. Export to a image works fine and is scanable. Any thoughts?
--
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.What is the font you used when exporting?
=-Chris
"SqlJunkies User" <User@.-NOSPAM-SqlJunkies.com> wrote in message
news:u#KYFogtEHA.3292@.TK2MSFTNGP12.phx.gbl...
> I have a report that requires a barcode. I'm using a wasp128 barcode. The
barcode works fine except when I export it to a pdf. It shows the barcode
only it is spread out like somebody has slipped some spaces every couple of
lines. Export to a image works fine and is scanable. Any thoughts?
> --
> Posted using Wimdows.net NntpNews Component -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine
supports Post Alerts, Ratings, and Searching.

Tuesday, March 20, 2012

PROBLEM WIHT OPENROWSET FUNCTION

HI FRIENDS THIS IS AMIT. THE PROBLEM IS I M TRYING TO EXPORT DATA FROM SQL SERVER TABLE TO EXCEL FILE USING FOLLOWING CODE SNIPPET,

insert into OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 7.0;Database=c:\testing.xls;',
'SELECT * FROM [Sheet1$]') select * from TABLE1

BUT IT IS SHOWING SOME ERROR WHICH IS AS FOLLOWS,

Invalid object name 'OPENROWSET'.

I FOUND OPENROWSET FUNCTION IN T-SQL REFERENCE BUT STILL THE ABOVE MESSAGE IS COMING PLS HELP IN THIS MATTER ASAP.

REGARDS,

AMIT.

What version of SQL Server are you using (show the output of SELECT @.@.VERSION)?

Steve Kass
Drew University
http://www.stevekass.com|||

Make sure you have "Ad Hoc Remote Queries" enabled for your instance.

|||Kindly provide the version of the SQL Server you are using, it should ideally work without problem in SQL Server 2000 and above. You can however try the same using DTS (Data Transformation Services)|||Excel 7.0??

Try Excel 5.0 or Excel 8.0

Problem while using import/export wizard

I did use Import/Export wizard to convert MS-Access db into MS-SQL Server,
while doing so few of the tables were not converted and many of the tables
were blank.
What's the fix.
TIA
RAJ.
Any errors?
Have you tried fom Access side with the Upsize Wizard?
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
"krisrajz" <krisrajz@.discussions.microsoft.com> wrote in message
news:DC16E7D0-9FE0-45A0-AAA0-92E891C8D596@.microsoft.com...
> I did use Import/Export wizard to convert MS-Access db into MS-SQL Server,
> while doing so few of the tables were not converted and many of the tables
> were blank.
> What's the fix.
> TIA
> RAJ.

Monday, March 12, 2012

Problem while exporting in MAPI

Hi,

I am using crystal report v8.5.
I click on the export icon & select Acrobat Format (PDF) as Format and MAPI as Destination.
But nothing appeared and i couldn't export report whereas i can succesfully save the same report when select Acrobat Format (PDF) as Format and "disk file" as Destination.
Please help me out?

Thanks,
JasIs this on you development machine or the Client machine? Did you make sure you had the correct MAPI dll installed on the computer?|||this is on my developing m/c. i use outlook express for mailing purpose, which works fine. how to check whether correct mapi dll is intalled?

thanks

jas|||I also use CR 8.5. On my computer (Win2k), all the Export dlls are located in C:\WINNT\Crystal. The MAPI one has the name u2dmapi.dll. If you can't find the right dll, maybe it wasn't installed when you installed Crystal Reports. You may be able to reinstall it or pull the dll from the installation CD.|||i use win xp professional, u2dmapi.dll is present in my C:\WINDOWS\Crystal folder but still i couldn't mail. when i click "ok" after selecting format as Acrobat and destination as MAPI, one window appeared titled as "Export options" which allows to enter page range. But after that nothing happened.|||Do you have Outlook or something setup on your computer? I'm not familiar with MAPI, but while researching one of my exporting problems, I read a post where someone was having trouble exporting with MAPI and it was because Outlook wasn't set up with a user profile.|||yaa, i m using outlook express to send n receive mails and it is working perfectly.|||Outlook express is not connected through MAPI, while Microsoft Outlook uses MAPI, to configure a profile follow these steps

1. Open Mail Control Panel
2. Configure Message Store and Internet mail account
3. then use Microsoft Outlook to send & receive mail, if it works then ur Export will also work.|||Thanx for ur help. I m off from work for 2-3 weeks, got chicken pox :( , will try later.
Thanks again
Jas|||Get well soon

Problem while exporting in MAPI

Hello everyone,

I m repeating my problem.
I am using crystal report v8.5.
After running report successfully, when I click on the export icon & select "Acrobat Format (PDF)" as Format and "MAPI" as Destination, dialog box appeared which ask for page range selection. But after that nothing appeared and i couldn't export report.
I m using "outlook express" for mailing which is configured properly.
Please help me out?

Thanks,
Jasafter setting outllook express as default mapi client this problem gets resolved

Problem while export report to Excel

When i export a report to Excel, there are created some coluns and line
that not appear in the report.
These lines and coluns are smaller than the normal ones, but if i need to
work with this file, a must have to delete each one.
And athis operation is not easy.
Thanks by your help.
Pedro Julião
Belo Horizonte - Brasil
--
Message posted via http://www.sqlmonster.comI have run into the same problem. I am just building Excel Macros to delete
the columns.
"Pedro Julião Moura Machado Coelho via S" wrote:
> When i export a report to Excel, there are created some coluns and line
> that not appear in the report.
> These lines and coluns are smaller than the normal ones, but if i need to
> work with this file, a must have to delete each one.
> And athis operation is not easy.
> Thanks by your help.
> Pedro Julião
> Belo Horizonte - Brasil
> --
> Message posted via http://www.sqlmonster.com
>|||Dear Eden,
Thanks by your help.
Can you send me some examples of this macros?
Best regards,
Pedro Julião
--
Message posted via http://www.sqlmonster.com