Create an automatic SUM ROW

Hello.
In a previous program i used to create reports, I had the option to enter a "SUM ROW".

I saw that in RS2005 I can check the "add total" when using the report wizard and it will create for me a row with SUM for my column.

Is there a way to create a row like this automatically with out the wizard (a sum row for all my columns instead of creating a textbox with "sum" for each column)?

Thanks in advance,
Roy.

Hi,

nom this behaviour is influenced by the normal summing / grouping operations. A sum in a row has nothing to do with this. I don′t think that the standard behaviour of the wizrad cab be changed in Reporting Services.

HTH, Jens SUessmeyer.

http://www.sqlserver2005.de

|||Hi Jens, Thanks for the replay.

I don't want the "standard behaviour" of the wizard to change.
I'll like the "SUM" je is makeing in the entire row.
what i whanted to know is:
if i'm making my own report, not with the wizard, is there a simple way to create a sum row like the wizard with out creating a textbox for every column manually?

Thanks in advance,
Roy.
|||

After making the report with the wizard you can simply use the Expression =SUM(Fields!SomeValueinQuery1.Value + Fields!SomeValueinQuery2.Value + Fields!SomeValueinQuery3.Value +Fields!SomeValueinQuery4.Value) OR use the appropiate ReportItems!Textbox1.Value, but there is no function like in Excel which automatically tries to gues what you want to summarize (even this function in Excel sometime guesses wrong what you want to achieve :-) )

HTH, Jens SUessmeyer.

http://www.sqlserver2005.de

create a global data source

Hi guys,

I have a number of reports deployed on the report server. I want to point all these reports to another data source. Currently, what I am doing is go to the individual report on the report server and change the data source property to point to the new data source. It is very tedious to do the same thing for all of the reports.

So, Is there any way to point all the reports under a project at one time.

Any idea is appreciated.

Thx!

I would use global replace. That's the only way that I know of.

|||

would u explain that a lil bit

thx

|||

At the top menu, click Edit -> quick replace.

In the find box, enter the old dataset name.

In the replace box, enter the new dataset name.

You may want to do a find next and replace on a case by case basis instead of replace all, because I'm not exactly sure how your project is set up.

|||This is exactly how we have our reports configured.

1. In your business intelligence projects, create a new "shared" data source that points to the database your are pulling your data from. If you are using more than once database, create a single shared data source for each database. Each data source will have a name. For this example, lets assume you created a datasource called "DS_TEST" that points to a database called "MY_DATA"

2. When you build your reports, always use the shared datasources that you created from step 1.

3. When you deploy the reports, they will still be looking for the datasources by name. From step 1, the reports are all looking for a datasource called "DS_TEST". If you developed the reports on the same machine that hosts reporting services, everything should work (although my environment is not set up this way so I have not tested this). If you developed the reports on one machine and deployed to another, you must create the datasource on the deployment machine. To do this, navigate to the reporting services home page where the reports are deployed and click the "Add New Datasource" link (if you do not see this link, then you do not have the correct permissions). Point the datasource to the database you want the reports to pull from, but make sure and name it "DS_TEST" or whatever name you choose in step 1. The reports will now use the datasource called DS_TEST on the server the report is deployed on..

By having the global data source, it makes it easy during development to point the reports to test data so we do not effect the performance of the live system, and later when the reports are deployed to the live system they naturally point to the correct data.

crashing excel when printing exported RS report

We are having a problem with some reports that get exported to excel and then
trying to print. we don't get this with all reports just some.
Here is what happens:
The report generates fine in RS. We then export to excel. We tell excel to
print and then get a 'Memory can't be read' error and excel crashes.
Whenever we want to just print a report as is, we export to PDF and print
that way. But many times the report is used in excel for further analisys
with other data. I have tried printing without touching the report in excel
and still get the error. So I know it is not something we added.
Because we are only getting this error with some reports and not all, I am
guessing that there must be something that was(n't) added to the report in RS
that would cause this.
Did I make enough sense to explain my issue?We are having the same problem with a couple of reports that were recently
modified. The modifications included adding a couple of additonal parameters
and then displaying the parameter values in the report footer. We already had
the report parameters displaying in the footer with no problems.
Our users are running Office 97 on WIndows NT worksatations. Our
deveoplment environment is running Windows XP with Office 2003 and the report
printing problem cannot be reproduced in the development environment.
Anyone had any luck with fixing this problem?
Ray
"David" wrote:
> We are having a problem with some reports that get exported to excel and then
> trying to print. we don't get this with all reports just some.
> Here is what happens:
> The report generates fine in RS. We then export to excel. We tell excel to
> print and then get a 'Memory can't be read' error and excel crashes.
> Whenever we want to just print a report as is, we export to PDF and print
> that way. But many times the report is used in excel for further analisys
> with other data. I have tried printing without touching the report in excel
> and still get the error. So I know it is not something we added.
> Because we are only getting this error with some reports and not all, I am
> guessing that there must be something that was(n't) added to the report in RS
> that would cause this.
> Did I make enough sense to explain my issue?
>
>|||We have finally solved this issue.
Our poblem was solved by reducing the amount of information in the report
footer. We display the users input parameter values in the footer to allow
them to print the parameters used when rendering the report. In our case we
had increased the number of parameters in the report and hence displayed in
the footer from 6 to 8. This caused Excel to crash when attempting to print
the export file. We have since reduced the parameters in the footer to 6
again and now the report prints in Excel.
Hope this may help you in finding the soucre of you printing problems.
"David" wrote:
> We are having a problem with some reports that get exported to excel and then
> trying to print. we don't get this with all reports just some.
> Here is what happens:
> The report generates fine in RS. We then export to excel. We tell excel to
> print and then get a 'Memory can't be read' error and excel crashes.
> Whenever we want to just print a report as is, we export to PDF and print
> that way. But many times the report is used in excel for further analisys
> with other data. I have tried printing without touching the report in excel
> and still get the error. So I know it is not something we added.
> Because we are only getting this error with some reports and not all, I am
> guessing that there must be something that was(n't) added to the report in RS
> that would cause this.
> Did I make enough sense to explain my issue?
>
>

cr90devwin_en.exe error

Hello,

In our organization we are using a mat work a client registration software.
To generate reports there we are using the Crystal reports.
De client registration application running on 4 Citrix servers.
Last month after an abdate of the application there were problems with the reporting system.
The advice of the application liverancier was the installation of the (cr90devwin_en.exe). I have installed the exe on 3 servers without problems and the problem is resolved.
When I run the exe on the fourth server he begins with the stopping of the www, smtp and IIS manager services, and then I am getting the error message (can not create backup folder). check the attachment

Maybe you know how can i solve this problem.

Thanx in advanceSee if you find answer here

http://support.businessobjects.com/

CR9 Runtime Components ?

Dear All,
I developed an application in VC++ 6.0 with Crystal Reports 9.0.

Now i want to deploy my application on client machine but i don't now what components (files, dll) of CR are required to register or deploy with my application.

Would some body please help me, its really very urgent.Hi! All!

I'm aslo having the same problem in CR9 Runtime Components in Client machine.

I'm using VB 6 & Crystal Reports 9.

What are all the CR9 componenets or dll files need to be installed in Client machine?

Please if anyone help me to solve this problem.

Thanks.

-Raja|||Visit the next urls -->

http://support.businessobjects.com/communityCS/TechnicalPapers/rdc9_deployment.pdf.asp

http://support.businessobjects.com/documentation/installation_resources/crystal_reports/cr9.asp

CR XI Report printing in Landscape instead of Portrait

CR XI Report printing in Landscape instead of Portrait

Even though we specify the orientation of report in Crystal reports XI as Portrait during design time from report designer (i.e. File -> Page Setup), while printing it uses the default printer options i.e. orientation set to Landscape and prints the report in Landscape.

But the same report in Crystal report 7.0, when set to Portrait at design time from report designer, it print as set in the report designer i.e. Portrait and does not take default printer settings.

In Crystal Reports 7.0 have File -> Page Set up and File -> Printer set up options, using which the report orientation can be set, where as in Crystal Report XI has File -> set up options only.

Why is this wierd behaviour using CR XI ? Any idea.

We are using VB 6.0, Could the printer settings be supplied from VB 6.0 programmatically.

I would appreciate if anybody could help in this regard.

Thanks,try this found in crystal report samples.

Thanks

CR XI and VB6 prints some blank rows

I've been trying to move some more complex reports from VB DataReports to CR.

I have a CR report that is linked at runtime to a ADO recordset. Although the recordset has some NULL data, entire rows of information will come up blank. If I put in a null substitution in the fields, the substitution shows up. The correct number or rows are printed in the report, just some are blank.

Here some basic facts:
1. If I link to a VB6 DataReport, all data is displayed.
2. I setup a form with a listView to print out the exact recordset that I'm linking and all the data is present.
3. If I just run the query in SQL Enterprise Manager, it returns the correct data.
4. It's not random, it is always the same records (not matter how their selected) that show up blank.

Is there something that would tell CR to ignore a whole line if some or any of the values are null?Sorry...this appears to be a ADO issue...my mistake.

CR doesnt show what i want

Hi all! I'm a student from Belgium and I need to make several reports in CR, but I'm having some difficulties.. I hope I can get some help here..

I need to make a reports that shows student's grades, from a class and a period (there are 3 periods):
I have 2 tables, the first one (LLADMIN) has the name, class, etc (general fixed data) of the student, the second table (KLEUTER) holds the grades, period, (data that has been inputted)etc..

The reports should look something like this:

Class: LLADMIN.class Period: KLEUTER.period

Name Grade1 Grade2 Grade3
LLAdmin.name KLEUTER.grade1 KLEUTER.grade2 ...
... ... ...

The 2 tables are linked to eachother (visual linking expert) by a unique students-number, with a Right Outer Join from KLEUTER to LLADMIN

I need to show all the students of 1 class, and the according grades, from 1 period.
So i need to put a Select Expert on LLADMIN.class and KLEUTER.period

The Select Experts on LLADMIN.class works perfect, and the report show all the student names and the grades, but also the grades from period 2 and 3
(reports show something like this now:
Name1 |nogrades|
Name2 |nogrades|
Name3 |grade1_period1| |grade2_period1| ...
Name3 |grade1_period2| |grade2_period2| ...
Name3 |grade1_period3| |grade2_period3| ...
Name4 |grade1_period1| |grade2_period1| ...
Name4 |grade1_period2| |grade2_period2| ...
Name5 |nogrades|
...
)

So I put a Select Expert on KLEUTER.period (=1): but then the reports only shows the names of the students who have a grade for that period (where there is a dbase-entry) (not all students have grades for that period)
The reports should still show the names, even if there are no grades present in the dbase.
(reports show something like this now:
Name3 |grade1_period1| |grade2_period1| ...
Name4 |grade1_period1| |grade2_period1| ...
)

I have like 20 students in a class, and as a test i have only given 2 students grades. When I put an Select Expert on KLEUTER.period the reports only shows the names of those 2 students, and their grades. This should not happen! It should show all the names!

I hope you understand my problem! If not, I will give more explantion..

thanks in advance and sry for my not-so-good-english :)The problem is that you should use an outer join to your condition as well KLEUTER.period (=1). This can be best accomplished by using the add command property in the database expert and write manually your database query

select t.field1, r.field1, t.field2, r.field2
from tab1 t, tab2 r
where tab1.field3 = tab2.field3 (+)
and tab2.field4 (+) = 1

This works fine using CR version 10, if you are using an older version (8.5) you can type the 'and tab2.field4 (+) = 'A'' part of the condition to the SQL-query (DATABASE, EDIT SQL-query).

- Jukka

CR 8.5 - (almost) blank first page

Hi,

Having a problem with crystal reports 8.5 (from within VB6). searched and searched, to no avail, so now I post... :)

i have a report with the following layout:
-Report header
-Page header
-Group header 1
-detail
-group footer 1
-page footer
-report footer

Problem is, if group 1 will not fit on the first page of the report, then the first page will print with only the report header and report footer on it - nothing else.

I've tried unchecking all the "Keep together" options on the sections but it doesn't change a thing. any advice people? i found an article talking about this problem and how V10 fixes it, but surely there is a workaround (or at least something). Frankly, I don't care if it puts half a section on a page if it will fit complete on the next - i just don't want this silly blank first page printing.Have you remembered checking off the Keep Group together option in both the Change Group Options and Format Section Menues? Doing this for all groups has worked for me this far.

- Jukka|||Great stuff - it works. Thanks heaps for actually finding this post and replying to it. I'd given up!

CR 10 creating charts

I am using Visual Studio 2005 VB.NET and Crystal Reports 10. I need to create a line graph on a crystal report by sending it a dataset from the vb.net page. I am new to this. Does anyone have any example code or know of any websites that demonstrate how to do this?Please see here (http://www.dev-archive.com/forum/showthread.php?t=409951)

CPU Usage pegged at 100%

Last night we had reports that our website was not responding. After some
investigation we found that the issue was SQL Server had all of the CPU's
pegged at 100% on a server that usually runs no higher than 10%. Our site
was not exceptionally busy, nor have we installed anything new that accesses
the database recently. In the sQL Server Error Log I see alot of "buffer
latch errors", but they appear to have occurred after CPU usage had already
hit 100%.
No one here is really a SQL Server troubleshooting or tuning expert. What
should we do to try to determine the cause?
Thank youEvan,
This can be difficult to track down because you really do not have any idea
what was occuring at the time. You might consider creating an automated
proactive solution to tracking these kinds of issues by using Profiler,
jobs, alerts (performance condition alerts included), SysMon, MOM 2005
and/or a related third-party product.
HTH
Jerry
"Evan Nelson" <EvanNelson@.discussions.microsoft.com> wrote in message
news:CB0D7602-453D-4D35-A09C-9672D7B47E29@.microsoft.com...
> Last night we had reports that our website was not responding. After some
> investigation we found that the issue was SQL Server had all of the CPU's
> pegged at 100% on a server that usually runs no higher than 10%. Our site
> was not exceptionally busy, nor have we installed anything new that
> accesses
> the database recently. In the sQL Server Error Log I see alot of "buffer
> latch errors", but they appear to have occurred after CPU usage had
> already
> hit 100%.
> No one here is really a SQL Server troubleshooting or tuning expert. What
> should we do to try to determine the cause?
> Thank you
>|||Try this product eval:
http://www.teratrax.com/tpm/index.html

CPU Usage pegged at 100%

Last night we had reports that our website was not responding. After some
investigation we found that the issue was SQL Server had all of the CPU's
pegged at 100% on a server that usually runs no higher than 10%. Our site
was not exceptionally busy, nor have we installed anything new that accesses
the database recently. In the sQL Server Error Log I see alot of "buffer
latch errors", but they appear to have occurred after CPU usage had already
hit 100%.
No one here is really a SQL Server troubleshooting or tuning expert. What
should we do to try to determine the cause?
Thank you
Evan,
This can be difficult to track down because you really do not have any idea
what was occuring at the time. You might consider creating an automated
proactive solution to tracking these kinds of issues by using Profiler,
jobs, alerts (performance condition alerts included), SysMon, MOM 2005
and/or a related third-party product.
HTH
Jerry
"Evan Nelson" <EvanNelson@.discussions.microsoft.com> wrote in message
news:CB0D7602-453D-4D35-A09C-9672D7B47E29@.microsoft.com...
> Last night we had reports that our website was not responding. After some
> investigation we found that the issue was SQL Server had all of the CPU's
> pegged at 100% on a server that usually runs no higher than 10%. Our site
> was not exceptionally busy, nor have we installed anything new that
> accesses
> the database recently. In the sQL Server Error Log I see alot of "buffer
> latch errors", but they appear to have occurred after CPU usage had
> already
> hit 100%.
> No one here is really a SQL Server troubleshooting or tuning expert. What
> should we do to try to determine the cause?
> Thank you
>
|||Try this product eval:
http://www.teratrax.com/tpm/index.html

CPU Usage pegged at 100%

Last night we had reports that our website was not responding. After some
investigation we found that the issue was SQL Server had all of the CPU's
pegged at 100% on a server that usually runs no higher than 10%. Our site
was not exceptionally busy, nor have we installed anything new that accesses
the database recently. In the sQL Server Error Log I see alot of "buffer
latch errors", but they appear to have occurred after CPU usage had already
hit 100%.
No one here is really a SQL Server troubleshooting or tuning expert. What
should we do to try to determine the cause?
Thank youEvan,
This can be difficult to track down because you really do not have any idea
what was occuring at the time. You might consider creating an automated
proactive solution to tracking these kinds of issues by using Profiler,
jobs, alerts (performance condition alerts included), SysMon, MOM 2005
and/or a related third-party product.
HTH
Jerry
"Evan Nelson" <EvanNelson@.discussions.microsoft.com> wrote in message
news:CB0D7602-453D-4D35-A09C-9672D7B47E29@.microsoft.com...
> Last night we had reports that our website was not responding. After some
> investigation we found that the issue was SQL Server had all of the CPU's
> pegged at 100% on a server that usually runs no higher than 10%. Our site
> was not exceptionally busy, nor have we installed anything new that
> accesses
> the database recently. In the sQL Server Error Log I see alot of "buffer
> latch errors", but they appear to have occurred after CPU usage had
> already
> hit 100%.
> No one here is really a SQL Server troubleshooting or tuning expert. What
> should we do to try to determine the cause?
> Thank you
>|||Try this product eval:
http://www.teratrax.com/tpm/index.html

cpu quota / resource management

Hello *,

Is there a way to restrict resource consumption by user or connection?

If I execute some long running reports my complete server slowes down. I'd like to assign this reports only limited resources.

Thanks,

Michael

You can configure database mirroring for the target database in your production SQL instance and create snapshot on the mirror server (your backup SQL instnace) on different machine. The principle system can be considered as your normal OLTP business system and the mirror server can be used to support your reporting system. Since the reporting system will be run on differet SQL Server instance on different machine, it will not hurt your normal business onthe principle server. HTH|||Really your easy options are limited to setting query govenor which is time based not resource based.|||Thanks for the hint, "SET QUERY_GOVERNOR_COST_LIMIT" is useful in this context. Additional question:-
Is there a way to cancel running querries? For instance by issuing a "cancel" call from a seperate thread?

Thanks,
Michael

Couple of Questions about RS2005

My client was using Reporting Services 2000, but is currently leaning toward
Crystal Reports XI. The reason being is that most of their data is filtered
through DLLs providing business logic. In RS2000, the only way to use the
DLLs as a data source was to write an extension and essentially hard code
the calls to methods and parameters inside the extenstion. Their complaint
was that every time they had to add something they had to recompile the
extension, send it to the server admins, wait for installation and so on.
With CRXI, all they had to do was point to the DLL as a data source and they
were prompted for the method to use as well as paramters and so on. Is
something like what CRXI (and CRX for that matter) provides in RS2005? Can
they use a DLL for a Datasource without writing a wrapper every time?
On a second question, another client of mine is using SQL RS2000 with
Oracle providing the data for the reports and VS 2003 as the application.
We are late in the developement of the application but are considering
upgrading to RS 2005. I have been unable to give them several reasons why
upgrading to RS 2005 would benefit them, since i can only see a few
drawbacks. One drawback is that they would have to use a seperate IDE to
create the reports (the VS2005 like IDE). One thing they liked was the
ability to run ad-hoc reports and use an embedded viewer instead of a web
browser (we currently have IE embedded in the app to display reports). I am
under the impression that the Report Viewer component will only work with
VS2005 (.NET 2.0). Is this correct? Is there any way to use the component
with VS 2003 and .NET 1.1? We can't upgrade the app to 2005 anytime real
soon. Also, a list of benefits to RS 2005 would be greatly appreciated.
Thanks,
Rob Edwards
For the first question, I don't see why you need to hard code the method calls. for the query language for their data extension, they can use a syntax like:

class.method (parameter1, parameter2)

They can parse the call, load their assembly, use reflection to grab the class definition and execute the method (look at Type.GetMethod) using the parameters. The extension never needs to change, just the business object.

For the second question, the ReportViewer controls don't work with VS 2003. You can, however, use VS 2003 to publish to RS 2005. You won't get any of the new report design features (multi-value parameters, end user sort, etc.) until you move to VS 2005.

Counting fields with data

I call a Crystal Reports 8 report from VB6. In the report there is eight fields as part of each record. Some of those eight fields will contain data and some won't. Random order.

How can I keep count of how many fields has data in them for each record. I need to display a count at the end of the record i.e. 3/8 or 0/8 etc.

I think the idea would be to create a counter that can be initialised to 0 for each record and as each field is displayed it must increment the counter but only if there is data displayed in the field so if 3 fields (any 3 of the 8 fields) contain data the counter will be 3 for that particular record and the counter can then be displayed.

Can this be accomplished and how?

Bezziewrite a formula like

numbervar a;
a:=0;
if not isnull(databasefield1) then
a:=a+1;
if not isnull(databasefield2) then
a:=a+1;
a;|||Thanks sraheem.|||Another way is to create a Running Total for each field and add them together at the end of the report.