if text box is blank and report is exported to word, document does not take specified font but shows some default font in text box.
Hi there, I have created a report which has a checkbox for date with font as verdana. when i pass the date in the text box and export the report to word it shows the date with verdana font. but, when the text box is empty i.e no date in the text box and if i export it to word and try to enter date word document takes "Times new roman" as font. Requirement is to get the font as verdana ever if there is no date or with date. bcz if no date is provided then user can enter date in word document and then take print out Thanks sadaf
January 16th, 2011 10:41am

Hi Shaikh, Yes when the value is blank it does not pick the font you have set. To overcome this, you may pad a space to the end of the date, so that it would be forced to pick the font. I guess it would not be a hassle for the users to overwrite the space when they want to enter a date. Please try setting the below expression in the place where you display the date =Parameters!MyDate.Value & " " Regards Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful. BH
Free Windows Admin Tool Kit Click here and download it now
January 17th, 2011 6:46am

Thanks for reply, but this solution does not work with HTML enable text boxes because it supress the blank space. plz suggest some other solution for this... thanks sadaf
January 19th, 2011 11:42am

Hi Sadaf, As BH posted, one workaround is to use an addition space, and it also be applied to to textbox with HTML placeholder. Please refer to the steps below: 1. Select the textbox of date. 2. Focus the cursor at the position before the existing placeholder of date field. 3. Right click and select Create Placeholder… 4. In the Placeholder Properties window, specify the Value to the expression =” ” 5. Click OK. Thanks, Tony ChainTony Chain [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Free Windows Admin Tool Kit Click here and download it now
January 23rd, 2011 12:33pm

Hi Tony Chain, I tried this solution and it works fine but only the problem is even if the data is coming it reserves one space. Is there any alternate way?Everything about SQL Server | Experience inside SQL Server -Mohammad Nizamuddin
January 24th, 2011 2:12pm

Doesn't exists an alternative solution? I mean, this works, but it is not the best solution. Thanks, Daniel Fricke
Free Windows Admin Tool Kit Click here and download it now
December 14th, 2011 6:12am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics