Data regions are not allowed inside a table detail ..

Developing using Visual Studio .Net (2003).
I have a simple table on my report showing data from a dataset. Works
fine. Displays a bunch of records.
One of the values from my dataset is a percentage value (integer from 0
to 100). I'm attempting to illustrate this using a chart. So I'm
attempting to put a chart in the table detail row. It doesn't like me
doing this, though. I get a build error:
"The chart 'chartx' is contained inside a table detail row. Data
regions are not allowed inside a table detail...".
Is there a way to do what I'm attempting with Visual Studio .Net (i.e.
SQL Server 2000 Reporting Services)? I know it can be done with Visual
Studio 2005, as that just makes you define a group expression when
attempting to "use a data region in a list".
Any help/info would be great.
Thanks.Have you tried putting it inside a matrix?
I tried putting a chart inside a table detail row, but vs didn't let me
do it "Cannot place a chart at this location in a table"
However, putting it inside a matrix works just fine.
eamon wrote:
> Developing using Visual Studio .Net (2003).
> I have a simple table on my report showing data from a dataset. Works
> fine. Displays a bunch of records.
> One of the values from my dataset is a percentage value (integer from 0
> to 100). I'm attempting to illustrate this using a chart. So I'm
> attempting to put a chart in the table detail row. It doesn't like me
> doing this, though. I get a build error:
> "The chart 'chartx' is contained inside a table detail row. Data
> regions are not allowed inside a table detail...".
> Is there a way to do what I'm attempting with Visual Studio .Net (i.e.
> SQL Server 2000 Reporting Services)? I know it can be done with Visual
> Studio 2005, as that just makes you define a group expression when
> attempting to "use a data region in a list".
> Any help/info would be great.
> Thanks.sql

Data outside parameter field

Can any body help me that how to get data (opening balance) of an account in report wich showing data in between specific dates. The opening balance will be the values before the parameter fields.Use Sub report to show the Opening Balance. So create a sub report without using parameters, just show the opening balance and dont link the sub report and main report.

In the sub report created a formula, "sub_op"

WhilePrintingRecords;
Shared x As Number
x = Opening Balance

and in the main report create a formula, "main_op"

WhilePrintingRecords;
Shared x as number

Use this formula in the main report to show Opening Balance. Important thing is place the subreport in the header before using the main_op formula, so that subreports gets executed first and will show the Opening Balance value in the main report.|||But if I want to get opening balance for a specific date then I have to pass a parameter for that.

So, if the I could not insert the subreport at header then what could be the solution.

Thankyou|||First I agree with khs_shankar that a subreport for the OpeningBalance is the way to go.

If you want to select date(s) for OpeningBalance independent from the the main report parameter field, then create parameter field(s) in both main & subreport, say Op_date1 (& Op-date2?). In your subreport, use these dates as a filter. Link the main & subreport by these Op_ parameter fields so you can pass the values.

If the Opening Balance are for the dates prior to your main parameter field, like a cut off date to show previous balance & details afterwards, then you can create a parameter field in your subreport, say Op-date. Link the parameter field in the main report with the Op-date field in the subreport. Use this Op_date field as a filter in the subreport.

Hope this help.|||I want to alter my question here.

The Opening balance must be of the current month and les then by the date which is selected by user.

Because I have tried "thg's" logic but when I want to link parameter main report with the Op_date of sub report, it does not show the op_date field in link combo.

Help in this regard.

Data not showing in ReportViewer but will display when exported

Hi again,

I'm having a funky problem with the ReportViewer control. When I load the report page, the ReportViewer will come up with my blank rdlc file with no data being displayed. However, when I choose to export the data, it will show in the excel or pdf. It was working fine on a test server, and all of a sudden this happened.

I am having the same issue. It was working fine using Atlas. I switched my project to Ajax, and now it's broke. My ReportViewer is inside an UpdatePanel. I removed the updatepanel tags, and I now get an Error "Execution '' cannot be found".

Data not showing for some users

Hi there,

Some users, when they select a table and try to "Return all rows" in Enterprise Manager, they get the word Binary instead of the data that should be there. The table has 4 columns, an ID column and three data columns. The ID field data is correct but the data in the other columns just show the word 'Binary'.

I got the user to connect to the database using the 'sa' login and the problem is still there. I can connect from my machine and see the data fine. Only one user is experiencing these problems.

The problem occurs with all the tables in the database. Any field that should have text data, e.g. nchar, nvarchar, etc., is showing 'Binary'. Fields that have numeric or date types show fine.

If the users runs a select query from Query Analyser, then the data appears fine.

Any help??This problem seems to have occured since i tried to install a SQLBase odbc driver. The data in the database is fine but Enterprise Manager seems to be corrupted.

Any help??

Data not showing

Hi,
I am new to crystal reporting. I created a report using 2 tables. when i go to preview tab data is not showing up. and in the preview tab on the left hand side there is no drilldown button(+ sign) next to my report name. Please help me. Thanks in advanceHi, Did you make proper joins between two tables?

Madhivanan|||Thank you you are right

Data in Table not showing

I am just starting with Report Services, so this may be an easy or dumb
problem but here goes:
I am working in Visual Studio with a simple report based on a sproc with
several parameters that returns a result set. In the report I have set up a
table and the dataset for it, as well as the parameters. Everything works
great until I test the report, the report renders but the table shows as
having no data. I can go to the data tab and run the sproc and enter the
same parameters and I get data back.
I have checked all the places I could think of that might hide the data, but
nothing.
I'm hoping someone else has been through this or has some ideas on where I
could look.
TIA,
NancyHave you added a filter somewhere? Edit the dataset on the Data tab, click
the Filters tab and see. Also go to Properties of your table and check the
Filters tab. If your sproc returns data, the data should appear in the
report. I have a sproc in one of my reports and ti works just fine.
Charles Kangai, MCT, MCDBA
"Nancy Lytle" wrote:
> I am just starting with Report Services, so this may be an easy or dumb
> problem but here goes:
> I am working in Visual Studio with a simple report based on a sproc with
> several parameters that returns a result set. In the report I have set up a
> table and the dataset for it, as well as the parameters. Everything works
> great until I test the report, the report renders but the table shows as
> having no data. I can go to the data tab and run the sproc and enter the
> same parameters and I get data back.
> I have checked all the places I could think of that might hide the data, but
> nothing.
> I'm hoping someone else has been through this or has some ideas on where I
> could look.
> TIA,
> Nancy
>
>|||Thanks, I went ahead and I checked for filters and I can find none. I know
it must be something simple I am missing.
Any other ideas? Anyone?
TIA,
Nancy
"Charles Kangai" <CharlesKangai@.discussions.microsoft.com> wrote in message
news:53541C34-C4A7-4769-AB92-43C023605AFD@.microsoft.com...
> Have you added a filter somewhere? Edit the dataset on the Data tab, click
> the Filters tab and see. Also go to Properties of your table and check the
> Filters tab. If your sproc returns data, the data should appear in the
> report. I have a sproc in one of my reports and ti works just fine.
> Charles Kangai, MCT, MCDBA
> "Nancy Lytle" wrote:
> > I am just starting with Report Services, so this may be an easy or dumb
> > problem but here goes:
> >
> > I am working in Visual Studio with a simple report based on a sproc with
> > several parameters that returns a result set. In the report I have set
up a
> > table and the dataset for it, as well as the parameters. Everything
works
> > great until I test the report, the report renders but the table shows as
> > having no data. I can go to the data tab and run the sproc and enter
the
> > same parameters and I get data back.
> > I have checked all the places I could think of that might hide the data,
but
> > nothing.
> >
> > I'm hoping someone else has been through this or has some ideas on where
I
> > could look.
> > TIA,
> > Nancy
> >
> >
> >

Data in a group loops and repeats

I have a report with some subreports. The report is grouped by customer. For some reason one customer is showing the same data twice. Its only happening to this one customer and everyone else is normal. In the left column with all the groups, its only shown once, so it wouldnt be a problem with the database. What can I look for to help solve this?
ThanksI have a report with some subreports. The report is grouped by customer. For some reason one customer is showing the same data twice. Its only happening to this one customer and everyone else is normal. In the left column with all the groups, its only shown once, so it wouldnt be a problem with the database. What can I look for to help solve this?
Thanks

Hi,

Im having the same prob.. still did not get any answ... but i guess i could help u some reason, coz my issues is bit serious, i m using VS2003 + CR 9
a report with grouping was working ok, suddenly the grouping field satrts repeating (with out doing any changes) all the field values (e.g buyer names), this is not possible coz
there is no way once grouped and the field is placed at the right place and this hppening

May be resons,

1) there is conflicting versions of CR in my machine
2) or im using Dot net 2003, CR Editor to do the report design

and U R Problem, accord.. to the way i got the issue, the solut...

1) if u r repettion getting in the Sub Rpt, did u use the propper grouping for the Sub Rpt as well

If possible Send me a Copy of the Rpt to get an idea of it (if u dont mind)

Sorry for inadequate dirrect answer, at least i tried
will get back to u when i get the solut...|||I updated to CR11 Release 2 and seems to have gone back to normal

Data from a recordset

Hi !
I'm new to CR 8.0, so here's my question:

I have a recordset in my VB6 code and want to make a report showing that information. How do I specify in the report's design which fields to show?

If the report used data from a table, then I could select the database fields and paste them in the "Details" section, but as I use a recordset created from VB6, I don't know how to "paste" the fields...

Just in case, this is my code:

Set rstData = db.Execute ("Select * From ...")

Dim Report As New CRAXDRT.Report
Dim CRApp As New CRAXDRT.Application

Set Report = CRApp.OpenReport(gstrPathReports & "\Persons.rpt")

Report.Database.SetDataSource rstData

CRApp.LogOnServer "P2SSQL.DLL", gstrCfgServerName & "\" & gstrCfgInstanceName, _
gstrCfgDBName, "sa", "mypwd"

CRViewer.ReportSource = Report

CRViewer.ViewReportYOu can create a ttx file for your fields, then pass the recordset to Crystal and Crystal will populate the fields in the ttx file in order.

To make a ttx file, use either Method 1 or Method 2:

Method 1: Pass your recordset to this function:

Declare Function CreateFieldDefFile Lib "p2smon.dll" (lpUnk As Object, _
ByVal fileName As String, ByVal bOverWriteExistingFile As Long) As Long

'--------------------------
'LpUnk - The active data source used to create the field definition file.
' In C or C++, this is a pointer to an IUnknown derived COM interface
' relating to a DAO or ADO Recordset. In Visual Basic, this is a
' Recordset or Rowset object.
'Filename - The path and file name of the field definition file to be created.
'bOverWriteExistingFile - If a field definition file already exists with the
' specified path and file name, this flag indicates whether or not to
' overwrite that file.
'--------------------------

'rsRecordset is an ADO Recordset (I haven't tried it with DAO and it doesn't look like it would work with RDO
Call CreateFieldDefFile(rsRecordset, App.Path & "\" & strTtxFileName, True)

Method 2: The manual way

Open Notepad and type your FieldName (doesn't have to match the name of the column, but it makes it easier if it does), then hit Tab and type the DataType (if it's a string, hit Tab again, then type the Max length of the field), then (if you want, it's not necessary) hit Tab again and put in sample data (like what you see for Boolean, True would be the sample data). Sample Data has no effect on your report, I usually leave it out since it's not necessary.

Your ttx file will look like this (I have included all data types it supports):

BLOB BLOB
Boolean Boolean True
Byte Byte
Currency Currency
Date Date
Long Long
Memo Memo
Number Number
Short Short
String String 50
;Comment

If you forget to use a tab in between the FieldName and the DataType, you won't get an error, but that column won't show up in your report. Also, you can include a comment by preceding it with a semicolon.

Save the file as FileName.ttx. (Notepad will default the filename to FileName.ttx.txt, so make sure you delete the .txt from the end or you won't be able to use the file.

After your ttx file is created, open Crystal Reports, choose Add Database, then expand More Data Sources, Active Data. Browse to your ttx file that you created. Now use those fields as you normally would.

The code you have should get your recordset to Crystal.|||I'll try it out, thank you very very much !!!!