Search results for query: *

How do you get ssrs conditional running values that only include items that have Shipped.Value = True =IIF(Fields!Shipped.Value = True, RunningValue(Fields!Order_Amount.Value, Sum, "Group1"), RunningValue(Fields!Order_Amount.Value,0 , "Group1")) Still does not work, as it includes Both True...

When including an SSRS subreport I have found that it interferes with the column formats in the main report in SSRS. How does one get around that. Crystal by comparison does not have this problem

How do you publish a CR9 report using CR9 Enterprise Manager or Reports Publiser and set the Allow Modify Report option so runtime users can modify Select, Sort, etc, before running a report

How can you add the results of two $amount Oracle subquery fields together using their AS subquery column names I get invalid column name errors when I try to reuse and add them together using the subquery results AS column names lower down in the main SQL script, although they display OK...

How can one zero suppress bar chart 0 values in CR 11. I am using a stacked horizontal bar chart with custom green, yellow, and red bars for each value. But some values are 0 and if I dbl click on the data label value field, there is a font change menu dropdown option but no zero suppression...

How to increase size of data labels on CR11 bar charts. I am using a CR11 horizontal stacked %bar chart with data labels on each part of the bar. But the labels are so small you can hardly see them, and I only see a flag to Show Data Labels, under Chart Options / Data Labels.

Will Crystal 9/10 Add Command speed up report record selection, and will it be run on the server. My understanding is: Crystal treats Add Command as if it was running on a View or Stored Procedure. And so this should improve processing time vs selecting from tables in a report selection...

We are running CR10 / CE10 on a DB2 / UDB database on a backend Unix system, from an NT client. Our local CR10 Report Designer environment uses ODBC and the CE10 backend uses DB2 drivers. CR10 Report Designer interprets the DB2 / UDB String fields as TWICE as long as the db says they are...

We have found that we are not able to run CR10 reports containing groups on CE10 Enterprise Manager even though we can run these same reports in the Crystal Report 10 design tool all day. We keep getting an Invalid Group error in Crystal Enterprise 10, when a report containing group(s) is...

How do you pass Crystal 10 parameters to subreports. I would like to pass a Fiscal Period parameter from my main report to a Payable To Date Subreport, so the S/R knows which Fiscal Period to use when it selects records, but Crystal won't let you use a Shared Variable containing a parameter in...

Does any one know where I can find real good tech info on what is involved if I try to upgrade my win2k SP4 system from CR9+CE9 to CR11 + CR11 Rpt Server

I have set up a VB6 MultiLine Text Box with Vertical and Horizontal Scroll Bars. But when I add text lines to it at runtime, and the text lines pass below the bottom of the Text Box, it does not scroll down to show the latest text that is added, but simply stays at the top of the Text Box How...

How do you use the Windows "Open With" drop down list in VB6 when no File Association exists so you can't use ShellExecute as noted below r = ShellExecute(plngHandle, "open", OpenFile1Path$, 0, 0, SW_SHOWNORMAL) This code will give me an error that I can process if a File is not found, but I...

My VB6 executable program does not appear in the Taskbar now, when it is loaded. Previous versions used to do so. I recently added the ability to resize the MSFlexGrid in my VB6 Directory_Checker program which compares files in two directories side by side, and added ShellExecute to allow...

The following ShellExecute code won't open Manually Associated files, but it will open files like PDF, DOC, and XLS that have Installed File Associations. If I manually Associate a text file like SAMPLE.D12 with an editor like TEXTPAD 4.5 (using the Always Open With option), then when I run...

I need some VB6 code for a "msgbox button = Yes to all" as you see when overwriting Read Only files in Windows Explorer. I need a MsgBox that not only has Yes, No, and Cancel, but also has the Yes to All button. If anyone knows of any VB6 code segments that might let me do this, let...

I had to install Win2k Sp3 and SQL7 SP4 in order to prepare for an installation of Crystal Enterprise Manager 9. Now, in SQL 7 SP4 Enterprise Manager, in my SQL Server Group, my BBUSSELL Server Database list disappears each time I reboot my Win2k system. I click on databases and get a blank...

My Logitech trackball mouse does not auto scroll in win 2k on old or new VB 6 Grids, when using LOgitech Mouseware 9.78. I tried creating a new VB6 MSFlexGrid today, and my moouse still does not auto scroll on the new grid in win 2k. But the same VB 6 program in w95 with an older Logitech...

I have encountered a problem where my VB6 MSFLEXGRID auto scrolls to the top row in the grid when one does Mouse Click+Drag on a fixed hdr cell in the first row = 0, and the grid has been previously scrolled down manually so the top visible row is not the actual first row in the grid. The Mouse...