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...
Thank you, Thank you
I came up with the same thing and couldn't believe it.
Why was it written this way just to get the first of the month when all the dates in this field are by definition and default the first of some bloody month??????
Oh well! Whenever someone leaves a contract and some...
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...
Is there a way to change the order of the reports listed in the Solution Explorer window? When adding reports to a project, the rpt names appear in the order that they're added.
We would like to see them in alpha order.
Thanks,
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...
Thanks for the quick reply.
The List(Tablix) appears to work, but gives an error like:
>>Table2’ has a detail member with inner members. Detail members can only contain static inner members.
Doing the same thing in a Table (also a Tablix) and deleting the detail row and using just the header...
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...
Check out the HasValue() function in CR2008.
It allows for a blank value in a parameter.
It's new in 2008 and will cause errors if the report is created in 2008 and run in Xi.
I've played around with this as well. I have only 275 values in the pick list and in v2008 the prompt will display 250 in batch 1 and the remainder in batch 2. We get this behavior even after making the registry entry 2000.
It looks like something we're going to have to live with.
I opened it notepad and it’s a list of 1000 values and resaved with the same result. This batching thing is something in Crystal Reports 2008 and I can't find any reference to it anywhere, so far.
No there is just one parameter.
Here's what I just tried.
In Excel, create a list of 1000 numbers. Save as book1.txt, a plain text file.
Open CR2008,
Create a blank report with no database.
Create a new parameter called My Parameter.
Import book1.txt.
Drop MyParameter into the Detail...
I've tried that. The default is supposed to be 1000. My list only has 275 values and should not be affected. Even after making the registry change, the prompt still show 2 batchs of values, one with approx 200 values and the other 75 values in the second batch.
As a follow up. There are exact...
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 =...
Transferring multiple tables/queries from Access to a single Excel workbook is something we do all the time. Here is a sample of the code to transfer 4 tables from Access to a single xls book called 'FileName'.
Dim SheetName1 As String
Dim SheetName2 As String
Dim SheetName3 As String
Dim...
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...
I believe the limit is 1000.
There is a registry hack that will let you change that limit, but I can't think of it off the top of my head.
Try a search on Crystal Reports pick list limit
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.