Search results for query: *

Q for programmers. After installing SQL Server 2008 with reporting services, Visual Studio 2008 doesn't show any regular project templates. Like types of projects for web site, console application project and so forth. After installing sql 2008, I ran installation of Visual Studio 2008 and...

As I remember from Crystal reports, there is a generic functions area. Where one would be able to create a new function and use it as a data in any field of the report if necessary. Whereas in Business Intiligence studio there are expressions available for existing fields, but no place to put a...

How to set groupping in matrix dynamically, based on parameter? In matrix we have a group row, group column and value. I want for example set row to Sales!Category if parameter1 = 'Category' else set to Sales!Subcat set column to Sales!Year if parameter2 = 'Year' else set to...

I have a predetermined number on values for the chart. Can I have these values put in arrays (or something else besides the input table) and build a chart on it. I'm thinking may be using cross-tab, but still have no clue how. Any help please? Oleg (I'm using Crystal XI)

I'm using Crystal XI. Creating chart challenge. Can't figure how. I have INPUT DATA sample, REPORT looks sample and CHART CHALLENGE requirements. Need help. INPUT DATA columns: code week1 week2 week3 week4 week5 week6 sample rows of data: AA 20 30 23 24 31...

I have a horizontal bars chart. How to make 'axis title' ( on my vertical axis) not to overlap with 'axis labels' (on my vertical axis)? Details: when I modify chart formatting while in preview, those two items are becoming separate. but when I modify chart formatting while in design...

I have a chart in report(Crystal XI) and need to make axis label to be wider. Because currently I have a problem where vertical axis labels and vertical axis title overlap. Plus vertical labels have too little room assign to them. In preview of the report if I format the chart, labels adjust...

I'm looking for a good idea as to how to approach this problem in a best way. I'm using Crystal XI. Please look at following input table and desired output for report. (Copy and paste to notepad for easier reading) Input (my input table): Code DefectCount WeekNumber WeekStartDate AA 20 5...

Does anybody know perfomance wise if linking main report to subreports on integer improve compare to string? if it would, by how much? I'm running Crystal XI and on the web page. Linking is at detail level. On the page I first collect all data in datasets and then Set data source for each...

I have two list of values(two variables) each in it's own single string: "Lane,Drop Distance,Empty Count,Allowed Threshhold,Applied Count" "1,4.07,49,73,122" I need them to be output in this format(two columns): Lane 1 Drop Distance 4.07 Empty Count 49...

I wonder how Crystal calls subreports and if it’s multithreaded(or makes DB calls simultaneously). I’m using Crystal XI. There is a main report with 6 subreports in it. My concern is the speed of processing(how slow it is). Each subreport would be pulled by Crystal by its own stored procedure...

I wonder how Crystal calls subreports and if it’s multithreaded(or makes DB calls simultaneously). I’m using Crystal XI. There is a main report with 6 subreports in it. My concern is the speed of processing. Each subreport would be pulled by Crystal by its own stored procedure based on a...

I have 20(always the same number) records coming all together in the report. Can I collect all strings in my 3 columns and output them in the report footer or group footer all together? The reason for that is that they need to be in a certain format. I could've used a Sum function, but it...

I have 20 records coming all together in the report. Can I collect all strings in my 3 columns and output them in the report footer or group footer all together? The reason for that is that they need to be in a certain order and format. I would use a Sum but it doesn't take strings. Thanks, Oleg

I have a Detail section Flow direction set to: 'Across Then Down'. And there are strings of data coming. One per row from the datasource. If I had detail section width set dynamically to approcimate size of my string, then the output would look nicely( no big spaces and no cut offs) for example...

I have a report that has subreports. I'm trying to use a push method for main report. For subreports I want to be pulled. My code either gives me connection error or there would be no data in subreports. Any way I put it the output is incorrect. How do I code it correct way? The samples...

I have a report that has subreports. I'm trying to use a push method for main report. For subreports I want to be pulled. My code either gives me connection error or there would be no data in subreports. Any way I put it the output is incorrect. How do I code it correct way? The samples...

Here's a problem. There is a report with multiple subreports. It works fine with Crystal 11 when in designer. It works on my computer when I run it on web page (IIS is on my machine also). No (linking) parameters are asked for. When I installed it to another computer (also windows XP) it started...

As you know when displaying a report with some number of subreports in it you can click on the subreport and that will display that particular subreport snippet by itself on a page. I don't want it to be clickable for the reason that it takes time to reload and there could be an accidental...

Hi, I'm using Crystal 11. 1.How do I start a new page when new group starts? 2.How do I repeat header on each page? Thanks, Oleg