login
Forgot?
Login with Facebook

Don't have an account? Register one now!

PDF Creation using data from SQL Database !

Bids 
22
Avg Bid
$137 USD
CLOSED
  • Project ID:

    631131
  • Project Type:

    Fixed
  • Budget:

    $30-$250 USD

Project Description:

Hi,
I have a team of developers that are finding it difficult to automate the creation a certain type of pdf. We are building a real estate website and once we have inserted all of the details about someones house into the MS Sql database we will want to display this information on a pdf document which will include photographs of the property. My team of programmers can create the pdf with the template we had designed and they can get the information and photographs to display but what they cannot do is only display the room names that we asked them to. For example, if we have say 10 possible room types for a property like Lounge, Kitchen, Laundry Room, Bedroom etc but a house we want to list only has say 3 of those rooms we would only want to display the 3 room names and then the detail and photographs for each of those rooms. At the moment the pdf gets created with all room names even if the room name / type in the property does not exist. So we end up having lots of whitespace which is not necessary. I guess this is a formatting issue which I need to fix. I know this is possible because I have seen it on other websites before. We just need to know how to do it. This is a post for advice on how this can be achieved. I do not need anybody to do the work but I will need you to speak with my programmers and tell them the technique. I will pay for your advice as long as we are able to achieve what we want. I am also hapopy to escrow the funds.
Thanks
Chris

Skills required:

.NET, ASP, SQL

Project posted by:

ChrisWhatcott United Kingdom
(19 Reviews)

Last seen:

Public Clarification Board

1 messages

  • hari505

    hello
    we are working as developers since four years as we are new to this site we have no ratings ..if you need any samples of work we provide to you upon your request ...waiting fir your reply

    over 1 year ago


If you are the project creator or one of the bidders, please Log In for more options.


All Bids ()

ByteAnt Ukraine
ByteAnt
Ukraine From Ukraine     Gold Member     Offline
  General Freelancer Orientation (80%, 90th percentile)
  Foundation EUFreelance.com Member
$100 in 1 day 
0
over 1 year ago
5.0

7.5

32 Reviews
93% Completion Rate
Hello, we have rich experience in ASP.NET websites development, including export to PDF routines programming and would be glad to help. Please, check PM.
shmai Pakistan
logo.gif
shmai
Pakistan From Pakistan     Gold Member     Online
  General Freelancer Orientation (80%, 90th percentile)
  Foundation EUFreelance.com Member
$250 in 2 days 
0
over 1 year ago
4.9

6.9

161 Reviews
84% Completion Rate
have a glance at PM. Regards,
sadam Ukraine
sadam
Ukraine From Ukraine     Offline
  Foundation EUFreelance.com Member
$150 in 5 days 
0
over 1 year ago
5.0

6.0

24 Reviews
81% Completion Rate
Hello, please see PMB
ambar India
SSD-Icon-D2.jpg
ambar
India From India     Gold Member     Offline
  Foundation Freelancer.co.uk Member
  US English Level 1 (90%, 45th percentile)
$45 in 1 day 
0
over 1 year ago
5.0

5.5

19 Reviews
80% Completion Rate
Dear Sir/Madam, Please check my private message. Thanks Shome.
totalsoftwares India
TS_GAF.gif
totalsoftwares
India From India     Offline
  General Freelancer Orientation (85%, 95th percentile)
$125 in 3 days 
0
over 1 year ago
5.0

4.4

5 Reviews
50% Completion Rate
Please see PMB for details
JohnInFL United States
JohnInFL
United States From United States     Offline
  US English Level 1 (100%, 100th percentile)
  SQL Level 1 (95%, 97th percentile)
  General Freelancer Orientation (85%, 95th percentile)
  Foundation LimeExchange Member
$50 in 1 day 
0
over 1 year ago
5.0

2.3

2 Reviews
50% Completion Rate
Please read PMB, thanks!
sm2mafaz
26432_377197607346_545917346_3505421_4564286_n[1].jpg
sm2mafaz
    Offline
  General Freelancer Orientation (75%, 81st percentile)
  Foundation LimeExchange Member
  Foundation EUFreelance.com Member
$120 in 5 days 
0
over 1 year ago
5.0

1.9

1 Review
81% Completion Rate
Hello Chris, Please have a look to the PMB for further discussion. Kind Regards, Mafaz
agriz India
MV5BMjA1NTU0Mzk4OF5BMl5BanBnXkFtZTcwNTc4MTY0MQ@@._V1._SX94_SY140_.jpg
agriz
India From India     Offline
  General Freelancer Orientation (80%, 90th percentile)
  Foundation LimeExchange Member
  Foundation EUFreelance.com Member
$200 in 4 days 
0
over 1 year ago
5.0

1.2

2 Reviews
75% Completion Rate
Hello Sir, I am ready to start now. Thanks Agriz
logicland Ukraine
logo.png
logicland
Ukraine From Ukraine     Offline
  Foundation EUFreelance.com Member
$250 in 4 days 
0
over 1 year ago
5.0

1.0

1 Review
92% Completion Rate
Good day. We can do this project for you. Please look on this https://www.freelancer.com/projects/PHP-Website-Design/PDF-Home-Info-Flyer-using.html project which we performed.
logicamatics India
longLogo.gif
logicamatics
India From India     Offline
  Foundation EUFreelance.com Member
$250 in 3 days 
0
over 1 year ago
0.0

0.0

0 Reviews
0% Completion Rate
Please read the Message.
arun5920 India
arun5920
India From India     Offline
  Foundation LimeExchange Member
  Foundation EUFreelance.com Member
$200 in 5 days 
0
over 1 year ago
i have interested work with.if u hvae any question mail to my id arunkumarv77.
my2011world India
my2011world
India From India     Offline
$81 in 10 days 
0
over 1 year ago
Myself chetan parmar, i belong in softworld technologies ahmedabad,gujarat india, 9510012200. I have 12 php experience person which have good experience . We are capable for this work in your deadline.Reach to deadl... more
Myself chetan parmar, i belong in softworld technologies ahmedabad,gujarat india, 9510012200. I have 12 php experience person which have good experience . We are capable for this work in your deadline.Reach to deadline its our passion. less
vijayjoshi1012 India
vijayjoshi1012
India From India     Offline
  Foundation LimeExchange Member
  Foundation EUFreelance.com Member
$200 in 10 days 
0
over 1 year ago
Assure you for quality of the work. lets start the work to finish it with professional touch.
rajeshborn4u India
rajeshborn4u
India From India     Offline
  General Freelancer Orientation (85%, 95th percentile)
  Foundation EUFreelance.com Member
$120 in 3 days 
0
over 1 year ago
0.0

0.0

0 Reviews
0% Completion Rate
Hi , I am Rajeshkumar from India. I am a Freelancing Project manager. I came to see that your programmers are finding very difficult to automating the PDF generation. I am glad to help you on this, we have done this... more
Hi , I am Rajeshkumar from India. I am a Freelancing Project manager. I came to see that your programmers are finding very difficult to automating the PDF generation. I am glad to help you on this, we have done this way before a long time. We have generated automated MS word, MS power point and PDf. We can assure that it can be done within a couple of days. The amount I quoted is a reasonable one for completing the task and we can give support for your future enhancements as well. I am waiting for your positive reply on this . Regards Rajeshkumar less
yadajay India
yadajay
India From India     Offline
$30 in 5 days 
0
over 1 year ago
Hi, I am solo developer , I will be able to complete this task successfully in time. Please give me a try. Thank You
meteor Serbia and Montenegro
meteor
Serbia and Montenegro From Serbia and Montenegro     Offline
$100 in 7 days 
0
over 1 year ago
I can guarantee you that I pointed end. I work with PDF so I was not a problem to do this job. I am using pdfizer component for this purpose. I think that could be the best solution, especially pdf api’s is easy hand... more
I can guarantee you that I pointed end. I work with PDF so I was not a problem to do this job. I am using pdfizer component for this purpose. I think that could be the best solution, especially pdf api’s is easy handling. 7 days, I wrote in terms of the deadline, and since the weekend is probably going to be completed until end of the weekend. The requirements are clear. This is my first on the freelancer.com. Please give me a chance I wouldn’t disappoint you. I’m available after 5 pm CET. Here is source example: iTextSharp.text.pdf.BaseFont helvetica = iTextSharp.text.pdf.BaseFont.createFont("Helvetica", BaseFont.CP1252, BaseFont.EMBEDDED); iTextSharp.text.Font font = new iTextSharp.text.Font(helvetica, 14, BaseFont.FONT_TYPE_TT); try { clElement = new Cell((new Jpeg(Request.PhysicalApplicationPath + @"\images\eml-logo.jpg"))); clElement.setHorizontalAlignment("align = \"right\""); clElement.Width = "width: 21px"; clElement.BorderColor = new Color(System.Drawing.Color.White); table.addCell(clElement);  less
juyizhao China
juyizhao
China From China     Offline
$100 in 5 days 
0
over 1 year ago
Hi sir, I have 4 years experience on .Net and Sqlserver. I'm willing to do this project by your requirement. if need i could provide a demo by your requirement. Regards!
matoliamk India
M1.JPG
matoliamk
India From India     Offline
$100 in 2 days 
0
over 1 year ago
Please see PMB for details
metal333 India
metal333
India From India     Offline
  General Freelancer Orientation (80%, 90th percentile)
  Foundation EUFreelance.com Member
$150 in 1 day 
0
over 1 year ago
0.0

0.0

0 Reviews
80% Completion Rate
Check ur PM...
cnut17 France
cnut17
France From France     Offline
$60 in 1 day 
0
over 1 year ago
0.0

0.0

3 Reviews
33% Completion Rate
Well this is a very basic SQL query problem. I don't want to say anything bad about your developers but you should offer them a general training on relational databases and on algorithms. The actual solution depends ... more
Well this is a very basic SQL query problem. I don't want to say anything bad about your developers but you should offer them a general training on relational databases and on algorithms. The actual solution depends on how these informations about rooms count are coded in the database. A good database designer would code this with three tables : one to store properties, one to store every possible room type, and one to tell how many of each kind of rooms there is in each property. With this approach, if a house has no dressing, you don't use disk space to say there is zero, you just ommit the link to the missing ones. This is called an (n,m) relationship (many to many). so when you want to generate the pdf for a given house, you enumerate only the ones that exist, you don't scan all types including the ones you don't have. And even if you do so, you don't skip a blank line in the document. less
sweta702 India
sweta702
India From India     Offline
$100 in 2 days 
0
over 1 year ago
I am interested in your project , i need your further feedback to go ahead.
hari505 India
hari505
India From India     Offline
$235 in 5 days 
0
over 1 year ago
regards plz see pm