asked on

Crystal Reports Data Connection

Crystal Reports Data Connection. I have 2 tables (Dynamics GP in SQL) in the same database one the Current Year (GL20000) and the other the History Table (GL30000). I need to pull them onto the same report to do percentage comparisons. I have another table that is being used for each of them that has the description information for the Location. I can seem to get this setup properly. I get the Current all setup and it brings over the data I expected. Then I pull the summary field over to the report for the History and it severely distorts the numbers. Causing records to be counted several times? Please help me figure this out...hopefully without using a subreport.

Thanks

SOLUTION

Mike McCracken

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Victoria Yudin

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Paula Ward

ASKER

Victoria...Can you go into more specifics on how to create the stored procedure? I have never done this. Would that be done in SQL Studio? If so, I am like a baby deer using that program, but I can follow instructions pretty well. Thanks

Paula Ward

ASKER

mlmcc...
Can you give me more specific instructions on creating a Union Query? I have never one this and don't even no where to begin. Will I need to start with a fresh report or can this be added to the one I've already started.

Thanks

Victoria Yudin

Paula,

You likely do not need a stored procedure, at least not yet. Why not use the code I have on my blog that I pointed you to as a start and see if that will get you what you need? That will create a SQL view that can be used the same way as a table in Crystal.

-Victoria

Paula Ward

ASKER

I don't want to seem stupid, but here goes. I can copy and paste your statement, but I don't know where to put it. SQL...Crystal Reports. I need specifics.

Thanks

ASKER CERTIFIED SOLUTION

Victoria Yudin

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial