Search results for query: *

Hi friends, Whenever I have created a local cube and have created an excel report from the local cube and after I send this report + the local cube to a client. I find that they often save the report + local cube to a different directory. The problem is that the excel actually stores an...

Hi friends I have a funny situation. I have a period dimension which contains Year, Qtr, Month. I also have another Time dimension which contains Mth1 .. Mth25. The 2nd Time dimension matches that of the 1st Time dimension ie. Mth25 is 2005.April. and Mth24 is 2005.March and so on... However...

Hi guys I have built several cubes. However I would need to create local cubes from the built cubes in Analysis Services. As a result I need to work out the DDL for my existing cubes. However the cube contains many mdx calculated members. I was wondering if it would be easier to simply generate...

Hi guys. I want to create a top 20 product list from a few thousand products. I want the rest of the products to be grouped into 'others'... I also want the products to be ordered by the facts in the cube. Thus the product dimension would dynamically change depending on the Time dimension...

Hi guys. I need to calculate YTD-P which is for the last year ie. 2004/Jan -> 2004/June or in other words x/Jan -> x/June depending on the selected dimension. this is so that I can compare with the current year's YTD The problem is there's no way that I can work out how to do this in mdx...

Hi all I am trying to perform Pervious Year To Date Total (which is like YTD but for the previous year. ie. ytd would work for this year's jan -> whatever month. But I need a total from Last year from jan -> whatever year to do comparision), However I've ran into the following issues. Since...

Hi guys I'm investigating whether if its possible to Dynamically create a cube. Then Process this cube before exporting it to a .cub file. I know that DTS in sqlserver is able to process a cube given at a scheduled time interval. But I'm not sure how I can export a cube to a offline .cub file...

When export to word format crystal report puts the exported report text fields into little text area boxes in msword. This doesn't allow users of the word document to edit the text as the textbox in msword does not grow and adjust to the text. Is there a work around for this ? I use CR 10...

When export to word format crystal report puts the exported report into little text area boxes. This doesn't allow users of the word document to edit freely. Is there a work around for this ? Thanks Tom

Hi guys I am trying get my crystal report 10 .net to load data from a dataset everytime I run it It asks for login information to get into DataSet1 (the name of my dataset). Yet it seems no login/pass that I enter is correct I've tried all login/pass I know and nothing worked.. Does anyone...

Hi everyone I have noticed a rather strange error when I tried to integrate cr9.2 with vs.net2003 on windows 2003 enterprise server. I can not decribe the problem in detail the problem best left as an image so that everyone understand. I received the same error after various attempt at...

hi friends is there way I could implement dynamic image loading based on the user selection before passing into Crystal Report 9 ? Thankyou Tom

hi guys... I have a fundamental problem of the crystal report that I've written not reflecting my changes. ie.. if I was to insert a text field type in the text.. then run it.. I can see it but after I remove this field compile run again I can still SEE it !! its really weird... however after...

Is there a way for me to retrieve the database field text thats generated by cr.net after grouping ? .. so if its grouped ie one .... .... two .... .... ... three .... ... I want to retrieve one two and three in that order is that possible ? thankyou Tom

Hi guys does anyone know where I can find documentation regarding COMs in crystal report ? I would really like to retrieve grouping information from the report at run time... appreciate any help thankyou Tom

how do I insert data into my sql server from my crystal report as it runs ? in this article below it suggests that I use CR to insert data into sql server. but I'm having trouble inserting this query into the expert.. as its not picking up on the return field/...

Anyone know how I can generate a table of content in the header of my crystal report based on the content of that particular report... I have been researching everywhere for over 3 days I couldn't find anyhting useful. I know how to generate a table of content at the footer of my report... but a...

Hi there I am having such a hard time to try to generate a table of content at the begining of a catalogue that I had generated dynamically based on data from the database. Does anyone have any idea how this can be achieved ? much appreciated ! thankyou Tom