Search results for query: *

We are running BOE 4.2 on a Windows Server 2012 VM. All of the reports (4000+) have been created in Crystal Reports as a stand alone app and then published to BOE. We need a lot more CR licenses for the people who are demanding the ability to create their own reports. BOE 4.2 Launchpad, under...

Does anyone have any Web sites or leads about training courses for Advanced Level SSRS 2008 (R2)? Preferably on DVD or download. I've been working with SSRS for a couple of years and have had to make it jump through hoops to do some of the reports that were requested. Now it's time to find out...

Using SQL Server 2008 R2 Trying to figure out out what date this statement produces with a starting date of mydate=10/1/2010 CONVERT(datetime, CONVERT(char(11), DATEADD(dd, - (DAY(DATEADD(mm, 1, drh1.mydate)) - 1), drh1.mydate), 101)) I've tried to break it down piece by piece and pulling...

SQL Server 2008R2, SSRS 2008R2 I found a page on the MS Technet called Creating a Data-Driven Subscription. This is exactly what we need. Now the problem. It appears that this only works with the Dev and Enterprise editions. We have the Standard edition in production. I'm not sure if we can...

SQL Server 2008, SSRS 2008 R2 I'm creating a report that shows 12 rolling months with rows of: Beginning Bal Receipts Outflows Ending Bal This will be exported to Excel. What they would like to be able to do is, in Excel, click on the Receipts cell and hyperlink to a xls tab in the...

Using SQL Server 2008 SP2, SSRS 2008 SP2 I have a working report with multiple tables, charts, etc. The end result is exactly what it should be....for a single client. We have almost 100 clients and growing, so I need to run this report for each client. I don't want to run one at time, nor is...

Running SSRS 2008 R2, SQL Server 2008 I've created a report with multiple tables and a single value parameter for CoID. There are 4 different queries for the 8 tables on the report, so what I did was add a filter for each table for the CoID parameter. This works great.....however, Now I need...

CR2008 I created a dynamic parameter that has just 275 values in it. When I run the report and prompt the user, CR displays about 200 values and puts the rest in another batch that has to be selected before the values are available. I have Allow Multi Values = True and Allow Discrete Values =...

I have a table with states, countys and zips. Many counties have more than one zip. Some may have a hundred or more. This zip table has about 80k records. I need to create a table that has a state field, a county field and one field that has all the zips for that county separated by commas...

CRXi R2, SQL-Server 05 Is there a limit to the number of rows that a xtab can grow to? Somewhere I saw a limit of 255 columns, but I can't find if there is a limit to the number of rows. Thanks.

CRXi R2, MS-SQL05 (Xtreme.mdb for testing) Sample: Xtreme.mdb using the Customer and Orders tables. What I need to end up with is: The group tree would show All Groups and then each customer. The All Group group would display each customer and their orders. Basicly a summary of all. Clicking...

Hi Using XiR2, SQL-Server2005, XP-SP2 This may have been discussed before, however, nothing showed in my search. If it has, please direct me the appropriate thread. We have a table that has ItemID, Change_Date, Old_Value and New_Value. Old and New Values are attributes that can change from...

Is it possible to export a rpt to Excel and set/change the Excel tab name at the same time?? i.e. Export a rpt called myStats.rpt to Excel and the Excel tab will say myStats. Thanks

I'm on the reporting team for a large corp and they have outsourced a new project that will involve us. The project includes a new front end for the end users, a massive db backend (MS-SQL2005). They also include BOXi-R2 for report distribution/scheduling, etc. We have been told that they...

Is it possible to use vba/macro to examine a merged cell on a sheet and determine how many rows/columns have been merged together? I have a d/l from a MS-SQL db that may have multiple rows for the column headers. The current macro selects the rows (i.e. A1:A4) and merges them. Now I need to do...

Is it possible to have BOXi R2 on one server and Crystal Server Xi on another and use both. The scenario I’m looking at is this: The main office will be using BOXi R2 and Universes for reporting and dashboard needs. Our branch office has Crystal Reports Dev Xi R2 and a copy of Crystal Server...

CR 10, CRXiR2, BOXiR2 .Net I've run into a spacing issue with crosstabs that I haven't encountered before. Report has 3 groups: FNumber, CostType (str), CostPool (str) The xtab is in group 3 header with: Rows: CostType, CostPool, Formula (either blank or CostName) Columns: Formula (Year from...

Crystal Reports Xi R2, BOXi-R2 We are using the single sign-on feature (auto-logon) in a .NET environment. In Infoview we have to use the DHTML or Adv-DHTML to view reports. We cannot use the Java or ActiveX viewers. A CR with a chart, viewed in Infoview, displays the dreaded Red-X for the...

Using CRvXi-R2, BOXi-R2 I’ve been trying to get dynamic cascading prompts to work. The example from BO uses the customer tbl in the Xtreme sample db. They have a dynamic cascading parameter using the country, region and city fields and it works just great. Then I tried this: • Create a rpt...

CR XiR2, BOXiR2 I know that creating a chart from group totals in CR and running it through Infoview allows drill-down. i.e. Double clicking in in the chart will drill-down and display the detail data on a new preview page. The question is: can the double click action run a another report...