Search results for query: *

Dear All, it would be really great if somebody could give tip how can i solve the problem with web services. I have Crystal Reports XI and need to create report based on the list from SharePoint site (Windows SharePoint Services 3.0). If i use MS Access DB i can get access to this list as...

Unfortunatelly i can neither use Access nor db link in this case, that's why i was trying to find solution in CR. At the moment it looks like i have to set up special table in Oracle db for it and load data into this table. As far as i understand there is no solution in CR?

Hello All, I have two commands on two different data sources (can't create one query with union inside). I have to merge all data into one data set. Actually data from one data source cover gap in the data from other data source. I need to create one graph with all data. Is it possible...

Thank you, skrandel. The link you gave was the first where I checked. I posted even my question where. But nobody answered until now. I tried GROUPBYCOL=YES, that caused GROUP BY 1 while creating query. And error during running. From what I understood, it works with SAS, but not with DB2.

Hi ALL, it looks like big problem. I have database in DB2 V7 (old one) and I need to count records on the monthly base. The field in the table is date, so I have to perform some calculation to make just only month. But when I create Universe with grouping by this month, it doesn't work because...

Yes, it is True Type. I don't know, should be. When I open rtf file in Word and export it to the pdf, font is correct, I've got what I need.

In the InfoView as well as in 'rtf' and xls format by scheduling everything is correct. But if I export from Infoview to pdf file, I've got again incorrect font. I realy need this font because I have to draw arrows in different directions and in different colors (every direction might be in...

Well, even worse. Actually, problem is in formatting into Adobe pdf file. Do users have any influence on this process? "Use options saved with report " doesn't help.

Hello All, could not find how to solve this problem, help please! I have to use special font in the report because of special symbols. This font is installed on the BO Server and on my local PC. I created report in Crystal Reports and it works as should be. When I run report in Infoview, it...

Hi All! CR XI, BO XI release 2. I have to schedule report in the csv format (to be sent via e-mail). When I try to export this report from CR to csv format I get all data as expected. But then I schedule this report using this format, I've got ether empty report or only header, no data at all...

Super! It works! Many thanks, Ibass! (date comparing is a bit more complex because of some conditions but it is not a problem)

Hello All! It is about CR XI. I have graph with Multi-Axes showing two lines. One of these lines goes to the 0 in the middle of graph. It is normal because graph shows Forecast and Actual data and from current_date there is no actual data, only Forecast. At the moment line for actual data...

Thanks, dgillz, that's what I thought to do but was hopping there is any other way. The report is done for one year until current_date, that means, I have to use week number together with year (for example, 2007 week 23). Additionally, report should be scheduled monthly, I have no idea for how...

Hello All! Please help! Our managers like nice pictures and think that it is most important thing :-) CR XI. I have data for several days, I need to group it weekly and then show in the graph. The problem is - not for every week we have data. In this case I MUST show week number but with 0...

Hi ALL, need your advise. There are BO XI Release 1 and report created in CR XI published in the BO. Report itself is depended of department - for different departments it should be created different reports. We have an xls-file with list of all departments and at the moment it is taken as...

dgillz, under 'Change of' I have fields, one of them is "date" type. In the option for these fields I can choose only 'Order....' or 'Top N'. In the 'Order...' I'm able to select "for each month" (actually selected) or "Use formula as Group Sort Order'. So, when I choose this 'for each month'...

Hello dgillz! Thanks a lot - it works! :-) Honestly I don't understand relation between group and chart in this case - when I created chart, I put as Data -> on change of just this field and in The section will be printed I have chosen for each month . What would be if I don't have any...

Manually changes we have to exclude because report is for scheduling :-) It will run automatically every month. To the formula - it works, but there is one problem - how to order this month? Because if you convert date format to the text it would be ordered alphabetically. And even more - in the...

Thank you, Tatertot45, for answer, but unfortunately that doesn't help. This Tabs "number" appears only if original data format is Number, but I have Date from the beginning. For this format there is no such tabs at all :-(. Sounds stupid, but how it is - special date format can be chosen only...

Forgot to mention. We are using Crystal Report XI