Showing posts with label pdf. Show all posts
Showing posts with label pdf. Show all posts

Wednesday, March 28, 2012

Modelling Tool Help

Hello,

For management that doesn't have the software I do, I've been using a PDF postscript utility to print the model and give it to them. However, I have to fit the model for the specific page (which is really small, and you have to zoom in), or you have to view it on multiple pages. Well multiple pages can be a pain, because the table you are looking at is on page 1, but the relationships are on page 12, 22, or 50, for example. So I was looking for a tool that is cheap enough to implement that we could look at the entire model on one "surface" (not necessary to print), that the model could be viewed in.

Thanks,

BrianHow about visio?|||Yes, we have that too, and I did find the Meta Information Model Bridge that converts to different formats, but we are looking for a general viewer without the data modelling need. It may just have to be Visio.

Thanks,

Briansql

Saturday, February 25, 2012

missing image

Hey
Im trying to display an image in a report in .PDF, but the problem is,
that there will not allways be an image. Im retrieving the image from
the database (MS SQL Server) but the table with the images is left
outer joined with some other tables ie. it will allways return a row,
but not allways will the content field contain an image.
Ive tried the following in the value property of the image item:
=First(Fields!Content.Value)
Results in the report timing out whenever theres no image. The report
never shows.
=iif(Trim(Fields!Content.Value) = "", Nothing, Fields!Content.Value)
Results in a red cross in the report where the image should be. It
doesnt matter wether theres an image or not, it just shows the red
cross.
I would like it not to show anything if theres no image, and if there
is an image, to show the image.
Anyone Please help
Regards
Jimmywell in sql server there is a function named DATALENGTH(ImageDataField)
and returns no of bytes occupied by the image
u should use this to check how many bytes r of a pic better to make a
calculated field in ur data set
then use this calculated field to hid or show the image in the report
by using the following expression in the HIDDEN property of the IMAGE
=iif(imagelengthfield.value=1,true,false)
when image wont b avaiable ur this calculated field ll return 1
otherwise some bigger value representing bytes of the image
u can further go to restrict data set by using
datalength(imageDatabaseField)>1 to come up in the dataset of the
report with the records having images only
choice is urs
take care
regards|||Hey
Actually what did the trick was to specify the dataset name. Dont know
why, it took me very long time, but it was after reading your post that
i found the solution, so thank :)
Jimmy

Missing Header Footer in

Hey all-

We have a number of reports that have headers and footers in HTML and PDF, but when exporting to Excel the headers and footers disappear.

Has anyone else seen this happen? Any ideas on how to re-enable the headers?

Thanks in advance,

Tristan

Tristan, did you find a way to do this? I am in a very similar position where the footers are not displayed.

Thanks,
AJ