GDI+ error when using TIFF in PRINTERDELIVERY sample

Hi,
I'm playing with the Printerdelivery sample in 2005 and having problems.
1. When I use the EMF Image type the printout for the rendered report is
larger then expected. The fonts seem larger and the lines of text are cut
off. I tried modifying the Device Info and add the DpiX and DpiY to 300, but
this gave me the same thing. Why does EMF make the rendered report larger
then expected.
2. When trying a diffent type such as TIFF I get the error "A generic error
occurred in GDI+." I don't know what this error my be indicating. Here is
my line from the sample
deviceInfo = String.Format(
System.Globalization.CultureInfo.InvariantCulture,
@."<DeviceInfo><OutputFormat>{0}</OutputFormat><StartPage>{1}</StartPage><PageHeight>{2}</PageHeight><PageWidth>{3}</PageWidth></DeviceInfo>",
"tiff", startPage, pageHeight, pageWidth);
Any help greatly apprciated.
David BotzenhartI'm having the same problem...did you find a resolution?
Thanks,
Gary
"David Botzenhart" wrote:
> Hi,
> I'm playing with the Printerdelivery sample in 2005 and having problems.
> 1. When I use the EMF Image type the printout for the rendered report is
> larger then expected. The fonts seem larger and the lines of text are cut
> off. I tried modifying the Device Info and add the DpiX and DpiY to 300, but
> this gave me the same thing. Why does EMF make the rendered report larger
> then expected.
> 2. When trying a diffent type such as TIFF I get the error "A generic error
> occurred in GDI+." I don't know what this error my be indicating. Here is
> my line from the sample
> deviceInfo = String.Format(
> System.Globalization.CultureInfo.InvariantCulture,
> @."<DeviceInfo><OutputFormat>{0}</OutputFormat><StartPage>{1}</StartPage><PageHeight>{2}</PageHeight><PageWidth>{3}</PageWidth></DeviceInfo>",
> "tiff", startPage, pageHeight, pageWidth);
>
> Any help greatly apprciated.
>
> David Botzenhart
>
>|||Check this out...
http://www.sqlmonster.com/Uwe/Forum.aspx/sql-server-reporting/3566/Printer-Delivery-Extension-Font-Problem
"GaryV" wrote:
> I'm having the same problem...did you find a resolution?
> Thanks,
> Gary
>
> "David Botzenhart" wrote:
> > Hi,
> >
> > I'm playing with the Printerdelivery sample in 2005 and having problems.
> >
> > 1. When I use the EMF Image type the printout for the rendered report is
> > larger then expected. The fonts seem larger and the lines of text are cut
> > off. I tried modifying the Device Info and add the DpiX and DpiY to 300, but
> > this gave me the same thing. Why does EMF make the rendered report larger
> > then expected.
> >
> > 2. When trying a diffent type such as TIFF I get the error "A generic error
> > occurred in GDI+." I don't know what this error my be indicating. Here is
> > my line from the sample
> >
> > deviceInfo = String.Format(
> >
> > System.Globalization.CultureInfo.InvariantCulture,
> >
> > @."<DeviceInfo><OutputFormat>{0}</OutputFormat><StartPage>{1}</StartPage><PageHeight>{2}</PageHeight><PageWidth>{3}</PageWidth></DeviceInfo>",
> >
> > "tiff", startPage, pageHeight, pageWidth);
> >
> >
> >
> > Any help greatly apprciated.
> >
> >
> >
> > David Botzenhart
> >
> >
> >

Full-Text-Search

Hi,
I have a full-text search enabled table and an image data type column that stores the extracts from the documents stored in the files. I have created a full text catalog that indexes few columns in the table and image data type column as well and I assigned the extension column to this image data type column.
Everything works fine except that search on the image data type column called, in my case "body" does not return anything. The documents exist, there is an information in the "body" column.

My code goes like this:
select FT_TBL.resourceID, FT_TBL.lang, FT_TBL.keywords, FT_TBL.description, FT_TBL.extension, b.rank
from full_text_search as FT_TBL inner join containstable(full_text_search, *, 'Microsoft') as b
on b.[key] = FT_TBL.resourceID
order by b.rank desc

any help appreciated,
thanksI figured the solution to the previous post. I was trying to search on the .pdf files, but I do not have filter installed on the server to filter through these files, other files extension work fine.

Another problem:
I have two tables that are full-text search enabled. And I need to search one table first, and than the columns in the second one. This works fine if the search criteria is found in both tables, but if not the query returns nothing.

help much appreciated!
Thanks|||use union all.

Full-Text Search

I am trying to create a full text index on a column in a table and the data type is Image, but the TYPE COLUMN FILE EXTENSION is in another table. there is no way of creating the type in the same table. the wizard will not allow me to pick the data type field from another table. is there a work around this issue?

Emadkb

Adding a column to the table is not an option?|||It is a fram work table and making any changes now would be impossible. Do you see any other solutions to this issue. I really appreciate your quick response. Emadkb|||If you are using SQL 2005, you can make an indexed view and build fulltext index on the view. However that do means you dup the storage for the image columns.|||Thank you so much....I was wishing there is another solution. emadkb|||

hey Feng Tian
I hope you could help me in FullText Search. No one else seems to be knowing about Fulltext Search.
I'm able to create Full text indexing catalogs, populate them etc.. when i login directly from the server using Sql Server Enterprise manager but when I try to use the same login (db owner) remotely from some other machine using SQL Server Enterprise Manager, I see disabled(stopped) Full-text Service and all full-text features disabled. So does it mean i cannot populate or create catalogs remotely using sql server enterprise manager.
I have tried this on two different servers and then accessing from two different remote/client machines. But the problem is there any way.

Server: Mssql 2000 server
Remote/Client system: Win XP service Pack2
Access Software: Microsoft Sql Server 2000 Enterprise Manager.

Thanks
Sattva

|||

Sattva,
The behievor you are experiencing with your SQL Server 2000 Enterprise Manager (EM) is typical and expected. The EM cannnot "see remote" services such as the "Microsoft Search" (MSSearch) service on remote servers when accessed across the internet or the server is registered as an IP address. However, SQL FTS is still functional and you can use the system stored procedures to remotely manage and populate the FT Catalogs, for example:

To Create/Remove the Existing Full-Text Table Index, Catalog
-- If Full-Text Index exists, DROP that Index,
-- If Full-Text Index does not exist, CREATE that Index.
--
use pubs
go
IF OBJECTPROPERTY ( object_id('pub_info'),'TableHasActiveFulltextIndex') = 1
BEGIN
print 'Table pub_info is Full-Text Enabled, dropping Full-Text Index & Catalog...'
EXEC sp_fulltext_table 'pub_info', 'drop'
EXEC sp_fulltext_catalog 'PubInfo', 'drop'
END
ELSE IF OBJECTPROPERTY ( object_id('pub_info'),'TableHasActiveFulltextIndex') = 0
BEGIN
print 'Table pub_info is NOT Full-Text Enabled, creating FT Catalog, Index & Activating...'
EXEC sp_fulltext_catalog 'PubInfo', 'create'
EXEC sp_fulltext_table 'pub_info', 'create', 'PubInfo', 'UPKCL_pubinfo'
EXEC sp_fulltext_column 'pub_info', 'pub_id', 'add'
EXEC sp_fulltext_column 'pub_info', 'pr_info', 'add'
EXEC sp_fulltext_table 'pub_info', 'activate'
END

EXEC sp_fulltext_catalog 'PubInfo', 'start_full' -- "Full Crawl"
Wait for crawl to complete
--
Confirm above results with:
--
SELECT pub_id, pr_info
FROM pub_info WHERE CONTAINS(pr_info, '"book*"')

See my blog entry "SQL Server 2000 Full-Text Search Resources and Links" for more SQL 2000 FTS information.

Hope that helps,
John

SQL Full Text Search Blog
http://jtkane.spaces.live.com/

|||

Thanks John. It was a great help. Now I hav it all working.

Cheers mate.