Monday, July 27, 2009

text with rotation displayed with no effect in crystal reports.

Problem

Text with rotation have no effect on DHTML viewer.

Resolution

1. locate default.css from C:\Program Files\Business Objects\common\3.5\crystalreportviewers115\css\

2.Add the vertical text entry to the CSS file and save

.verticalText
{
writing-mode: tb-rl;
}

3. Specify the vertical text tag in your report by right clicking on the field that you want vertical, selecting properties, and under the “common” tab, enter “verticalText” in the “CSS Class Name” field.

Hope this helps.
Thanks.

Images/Charts not displayed on view but fine when exported.

Symptom

Charts/Images on crystal report are not dispalyed when viewed from viewer, but when you export it to any of the format for example "pdf", there you will find your charts/images. I have found a work around for this.

Resolution

1. Right-click My Computer and click Manage.
2. Navigate to Services and Applications > Internet Information Services (IIS) Manager > Web Sites > Default Web Site.
3. Right-click crystalreportviewers115 and then click Properties.
4. On the ASP.NET tab, choose a 2.0.x version from the ASP.NET Version list.
5. Click the Apply button and then click OK.
6. Right-click businessobjects and click Properties.
7. On the Virtual Directory tab, click the Configuration button.
8. Check the path of the mappings and note the version number (in the path ...\Framework\vX.X...)
9. Repeat steps 2 to 5 for crystalreportsviewers115.If the paths for businessobjects and crystalreportviewers115 are different, change one or the other so that they point to the same version of .NET Framework.
10. Stop and restart the Default Web Site.


Hope this helps

Thanks.

How to pass the logged in user name to the store procedure or query in Crystal Reports.

Crystal Report has this lilmitation that you cannot use or pass the Crystal Special fields to the stored procedure or command object as a parameter, say if you want to retrieve the data of the current logged in user as

Select * from tUser where user_id = CurrentCEUserName

CurrentCEUserName is the crystal special field. To achieve the above thing, please follow the following steps.

1) Create a blank report, suppress all the sections except the report footer.
2) Add a formula field and place the special field CurrentCEUserName in the formula.
3) Create a subreport in the and place in the report footer.
4) Create the command with parameter UserId in the subreport.
5) From main report link the formula field created with the subreports command parameter.This way the Current CE User Name will be available in the subreport which is actually our main report.

Hope this helps,

Thanks.

Navigate to portal home from Mysite.

We had this problem of having Portal home link (to return to the portal home page) on Mysite of every user during one of our project, what we did was we created a link in SharedServices1 > Personalization site links.

Easy enough to add a link in SharedServices1 > Personalization site links. Except that when you click and return to your Portal, the menu has retained the MySite navigation because the URL contains "?MySiteView=1".The solution (as per link) is to add a # on the end of the URL you enter, this makes the rest of the link an anchor so SP will ignore it and display your normal menu. Thought to share it with you guys.
http://portalhome/#

Thanks.