Recent content by prgmrcr

RiverGuy and dkyrtata, Thanks so much for valuable inputs. The examples you guys have given make perfect sense. How ever the issue mentioned by dkyrtata thrown me off again. So with SCD type2, if the person has a different address after moving to CA, if you want your facts tied to the most...

Hello Members, I am in the process of learning datawarehouse concepts. I have read through few books. However, i have one question about SCD Type 2 dimensions. For example, if there is an person X and he is located in CO and he has some data in fact table. These two tables are joined by personid...

Hello Members, I have a report which has an image (picture of a person). The image is displayed properly on the Crystal reports application. When ever i display it on XIR2 viewer, there is loss of quality in the image. It happens even when i export the report to pdf. Is there any solution to...

To elaborate this issue more clearly: The image is displayed properly on the Crystal reports application. When ever i display it on XIR2 viewer, there is loss of quality in the image. It happens even when i export the report to pdf. Is there any solution to resolve this issue ? Are there any...

Hello Members, I have an issue with loss of the picture quality of an image when exporting the crystal reports (xIr2) to pdf. Is there any solution to resolve this issue ? Thanks a lot in Advance!!

Hello Members, I have a report viewed using the Crystal Reports Viewer in XIR2. This report displays a image stored in network location. The image is stored as .bmp file when is stored on network location. When the report displays the image on viewer, the viewer is converting that image from...

Hello Members, I have Crystal report that has date range parameters ? Can i default the end date parameter with the current date (which changes every other day automatically)? Is it possible to do this in Crystal Reports ? Thanks in Advance!

Hello Members, I have to build a report using Crystal Reports. The query pulls the data with variblae number of columns. The columns are not fixed and they change based on the criteria. I have tried using corss tab. The problem with teh cross tab is it is not diplaying the title of the fields...

Pulling the data is not a problem. I have to display the data and format based on th xml code. The data is stored in xml format in the column. I have tired html text interpretation but that did not work. For example this is a sample xml code: <?xml version="1.0" standalone="yes" ?> -...

Hello Members, I have to develop a report and show the data that is stored in xml in a column in the physical table.It comes down to creating a dataset out of a query. In Crystal reports, i have developed a report using xml file as dataset and it works great. How can i develop a report if that...

Hello Members, When Crystal reports enterprise is installed, does it install any tables ? If it does where it installs those tables ? Does any one know the names of those tables (if default names are used) ? Thanks in Advance!

I have chosen the same path :). Thanks for looking into the post.

Hilfy- Thanks for the reply. The report is displayed using an application. So we resolved this issue by adding a CSS which defines the rotation of the text. Thanks for taking your time to look into the post.

Hello Members, Is there a way to increase the width of the prompt box to display the values completely in crystal reports ? I have attached a bmp file to show the prompt text box. The url to access the file is http://www.megafileupload.com/en/file/214188/promptbox-bmp.html Thanks a lot in...

Hello Members, I have a repoort that rotates the text field by 90 degrees. The problem when i display the report on the viewer or info view, it displays normally without any rotation.If i export the report to pdf, i see the text field rotarted by 90 degrees. How to fix this problem, so that the...