How to manage security with Access FE and SQL 2005 Express BE

I have upsized my Access 2003 database to SQL Server 2005 Express so that al
l
the tables are now reside in SQL Server; forms, queries and report are still
in Access, but how do I manage users now?
Do I setup users on the SQL Server or maintain those which I have set up in
Access using the security wizard.
It is important that users have no direct access to the tables but
unfortunately they can still do so in Access. I do not wish that they amend
or edit them directly. I am hoping that I could prevent this with the SQL
server, but I don’t know how to and then how do I connect the security of
the
SQL server with that of the Access database.
Please help.Hi,
yeah you can manage users the same as you done in MS ACCESS
1). Create SQL Users
2). Create Roles
3). Assign proper privileges to Roles
4). Map the users to that Roles respectively
and refer http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=24
:-)
Regards
--
Andy Davis
Activecrypt Team
---
SQL Server Encryption Software
http://www.activecrypt.com
"Lisa Tanenbaum" wrote:

> I have upsized my Access 2003 database to SQL Server 2005 Express so that
all
> the tables are now reside in SQL Server; forms, queries and report are sti
ll
> in Access, but how do I manage users now?
> Do I setup users on the SQL Server or maintain those which I have set up i
n
> Access using the security wizard.
> It is important that users have no direct access to the tables but
> unfortunately they can still do so in Access. I do not wish that they amen
d
> or edit them directly. I am hoping that I could prevent this with the SQL
> server, but I don’t know how to and then how do I connect the security o
f the
> SQL server with that of the Access database.
> Please help.
>|||Andy
Thanks for your reply. I am completely new to SQL Server so it wasn't so
obvious to me. I think I understand it a little better now.
"Andy Davis" wrote:
[vbcol=seagreen]
> Hi,
> yeah you can manage users the same as you done in MS ACCESS
> 1). Create SQL Users
> 2). Create Roles
> 3). Assign proper privileges to Roles
> 4). Map the users to that Roles respectively
> and refer http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=24
> :-)
> Regards
> --
> Andy Davis
> Activecrypt Team
> ---
> SQL Server Encryption Software
> http://www.activecrypt.com
>
> "Lisa Tanenbaum" wrote:
>

how to make this report?

on a timesheet system, if I want a sum of a user on each project over a given period, how can I do this without creating a view? I mean creating a view will just do the sum for that given period, but not prompting the user for the period.

the table looks like this:

empid, projid, hours,closingDate

now I want the sum of the hours on two closing dates, can crystal report prompt the user for two closing dates then do the sum for each employee on each project?You want to sum the hours on 2 closing dates.
Create 2 parameters for each closing date (in 8.0: Insert | Field Object ... on the menu, then create a new parameter value for each date that the user can enter. Be sure to select Date for data type.)

You want the report to prompt the user, so use the parameters in the report and in the select statement or Select Expert. If you named your parameters Date1 and Date2: ({closingDate} = {?Date1}) or ({closingDate} = {?Date2}).

Insert a Group on the ID.
Insert a Group under that on the projid.
Sum the hours for all groups and you will get a total for each projid and a total for the id.

Format your report to make it look like you want it to.

I hope this helps!
Kymberlie|||thx kstefanski

How to make the report show fields in multiple columns?

I am writing a report in SQL server 2005 Reporting service. The report has two parts: first part shows basic information about the client; the second part lists all the softwares the client has. My question is how to make the softwares listed in two columns as shown below?

John Smith

Title: MSTP Location: Main Campus IP:127.0.0.1

Softwares:

Adobe Standard 7.0 Access 5.0

Internet Explore 6.0 Office XP

Any suggestion is appreciated.

There is an option in Crystal Reports -- "Format with multiple columns". I couldn't find the similar configuration in SQL reporting. There is a "Columns" setting in Body Properties, but it doesn't work as making the report in multiple columns. Please help!!

How to make the order by date fine enough in SQL

hi,

I was pulling up a report in SQL, and I wanted the records to be ordered by dates descending. However, I found this ordering was only fine enough to order records by dates (not hours or minutes) (within the same date, records were ordered so that the latest entered were at the bottom). I wonder if anyone else has encouted this problem before, or I am doing something wrong.

Thanks very much.

Then you're trying to do a select order by datedesc, and group by date, within each group you wanna order by timeasc, right? If so you’re trying to do sorting within grouped records. In SQL2005 you can useRANK Functions, for example:

SELECT*,RANK()OVER(PARTITIONBYCONVERT(VARCHAR,CDATE,102)

ORDERBYCONVERT(VARCHAR,CDATE,108))AS RANK

FROM testP

ORDERBYCONVERT(VARCHAR,CDATE,102)DESC

|||Thanks!

How to make textbox Invisible when viewed on screen but visible when printed?

I have a couple reports that have parameters on them. Problem is when the report is printed, the parameters are not displayed.

To solve this, I have added the selected values to the header section of the report in a text box. I now want to find away to hide these values when the report is being viewed on screen but visible when printed. Any suggestions are welcome. Thanks

Does anybody have any suggestions on this or a workaround. I want the user to be able to know the parameters they selected when they print the report.

Thanks

|||

Hello,

You could have another parameter called "Show Parameters" (defaulted to False), then set the visibility of your textbox based on this value. Of course, your users would have to check that box to show them before they printed/exported.

Hope this helps.

Jarret

|||Thanks, interesting and simple work around. I have implemented it. Let's see if the clients like it.

How to make subreport visible based on parameter condition?

Hi,

I have a subreport added to the main report and I want to make this report visible only when the parameter value is met.

Ex, I have a parameter CustName in the main report and want to show the subreport when the custName = xxxxx. There reports are parameter driven not data driven reports.

Any help is greatly appreciated.

Thanks,

Sirisha

When you are binding the Subreport and main report with a parameter , you can accomplish this by doing below steps.

1.) Click on Subreport and go the properties.

2.) In the second tab which is "Visibility" click on Expression radiobutton and press Fx button and paste this code.

=IIF(Fields!CustName.Value= "xxxxx",False,True)

Hope this helps...

|||Thanks Deepak, it worked great

How to make Sub total will be first the first record in next page

I have a report with 1 group per page.

I need Sub Total from Group footer in page 1 will be Subtotal in Group Header in Page 2 (or viewing in Group Header in Page 2), Sub Total from Group footer in page 2 will be Subtotal in Group Header in Page 3, and so on...

How to implement it...Plase help me, urgent.

Thanks Before,

AgusHave you tried to use shared variables?One way to solve the problem is to calculate running total in group footer and assign the value to shared variable.Then you could split group header where top section would display shared variable and bottom section would be used to reset it.|||Dear Denan,...

Thanks for your suggestion.
Actually i never used shared variabel. Would you like to help make an example formula code where is it using shared variabel.

Thanks before,

Agus|||Hi Agus
Well,as I said one formula should be placed in group header.Here you display your total and reset it.Formula would be something like this.
shared numbervar Total;//This is your shared variable
numbervar out;//temporary variable

out:=Total;//Assign total to temporary variable
Total:=0.0;//Reset Total
out//Display result

In group footer you calculate running total and assign that value to shared variable which will hold it until CR passes through group header next time

shared numbervar Total;//Shaerd variable must have same name as in header formula
Total:=#YourRunningTotalName

I hope this helps|||Thanks Denan,...

How to make some textboxes repeat with a table across pages

In the Body portion of a report I have a List. Within the List I have a
textbox. Under the textbox I have a table with various columns. It's
possible that the table spans more than one page, which is OK - it just
depends on how much data I have. What I'm having trouble doing is the
following:
When the table spans multiple pages, I want the textbox to print as well.
The textbox is like header info for the table. I have a client with
invoices. The invoice data is shown in the table. The client name in the
textbox.
I've tried the RepeatWith property on the textbox and set the value to the
name of the table, however, it still doesn't repeat. What am I missing'
ThxSo Adrian,
Did you ever get an answer or figure this issue out?
I could certainly use a solution.
Thx,
Russell
"Adrian Maull (MCP)" <no_spam@.no_email.org> wrote in message
news:eKAdWqZxEHA.3896@.TK2MSFTNGP10.phx.gbl...
> In the Body portion of a report I have a List. Within the List I have a
> textbox. Under the textbox I have a table with various columns. It's
> possible that the table spans more than one page, which is OK - it just
> depends on how much data I have. What I'm having trouble doing is the
> following:
> When the table spans multiple pages, I want the textbox to print as well.
> The textbox is like header info for the table. I have a client with
> invoices. The invoice data is shown in the table. The client name in the
> textbox.
> I've tried the RepeatWith property on the textbox and set the value to the
> name of the table, however, it still doesn't repeat. What am I missing'
> Thx
>|||No answer yet. I'm currently looking for other Report Services newsgroups.
This one doesn't seem to be monitored very well.
"Russell Hardie" <russell_hardie@.cranevalve.com> wrote in message
news:%23ex51%23pxEHA.1308@.TK2MSFTNGP09.phx.gbl...
> So Adrian,
> Did you ever get an answer or figure this issue out?
> I could certainly use a solution.
> Thx,
> Russell
> "Adrian Maull (MCP)" <no_spam@.no_email.org> wrote in message
> news:eKAdWqZxEHA.3896@.TK2MSFTNGP10.phx.gbl...
> > In the Body portion of a report I have a List. Within the List I have a
> > textbox. Under the textbox I have a table with various columns. It's
> > possible that the table spans more than one page, which is OK - it just
> > depends on how much data I have. What I'm having trouble doing is the
> > following:
> >
> > When the table spans multiple pages, I want the textbox to print as
well.
> > The textbox is like header info for the table. I have a client with
> > invoices. The invoice data is shown in the table. The client name in
the
> > textbox.
> >
> > I've tried the RepeatWith property on the textbox and set the value to
the
> > name of the table, however, it still doesn't repeat. What am I
missing'
> >
> > Thx
> >
> >
>|||I understand. My valid email address is in my profile, so if you wouldn't
mind contacting me via email to discuss this further, please do.
Thx,
Russell
"Adrian Maull (MCP)" <no_spam@.no_email.org> wrote in message
news:exFpbU2xEHA.1400@.TK2MSFTNGP11.phx.gbl...
> No answer yet. I'm currently looking for other Report Services
> newsgroups.
> This one doesn't seem to be monitored very well.
> "Russell Hardie" <russell_hardie@.cranevalve.com> wrote in message
> news:%23ex51%23pxEHA.1308@.TK2MSFTNGP09.phx.gbl...
>> So Adrian,
>> Did you ever get an answer or figure this issue out?
>> I could certainly use a solution.
>> Thx,
>> Russell
>> "Adrian Maull (MCP)" <no_spam@.no_email.org> wrote in message
>> news:eKAdWqZxEHA.3896@.TK2MSFTNGP10.phx.gbl...
>> > In the Body portion of a report I have a List. Within the List I have
>> > a
>> > textbox. Under the textbox I have a table with various columns. It's
>> > possible that the table spans more than one page, which is OK - it just
>> > depends on how much data I have. What I'm having trouble doing is the
>> > following:
>> >
>> > When the table spans multiple pages, I want the textbox to print as
> well.
>> > The textbox is like header info for the table. I have a client with
>> > invoices. The invoice data is shown in the table. The client name in
> the
>> > textbox.
>> >
>> > I've tried the RepeatWith property on the textbox and set the value to
> the
>> > name of the table, however, it still doesn't repeat. What am I
> missing'
>> >
>> > Thx
>> >
>> >
>>
>

How to make setup of report

Hello all
I made some reports at my machine. Now i installed Sql Server Reporting
Services on other machine which is production machine. I want to make
an installable or setup or any package to install created reports. Can
anyone help me how to do this?
I gone through Publish sample reports, i tried to publish my one
report, but it shows some error. In the script i dont know what to put
infront of parentFolder. can any one help me.
Thanks & Regards
RajThe server should be something like
http://yourservername/ReportServer
If you want the report in my reports...use
My Reports/Yourfoldername
and for data sources
My Reports/Data Sources
replace My Reports with whatever directory under RS you wish your reports to
be deployed ( and that you have permission to do.)
Hope this helps...
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"Raj" wrote:
> Hello all
> I made some reports at my machine. Now i installed Sql Server Reporting
> Services on other machine which is production machine. I want to make
> an installable or setup or any package to install created reports. Can
> anyone help me how to do this?
> I gone through Publish sample reports, i tried to publish my one
> report, but it shows some error. In the script i dont know what to put
> infront of parentFolder. can any one help me.
>
> Thanks & Regards
> Raj
>

How to make report server email a report on request?

Rather than use a schedule to email a report, I want to get the report
server to email a report on request from a batch job.
Is it possible to do this by issuing a single HTTP url to the report server?
--
McGeeky
http://mcgeeky.blogspot.comTry this:
1. Schedule the report to send an e-mail the way you want it. Set the next
run time to yesterday at this time. Save the schedule.
2. Look at the jobs in the SQL Server, and look for the job that has a
scheduled date/time of yesterday.
3. either you call that job or execute the SQL from the only step within
your app. Either way, do not modify the scheduled job or the RS Schedule,
otherwise the link is lost and the report will not work.
If somebody knows how to schedule directly the reports within RS via T-SQL,
please share it with us.
Thank you|||Thats a good tip. Thanks Cesar
--
McGeeky
http://mcgeeky.blogspot.com
"Cesar Meza" <CesarMeza@.discussions.microsoft.com> wrote in message
news:D387E824-1664-4FE0-8FA3-1111DDBBA182@.microsoft.com...
> Try this:
> 1. Schedule the report to send an e-mail the way you want it. Set the next
> run time to yesterday at this time. Save the schedule.
> 2. Look at the jobs in the SQL Server, and look for the job that has a
> scheduled date/time of yesterday.
> 3. either you call that job or execute the SQL from the only step within
> your app. Either way, do not modify the scheduled job or the RS Schedule,
> otherwise the link is lost and the report will not work.
> If somebody knows how to schedule directly the reports within RS via
T-SQL,
> please share it with us.
> Thank you

how to make report parameter value change dynamic when run time?

Dear all,

i have 2 parameter [startDate] [endDate].
startDate will basic on the day run report to get the start date from system(follow the store procedure) as below.

CREATE PROCEDURE [dbo].[CFSRep_spGetLastWeekMonDate]
AS
BEGIN
DECLARE @.dtStart DATETIME
-- SET @.dtStart = GetDate() --Set Date to Todays Date
--Set Start Date to 6 days before. If its a Sunday it will get this weeks Monday Date, else any day before will get the past weeks Monday Date
SELECT @.dtStart = dateadd(dd, -6, Getdate())
WHILE (datepart(dw, @.dtStart) != 2) --While its not Day 2 (Monday)
BEGIN
SELECT @.dtStart = dateadd(dd, -1, @.dtStart) --Set the Start Date to a day before
END

SET @.dtStart = CONVERT(DATETIME, FLOOR(CONVERT(FLOAT, @.dtStart))) --Set the time to 00:00:00 AM

SELECT @.dtStart as LastWeekFirstDay
--

END
GO


endDate will get the date after the startDate is process. let say the answer as below.
SELECT DATEADD(dd, 4, @.startDate) as endDate

when i get the startDate = 30th Jan 2006, then the endDate = 3rd Feb 2006

then when i preview report, and i change the parameter of the date on start date to 23rd Jan 2006 but the endDate still the same 3rd Feb 2006.

anyway for me to refesh the endDate to 27th Jan 2006?

Hi Terence,

first of all you can use visual basic functions like Today etc. to get the startdate. In case of that you must not go to the database.

then you can try the following steps:

1. define 2 parameters (startdate + enddate)

2. in the enddate-dataset define a parameter @.startDate and set it to =Parameters!StartDate.Value.

3. make your 'SELECT DATEADD(dd, 4, @.startDate) as endDate' statement.

Now the reportservice should set in the endate-parameter the startdate-param +4 days.

hope this will work for you

sql

How to make Report Caching work when rendering a report through the Web Services method Re

I've read carefully about the section "Report Caching in Reporting Services"
on the online document. It seems to me that report caching only works for
URL accesss. I use the web service method Render to render a report content,
and set cache option TimeExpiration.minutes = 20. However, each time when a
user make a Http request, the proxy object of ReportingService is recreated,
and it's Render method gets executed no matter whether the Cache option has
been set up or not. Is there any way that when I call the method "Render"
and tell this method to render from the cached report content instead of
reexecuting the report processing?It should automatically render from the cached report even in SOAP access.
You can test this by reading the SOAP header SessionHeader and checking the
IsNewExecution property. There is an example of this in Books Online. Seach
for SessionHeader.
--
Bryan Keller
Developer Documentation
SQL Server Reporting Services
A friendly reminder that this posting is provided "AS IS" with no
warranties, and confers no rights.
"Wendy H" <WendyH@.tequilasoftware.com> wrote in message
news:e7X9c$abEHA.212@.TK2MSFTNGP12.phx.gbl...
> I've read carefully about the section "Report Caching in Reporting
Services"
> on the online document. It seems to me that report caching only works for
> URL accesss. I use the web service method Render to render a report
content,
> and set cache option TimeExpiration.minutes = 20. However, each time when
a
> user make a Http request, the proxy object of ReportingService is
recreated,
> and it's Render method gets executed no matter whether the Cache option
has
> been set up or not. Is there any way that when I call the method "Render"
> and tell this method to render from the cached report content instead of
> reexecuting the report processing?
>|||I did something wrong, which reset cache option everytime when the render
method was called. After I move these codes into some other place, the
report caching works just as good as the one in Report Manager.
"Bryan Keller [MSFT]" <bryanke@.online.microsoft.com> wrote in message
news:eM6gh%23nbEHA.3988@.tk2msftngp13.phx.gbl...
> It should automatically render from the cached report even in SOAP access.
> You can test this by reading the SOAP header SessionHeader and checking
the
> IsNewExecution property. There is an example of this in Books Online.
Seach
> for SessionHeader.
> --
> Bryan Keller
> Developer Documentation
> SQL Server Reporting Services
> A friendly reminder that this posting is provided "AS IS" with no
> warranties, and confers no rights.
>
> "Wendy H" <WendyH@.tequilasoftware.com> wrote in message
> news:e7X9c$abEHA.212@.TK2MSFTNGP12.phx.gbl...
> > I've read carefully about the section "Report Caching in Reporting
> Services"
> > on the online document. It seems to me that report caching only works
for
> > URL accesss. I use the web service method Render to render a report
> content,
> > and set cache option TimeExpiration.minutes = 20. However, each time
when
> a
> > user make a Http request, the proxy object of ReportingService is
> recreated,
> > and it's Render method gets executed no matter whether the Cache option
> has
> > been set up or not. Is there any way that when I call the method
"Render"
> > and tell this method to render from the cached report content instead of
> > reexecuting the report processing?
> >
> >
>

How to make part of the report show in 2 columns?

I am writing a report in SQL server 2005 Reporting service. The report has two parts: first part shows basic information about the client; the second part lists all the softwares the client has. My question is how to make the softwares listed in two columns as shown below?

John Smith

Title: MSTP Location: Main Campus IP:127.0.0.1

Softwares:

Adobe Standard 7.0 Access 5.0

Internet Explore 6.0 Office XP

Any suggestion is appreciated.

In Crystal Reports, there is an option called "format with multiple columns". Could not find the similar configuration in SQL reporting. Please help!

|||

HI, MiaF:

You can manualy select the two columns in the data section. Right click and select merge cells.

|||

Rex,

Can you explain a little bit more please? I wanted the results to show in multiple columns, how can I make it happen by merging cells? Also, when you say merging cells, you mean in a table?

I found this article that seems saying that what I asked is impossible:

http://msdn2.microsoft.com/en-us/library/ms155816.aspx

"A multi-column layout applies to the entire report. It is not possible to specify a multi-column layout on the top half of the report, and a tabular layout on the bottom half of the report. " Is there anyway to get around this? Thanks.

How to make more than One Page Report in Sql Server Reporting Services 2005

i have a stored procedure that return a single row and more than 100 colums data. i want to show that columns more than one page.

how can i design my report when i preview the report it shows the data on 2 page

DO you want to display the pages next to each other or do you want to display the second page under the first page ? For the first one simply extend the page size to the double size. For the second choice place multiple detail rows on the page until all data is displayed.

HTH, Jens SUessmeyer.

http://www.sqlserver2005.de

How to make hiding the parameter row as default?

When I ran the report from the browser (not from the preview when designing the report), the parameters and the View Report button still displayed. I noticed clicking a double arrow button can hide or show the parameter section . How can I make hiding the parameter section as default? Currently showing the section is the default.

Thanks.

DanYeung

At the end of the URL, just set the paramaters to false, like so:

http://375868d/ReportServer/Pages/ReportViewer.aspx?/Exhumation/ops_samples_all&rcarameters=false

What is with the smiley face? It should be Parameters=false, not arameters=false...

|||

Set the parameter to false can only hide the value of the parameter. I want to hide the who section that shows all parameter names and values, and also the Preview Report button.

Thanks.

DanYeung

|||

I figured it out and wanted to share. In the Report Parameters dialog, check the Hidden checkbox for all parameters. The whole section will be hidden as default.

DanYeung

How to make footers page number appear when i print the report

I have the footer with the following in it,

**********************************

= " Page " & Globals!PageNumber & " of " & Globals!TotalPages & " " & String.Format(Globals!ExecutionTime, "dd-MM-yyy uu:mm")

********************************

When i view the report it shows the page number and time, but when i print it does'nt appear at all on the print paper( page number and time)

is there a trick to make it appear on the print.

Thank you very much.

Reddy,

I'm going to assume you have the above code inside a textbox expression with in your footer. There is no smoke and mirror involved in displaying page number in the footer. I would suggest checking the textbox to make sure visible is true, check footer for printonfirstpage is true (in case there's one page), also go to the print view of the report to see if it shows up there.

I hope this helps.

Ham

|||You might have it too far down. Sometimes it cuts it off if you place the textbox too far down.

How to make Fields dynamic in a table column?

I am developing a single dynamic report in report designer and I have
a small problem. My report has several parameters and I use MDX to
query from a Cube(Analysis Services). Everything works fine until I
want a field in the report to change dynamically when a user changes a
parameter.
Example:
I have one parameter, dimension, which is a drop down list. If the
user chooses 'region' as the dimension, I want the Field!Region.Value
to be my field in the table column. If he chooses 'store' I want
Field!Store.Value to show instead of Region or any other dimension in
the column. Is there any way to make a report dynamic like this in
report designer?
At this moment I have to define fields with the same adress as the
database location: 'Store' has field expression like this -
[Customer].[Store].[MEMBER_CAPTION] and if I use this expression in
the dimension field when the user chooses 'Store' from the drop down
list, I`ll get all the results displayed in the table. This is what I
want to make more dynamic.
My simplyfied MDX query:
SELECT {[Measure].[Units Ordered]} on Columns,
{[Customer].[" + Parameters!Dimension.Value + "].Members} on Rows
from Orders
Does anyone have a solution to this problem?You can use the collection-based syntax for referencing field names in the
report layout. E.g.
=Fields(Parameters!DimensionSelection.Value).Value
Based on the actual parameter value, the field name will be determined at
report processing time.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Oddvar Brennhovd" <oddvar.brennhovd@.isolutions.no> wrote in message
news:83475cf2.0502230717.48b871f6@.posting.google.com...
>I am developing a single dynamic report in report designer and I have
> a small problem. My report has several parameters and I use MDX to
> query from a Cube(Analysis Services). Everything works fine until I
> want a field in the report to change dynamically when a user changes a
> parameter.
> Example:
> I have one parameter, dimension, which is a drop down list. If the
> user chooses 'region' as the dimension, I want the Field!Region.Value
> to be my field in the table column. If he chooses 'store' I want
> Field!Store.Value to show instead of Region or any other dimension in
> the column. Is there any way to make a report dynamic like this in
> report designer?
> At this moment I have to define fields with the same adress as the
> database location: 'Store' has field expression like this -
> [Customer].[Store].[MEMBER_CAPTION] and if I use this expression in
> the dimension field when the user chooses 'Store' from the drop down
> list, I`ll get all the results displayed in the table. This is what I
> want to make more dynamic.
> My simplyfied MDX query:
> SELECT {[Measure].[Units Ordered]} on Columns,
> {[Customer].[" + Parameters!Dimension.Value + "].Members} on Rows
> from Orders
> Does anyone have a solution to this problem?|||Thank you. Now the problem is solved!

How to make drill-through on chart

Hi,

I understand it is possible to use a drill-through from a chart to open another detail report.

However I am not finding any documentation or dialogue to do this. I am locked into VS2003 on SQL 2005 at present.

Thanks,

Thanks. Found it on the Action tab of the Edit Chart Value.

How to make data sets of one report also available for other reports?

Hi, all experts here,

Thank you very much for your kind attention.

I am building reports on SQL Server 2005 Reporting Services.

I am having a question about how to make the data sets of one report for other reports as well within the same report project? As we may need to use the same data sets for report parameters settings. Really need help for that.

Thanks a lot in advance for any guidance and help for that.

With best regards,

Yours sincerely,

In one report, you can use the same dataset for parameters and the body of the report. But currently it's not possible to reuse the datasets of one report for other reports. It is on our wishlist for a future release.|||

Hi, Fang, thanks a lot for your information.

With best regards,

Yours sincerely,

How to make CR not avg sums

I have created a CR that pulls info from MAS90 for a 401(k) report that calculates the employer contribution and then "brings in" the employee contribution that was deducted from their pay.

These are in three columns including a total column adding the EE and ER amounts together for each employee.

My problem is the column totals (grand total) for these three columns at the bottom of the page are off by a few cents. If I manually add up the numbers, I get the correct amount. For some reason CR is averaging up or down instead of EXACT amounts.

I have checked my regional settings for Windows XP. I have tried a custom number setting in CR. Nothing is working.

I also tried doing a running total for each column - that didn't work either. Amounts were still off, but could see them in the running total(s).

Can anyone help, please? Thank you!
JulesI would guess that as your report calculates the contributions that the calculated value isn't exact to 2 decimal places but you are displaying it to 2dp.
Have you tried truncating the calculated values to 2dp and totalling on that?|||Jagan, how do I "truncate" the numbers?

Sorry I'm such a dummy here!

Jules|||Truncate(1.999)

Returns 1.

Truncate(12346.33, 1)

Returns 12346.3.

Truncate(12345.33, -2)

Returns 12300.00.

F1 it helps ... :-)