Search results for query: *

Business Objects KB has an article on this. It shows a piece of code for VB for RDC that allows you to change the group sort direction before the report is viewed. So I added a Select Case statement in VB. Depending on the value of the GroupBy it will set the sort direction. And it works.

Thanks for the tip. Sorry for the late reply as I got busy on something else. I did your trick and it worked but one problem. The old numeric group was set to Descending. While the old string group was set to Ascending. I put it together in one group, it works just find and the group tree...

I do this all the time for customer reports I manage. Here is how if I understood you correctly. Otherwise it will benefit someone. In Group1, select to group by customer ID (If you hold the mouse on the Group Header1, the tooltip says "Group Header #1: CustomerID" Put the Customer Name field...

I write/maintain over 70 reports using VB6 to manage the reports. We want to turn on the GroupTree for Preview as clients are getting tired of wadding thru the preview to find the data they want prior to printing a few of hundred of pages. So I started working on the Change Group Options by...

LB, Maybe it works in version 11 but not in 10. What it does now is print the report as it first appeared. So if you run the report, the preview window appears with one tab. (That is what it prints) If you drilldown, another tab appears and that tab become the current tab for viewing. If you...

I did a search and found nothing. I am using CR10 and VB6. We have a report that does drilldown. It just does fine and nothing wrong. But the pages can get as large as 200+. Client doesn't want to print all of it. The way the report is generated, we can't quite narrow it down. So if the report...

Alright, Problem solved. I will post what I did here. Darn that consultant we hired as he doesn't really know anything. He has that ASC function in a number of reports. So I will have to clean them up. Don't bother using the ASC function if you have different data types in a formula. Instead...

Alright. Two things I did. I created my own test data. 6 records, two of each records of same location so I have 3 different locations. In the two records that have the same location, each one has a different category. Part Type Location Category 850 AA-A-0-01 U 850...

OKay, after spending so much time on this. I have learned a few things but I still can't resolve it. I know what it is doing conflicts with another thing, which I don't know. What I saw was that the Location data field is on the Detail line while the Inventory Number in most cases is unique...

I have tried a variety of different methods. I even am trying to recreate it here with our testing system and I am not getting it to work as it is. I really want to know what the sum is for that formula. I put the formula on the group header. The output is like 4.178e+17. I did the math with...

I forgot one thing that you might notice. The last part of both ASC calculations shows *-1 is for the value to be negative as the sort direction is descending for the numeric values to show largest to smallest. By having a negative value, it will shows A-Z instead of Z-A.

This is a toughy and I have already spend a full day on this. I am not sure what I can do. It works as far as I know but there is a little thing that I am not seeing. I hope you can help. Here is the specs. The report has 5 groups. All but one is grouped by a recordfield. The only one is a...

Just what I also need. I did find a small problem but it was resolved quickly and it works great. The small problem was that we use detail shading on alternate details. Now with that new group header, it created two detail lines that are not shaded. I copied the code for shading in Color tab...

Using CR10, we have several printers that change the output size. Sometimes an edge will get cut off by 1/8 or 1/4 when printed on one printer. But it is fine on another printer. I can even see the changes in CR when working on a report after changing the printer. So with a report open, click...

Thanks. That works better. I was using 'NumberOfRecordPrinted' instead.

I do. But it is only what the stored procedure returns. The issue is after you filter the records to meet the criteria the user selected in CR. I have two solutions, one is to use RDO cuz I don't need the fancy ADO stuff such as MoveFirst, MoveNext, etc. The other is to pass all user...

Darn it. In the link I provided that is updated for CR9, there is a note on the bottom that it doesn't work with ADO recordset. We use stored procedure on the MS SQL Server. It returns a recordset. While I am not an expert on SQL server, I know the recordset that gets passed back to VB is in...

Thank you for the thread to point to. I read it and like that guy, I dug into it further. There is an updated one. http://support.businessobjects.com/library/kbase/articles/c2013862.asp Apparently, ReadRecords is the key. That lead me to something else if I could improve my code a little...

No SQL used. It is an ADO recordset that I get from calling a query. I set the report (rptTable) SetPrivateData property with that recordset in VB. Any other ideas? It has to be done in CR. I am using v10.

I want to say that there is no grouping in my report and there are 11 columns. The user can sort by any one of the 11 columns. The 11th column is the percentage column. That 11th column is a percentage of all sales. So say you have 10 stores. The formula for the 11th column takes the total...