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...

I'm getting it. What I was interested in was having acces to Fields!SomeColumn.value inside that formula. It seems like I can pass some simple types to Code module and write it in VB.net style, but Access to 'Fields' collection object is not available. Therefore this function is completely...

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)

Mure, I would use 'Auto range' feature under Chart Expert - Axes tab. Oleg

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...

The truth is that the chart is not completely configurable. Nevertheless, I solved my problem to the extend that was needed. Here how you do it. (everything is in the designer mode as opposed to preiview) You can click on the vertical bar and move it to the right. After that select vertical...

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...

Just to make clear, I don't display links on the page, report has links from main report to subreports. The reason for linking is that I use further grouping in each subreport. How else would I display multiple subsections in this format. Main Detail/Item1,Item2,Item3,Item4 sub1 group by...

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...

In my case I have 6 subreports(called by parametrized stored procs on each item change in main report). They all are linked to main report by proc parameter. there is no gouping in report(no need for it). I tested main report on push model and subreports on pull model. Very slow. So, I'm...

thanks a lot it did it. I'm also looking into self education. Do you know any good books on Crystal Reports (XI preferebly)? Oleg

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...

On advise/idea of Synapsevampire, I put in ReportFooter: WhilePrintingRecords Global StringVar Names; Split(Names,",")[1] and in ReportDetail: whileprintingrecords Global StringVar Names; if Names <> "" Then Names:= Names + ","; Names:= Names + {get20;1.Name}; Global StringVar Values; if...

Thanks k, here's sample of data columns in DataSet: Name;Value;Type sample rows: name1;value1;com name2;value2;com name3;value3;com name4;value4;com name5;value5;com name6;value6;com name7;value7;com name8;value8;com name9;value9;com name10;value10;com name11;value11;rev name12;value12;rev...